14.1 sp412_trace_masks
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table contains a set of trace masks that define the level of diagnostic output that can be produced by a ServiceOptimizer process.
A trace mask consists of a set of trace levels as defined in sp420_trace_levels.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| trace_mask_no | number |  | |
| description | varchar2(50) |  | |
| trace_mask | number | |
Keys
primary key (trace_mask_no)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| trace_mask_no | Unique identifier of the trace mask. |
| description | Textual description of the trace mask. |
| trace_mask | Value of the trace mask. |
Preloaded Values
| trace_mask_no | description | trace_mask |
|---|---|---|
| 0 | Basic trace information (no protocol) | 63 |
| 1 | Basic trace information plus protocol | 575 |
| 2 | Debug1 + Optimizer trace enabled | 8831 |
| 3 | All debug trace enabled | 8959 |
| 4 | Basic trace, Debug1, ABS Search, Optimizer enabled | 10879 |
| 5 | Basic trace + hearbeat enabled | 1599 |
| 6 | Debug1, 2, 3, ABS search, Optimizer enabled | 8192 |
| 7 | Basic trace, ABS search, Optimizer trace enabled | 13886 |
| 8 | Debug1, 2, 3, Optimizer trace enabled | 9215 |
| 9 | System Monitor default' | 639 |
| 11 | All (0xFFFF) | 131071 |
| 12 | Basic + DEBUG1 + DATABASE | 16991 |