-
advise on statspack report
below is the stat on my report
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 99.83 Redo NoWait %: 100.00
Buffer Hit %: 91.78 In-memory Sort %: 97.00
Library Hit %: 97.27 Soft Parse %: 95.93
Execute to Parse %: 39.28 Latch Hit %: 99.73
Parse CPU to Parse Elapsd %: 27.96 % Non-Parse CPU: 99.95
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 90.50 90.27
% SQL with executions>1: 53.53 74.76
% Memory for SQL w/exec>1: 47.92 64.18
Top 5 Wait Events
~~~~~~~~~~~~~~~~~ Wait % Total
Event Waits Time (cs) Wt Time
-------------------------------------------- ------------ ------------ -------
SQL*Net more data from dblink 5,091 35,811 37.22
SQL*Net break/reset to client 50 20,530 21.34
db file sequential read 77,933 19,841 20.62
SQL*Net message from dblink 8,537 5,632 5.85
db file scattered read 12,169 4,041 4.20
I wouldn't worry too much about dblink b/c the users getting data from another data to this database and I won't worry much about. what I need to aks is
Parse CPU to Parse Elapsd %: 27.96 which I think it's low, what about the SQL*Net break/reset to client???
thanks
-
SQL*Net events can usually be ignored...
Jeff Hunter
-
thanks so much Jeff
what about Parse CPU to Parse Elapsd %: 27.96 which I think it's low.
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
|