| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dropping table is not completing
The first script will show you what transactions are taking place.
Look for lot's of work on sys.uet$ and sys.fet$
The second query will show session waits, and you may in fact want to run it first.
Jared
set line 120
col osuser format a8 heading 'O/S|User'
col username format a10 heading 'Oracle|Userid'
col sid format 9999 head 'SID'
col segment_name format a6 heading 'R-S|Name'
col space format a5 head 'Space|Trans'
col recursive format a5 head 'Recur|sive|Trans'
col noundo format a5 head 'No|Undo'
col used_ublk format 999999 head 'Used|Rbs|Blks'
col used_urec format 9999999 head 'Used|RBS|Recs'
col log_io format 99999999 head 'Logical|IO Blks'
col phy_io format 99999999 head 'Physical|IO Blks'
col txt format a30 heading 'Current|Statement' word
--spool showtrans.txt
select s.osuser
,s.username
,s.sid
,r.segment_name
,t.space
,t.recursive
,t.noundo
,t.used_ublk
,t.used_urec
,t.log_io
,t.phy_io
,substr(sa.sql_text,1,200) txt
from v$session s,
v$transaction t,
dba_rollback_segs r,
v$sqlarea sa
where s.taddr=t.addr
--spool off
select
s.username username, e.event event, s.sid, e.p1text, e.p1, e.p2text, e.p2, e.wait_time, e.seconds_in_wait, e.state
and s.sid = e.sid
and s.username like upper('&uusername')
"Cale, Rick T
(Richard)" To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
<RICHARD.T.CALE cc:
@saic.com> Subject: RE: Dropping table is not
completing
Sent by:
root_at_fatcity.co
m
10/04/01 12:10
PM
Please respond
to ORACLE-L
It just hangs and I am not sure what tables/views to query to find out what the problem is.
Thanks
Rick
-----Original Message-----
Sent: Thursday, October 04, 2001 2:30 PM
To: Multiple recipients of list ORACLE-L
What is the error? Or does it just hang? Have you looked at session wait events to see what is holding it up? If it was locked, it would echo right back saying acquire with nowait failed. Perhaps trying to drop it with a trace behind it. Or trace the session as you wait from sys.
"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----Original Message-----
Sent: Thursday, October 04, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L
Hi All,
I am trying to drop a table. It is not locked and has very few records in it. I am trying to drop it but it will not. What can I check to find out why it will not drop?
Thanks
Rick
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: RICHARD.T.CALE_at_saic.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: cspence_at_FuelSpot.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: RICHARD.T.CALE_at_saic.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Oct 04 2001 - 14:45:07 CDT
 |
 |