Query to find loaded object details in Shared Pool

Query to find loaded object details in Shared Pool

Query:

SELECT OWNER, NAME, TYPE, ROUND(SHARABLE_MEM/1024,2) SIZE_KB, LOADS, KEPT, EXECUTIONS, LOCKS, PINS 
FROM V$DB_OBJECT_CACHE 
WHERE TYPE IN (‘PROCEDURE’, ‘PACKAGE BODY’, ‘PACKAGE’, ‘FUNCTION’, ‘TRIGGER’, ‘VIEW’) 
— AND NAME LIKE ‘%OBJECT_NAME%’
ORDER BY SHARABLE_MEM DESC;


its possible to clear the contents of shared pool with the following command:


alter system flush shared_pool;






  • September 20, 2018 | 16 views
  • Comments