Re: UNDO Tablespace Full

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Tue, 20 Jun 2006 17:06:33 GMT
Message-ID: <tWVlg.7847$nS5.4040@trnddc07>

ADRoman wrote:
> Chuck;
>
> Let me tell you that we have a Hybrid database (OLTP and DSS).
> That is the reason we use 2 undo tablespace, for OLTP 5 GB and for DSS
> 10 GB,
> Large processes are run seldomly, I mean by night or weekly. Those
> processes are supposed to be using the undo tablespace for DSS mode.
>
> I'm still wondering WHY the full segments are not being released, if
> nobody are using them??
> It has been 2 days and they are still full.
>
> Plese helpme with this doubt.
>
> Alonso

Please don't top post. It makes it harder to follow the flow of responses.

It still doesn't matter. You need only one undo tablespace large enough to hold all the undo that gets generated during the undo_retention period.

What is your undo_retention setting? Received on Tue Jun 20 2006 - 12:06:33 CDT