Database Tuning (MOSC)

MOSC Banner

is_bind_aware in v$sql

edited Nov 28, 2014 10:07AM in Database Tuning (MOSC) 2 commentsAnswered

Hello,

Please help me with an example when is_bind_aware becomes y in v$sql

I used one sql with bind when I executed this first time is_bind_sensitive got y but is_bind_aware was still n however when more no. of times the same sql was executed even then is_bind_aware was still n.

Please share some example under what circumstance is_bind_aware become y

Below is the statement and cursor_sharing=FORCE

select * from emp2 where id=:b1

Best regards,

Vishal

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