Re: Flush UNDOTBS?

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Tue, 7 Feb 2006 10:40:05 +0200
Message-ID: <6e49b6d00602070040g1318fd03n@mail.gmail.com>

2006/2/7, Norman Dunbar <norman.dunbar_at_environment-agency.gov.uk>:
> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 07 2006 - 02:40:05 CST