Home » RDBMS Server » Server Administration » undo blocks of killed session
undo blocks of killed session [message #398875] Sat, 18 April 2009 23:34 Go to next message
Messages: 16
Registered: January 2009
Junior Member

Can you please tell what will happen to undo blocks used by uncomitted transaction of a killed session?

Lets say, a session is doing huge DML,say 2 GB of undo blocks is used,These are un-comitted.If some one kill this session,what will happen to those undo blocks? Will they will be marked

1) unexpired or
2) expired or
3) free/available

thanks.. in advance.
Re: undo blocks of killed session [message #398881 is a reply to message #398875] Sun, 19 April 2009 00:54 Go to previous message
Michel Cadot
Messages: 65138
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
None of the above.
They are active until pmon completes the session transaction rolls back.

Previous Topic: How To Apply Patch
Next Topic: ORA-27092: skgfofi: size of file exceeds file size
Goto Forum:

Current Time: Fri Aug 18 00:10:45 CDT 2017

Total time taken to generate the page: 0.18775 seconds