RE: Oracle 7.3.4 problem... SLOW Drop user

From: <Jared.Still_at_radisys.com>
Date: Wed, 4 Aug 2004 11:12:16 -0700
Message-ID: <OF903D2A85.ECEE3346-ON88256EE6.006390D2-88256EE6.0064007D@radisys.com>

> Jared / Everyone
>
> Many Thanks for the input.
> One quick question, the situation makes me nervous. Can I kill the drop
> session? Will the user still be there?
>

Yes, it may take awhile for oracle to recognize the break, as it will be busy dropping a segment.

The user will still be there, minus some tables and whatnot.

I don't know what the internal procedures are in 7x for dropping a user, other than what Cary just told us about.

I do know that it was not unusual for a drop user to cause an ORA-36, which is essentially 'recursion too deep'.

Jared

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 Wed Aug 04 2004 - 13:09:48 CDT