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: 231
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: 64153
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 Dec 11 02:28:36 CST 2016

Total time taken to generate the page: 0.07066 seconds