Search notes:

Oracle: V$LIBRARYCACHE

v$librarycache contains statistics about library cache performance and activity.

Namespaces

select
   namespace
from
   v$librarycache
order by
   namespace;
--
-- ACCOUNT_STATUS
-- APP STATE
-- AUDIT POLICY
-- BODY
-- CLUSTER
-- CMP
-- DBINSTANCE
-- DBLINK
-- DIRECTORY
-- EDITION
-- HINTSET OBJECT
-- INDEX
-- OBJECT ID
-- PDB
-- QUEUE
-- RULESET
-- SCHEMA
-- SQL AREA
-- SQL AREA BUILD
-- SQL AREA STATS
-- TABLE/PROCEDURE
-- TEMPORARY INDEX
-- TEMPORARY TABLE
-- TRIGGER
-- USER PRIVILEGE
-- XML SCHEMA

See also

library cache
x$kglst
Dynamic performance views

Index