Re: Status of Undo Tablespace

Hi Pete,

Welcome back, gee it was quiet without you ...

In my defense (as i wipe the pooh from my face), I did mention that there can be active undo segments from another tablespace if a switched had recently occurred and prior transactions had not yet complete. It depends somewhat on the definition of an 'active' tablespace.

Can I at least get a C- ?

Cheers

Richard

Pete Sharman wrote:
>
> In article <3D5A0D26.CDBE6B96_at_oracle.com>, Richard says...
> >
> snip
> >>
> >> I thought only one would be active at one time.
> >
> >Correct. Only one undo tablespace can be active at a time per instance.
> >
> Seems like Howard's been keeping you honest while I was off tripping aroung
> North west US with the family, Richard, but I haven't seen this one corrected
> yet (maybe I just missed it).
>
> It is in fact quite possible to have two undo tablespaces active at one time per
> instance. If you have active transactions in one undo tablespace and switch to
> a new undo tablespace, new transactions will use the new undo tablespace and the
> old transactions will complete in the original undo tablespace. They are not
> swapped to the new undo tablespace. AS a result, temporarily two undo
> tablespaces are being used. Of course, I'm sure you already knew that but I
> couldn't resist rubbing your nose in it! :)
>
> HTH. Additions and corrections welcome.
>
> Pete
>
> SELECT standard_disclaimer, witty_remark FROM company_requirements;
Received on Thu Aug 15 2002 - 05:08:08 CDT