Tuesday, 7 August 2018

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;

No comments:

Post a comment