SELECT * FROM v$librarycache;

NAMESPACE       GETS       GETHITS    GETHITRATI PINS       PINHITS    PINHITRATI RELOADS    INVALIDATI DLM_LOCK_R DLM_PIN_RE DLM_PIN_RE DLM_INVALI DLM_INVALI
--------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
SQL AREA               483        400  .82815735       1745       1569 .899140401         10          0          0          0          0          0          0
TABLE/PROCEDURE        298        195 .654362416        470        302 .642553191          0          0          0          0          0          0          0
BODY                     1          0          0          1          0          0          0          0          0          0          0          0          0
TRIGGER                  0          0          1          0          0          1          0          0          0          0          0          0          0
INDEX                   29          0          0         29          0          0          0          0          0          0          0          0          0
CLUSTER                134        129 .962686567        186        181  .97311828          0          0          0          0          0          0          0
OBJECT                   0          0          1          0          0          1          0          0          0          0          0          0          0
PIPE                     0          0          1          0          0          1          0          0          0          0          0          0          0