Performance issue in RAC

Dec 19, 2011 8:28PM

Moved from Documents section for User246174:

-----------------------------------------------------------

Hi Team

I have Perrformance is on RAC node from 1 to 4 i have pasted the awr report

Database is :10.2.0.4.0 os : Linux: 2.6.9-67.0.7.ELsmp

---------- ----------

Buffer Cache: 10,592M 10,416M Std Block Size: 8K

Shared Pool Size: 1,504M 1,680M Log Buffer: 112,628K

Load Profile

~~~~~~~~~~~~ Per Second Per Transaction

--------------- ---------------

Redo size: 121,202.19 4,366.77

Logical reads: 207,133.79 7,462.78

Block changes: 628.40 22.64

Physical reads: 1,236.34 44.54

Physical writes: 47.67 1.72

User calls: 226.68 8.17

Parses: 185.56 6.69

Hard parses: 9.95 0.36

Sorts: 131.37 4.73

Logons: 0.53 0.02

Executes: 1,200.20 43.24

Transactions: 27.76

% Blocks changed per Read: 0.30 Recursive Call %: 95.60

Rollback per transaction %: 2.02 Rows per Sort: 21.78

Instance Efficiency Percentages (Target 100%)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Buffer Nowait %: 99.99 Redo NoWait %: 99.99

Buffer Hit %: 99.42 In-memory Sort %: 100.00

Library Hit %: 97.80 Soft Parse %: 94.64

Database Tuning (MOSC)