Could maybe be a by product of when transactions completed.
Remember that the recording is made when the transaction completes...so timing
wise a long running transaction could have just completed when you began the
snap?
Hi
I have a HP-UX Server running Oracle
8.1.7.4, there are 6 CPUs.
I have a statspack
report which shows this (2 hours interval)
Snap Id Snap Time
Sessions
------- ------------------ -------- Begin
Snap: 143 20-Jul-06
02:31:02 453 End
Snap: 167 20-Jul-06
04:31:06 453
Elapsed:
120.07 (mins)Top 5 Wait Events ~~~~~~~~~~~~~~~~~
Wait % TotalEvent
Waits Time (cs) Wt Time--------------------------------------------
------------ ------------ -------latch
free
3,573,965 6,945,555 99.25log file
sync
122,691 30,316
.43log file parallel
write
146,604 18,685
.27SQL*Net more data to
client
522,539 1,762
.03db file sequential
read
10,923
534 .01 Statistic
Total per Second per Trans ---------------------------------
---------------- ------------ ------------CPU used by this
session
2,990,059
415.1 27.6CPU used when call
started
2,423,510
336.4 22.4I
was wondering how can we get over 69000 seconds waits in 2 hours with 6 CPUs?
That is much larger than
3600seconds * 6CPUs * 2hours
TIA
Alex
