CPU used by this Session and Wait time
- From: BN <bnsarma@xxxxxxxxx>
- To: oracle_L_list <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Nov 2006 16:41:32 -0500
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
Other related posts:
