Home » RDBMS Server » Performance Tuning » Oracle10g Standard Edition on Linux machine (SGA Tuning)
Oracle10g Standard Edition on Linux machine [message #539440] Mon, 16 January 2012 00:07 Go to next message
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
Re: Oracle10g Standard Edition on Linux machine [message #539441 is a reply to message #539440] Mon, 16 January 2012 00:23 Go to previous messageGo to next message
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.
Re: Oracle10g Standard Edition on Linux machine [message #539442 is a reply to message #539441] Mon, 16 January 2012 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 67951
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
John Watson
Messages: 8596
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.
Re: Oracle10g Standard Edition on Linux machine [message #539451 is a reply to message #539447] Mon, 16 January 2012 01:41 Go to previous messageGo to next message
gauravsrivastava
Messages: 22
Registered: November 2011
Location: india
Junior Member
Thanks for all for valuable advise , i will post my statspack report .
Re: Oracle10g Standard Edition on Linux machine [message #539454 is a reply to message #539451] Mon, 16 January 2012 02:17 Go to previous message
himabija
Messages: 33
Registered: December 2011
Location: San Francisco
Member
Quote:
You can't use AWR, because you have Standard Edition


Thanks John for this information.
Previous Topic: truncate table
Next Topic: Wait events for a query
Goto Forum:
  


Current Time: Mon Sep 27 10:44:08 CDT 2021