Home » RDBMS Server » Server Administration » What is actually undo_retention
What is actually undo_retention [message #267981] Mon, 17 September 2007 01:15 Go to next message
sureshkay
Messages: 21
Registered: June 2007
Junior Member
Does the undo_retention means the life time of the uncommited data OR Commited Data

which one of the below statement corretly defines the Definition of undo_Retention:

1. If I commit the Transaction the undo segment will remain active till the undo_retention time is over and then it overwrites the segment

2. If there are uncommited Transactions then undo_retention defines the life time for the undo segment and when the time expires the undo segment expires.

One more question:
from Oracle Documentation:
However, since DROP TABLESPACE drops an undo tablespace even if it contains unexpired undo information (within retention period), you must be careful not to drop an undo tablespace if undo information is needed by some existing queries.


How is it possible to drop undo tablespace when the there are unexpired undo information ???
can any one explain with a example.

[Updated on: Mon, 17 September 2007 01:28]

Report message to a moderator

Re: What is actually undo_retention [message #267987 is a reply to message #267981] Mon, 17 September 2007 01:36 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/undo.htm#BJFEHEIC

This is Undo Retention.
Re: What is actually undo_retention [message #267989 is a reply to message #267987] Mon, 17 September 2007 01:45 Go to previous messageGo to next message
sureshkay
Messages: 21
Registered: June 2007
Junior Member
Yes it is clear and it also answers my question from new topic i submitted "Undo Tablespace takes time to switch from pending offline to offline mode". Thanks
Re: What is actually undo_retention [message #267993 is a reply to message #267987] Mon, 17 September 2007 01:53 Go to previous messageGo to next message
kowmudi
Messages: 1
Registered: September 2007
Location: Bangalore
Junior Member
hi
iam new to this site,can u plz tell me where to ask questions?
Re: What is actually undo_retention [message #267997 is a reply to message #267981] Mon, 17 September 2007 01:58 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Click on new topic at the right hand side of your screen.
Re: What is actually undo_retention [message #268000 is a reply to message #267993] Mon, 17 September 2007 02:03 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But BEFORE clicking on "New topic" you have to carefully read OraFAQ Forum Guide.

Regards
Michel

[Updated on: Mon, 17 September 2007 02:03]

Report message to a moderator

Previous Topic: Undo Tablespace takes time to switch from pending offline to offline mode
Next Topic: PMON
Goto Forum:
  


Current Time: Sat Dec 03 06:14:42 CST 2016

Total time taken to generate the page: 0.09906 seconds