RE: question regarding automatic undo

Am I correct in that possibly database 2 was very busy and decided it
needed more segment so dynamically created them.  Sometime thereafter,
not needed so they were offlined????

>>> "Goulet, Dick" <DGoulet@xxxxxxxx> 6/21/05 12:54:27 PM >>>
Yes.  When you enable automatic undo management you leave all of that
to the database engine.

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeffrey
Beckstrom
Sent: Tuesday, June 21, 2005 12:41 PM
To: oracle-l@xxxxxxxxxxxxx; oracle-db-l@xxxxxxxxxxxxxxxxxxxx;
ORACLE-L@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx;
oracle-rdbms@xxxxxxxxxxxxxxx 
Subject: question regarding automatic undo



Two identical databases.
 
database 1 has 10 undo online and 2 offline
database 2 has 10 undo online and 23 offline
 
Why does the second have more offline undo segments.  Does Oracle
automatically create them if needed and when no longer needed offline
it??
 
 
 
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113

Other related posts: