How to find BIND VALUE?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to find BIND VALUE?

  1. #1
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Angry 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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    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

  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    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
  •  



Click Here to Expand Forum to Full Width