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 and t.xidusn=r.segment_id(+) and s.sql_address=sa.address(+) / --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 from v$session s, v$session_wait e where s.username is not null and s.sid = e.sid and s.username like upper('&uusername') -- skip sqlnet idle session messages and e.event not like '$message from client' order by s.username, upper(e.event) / "Cale, Rick T (Richard)" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <RICHARD.T.CALE cc: @saic.com> Subject: RE: Dropping table is not completing Sent by: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).