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: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Tue, 23 Jan 2007 09:50:43 +0300
Message-ID: <97b7fd2f0701222250n3fea0b0fs4202e93c54023180@mail.gmail.com>


Ram,

Your undo_retention is set to 7200 sec, i.e. 120 mint/2 hrs. Do you really need 2 hrs undo retention?

Upto my understanding, it should be the redo that must be generated highly not the UNDO.

By the way, how are you inserting data from one table to another?

Jaffar

On 1/23/07, Ram Raman <veeeraman_at_gmail.com> 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.
>
> We have the problem of running out of space in the UNDO TBS. The process
> erred out thrice due to lack of space in UNTO TBS. It is now set at 30G and
> is already 100% full. Why would the UNDO take so much space even though the
> data inserted is so less AND there is no simultaneous database activity.
> Only active processes other than this insert process is the Oracle
> background processes.
>
> Ram.
>
>

-- 
Best Regards,
Syed Jaffar Hussain
8i,9i & 10g OCP DBA

I blog at :http://jaffardba.blogspot.com/

http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 23 2007 - 00:50:43 CST

Original text of this message

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