is_bind_aware in v$sql
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