OraFAQ Forum: Data Guard » database

Home » Server Options » Data Guard » database_properties (oracle 12c Windows 2012)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database_properties [message #672707]

Thu, 25 October 2018 06:05

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi ALL,

I have just noticed a thing.

In the view of "database_properties", all the default and permanent settings are listed.
But not about the UNDO tbs information.

We could change the permanent tablespace of TEMP as well as DATA, the same way as UNDO.

Then why it is not included in it.

Regards
M.krish

Report message to a moderator

Re: database_properties [message #672709 is a reply to message #672707]

Thu, 25 October 2018 06:18

John Watson
Messages: 8997
Registered: January 2010
Location: Global Village

Senior Member

The undo tablespace is an attribute of the instance, not of the database. It has to be, otherwise RAC wouldn't be possible.

Report message to a moderator

Re: database_properties [message #672714 is a reply to message #672709]

Thu, 25 October 2018 06:51

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi John

Yes, thanks for the reply.

Regards
M.krish

Report message to a moderator

Re: database_properties [message #672726 is a reply to message #672714]

Thu, 25 October 2018 10:51

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So it's an instance property (you can see in v$system_parameter) not a database one.

Report message to a moderator

Previous Topic:	ORA-00308: -- DR looking for older archive logfiles
Next Topic:	Advantage of having Standby redo logs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 14 11:41:54 CST 2026