SharedPool , any advice
sql> –SHARED POOL V$LIBRARYCACHE STATISTIC NOTES:
sql> select NAMESPACE, GETS, GETHITS, round(GETHITRATIO*100,2) gethit_ratio,
2 PINS, PINHITS, round(PINHITRATIO*100,2) pinhit_ratio, RELOADS, INVALIDATIONS
3 from v$librarycache
4 /
NAMESPACE GETS GETHITS GETHIT_RATIO PINS PINHITS PINHIT_RATIO RELOADS INVALIDATIONS
---------------------------------------------------------------- ---------- ---------- ------------ ----------
SQL AREA 35132441 31619511 90 1881419208 1877686582 99.8 306044 66376
TABLE/PROCEDURE 104140471 104017977 99.88 348612479 348209616 99.88 140050 0
I have more "Invalidation" in the SharedPool , any advice ?
0