CPU used by this Session and Wait time

From: BN <bnsarma_at_gmail.com>
Date: Wed, 29 Nov 2006 16:41:32 -0500
Message-ID: <61292a9d0611291341v29e77e0ds817d151af8a2c13c@mail.gmail.com>

Greetings

Oracle 8i - 8.1.7.4

30 CPUs HP-UX Server, B.11.11 U 9000/800

Why is Wait Time = 3,189,073 so much greater than CPU used by this session = 1,895,903

I am folowing Metalink doc:232443.1

Is it because its Idle event? A script enabled browser is required for this page to function properly. **

Elapsed:                  60.03 (mins)

Top 5 Wait Events
~~~~~~~~~~~~~~~~~                                             Wait     %
Total
Event                                               Waits  Time (cs)   Wt

Time

-------------------------------------------- ------------ ------------
-------
queue messages                                    144,820    3,189,073
44.09
unread message                                    114,688    1,104,768
15.28
buffer busy waits                                 204,101      811,928
11.23
latch free                                      2,261,911      582,630
8.06
db file sequential read                           743,403      534,833

7.39

Statistic                                    Total   per Second    per Trans
--------------------------------- ---------------- ------------ ------------
CPU used by this session                 1,895,903        526.4          7.3
parse time cpu                             186,843         51.9          0.7
recursive cpu usage                      1,066,217        296.0          4.1

Service time=1,895,903
Wait Time= 3,189,073/44.09 = 72330.98
Responce time= 1,895,903 + 72330.98= 1968233.98 CPU Other=1,895,903-186,843-1,066,217=642843 =>642843/1968233.98*100= 32.6% queue messages = 3,189,073/1968233.98*100=162%

-- 
Regards & Thanks
BN

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 29 2006 - 15:41:32 CST