hi all
i want to information or view, which gives the information about the which sql in shared pool and which sql is consume how much memory from the shared pool.
hi all
i want to information or view, which gives the information about the which sql in shared pool and which sql is consume how much memory from the shared pool.
select name, bytes/1024/1024 "MB"
from v$sgastat
where pool = 'shared pool'
order by bytes desc