Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UNDO Tablespace Full
ADRoman wrote:
> 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
See also
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6894817116500
jg
-- @home.com is bogus. Chances are, 100% of life results in death.Received on Tue Jun 20 2006 - 13:36:46 CDT