Oracle - Statements not using bind variables (https://app.pluralsight.com/library/courses/oracle-performance-tuning-developers/table-of-contents)

stmt_not_using_bindv.sql

with statements as
(
    select force_matching_signature,
        count(1) over (partition by force_matching_signature) as statement_count,
        row_number() over (partition by force_matching_signature order by last_load_time desc) as row_index,
        parsing_schema_name,
        sql_text
    from v$sql
    where force_matching_signature > 0
    and force_matching_signature <> exact_matching_signature
)
select
    force_matching_signature, parsing_schema_name,
    sql_text, statement_count
from statements
where row_index = 1 and statement_count >= 5;