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

Report message to a moderator

Re: Undo Tablespace [message #343112 is a reply to message #343067] Tue, 26 August 2008 05:44 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 23:18:10 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.