waiting on library cache locks

From: "Kommareddy, Srinivas (MED, Wissen Infotech)" <Srinivas.Kommareddy@xxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Mon, 8 Mar 2004 07:47:44 -0600

Hi all,
 
DB:9i Solaris 2.8
 
When I tried to enable a trigger , its hung for long time. I checked the
sessions for any waits. I see that the session is waiting on library cache
locks.
 
i further checked and found that the trigger was dependent on a table which
is being analyzed that time.
 
Can someone thorugh some light on this. Is the above case true or 
Is there any other reson for the LC lock ?
 
Tx and Regards,
Srinivas

waiting on library cache locks

Other related posts: