Oracle8i hidden trace parameters Don Burleson

Note: Oracle hidden parameters are undocumented and unsupported by Oracle.
Make sure that you thoroughly test all hidden parameters before placing them in your production environment.

Parameter Name                            Description

----------------------------------------- ----------------------------------------------------------------

_trace_archive                            start DIAG process

_trace_buffer_flushes                     trace buffer flushes if otrace cacheIO event is set

_trace_buffer_gets                        trace kcb buffer gets if otrace cacheIO event is set

_trace_buffers                            trace buffer sizes per process

_trace_cr_buffer_creates                  trace cr buffer creates if otrace cacheIO event is set

_trace_events                             trace events enabled at startup

_trace_file_size                          maximum size of trace file (in number of trace records)

_trace_files_public                       Create publicly accessible trace files

_trace_flush_processes                    trace data archived by DIAG for these processes

_trace_instance_termination               trace instance termination actions

_trace_multi_block_reads                  trace multi_block reads if otrace cacheIO event is set

_trace_options                            trace data flush options

_trace_pin_time                           trace how long a current pin is held

_trace_processes                          enable KST tracing in process