Ing. En Sistemas Computacionales

Table 2: Trace configuration parameters
 
Section | Parameter | Description | Values |
database | enabled | Active / not active | true | false |
  | log_filename | Path to the log-file. Forsystem audit only | String |
  | max_log_size | Maximum size of the log-file, before a new log-file will be generated (log rotation). For system audit only | Integer |
  | include_filter | Trace SQLstatements only, which satisfy the regular expression | String (regular expression) |
  | exclude_filter | Explicitly do not trace SQL statements, which satisfy the regular expression | String(regular expression) |
  | log_connections | Trace connect, disconnect operations | true | false |
  | connection_id | Enable trace for a particular attachment ID (CURRENT_CONNECTION) only. In case of0, enabled for all attachments | Integer |
  | log_transactions | Trace of transaction operations (start, commit, rollback) | true | false |
  | log_statement_prepare | Trace, when a statementgot prepared | true | false |
  | log_statement_free | Trace, when a statement got freed | true | false |
  | log_statement_start | Trace, when a statement got started | true | false |
  |log_statement_finish | Trace, when a statement finished its execution | true | false |
  | log_procedure_start | Trace, when a stored procedure got started | true | false |
  | log_procedure_finish |Trace, when execution of a stored procedure got finished | true | false |
  | log_trigger_start | Trace, when a trigger got started | true | false |
  | log_trigger_finish | Trace, when execution ofa trigger got finished | true | false |
  | log_context | Trace, when a user-defined context variable got set via RDB$SET_CONTEXT | true | false |
  | print_plan | Output the execution plan | true| false |
  | print_perf | Output of detailed performance statistics | true | false |
  | log_blr_requests | Trace of BLR requests | true | false |
  | print_blr | Output the BLR text | true...