Package Compilation takes long time ...

Oracle will lock the package exclusively when the user attempt to compile the package. Incase if the package is used by other process, the compilation hangs..

Resolution:

1. Identify the package which is locked

SELECT * FROM DBA_DDL_LOCKS WHERE name = 'package name';

2. Get the sid

select * from v$access where object='package name';

3. Get the serial#

select sid,serial# from v$session where sid=;

4. Kill the session
alter system kill session 'sid,serial#';