encoded content removed -- binaries not allowed by ListGuru
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender
Today on a busy production system I saw dozens of sessions waiting on buffer busy
waits events. p1 and p2 from v$session_wait were the same and mapped to one of our
very large unique indexes on a large table.
For all but one of the sessions, p3=130. Using Metalink and Steve Adams's website,
Interesting.. What version and platform?
I have never seen p3=1 for a buffer busy wait. Was the session just hung? Did you by
chance
monitored SEQ# from v$session_wait?
- Kirti
--- John Clarke [EMAIL PROTECTED] wrote:
Today on a busy production system I saw dozens of sessions waiting on
