Home » RDBMS Server » Performance Tuning » Effect on physical standby database (oracle 9i-9.2.0.1.0-Red Hat Linux RHAS 2.1)
Effect on physical standby database [message #334777] Fri, 18 July 2008 00:15 Go to next message
jimit_shaili
Messages: 235
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Hi Friends

I'm going to increase my SGA and PGA related parameters in spfile on primary database,should i need to increase same in my standby database spfile.? My standby database is on a other server than primary database.Both server had same configuration with RAM,Hardware and all.
Re: Effect on physical standby database [message #334785 is a reply to message #334777] Fri, 18 July 2008 00:44 Go to previous message
Michel Cadot
Messages: 64611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As you intend to use the standby as the primary in case of failure, they should have the same parameters.

Regards
Michel
Previous Topic: replacing with single update statement
Next Topic: query tuning
Goto Forum:
  


Current Time: Sun Mar 26 23:49:51 CDT 2017

Total time taken to generate the page: 0.13005 seconds