Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> V$LATCH question

V$LATCH question

From: Anonymous <mail_for_deja_at_yahoo.com>
Date: 30 Nov 2001 17:49:01 -0800
Message-ID: <8ee5d7c9.0111301749.173b7097@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US