Re: Flush UNDOTBS?
- From: Gints Plivna <gints.plivna@xxxxxxxxx>
- To: norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx
- Date: Tue, 7 Feb 2006 10:40:05 +0200
2006/2/7, Norman Dunbar <norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx>:
> Oracle will reuse unexpired extents if it has to, so the UNDO_RETENTION
> setting is only advisory.
unless for undo tablespace RETENTION GUARANTEE is specified (in 10g).
Don't know how many actually uses that or cases when it is really
necessary...
Gints
--
//www.freelists.org/webpage/oracle-l
Other related posts:
