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