Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509

    Exclamation Unanswered: sql trace and bind variables.

    I have used sql-trace many times to see what a strange application is doing, but is there any way to have the values of the bind variables that the traced sql is using to show in the trace file? That would really help.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  2. #2
    Join Date
    Jan 2004
    Location
    Scottsdale, AZ
    Posts
    106
    set your 10046 event to a trace level of 4 or 12.
    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

  3. #3
    Join Date
    Jan 2004
    Location
    Germantown, MD
    Posts
    34
    It must be in the RAW trace file, 'cause when I use HOTSOS instead of tkprof, the BV's show up.
    "The world is a dangerous place, not because of those who do evil, but because of those who look on and do nothing. "
    - Albert Einstein

  4. #4
    Join Date
    Jan 2004
    Location
    Germantown, MD
    Posts
    34
    I run at level 12... That explains why I see them...

    ( :

    Quote Originally Posted by dbtoo2001
    set your 10046 event to a trace level of 4 or 12.
    "The world is a dangerous place, not because of those who do evil, but because of those who look on and do nothing. "
    - Albert Einstein

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    That took care of it. I came across a refernce to the DBMS_SUPPORT package, which is an undocumented frontend since Oracle 7 days that allow you to control tracing for your and other peoples sessions. Makes life easier.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •