Who has locked my package?

This question I have frequently faced while developing packages/procedures in PL/SQL in Oracle. 

Question: How will I identify who has locked a procedure or a package. I need to identify this because it should not hang after the compilation is issued?

Answer: You may see the details from v$sql with the search text (Your package name). If the query fetches results then join it with v$session to get the session information.

select * 
from v$sql, v$session
where sql_address=address
and upper(sql_text) like '%PACKAGE_NAME%';

Hope this simple tip saves you some time.

No comments :

Post a Comment