Home » RDBMS Server » Server Administration » Free space in standby database (10.2.0.3)
Free space in standby database [message #517148] Sat, 23 July 2011 01:02 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Hi

How do we find the free space in tablespaces in a standby database
Re: Free space in standby database [message #517149 is a reply to message #517148] Sat, 23 July 2011 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 58856
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is the same one than in the primary.

Regards
Michel
Re: Free space in standby database [message #517150 is a reply to message #517149] Sat, 23 July 2011 01:32 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
but i am not able to query dba_free_space in standby database...
Re: Free space in standby database [message #517151 is a reply to message #517150] Sat, 23 July 2011 01:36 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
but i am not using auto standby file management so space is different in primary and standby...
Re: Free space in standby database [message #517152 is a reply to message #517151] Sat, 23 July 2011 01:43 Go to previous message
Michel Cadot
Messages: 58856
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A physical standby is a copy block per block of the primary, so everything is identical, and so the free space.

Regards
Michel
Previous Topic: v$ views
Next Topic: SMON: Parallel transaction recovery tried
Goto Forum:
  


Current Time: Thu Aug 21 21:31:27 CDT 2014

Total time taken to generate the page: 0.05312 seconds