| Undo Tablespace takes time to switch from pending offline to offline mode [message #267978] |
Mon, 17 September 2007 00:56  |
sureshkay
Messages: 21
Registered: June 2007
|
Junior Member |
|
|
My instance is running in Automatic undo management mode.
I am using two undo tablespace (undo01,undo02)
Currently undo_tablespace is set to undo01.
there are transactions records in undo01
and i switch to undo02: alter system set undo_tablespace=undo02
as a result the undo01 tablespace turns to pending offline mode
then i commit all the transaction: commit;
But undo01 tablespace is still in pending offline mode
after sometime the undo01 tablespace gets offline automatically
Why does it take some time for the undo01 tablespace to turn from pending offline mode to offline mode
does the undo_retention has to do something with that extra time ???
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
