-
How to find BIND VALUE?
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.
Best wishes!
Dmitri
-
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
-
Thank you, I'll check metalink. I do not need to be very accurate.
Best wishes!
Dmitri
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|