Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> V$LATCH question
What is the differences between column MISSES and SLEEPS of V$LATCH.
From the book:
SLEEPS - The number of times a process had to wait before obtaining a Willing-to-Wait latch
MISSES - The number of times a Willing-to-Wait latch was not acquired and a wait resulted
To tune the Willing-to-wait latch, which column should I use?
Thanks,
David
Received on Fri Nov 30 2001 - 19:49:01 CST