| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: package compilation hangs
do it again, next time, see if the sid is a job. dbms_job.broken....kill,
rinse, repeat.
-----Original Message-----
From: jaysingh1_at_optonline.net [mailto:jaysingh1_at_optonline.net]
Sent: Tuesday, August 31, 2004 4:02 PM
To: oracle-l_at_freelists.org
Subject: Re: RE: package compilation hangs
Gogala,
Thanks for your immediate response.
<<SELECT * FROM V$SESSION_WAIT where sid= 667 >>
If I kill sid 667, some other session appears in DBA_DDL_LOCKS table for that package.
V$SESSION_WAIT says that it is waiting fro "library cache pin"
We cannot restart the db. It is 24/7 but OPS environment.
Thanks
Jay
> Did you check V$SESSION_WAIT to see what is it waiting for? It will
> give you exactly the lock you are waiting for. Kill the session
> holding the lock and re-try. If that doesn't help, connect as sysdba
> and type the following:
> STARTUP FORCE RESTRICT
> That will almost guarantee that you can recompile the package.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Aug 31 2004 - 15:05:59 CDT
 |
 |