Oracle Database Discussions

Hi

This is a 30mins interval statspack report's load profile taken during peak hour for a 9206 db running siebel. The problem we are facing now is latch free wait and 100% cpu utilization.

As you can see there is a very high number of execution, 7371/sec. If we cannot bring down the number of execution, is there anything that i can do to ease the performance issue.

Is there any guideline on the number/value where exceeding the threshold values would warrant closer attention?

Thanks
Ung

Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 24,085.42 3,907.06
Logical reads: 31,392.48 5,092.39
Block changes: 130.77 21.21
Physical reads: 189.50 30.74
Physical writes: 3.74 0.61
User calls: 7,768.65 1,260.21
Parses: 24.86 4.03
Hard parses: 0.41 0.07
Sorts: 8.74 1.42
Logons: 0.13 0.02
Executes: 7,371.61 1,195.80
Transactions: 6.16

% Blocks changed per Read: 0.42 Recursive Call %: 0.38
Rollback per transaction %: 0.21 Rows per Sort: 46.10