Re: Oracle 7.3.4 problem... SLOW Drop user

From: <Jared.Still_at_radisys.com>
Date: Wed, 4 Aug 2004 10:12:26 -0700
Message-ID: <OFA4B384BD.E9087BF6-ON88256EE6.005E3358-88256EE6.005E866D@radisys.com>

> Hello Folks,
>
>
> We have a legacy system on Oracle 7.3.4 on NT.
>
> I am dropping the user with cascade, but it is extremely slow???
Tends to be that way on v7.

> Can anyone tell me why? Can I stop it and restart it for beter
> performance?

Recursive SQL, specifically, transferring sys.uet$ to sys.fet$.
>
> I am doing the drop from a client machine, could this be the problem?
>

No.

> Any help would be appreciated!
>

Drop all the users tables individually.

eg.

set echo off term off pagesize 0 linesize 200

define dropuser='USERNAME'

select 'drop table &&dropuser.' || table_name || ' cascade constraints;' from dba_tables
where owner=upper('&&dropuser')
/

use the resulting generated SQL to drop the users tables, then drop the user.

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 - 12:10:07 CDT