Monday, January 18, 2016

How to check which are the object cached in memory

 How to check which are the object cached in memory:-

select SUBSTR(owner,1,10) Owner,SUBSTR(Type,1,12) Type,SUBSTR(name,1,20) Name,
executions,sharable_mem Mem_used,
SUBSTR(Kept||' ',1,4) "Kept"
from v$db_object_cache
where type in('trigger','procedure','Package Body','Package')
order by executions desc;

No comments: