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
oradbaexp
Messages: 16
Registered: January 2009
Junior Member
Hi

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: 64111
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.

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


Current Time: Mon Dec 05 19:03:51 CST 2016

Total time taken to generate the page: 0.06926 seconds