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

2002-07-16 Thread mkb
gt; 07/16/2002 11:41 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 > > > I was wondering where

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

2002-07-16 Thread kkennedy
by: [EMAIL PROTECTED] 07/16/2002 12:23 PM 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 I found this once but can't seem to find th

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

2002-07-16 Thread Jared . Still
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 &g

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

2002-07-16 Thread Jared . Still
lt;[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): kill -l # lists all kill signal names kill -l KILL # lists numeric

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

2002-07-16 Thread kkennedy
o > much time. > > Jared > > > > > > "BALA,PRAKASH (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

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

2002-07-16 Thread mkb
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
x27;t 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

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

2002-07-16 Thread Jared . Still
uch time. Jared "BALA,PRAKASH (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

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 is

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 ORAC

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 v$ses

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 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, v$sessio

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 statu