RE: How do I check whether a rollback activity is going on

2002-07-16 Thread Sherman, Paul R.
Jared, I agree with you, except for when MTS is being used. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list

RE: How do I check whether a rollback activity is going on

2002-07-16 Thread BALA,PRAKASH (Non-HP-USA,ex1)
Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon

RE: How do I check whether a rollback activity is going on

2002-07-16 Thread Jared . Still
(Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always

RE: How do I check whether a rollback activity is going on

2002-07-16 Thread Jared . Still
recommend doing it. :) Jared Sherman, Paul R. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity

RE: How do I check whether a rollback activity is going on

2002-07-16 Thread mkb
: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L

RE: How do I check whether a rollback activity is going on

2002-07-16 Thread kkennedy
by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could

RE: How do I check whether a rollback activity is going on

2002-07-16 Thread Jared . Still
] cc: Subject:RE: How do I check whether a rollback activity is going on I found this once but can't seem to find the full details at the moment. This will help though (Solaris8): kill -l # lists all kill signal names kill -l KILL # lists numeric equivalent for signal name KILL

RE: How do I check whether a rollback activity is going on

2002-07-16 Thread Jared . Still
] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple

RE: How do I check whether a rollback activity is going on

2002-07-16 Thread kkennedy
respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on I found this once but can't seem to find the full details at the moment. This will help though (Solaris8

RE: How do I check whether a rollback activity is going on

2002-07-16 Thread mkb
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something

RE: How do I check whether a rollback activity is going on

2002-07-15 Thread Khedr, Waleed
You should see some activity in v$transaction. Regards, Waleed -Original Message- Sent: Monday, July 15, 2002 5:39 PM To: Multiple recipients of list ORACLE-L Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status

Re: How do I check whether a rollback activity is going on

2002-07-15 Thread Jack Silvey
Gene, Run this repeatedly - used_ublk will reduce as it rolls back - after it is finished the session should dissappear. column sql_text word_wrapped select vs.sid, vs.serial#,vt.used_ublk, vt.start_time, vs.username, vs.osuser, substr(vsq.sql_text,1,75) sql_text from v$transaction vt,

Re: How do I check whether a rollback activity is going on

2002-07-15 Thread Jared . Still
It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the

Re: How do I check whether a rollback activity is going on

2002-07-15 Thread Jared . Still
Sorry, forgot to answer your question during all my ranting. 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