Home » RDBMS Server » Performance Tuning » Effect on physical standby database (oracle 9i- Hat Linux RHAS 2.1)
Effect on physical standby database [message #334777] Fri, 18 July 2008 00:15 Go to next message
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: 63931
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.

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

Current Time: Thu Oct 27 10:16:49 CDT 2016

Total time taken to generate the page: 0.22659 seconds