Home » RDBMS Server » Server Administration » Undo Tablespace takes time to switch from pending offline to offline mode
Undo Tablespace takes time to switch from pending offline to offline mode [message #267978] Mon, 17 September 2007 00:56 Go to next message
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 ???


Re: Undo Tablespace takes time to switch from pending offline to offline mode [message #267986 is a reply to message #267978] Mon, 17 September 2007 01:35 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/undo.htm#i1106407

Your answer is here.
Re: Undo Tablespace takes time to switch from pending offline to offline mode [message #267988 is a reply to message #267986] Mon, 17 September 2007 01:42 Go to previous messageGo to next message
sureshkay
Messages: 21
Registered: June 2007
Junior Member
I have read the documentation but why does it take time to switch from pending offline to offline. should'nt it happen immediately when all tranasaction are commited
Re: Undo Tablespace takes time to switch from pending offline to offline mode [message #267992 is a reply to message #267978] Mon, 17 September 2007 01:52 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

After committed all active transactions the undo tablespace goes from pending offline to offline.

Do you know really when Oracle actually committed transaction?

Answer is No.
Previous Topic: EmailId change in PFILE/SPFILE
Next Topic: What is actually undo_retention
Goto Forum:
  


Current Time: Tue Dec 06 14:16:53 CST 2016

Total time taken to generate the page: 0.10133 seconds