OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Rollback Session (oracle enterprise manager, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rollback Session [message #626333]

Sun, 26 October 2014 09:15

madhusmita.chakraborty
Messages: 2
Registered: January 2014
Location: Bangaluru

Junior Member

How to find out if a session(UPDATE QUERY) is doing rollback after killing it with "ALTER SYSTEM SESSION KILL IMMEDIATE" command , which was causing lock on almost 35 other session ?
Also how much rollback the session has to do?
Any script for this?

--------------------
------------------
Chakraborty
Oracle DBA

Report message to a moderator

Re: Rollback Session [message #626334 is a reply to message #626333]

Sun, 26 October 2014 09:25

John Watson
Messages: 8997
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read

If you query v$transaction, you'll see how the rollback is proceeding.

Report message to a moderator

Re: Rollback Session [message #626340 is a reply to message #626334]

Sun, 26 October 2014 12:22

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

... in the column used_ublk. Wink

Report message to a moderator

Previous Topic:	FRA space cross thresold limit
Next Topic:	Job scheduler issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 31 04:56:34 CDT 2026