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

Report message to a moderator

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: 68665
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 07:25:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.