OraFAQ Forum: Performance Tuning » Oracle10g Standard Edition on Linux machine

Home » RDBMS Server » Performance Tuning » Oracle10g Standard Edition on Linux machine (SGA Tuning)

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

Oracle10g Standard Edition on Linux machine [message #539440]

Mon, 16 January 2012 00:07

gauravsrivastava
Messages: 22
Registered: November 2011
Location: india

Junior Member

Hi All,

In my production ENV there is two node RAC database is runing , and on both machine RAM size is (35GB on node1,41GB on Node2) and other configuration is like below.

SGA SGA_TARGET DB_BLOCK_SIZE DB_MULTIBLOCK_READ_COUNT
NODE1 16G 14G 8K 16K
NODE2 16G 14G 8K 16K

Our Database size is 700GB approx.

Please suggest me the above SGA configuration is ok or need to be increase the size of SGA , our HIT RATIO is allmost 99%.

Please also provide me a way to findout or check the SGA is suuficient or not.

Thanks,
Gaurav

Report message to a moderator

Re: Oracle10g Standard Edition on Linux machine [message #539441 is a reply to message #539440]

Mon, 16 January 2012 00:23

himabija
Messages: 33
Registered: December 2011
Location: San Francisco

Member

Use performance tool (statspack,AWR) to check the HIT ratio for individual SGA component and analyze if any modification required or not.

Report message to a moderator

Re: Oracle10g Standard Edition on Linux machine [message #539442 is a reply to message #539441]

Mon, 16 January 2012 00:48

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Hit ratios is a bad performances indicator.
Check your wait events in the mentioned performances report (statspack, AWR).

But before trying to optimize SGA, did you optimize the business rules, the application design and code, the SQL statements?
Tuning the SGA is the last but one step of optimisation.

Regards
Michel

[Updated on: Mon, 16 January 2012 00:50]

Report message to a moderator

Re: Oracle10g Standard Edition on Linux machine [message #539447 is a reply to message #539440]

Mon, 16 January 2012 01:32

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Have you scheduled statspack snapshots for both instances? (You can't use AWR, because you have Standard Edition) Then generate a few statspack reports. Post them here, and you should get some advice.

Report message to a moderator