Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: V$LATCH question
Think of a sleep as a short wait. A miss is giving up and coming back to it
later.
Think of it as going to the movies to get a ticket. If the line is not too long you are willing to wait a little while to buy a ticket. (a sleep) You might call your buddies on your cell phone or in general do something else, but you are still in line to get the ticket. A miss is when the line is long and you just leave and come back later. You could have waited for awhile and then decided to go grocery shopping and come back and buy the tickets later.
So a miss is very bad, it means the line to get a ticket was so long that you decided to do something else and get the ticket later. The process that needed the ticket is going to have to wait a "long" time to get the ticket. Also you waste gas driving around to pick up groceries and then reparking to get the movie ticket later.
Jim
"Anonymous" <mail_for_deja_at_yahoo.com> wrote in message
news:8ee5d7c9.0111301749.173b7097_at_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 - 20:37:57 CST