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
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
(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
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,
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
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
14 matches
Mail list logo