Version 11.1.0.7
sga_target=0
memory_target=0
shared_pool_size=5G
SQL> select * from (select * from v$sgastat where pool = 'shared pool' order by bytes desc) where rownum < 5;
POOL NAME BYTES
------------ -------------------------- ----------
shared pool sql area 3168671784
shared pool CCursor 425642048
shared pool PCursor 238022512
shared pool PX subheap 100112976
Looks like many not shared sql, but it is not.
There is about 10 SQLs with versions ~50, but total count from v$sql (=30K) much less than on the other server(70K).
This other server has much more count(*) from v$sql, but much less "sql area" size.
And question is: How to determine where space is lost? How to drill down "sql area" from shared pool?