Package using which session

Package using which session

Trying to compile package but its not compiling and going in infinite loop.

Run this query to now which session is using package. It will give you SIDs

SELECT * FROM v$access WHERE object = 'XXXX_HR_COMMON_PKG';

Now run this command to get SERIAL# of that SID

select SERIAL# from v$session where sid='<SID>';

Now kill sessions

ALTER SYSTEM KILL SESSION 'SID,SERIAL#';

Its easy :)