Re: question regarding automatic undo

  • From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>, <davidsharples@xxxxxxxxx>
  • Date: Tue, 21 Jun 2005 14:41:53 -0400

Will the "extra" ones ever go away or will they just stay offline.  I
have no idea when they were created.  I just noticed them Friday after
doing a test recovery of a single tablespace.

>>> David Sharples <davidsharples@xxxxxxxxx> 6/21/05 2:34:31 PM >>>

On 6/21/05, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx> wrote:
> Two identical databases.

> Why does the second have more offline undo segments.  Does Oracle
> automatically create them if needed and when no longer needed offline

Other related posts: