database Performand issue on Rac nodes
Hi
I have performance issue at 1 to 4 very day kinldy help me
Race 2 node database version 10.2.0.4 OS linux
Node 1
Instance Efficiency Percentages (Target 100%)~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Buffer Nowait %: 99.99 Redo NoWait %: 100.00Buffer Hit %: 99.28 In-memory Sort %: 100.00Library Hit %: 99.00 Soft Parse %: 95.59Execute to Parse %: 92.31 Latch Hit %: 99.96Parse CPU to Parse Elapsd %: 37.16 % Non-Parse CPU: 98.15Shared Pool Statistics Begin End------ ------Memory Usage %: 85.99 87.80% SQL with executions>1: 88.99 84.96% Memory for SQL w/exec>1: 85.87 82.97Top 5 Timed Events Avg %Total~~~~~~~~~~~~~~~~~~ wait CallEvent Waits Time (s) (ms) Time Wait Class------------------------------ ------------ ----------- ------ ------ ----------db file sequential read 8,251,150 32,732 4 54.7 User I/OCPU time 16,454 27.5SQL*Net break/reset to client 308,873 9,4490