Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    335

    Unanswered: Monitor for Statement

    Hi,

    i've a monitor for Statement and the results are as expected. There's only one thing i'm missing. It fetches just the prepared Statements.
    Is there any way to fetch the real values?

    So, i don't want
    select b,c,d from TAB1 where a=?
    but
    select b,c,d from TAB1 where a='XYZ'

    Cheers
    nvk

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Your example shows different statements. If you use parameter markers, that's what is stored in the package cache.

    You can capture bound parameter values either via the client (CLI or JDBC) trace or with a detailed activity monitor.

Posting Permissions

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