How to find sql statements that are using literals instead of bind variables in the system?
My system shared_pool is being beaten pretty bad. I am pretty sure that there are lots of sql statements in the system using literals instead of bind variables.
However, when I try to query the system to find out, both query I got no rows selected. I am not sure if those are the correct queries to find out about sql statements using literals. Please advice. Thank you very much.
select force_matching_signature, count(1)
from v$sql
where force_matching_signature > 0
and force_matching_signature <> exact_matching_signature
group by force_matching_signature