Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UNDO Tablespace Full
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
I'm still wondering why you have ignored all of the advice you've been given and are still asking the same question.
It can't be made simpler than that.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Jun 21 2006 - 11:52:49 CDT