Home » RDBMS Server » Performance Tuning » reading AWR report (oracle 10g windown 2003 server)
reading AWR report [message #278060] Thu, 01 November 2007 12:25
skumar.dba
Messages: 82
Registered: October 2007
Member
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

Previous Topic: find out query is taking full table scan or index scan
Next Topic: Anti-Join (HASH_AJ) with multiple columns in the "NOT IN" clause
Goto Forum:
  


Current Time: Sat Dec 03 20:14:55 CST 2016

Total time taken to generate the page: 0.09435 seconds