Skip to main content

Tracing DB and SQL

  • trace_sql_normalize_enabled Boolean

    Default true

    It enables the function to normalize any SQL statements by extracting the literal part from each SQL statement. The literal part is denoted with "#."

  • profile_sql_param_enabled Boolean​

    Default false

    It is used to record SQL parameters in the transaction trace details. The parameters can be viewed by entering a separate security key.

    Note

    The security key is set to 6 characters within the WHATAP_HOME/paramkey.txt file where the whatap.conf file is located. If the paramkey.txt file does not exist, it is automatically created with a random value.