Database Tuning (MOSC)

MOSC Banner

How to find sql statements that are using literals instead of bind variables in the system?

edited Sep 27, 2019 5:07AM in Database Tuning (MOSC) 16 commentsAnswered
My version is 10.2.0.3 on solaris 10

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center