Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: UNTO TBS behavior in 9i

RE: UNTO TBS behavior in 9i

From: Polarski, Bernard <Bernard.Polarski_at_atosorigin.com>
Date: Tue, 23 Jan 2007 10:48:28 +0100
Message-ID: <25D4919915CCF742A88EE3366D6D913D117EA64C@mailserver1>


Normally, undo_retention will be discarded if there is a undo need for a DML over consistent read unless the 'retention guarantee' clause is used. So I don't see why the reason behind the undo growth if you are doing intermediate commits.

What is the value of the retention columns for the undo tablespace?

select tablespace_name ,retention from dba_tablespaces where retention != 'NOT APPLY'

TABLESPACE_NAME                RETENTION
------------------------------ -----------
UNDORBS                        NOGUARANTEE



Bernard Polarski
Oracle DBA

At 02:19 PM Tuesday, Ram Raman wrote:
>Hi all,
>
>We are running a batch process to insert data from one table to
>another. The data inserted is over than 10 million rows. We had
>about 20GB of UNDO tablespace. UNDO_RETENTION is 7200. When we start
>the insert process no other process runs and all the time during the
>insert process nothing else runs. We insert about 5.5 Gb of data
>including indexes.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 23 2007 - 03:48:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US