Home » RDBMS Server » Server Administration » Oracle 10G ideal parameters
Oracle 10G ideal parameters [message #257138] Tue, 07 August 2007 11:28 Go to next message
amit.d.mi2
Messages: 3
Registered: August 2007
Junior Member
Hi

I need to setup memory parameters after upgrading my database from oracle 9.2.0.7.0 to 10.2.0.3.0.
I am working on Aix-5L 4GB memory.
It has 2 databases.
I need to know the ideal sizing of memory parameters for oracle 10G
I need to know the sizing for paramters like SGA_TARGET and PGA_AGGREGATE_TARGET.


Thanx
Amit
Re: Oracle 10G ideal parameters [message #257142 is a reply to message #257138] Tue, 07 August 2007 11:32 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
take a look on Parameters
Initialization Parameters in Oracle 10g

http://www.dbazine.com/olc/olc-articles/ault7

http://www.oracle-base.com/articles/10g/PerformanceTuningEnhancements10g.php
Re: Oracle 10G ideal parameters [message #257143 is a reply to message #257142] Tue, 07 August 2007 11:35 Go to previous messageGo to next message
amit.d.mi2
Messages: 3
Registered: August 2007
Junior Member
hi
true but i need examples like
if i have 4Gb of os memory
and 2 databases on it
what should be the optimal sizing of sga_target
and pga_aggregate_target
Re: Oracle 10G ideal parameters [message #257144 is a reply to message #257143] Tue, 07 August 2007 11:41 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
It is very hard to say anyone what is right size for SGA parameter.

You can start with below value and run your application after generate statpack report and analyze if you feel and face any performance problem then modify sga parameters.

Total SGA should be 80% of RMAN

Note:
It is also depand on Database type OLTP or DSS,
running application,
no. of users,
no. of transactions per second.


and PGA should be 20% of SGA.

set sga_max_size for maximum size allocate for SGA. it will use later and when Oracle Server needed.

Regards
Taj

PS: Doing anything on Production box check on testing box first.


[Updated on: Tue, 07 August 2007 11:45]

Report message to a moderator

Re: Oracle 10G ideal parameters [message #257149 is a reply to message #257144] Tue, 07 August 2007 11:47 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
SGA
===
Operating system-dependent; typically 2 to 4 GB for 32-bit operating systems, and 4 GB for 64-bit operating systems

http://download.oracle.com/docs/cd/B12037_01/server.101/b10755/limits004.htm#i288165

[Updated on: Tue, 07 August 2007 11:47]

Report message to a moderator

Previous Topic: Reindex database
Next Topic: SQL Tunning Advisor
Goto Forum:
  


Current Time: Tue Dec 03 07:56:36 CST 2024