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 -> tuning question (latches)

tuning question (latches)

From: Jared <jared_at_hwai.com>
Date: 19 Nov 2002 10:48:49 -0800
Message-ID: <480f610.0211191048.41701b35@posting.google.com>


Consider, if you will, the results of a query of V$LATCH:

NAME                           MISSES     SLEEPS  SPIN_GETS   PCT_MISS

--------------------------- ---------- ---------- ----------
----------
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
1.78209802

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

Original text of this message

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