Spotlight version is 10.2.1.1504 x64
Oracle client (used for Spotlight) was 126.96.36.199 x64
Client OS is Windows 7 x64 SP1
Monitored database was Oracle 188.8.131.52 x64 on AIX
Once while presenting Spotlight capabilities during one of mine Toad hotest features, I have situation that Spotlight shows pretty long time buffer busy wait alram.
The bb wait situation lasts for 3-5 minutes and then I decide to took a picture, which is here as live example.
Once again, before this picture was taken BB wait shows red alarm (99%-100% values), and here, when the picture was taken was blue level.
Then I took ASH from the same period to show to users that Spotlight can replace ASH reports. But ... but in generated html report (from the 3 minutes before and after monitored Spotlight pic) there was no sign of mentioned buffer busy wait event at all. I cannot place html report here ( do not know how and do not want to compromise client data!) but please let me get someone mail to send ... not a problem.
I was then asked why is Spotlight showing this (quite often by their words wait event) and this state/problem is not reflected in ASH (which I belieive more, sorry to say that).
So please understand that this may be obvious to you people but not to me and not to mine client, who is waiting for an straight answer-what is underneath of that Spotlight message and how to inter-prate in the future.
THX in advance