The user probably has code objects (stored proc/pkgs) as well owns tables which are being replicated elsewhere? The lib cache pins can be explained by the need to lock/pin affected objects in the shared pool for invalidation. These objects are code owned by the user or are referring the objects owned by the user....
Hth, John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -----Original Message----- Sent: Friday, August 15, 2003 7:10 AM To: Multiple recipients of list ORACLE-L I'm doing some departed user cleanup and the 'drop user xxxx cascade' hangs for 2 -3 minutes before completeing. I ran a 10046 trace and it does a lot of waiting for 'library cache pin' - 100 times for 308 centiseconds each time. Dropped two different users, 100 library cache pin waits per user. It hits the wait in dbms_repcat_utl.drop_user_repschema(:myuser). While I was amazed at all the things a drop user has to do, what the heck is the drop_user_repschema doing that is causing all this library cache pin issues? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
