Re: UNDO Tablespace Full

Chuck wrote:
> 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?

My undo_retention is 3 hours.

but, sometimes I obtain errors 1555.
I am reading about error 1555

Thanks. Received on Tue Jun 20 2006 - 13:14:50 CDT