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
/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
(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
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
:
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
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
]
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
]
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
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
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
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
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
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,
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
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
15 matches
Mail list logo