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.
from v$sql, v$session
and upper(sql_text) like '%PACKAGE_NAME%';
Hope this simple tip saves you some time.