Oracle-L: RE: library cahce pin wait on drop user

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Fri, 15 Aug 2003 11:14:23 -0800
Message-ID: <F001.005CAF09.20030815111423@fatcity.com>

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: DEEDSD_at_Nationwide.com

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: ListGuru_at_fatcity.com (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: john.kanagaraj_at_hds.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------