Friday, January 22, 2010

Finding statement/s which use lots of shared pool memory

SELECT substr(sql_text,1,40) "Stmt", 
count(*),
sum(sharable_mem) "Mem",
sum(users_opening)   "Open",
sum(executions)      "Exec"
FROM v$sql
GROUP BY substr(sql_text,1,40)
HAVING sum(sharable_mem) > ;


MEMSIZE is about 10% of the shared pool size in bytes

Labels: ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home