-
Performance Tunning
Hi all,
below is the report of my DB:
oad Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 1,282.85 28,057.16
Logical reads: 843.05 18,438.42
Block changes: 4.24 92.77
Physical reads: 161.06 3,522.58
Physical writes: 7.03 153.74
User calls: 3.66 80.03
Parses: 4.34 94.94
Hard parses: 0.50 11.00
Sorts: 18.65 407.81
Logons: 0.21 4.58
Executes: 36.14 790.45
Transactions: 0.05
% Blocks changed per Read: 0.50 Recursive Call %: 96.13
Rollback per transaction %: 16.13 Rows per Sort: 19.16
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 99.90 Redo NoWait %: 100.00
Buffer Hit %: 80.90 In-memory Sort %: 99.86
Library Hit %: 99.14 Soft Parse %: 88.41
Execute to Parse %: 87.99 Latch Hit %: 99.94
Parse CPU to Parse Elapsd %: 59.71 % Non-Parse CPU: 99.91
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 79.94 73.91
% SQL with executions>1: 64.50 80.54
% Memory for SQL w/exec>1: 73.25 79.15
Top 5 Wait Events
~~~~~~~~~~~~~~~~~ Wait % Total
Event Waits Time (cs) Wt Time
-------------------------------------------- ------------ ------------ -------
db file scattered read 12,053 4,894 41.32
db file sequential read 20,648 3,474 29.33
SQL*Net break/reset to client 46 1,716 14.49
direct path read 2,307 653 5.51
file open 126 489 4.13
-------------------------------------------------------------
I have the SQL net break on the top 5 events and this could cause the time of the connection between client and the database, can someone give me hint how to fix this problem??? Plus some other area I can improve my database.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|