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
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?

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: 8782
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: 68314
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: Sat Dec 03 00:00:56 CST 2022