RE: Oracle 7.3.4 problem... SLOW Drop user

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Wed, 4 Aug 2004 14:17:55 -0400
Message-ID: <DE8A21F8F1D0254EA4A9214D52AB2FED11F2C031@exchsen0a1ma>

Denham,

Use orakill to kill the NT thread. Tha might kill it quicker than you think.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Denham Eva [mailto:EVAD_at_TFMC.co.za] Sent: Wednesday, August 04, 2004 2:05 PM To: oracle-l_at_freelists.org
Subject: RE: Oracle 7.3.4 problem... SLOW Drop user

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
-----------------------------------------------------------------
----------------------------------------------------------------
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:14:13 CDT