v$librarycache
contains statistics about library cache performance and activity. 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