Home » RDBMS Server » Server Administration » Undo Tablespace (AIX 9.2.0.6)
Undo Tablespace [message #343067] Tue, 26 August 2008 03:26 Go to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi,

At my Test DB there exists two Undo tablespaces.
I want to know which Undo Oracle is currently using.

I have fired the below command:-
==============================
sql> select value from v$parameter where name='undo_tablespace';

This showing I am using UNDOTBS1 tablespace.

Then I fired the below command for crosschecking:-
========
sql> select TABLESPACE_NAME, STATUS from dba_tablespaces where tablespace_name like '%UNDO%';

The below results found:-
==============
TABLESPACE_NAME STATUS
------------------------------ ---------
UNDOTBS1 ONLINE
UNDOTBS03 ONLINE

I am confused which Undo tablespace oracle currently using, because UNDOTBS03 should be OFFLINE as Oracle currently using UNDOTBS1.

Is there is any query to check which undo tablespace oracle currently using??

Please help.

Pokhraj







Re: Undo Tablespace [message #343112 is a reply to message #343067] Tue, 26 August 2008 05:44 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The tablespace used is the 'undo_tablespace' one.
The other one is online but bot used, it does not need to be offline to not be used.

Regards
Michel
Previous Topic: upgrade/migrate (merged)
Next Topic: ORA-01031 insufficient privileges
Goto Forum:
  


Current Time: Wed Dec 07 14:54:45 CST 2016

Total time taken to generate the page: 0.06585 seconds