shared pool fragmentation monitor
But when I issue the following query, I am getting one row returned:
select substr(sql_text,1,40) "SQL", count(*), sum(executions) "TotExecs"
from v$sqlarea
where executions <5
group by substr(sql_text,1,40) having count(*) >30 order by 2;
SQL COUNT(*) TotExecs
---------------------------------------- ---------- ----------
select t$item Item , initcap(t$dsca) dsc 57 82
Also, the following query returns:
SQL> select * from v$shared_pool_reserved where request_failures >0;
FREE_SPACE AVG_FREE_SIZE FREE_COUNT MAX_FREE_SIZE USED_SPACE AVG_USED_SIZE