How to find BIND VALUE?

[kgb]

Hi, guys
I am looking for the way to get bind variable value from the view
v$sqlarea. I need to find which records was queried from a table.
For example, I have select statement in the v$sqlarea which looks like that:

SELECT n_binary FROM nuance.dgdb__nuance where nuance_key = :1

and i would like to find real value for ':1'.

Is there any way to do it?

I appreciate it for any advice.

[pando]

well some Metalink analysts wrote a PL/SQL block to find this but even so she said it´s not 100% accurate. The best way is set event 10046 only

[kgb]

Thank you, I'll check metalink. I do not need to be very accurate.