Friday, July 12, 2013

Issue in compiling Code - Package body

There was an issue while compiling XXGL_JOURNAL_IMPORT_INTF_PKG package and took lot of time (still unsuccessful with timeout error message)

I was trying to find out root cause, so I looked into to v$locked_object but not found

After that, got How to: Determine if a Package that is About to be Compiled is Being Used Currently [ID 1054939.6] which says

SQL> connect / as sysdba
SQL> exec who_is_using('XXGL_JOURNAL_IMPORT_INTF_PKG');
(1-2195) - APPS
(1-3359) - APPS

Find relevant SID & Serial# and kill the session,

SQL> alter system kill session '2195,38431' immediate;

System altered.

SQL> alter system kill session '3359,1577' immediate;

System altered.

SQL> exec who_is_using('XXGL_JOURNAL_IMPORT_INTF_PKG');

PL/SQL procedure successfully completed.


Again compiled same packege, and got completed within  2 seconds.

No comments:

Post a Comment