how to collect information which sql are present in shared pool

[pande.dhiraj]

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.

[susarlasireesha]

select name, bytes/1024/1024 "MB"
from v$sgastat
where pool = 'shared pool'
order by bytes desc