undo_retention [message #352924] |
Fri, 10 October 2008 04:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vinniora
Messages: 56 Registered: October 2008 Location: Mumbai
|
Member |
|
|
HI all....i m asking a question abt undo_retention
by default undo_retention is 900s and my database too have this value.this means that the undo segment will flushes out the data after 900s but when i fired a query
select begin_time,end_time,undoblks from v$undostat;
it is still showing the undoblks (having some value)of previous date..
so why it is showing these value..as retention time is only 900secs...plz help me out
|
|
|
|
Re: undo_retention [message #352932 is a reply to message #352927] |
Fri, 10 October 2008 05:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vinniora
Messages: 56 Registered: October 2008 Location: Mumbai
|
Member |
|
|
version is oracle 10g
thank you for the reply..this means tht it will not be flushed until some of the transaction may take up tht space...if not then it will remain there forever
|
|
|
|
|
Re: undo_retention [message #352945 is a reply to message #352924] |
Fri, 10 October 2008 05:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vinniora
Messages: 56 Registered: October 2008 Location: Mumbai
|
Member |
|
|
and could u please answer that...if it flushes only when it needed the space then why we are using undo_retention....
|
|
|
Re: undo_retention [message #352953 is a reply to message #352945] |
Fri, 10 October 2008 05:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68680 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
1/ Yes data are not flushed after commit, this is the purpose of undo retention: to retain after commit
2/ undo retention, depending on RETENTION parameter of tablespace:
* when GUARANTEE, guarantees that the undo data earlier than retention time are not flushed
* when NOGUARANTEE, keep undo data earlier than retention time unless there is no more space for new transactions.
Regards
Michel
|
|
|