Hi,
this is one part of awr report. i had one question in this instance efficiency percentages.
what is the id al value for "parse CPU to Parse Elapsd %".
some time i am getting 100% 80%, 50%, 3.12% i am not able to understand this concept.
my question is what could be the ideal value for this. is it should be high or low. how do i identify it the exact value.
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.90 In-memory Sort %: 100.00
Library Hit %: 95.04 Soft Parse %: 93.00
Execute to Parse %: 65.88 Latch Hit %: 100.00
[B]Parse CPU to Parse Elapsd %: 101.52[/B] % Non-Parse CPU: 92.83
one more doubt in WAIT EVENTS
Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
---------------------------- -------------- ------ ----------- ------- ---------
control file parallel write 674 .0 2 2 2.1
[COLOR=blue]read by other session [/COLOR] 44,128 8 3,440 78 67.6
control file sequential read 1,102 .0 1 1 3.4
db file sequential read 70 .0 0 5 0.2
db file parallel write 538 .0 0 0 1.6
os thread startup 31 .0 0 6 0.1
log file parallel write 568 .0 0 0 1.7
log file sync 162 .0 0 0 0.5
SQL*Net break/reset to clien 182 .0 0 0 0.6
SQL*Net message to client 2,964 .0 0 0 9.1
latch free 1 .0 0 3 0.0
db file scattered read 2 .0 0 0 0.0
SQL*Net more data to client 3 .0 0 0 0.0
SQL*Net more data from clien 6 .0 0 0 0.0
direct path write 6 .0 0 0 0.0
SQL*Net message from client 2,965 .0 9,687 3267 9.1
Streams AQ: waiting for time 13 100.0 2,263 174065 0.0
virtual circuit status 68 100.0 2,040 30000 0.2
Streams AQ: waiting for mess 404 100.0 2,021 5002 1.2
Streams AQ: qmn slave idle w 72 .0 2,020 28056 0.2
Streams AQ: qmn coordinator 146 50.7 2,020 13836 0.4
wait for unread message on b 2,018 100.0 2,018 1000 6.2
jobq slave wait 625 99.7 1,873 2996 1.9
-------------------------------------------------------------
in this read by other session values are very high. what could be the problem and how do i rectify the problem.
[Updated on: Thu, 01 November 2007 13:02]
Report message to a moderator
] 
Blog
Search
Help
Members
Register
Login
Home
