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

2002-07-16 Thread Sherman, Paul R.
to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going

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

2002-07-16 Thread BALA,PRAKASH (Non-HP-USA,ex1)
/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back

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

How do I check whether a rollback activity is going on

2002-07-15 Thread Gurelei
Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system

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
to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going

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

2002-07-15 Thread Jared . Still
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I