Shulou(Shulou.com)06/01 Report--

A section of sql in the test environment is unable to run the result. In the production environment, the same sql is produced in seconds. Later, it is found that the package corresponding to the custom function behind select is invalid. Try to recompile the package, but cannot compile it. Find the session of the locked package, kill it all, and recompile it.

SELECT 'alter system kill session' | |'| | sid | |','| | serial# | |''immediate;', a.*

FROM dba_ddl_locks a, v$session ss

WHERE a.name LIKE'% package name% 'AND a.session_id = ss.sid

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.