Looking for some output back from some other systems to categorize "how many different sql statements" and "how many different execution plans".
Along with the output would be helpful to me to note please what release and what "kind" of system OLTP / ERP / DW etc. If done on a 12c system using CDB/PDB please run from CDB connection.
Output back here or emailed to firstname.lastname@example.org would be much appreciated.
select round(bytes/(1024*1024),0) count, 'Shared Pool Size' info from v$sgainfo where name = 'Shared Pool Size'
select count(*), 'First copy of sql' from v$sql_shared_cursor where child_number = 0
select count(*), 'Not first copy' from v$sql_shared_cursor where child_number >= 1
select count(*), 'Total Execution plans' from v$sql_shared_cursor
select count(*), 'Count from sqlarea' from v$sqlarea;