Friday, September 18, 2009

Shared pool contents - v$db_object_cache

select OWNER,
NAME,
DB_LINK,
NAMESPACE,
TYPE,
SHARABLE_MEM,
LOADS,
EXECUTIONS,
LOCKS,
PINS
from v$db_object_cache
order by sharable_mem;


select OWNER,
NAME||' - '||TYPE object,
SHARABLE_MEM
from v$db_object_cache
where SHARABLE_MEM > 100000
order by SHARABLE_MEM desc;


select owner, count(*), sum(sharable_mem) from v$db_object_cache group by owner order by sum(sharable_mem) desc;