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: Performance Tuning, v$sql
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home