Home » RDBMS Server » Server Administration » Rollback Session (oracle enterprise manager, Linux)
Rollback Session [message #626333] Sun, 26 October 2014 09:15 Go to next message
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
Re: Rollback Session [message #626334 is a reply to message #626333] Sun, 26 October 2014 09:25 Go to previous messageGo to next message
John Watson
Messages: 7620
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.
Re: Rollback Session [message #626340 is a reply to message #626334] Sun, 26 October 2014 12:22 Go to previous message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

... in the column used_ublk. Wink

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


Current Time: Mon Oct 22 03:02:41 CDT 2018