Trace file TKPROF with Bind variable option
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Trace file TKPROF with Bind variable option

  1. #1
    Join Date
    May 2006
    Posts
    1

    Question Trace file TKPROF with Bind variable option

    1.Is there any option to see the all bind variable's value in the trace file?
    2.I am running a report thru Oracle Application and I am getting the trace file in udump location but there are lot of bind variable looks like :B1..B10.
    3.Can anyone tell me that the option is available or not?
    4.Alternatively I have to put a lot of debug messages in the Report.
    Thnx
    Deb

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you need a 10046 level 4 trace to see the binds

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