OraFAQ Forum: Server Administration » Oracle 10G ideal parameters

Home » RDBMS Server » Server Administration » Oracle 10G ideal parameters

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 10G ideal parameters [message #257138]

Tue, 07 August 2007 11:28

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

Report message to a moderator

Re: Oracle 10G ideal parameters [message #257142 is a reply to message #257138]

Tue, 07 August 2007 11:32

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

Report message to a moderator

Re: Oracle 10G ideal parameters [message #257143 is a reply to message #257142]

Tue, 07 August 2007 11:35

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

Report message to a moderator

Re: Oracle 10G ideal parameters [message #257144 is a reply to message #257143]

Tue, 07 August 2007 11:41

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 06:41:58 CST 2024