Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Interesting Metric
I have a threaded batch process running in which all the threads are pretty
much doing the same thing. I have another report which shows total IO, CPU,
REDO and more by session. When you look at this report (basically workload)
all of the #'s and times are pretty much the same. Meaning all of the
threads are processing about the same amount of work. However, if you look
below I get these usual spikes in Buffer Busy waits and they correlate to
specific sessions. it looks like the spikes occur during a checkpoints. It
is strange because it looks like just a couple session accumulate all of the
buffer busy time instead of all of the sessions.
Total Latch Buffer Db File Db File D Path D Path Log
Buf Log File SQL*Net
SID Seconds Free Busy Sct Read Seq Read Read Write Enqueue
Space Sync to Cli
----- ------- ------- ------- -------- -------- ------- ------- -------