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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
None of the above.
They are active until pmon completes the session transaction rolls back.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 17:46:32 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.