RE: Oracle 7.3.4 problem... SLOW Drop user
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 4 Aug 2004 14:17:55 -0400
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@xxxxxxxxxx]
Sent: Wednesday, August 04, 2004 2:05 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jared.Still@xxxxxxxxxxx
Sent: Wednesday, August 04, 2004 7:12 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
