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.
NoteThe 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.