Doc

    Name:  sametext.sql

    Author Mark Gurry

    This script shows SQL that has the same 30 leading characters 
    and may be a candidate for using bind variables.

#


ttitle  ' SQL Statements that are Similar in Shared Pool Area'
select substr(sql_text,1,30) sql , count(*)
  from v$sqlarea
group by substr(sql_text,1,30)
having count(*) > 200;