Query to find the SQL Statements with Multiple SQL IDs | Oracle Database

How to find the SQL Statements with Multiple SQL IDs in Oracle Database?

Below mentioned queries can help you find the SQL Statements having multiple unique SQL IDs:

SELECT substr(sql_text,1,40), count(1)
FROM gv$sqlarea
group by substr(sql_text,1,40)
order by count(1) asc;