RE: Oracle 7.3.4 problem... SLOW Drop user

From: Denham Eva <EVAD_at_TFMC.co.za>
Date: Wed, 4 Aug 2004 20:04:41 +0200
Message-ID: <B822F724868AE8419D78F162BE7C2DB6C31A5B@cent12000.tfmc.co.za>

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?

Regards
Denham

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared.Still_at_radisys.com
Sent: Wednesday, August 04, 2004 7:12 PM To: oracle-l_at_freelists.org
Subject: Re: Oracle 7.3.4 problem... SLOW Drop user

> Hello Folks,

>=20
>=20

> We have a legacy system on Oracle 7.3.4 on NT.=20
>=20
> 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$.

>=20

> I am doing the drop from a client machine, could this be the problem?
>=20

No.

> Any help would be appreciated!

>=20

Drop all the users tables individually.

eg.

set echo off term off pagesize 0 linesize 200

define dropuser=3D'USERNAME'

select 'drop table &&dropuser.' || table_name || ' cascade constraints;' from dba_tables
where owner=3Dupper('&&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
-----------------------------------------------------------------
----------------------------------------------------------------
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:58:26 CDT