OraFAQ Forum: Server Administration » Free space in standby database

Home » RDBMS Server » Server Administration » Free space in standby database (10.2.0.3)

Sat, 23 July 2011 01:02

sekar52
Messages: 141
Registered: May 2010
Location: Mumbai

Senior Member

Hi

How do we find the free space in tablespaces in a standby database

Sat, 23 July 2011 01:25

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

Senior Member
Account Moderator

It is the same one than in the primary.

Regards
Michel

Sat, 23 July 2011 01:32

sekar52
Messages: 141
Registered: May 2010
Location: Mumbai

Senior Member

but i am not able to query dba_free_space in standby database...

Sat, 23 July 2011 01:36

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...

Sat, 23 July 2011 01:43

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

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 28 20:55:31 CDT 2025