Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> tuning question (latches)
Consider, if you will, the results of a query of V$LATCH:
NAME MISSES SLEEPS SPIN_GETS PCT_MISS1.78209802
--------------------------- ---------- ---------- ----------
----------
redo copy 82 113 4 22.2826087 parallel query stats 78 68 26 18.3962264 X$KSFQP 19841 340731 4 10.6961875 row cache objects 3438577 10095 3429030 3.15610367 parallel query alloc buffer 44 0 44
At the time of this query I had 63% of my 512 MB shared pool free, per OEM ( I would publish a screenshot, but it would be poor netiquette). Now, my large pool is set to 16 MB, but I didn't think any of the above objects used it. Am I mistaken? If not via shared pool, how would one approach tuning this (lowering the percentage of misses as a total of gets+misses)?
TIA -
Regards,
jh
Received on Tue Nov 19 2002 - 12:48:49 CST