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

Home -> Community -> Usenet -> c.d.o.server -> Re: UNDO Tablespace Full

Re: UNDO Tablespace Full

From: joel garry <joel-garry_at_home.com>
Date: 20 Jun 2006 11:36:46 -0700
Message-ID: <1150828606.851252.132890@i40g2000cwc.googlegroups.com>

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

Original text of this message

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