Re: what is the process queue reference latch?

  • From: "Alberto Dell'Era" <alberto.dellera@xxxxxxxxx>
  • To: "Tony van Lingen" <tony.vanlingen@xxxxxxxxxxxxxx>
  • Date: Tue, 5 Dec 2006 18:21:55 +0100

Also, misses is almost twice as high as gets. I always thought that the
misses were a sub-set of the gets, which should set a max to the amount
of misses one could possibly get (misses <= gets). Is that correct?

I remember reading the exact meaning of GETS, MISSES etc in
Steve Adam's book years ago; I don't remember the answer but I recall it
wasn't perfectly intuitive. I haven't the book handy and I failed to find
the detailed definition anywhere else, sorry.

Anyway from a practical point of view - MISSES should be almost zero
and several orders of magnitude less than GETS, whatever the definition;
so what you are experiencing is definitely an issue ...

hth (a little at least)
Alberto
--
http://www.freelists.org/webpage/oracle-l


Other related posts: