this is the output of ORADEBUG DOC for Version 19c.
SQL> oradebug doc
Internal Documentation
**********************
EVENT Help on events (syntax, event list, ...)
COMPONENT [<comp_name>] List all components or describe <comp_name>
oradebug doc event
SQL> oradebug doc event
Event Help:
***********
Formal Event Syntax
--------------------
<event_spec> ::= '<event_id> [<event_scope>]
[<event_filter_list>]
[<event_parameters>]
[<action_list>]
[off]'
<event_id> ::= <event_name | number>[<target_parameters>]
<event_scope> ::= [<scope_name>: scope_parameters]
<event_filter> ::= {<filter_name>: filter_parameters}
<action> ::= <action_name>(action_parameters)
<action_parameters> ::= <parameter_name> = [<value>|<action>][, ]
<*_parameters> ::= <parameter_name> = <value>[, ]
Some Examples
-------------
* Set event 10235 level 1:
alter session set events '10235';
* Set events SQL_TRACE (a.k.a. 10046) level 1:
alter session set events 'sql_trace';
* Turn off event SQL_TRACE:
alter session set events 'sql_trace off';
* Set events SQL_TRACE with parameter <plan_stat> set to 'never'
and parameter <wait> set to 'true':
alter session set events 'sql_trace wait=true, plan_stat=never';
* Trace in-memory the SQL_MONITOR component (the target) and all its
sub-components at level high. Get high resolution time for each
trace:
alter session set events 'trace[sql_mon.*] memory=high,
get_time=highres';
* On-disk trace PX servers p000 and p005 for components 'sql_mon'
and 'sql_optimizer' (including sub-components) at level highest:
alter system set events 'trace[sql_mon | sql_optimizer.*]
{process: pname = p000 | process: pname=p005}';
* Same as above but only when SQL id '7ujay4u33g337' is executed:
alter system set events 'trace[sql_mon | sql_optimizer.*]
[sql: 7ujay4u33g337]
{process: pname = p000 | process: pname=p005}';
* Execute an action immediatly by using 'immediate' for the event
name:
alter session set events 'immediate eventdump(system)'
* Create an incident labeled 'table_missing' when external error
942 is signaled by process id 14534:
alter session set events '942 {process: 14534}
incident(table_missing)';
Notes
-----
* Implicit parameter level is 1 by default
e.g. '10053' is same as '10053 level 1'
* Event target (see [<target_parameters>] construct) is only
supported by specific events like the TRACE[] event
* <event_scope> and/or <event_filter> are constructs
that can be used for any event
* Same event can be set simultaneously for a different scope or
target but not for different filters.
* '|' character can be used to select multiple targets, scope or
filters.
E.g. 'sql_trace [sql: sql_id=g3yc1js3g2689 | sql_id=7ujay4u33g337]'
* '=' sign is optional in <*_parameters>
E.g. 'sql_trace level 12';
* Like PL/SQL, no need to specify the parameter name for target,
scope, filters and action. Resolution is done by position in
that case:
E.g. 'sql_trace [sql: g3yc1js3g2689 | 7ujay4u33g337]'
Help sub-topics
---------------
NAME [<event_name>] List all events or describe <event_name>
SCOPE [<scope_name>] List all scopes or describe <scope_name>
FILTER [<filter_name>] List all filters or describe <filter_name>
ACTION [<action_name>] List all actions or describe <action_name>
SQL>
oradebug doc event name
SQL> oradebug doc event name
Events in library DIAG:
------------------------------
trace[] Main event to control UTS tracing
disable_dde_action[] Event used by DDE to disable actions
ams_trace[] Event to dump ams performance trace records
ams_rowsrc_trace[] Event to dump ams row source tracing
sweep_verification Event to enable sweep file verification
enable_xml_inc_staging Event to enable xml incident staging format
dbg[] Event to hook dbgtDbg logging statements
Events in library RDBMS:
------------------------------
wait_event[] event to control wait event post-wakeup actions
alert_text event for textual alerts
trace_recursive event to force tracing recursive SQL statements
clientid_overwrite event to overwrite client_identifier when client_info is set
sql_monitor event to force monitoring SQL statements
sql_monitor_test event to test SQL monitoring
eventsync_tac Event posted from events syncing tac
sql_trace event for sql trace
pmon_startup startup of pmon process
background_startup startup of background processes
db_open_begin start of db open operation
test_gvtf test GV$() Table Tunction
fault Event used to inject fault in RDBMS kernel
gcr_systest gcr_systest
em_express EM Express debug event
emx_control event to control em express
emx_test_control event to control em express testing
awrdiag[] AWR Diagnostic Event
msgq_trace event to control msgq tracing
ipclw_trace event to control ipclw tracing
kbc_fault event to control container fault injection
asm_corruption_trace event to control ASM corruption tracing
kxdrs_sim debug event to simulate certain conditions in kxdrs layer
kcfio_debug debug event to debug kcfio based on event level
krbabrstat_fault event to control krbabrstat fault injection
periodic_dump[] event for periodically dumping
kxdrs_log_for_wbfc debug event to log skipped extents for wbfc resilvering
clean_plsql_error_stack Event to clear ORA-06512s from the error stack
plsql_coverage_flag Event to set plsql coverage flag
Events in library GENERIC:
------------------------------
kg_event[] Support old error number events (use err# for short)
Events in library CLIENT:
------------------------------
oci_trace event for oci trace
Events in library LIBCELL:
------------------------------
libcell_stat libcell statistics level specification
cellclnt_skgxp_trc_ops Controls to trace SKGXP operations
cellclnt_ossnet_trc Controls to trace IP affinity in ossnet
cellclnt_high_lat_ops Control to trace High-latency I/O operations
diskmon_sim_ops[] Diskmon simulation events
cellclnt_read_outlier_limit Control to trace read I/O outliers
cellclnt_write_outlier_limit Control to trace write I/O outliers
cellclnt_lgwrite_outlier_limit Control to trace log write I/O outliers
cellclnt_sparse_mode Mode of how to handle sparse buffers
cellclnt_submission_recon Simulation period for forcing submission reconnect
Events in library FPLIB:
------------------------------
fgq_control fine grain quarantine control
Events in library ADVCMP:
------------------------------
arch_comp_level[] arch_comp_level[<ulevel, 1-7>]
ccmp_debug columnar compression debug event
inmemory_nobasic disable KDZCF_IMC_BASIC implementation
inmemory_nohybrid disable KDZCF_IMC_HYBRID implementation
ccmp_align columnar compression enable alignment
ccmp_countstar columnar compression enable count(*) optimization
ccmp_dumpunaligned columnar compression dump dbas of unaligned CUs
ccmp_rbtree columnar compression switch back to rb tree
inmemory_force_ccl inmemory force column compression levels
columnar_cache_config flash cash configuration event
inmemory_imcu[] inmemory_imcu[<ulevel= nocomp|dml|query_low|query_high|capacity_low|capacity_high>]
inmemory_nobitpacked_gd disable bit-packed GD codes in CU. Use ub4 instead
inmemory_dicthash enable storage of dictionary hash values in IMCU
inmemory_cache_joinopt inmemory cache join optimizations
inmemory_scan_joinopt join optimizations to use during scan
inmemory_compute_cachehash compute a hash vector when there is no cached hash
ifc_dump_block block rdba to dump in IFC
ifc_disable_scan_rid disable CC2 type scan when rowid is required
ifc_sim_version_mismatch simulate IFC version mismatch error
ifc_disable_col_crypto disable column level encryption/decryption
ifc_ulevel[] ifc_ulevel
inmemory_prefixdict enable prefix compression on dictionary encoded IMCU
inmemory_disable_dsb usage of stored DSB dictionary during scans
disable_skip_pdo Disable skipping KAFPDO columns during projection
inmemory_noime disable usage of IME in queries
Events in library PLSQL:
------------------------------
plsql_event[] Support PL/SQL error number events
Events in library VPLIB:
------------------------------
key_vector_debug key vector debug parameters
key_vector_diag key vector diagnostics parameters
key_vector_test key vector testing parameters
vector_groupby_test vector group by testing parameters
vector_groupby_debug vector group by debugging parameters
SQL> spool off;
Events in library DIAG:
SQL> oradebug doc event name trace
trace: Main event to control UTS tracing
Usage
-------
trace [ component <string>[0] ]
disk < default | lowest | low | medium | high | highest | disable >,
memory < default | lowest | low | medium | high | highest | disable >,
get_time < disable | default | seq | highres | seq_highres >,
get_stack < disable | default | force >,
operation <string>[32],
function <string>[32],
file <string>[32],
line <ub4>,
conuid <ub4>
SQL> oradebug doc event name disable_dde_action
disable_dde_action: Event used by DDE to disable actions
Usage
-------
disable_dde_action [ action_name <string>[100] ]
facility <string>[20],
error <ub4>
SQL> oradebug doc event name ams_trace
ams_trace: Event to dump ams performance trace records
Usage
-------
ams_trace [ relation <string>[30] ]
SQL> oradebug doc event name ams_rowsrc_trace
ams_rowsrc_trace: Event to dump ams row source tracing
Usage
-------
ams_rowsrc_trace [ relation <string>[30] ]
level <ub4>
SQL> oradebug doc event name sweep_verification
sweep_verification: Event to enable sweep file verification
Usage
-------
sweep_verification
level <ub4>
SQL> oradebug doc event name enable_xml_inc_staging
enable_xml_inc_staging: Event to enable xml incident staging format
Usage
-------
enable_xml_inc_staging
level <ub4>
SQL> oradebug doc event name dbg
dbg: Event to hook dbgtDbg logging statements
Usage
-------
dbg [ component <string>[0] ]
operation <string>[32],
function <string>[32],
file <string>[32],
line <ub4>
Events in library RDBMS:
SQL> oradebug doc event name wait_event
wait_event: event to control wait event post-wakeup actions
Usage
-------
wait_event [ name <string>[64] ]
SQL> oradebug doc event name alert_text
alert_text: event for textual alerts
Usage
-------
alert_text
ksd_fixed_table < disable | enable >
SQL> oradebug doc event name trace_recursive
trace_recursive: event to force tracing recursive SQL statements
Usage
-------
trace_recursive
SQL> oradebug doc event name clientid_overwrite
clientid_overwrite: event to overwrite client_identifier when client_info is set
Usage
-------
clientid_overwrite
SQL> oradebug doc event name sql_monitor
sql_monitor: event to force monitoring SQL statements
Usage
-------
sql_monitor
recursive < false | true >,
force < false | true >
SQL> oradebug doc event name sql_monitor_test
sql_monitor_test: event to test SQL monitoring
Usage
-------
sql_monitor_test
level <ub4>
SQL> oradebug doc event name eventsync_tac
eventsync_tac: Event posted from events syncing tac
Usage
-------
eventsync_tac
SQL> oradebug doc event name sql_trace
sql_trace: event for sql trace
Usage
-------
sql_trace
wait < false | true >,
bind < false | true >,
plan_stat < never | first_execution | all_executions | adaptive >,
level <ub4>
SQL> oradebug doc event name pmon_startup
pmon_startup: startup of pmon process
Usage
-------
pmon_startup
delay <ub4>
SQL> oradebug doc event name background_startup
background_startup: startup of background processes
Usage
-------
background_startup
delay <ub4>
SQL> oradebug doc event name db_open_begin
db_open_begin: start of db open operation
Usage
-------
db_open_begin
delay <ub4>
SQL> oradebug doc event name test_gvtf
test_gvtf: test GV$() Table Tunction
Usage
-------
test_gvtf
SQL> oradebug doc event name fault
fault: Event used to inject fault in RDBMS kernel
Usage
-------
fault
SQL> oradebug doc event name gcr_systest
gcr_systest: gcr_systest
Usage
-------
gcr_systest
action_type <string>[32],
total_memory <ub8>,
free_memory <ub8>,
inactive_memory <ub8>,
swap_space <ub8>,
total_swap_space <ub8>
SQL> oradebug doc event name em_express
em_express: EM Express debug event
Usage
-------
em_express
level <ub4>
SQL> oradebug doc event name emx_control
emx_control: event to control em express
Usage
-------
emx_control
web_caching < false | true >,
compress_xml < none | deflate | gzip | zlib2base64 >
SQL> oradebug doc event name emx_test_control
emx_test_control: event to control em express testing
Usage
-------
emx_test_control
capture_xml < stop | start >
SQL> oradebug doc event name awrdiag
awrdiag: AWR Diagnostic Event
Usage
-------
awrdiag [ name <string>[64] ]
level <ub4>,
str1 <string>[256],
str2 <string>[256],
num1 <ub8>,
num2 <ub8>
SQL> oradebug doc event name msgq_trace
msgq_trace: event to control msgq tracing
Usage
-------
msgq_trace
level <ub4>,
flag <ub4>
SQL> oradebug doc event name ipclw_trace
ipclw_trace: event to control ipclw tracing
Usage
-------
ipclw_trace
level <ub4>,
flag <ub4>
SQL> oradebug doc event name kbc_fault
kbc_fault: event to control container fault injection
Usage
-------
kbc_fault
location < create_end | commit_end >,
error < external | internal | segv | instance >
SQL> oradebug doc event name asm_corruption_trace
asm_corruption_trace: event to control ASM corruption tracing
Usage
-------
asm_corruption_trace
level <ub4>
SQL> oradebug doc event name kxdrs_sim
kxdrs_sim: debug event to simulate certain conditions in kxdrs layer
Usage
-------
kxdrs_sim
level <ub4>
SQL>
SQL> oradebug doc event name kcfio_debug
kcfio_debug: debug event to debug kcfio based on event level
Usage
-------
kcfio_debug
level <ub4>
SQL>
SQL> oradebug doc event name krbabrstat_fault
krbabrstat_fault: event to control krbabrstat fault injection
Usage
-------
krbabrstat_fault
location < allocation | chaina | modify | unchain | chainb >
SQL> oradebug doc event name periodic_dump
periodic_dump: event for periodically dumping
Usage
-------
periodic_dump [ name <string>[64] ]
level <ub4>,
seconds <ub4>,
lifetime <ub4>
SQL> oradebug doc event name kxdrs_log_for_wbfc
kxdrs_log_for_wbfc: debug event to log skipped extents for wbfc resilvering
Usage
-------
kxdrs_log_for_wbfc
level <ub4>
SQL>
SQL> oradebug doc event name clean_plsql_error_stack
clean_plsql_error_stack: Event to clear ORA-06512s from the error stack
Usage
-------
clean_plsql_error_stack
level <ub4>
SQL> oradebug doc event name plsql_coverage_flag
plsql_coverage_flag: Event to set plsql coverage flag
Usage
-------
plsql_coverage_flag
level <ub4>,
directory <string>[4096]
Events in library GENERIC:
SQL> oradebug doc event name kg_event
kg_event: Support old error number events (use err# for short)
Usage
-------
kg_event [ errno <ub4> ]
level <ub4>,
lifetime <ub4>,
armcount <ub4>,
traceinc <ub4>,
forever <ub4>
Events in library CLIENT:
SQL> oradebug doc event name oci_trace
oci_trace: event for oci trace
Usage
-------
oci_trace
level < default | lowest | low | medium | high | highest | disable >
Events in library LIBCELL:
oradebug doc event name <libcell_events> doesn't show any documentaion.
Events in library FPLIB:
SQL> oradebug doc event name fgq_control
Error: "fgq_control" not a known event/library name
Use <event_name>, <library_name> or <library_name>.<event_name>
Events in library ADVCMP:
SQL> oradebug doc event name arch_comp_level
arch_comp_level: arch_comp_level[<ulevel, 1-7>]
Usage
-------
arch_comp_level [ ulevel <ub4> ]
ilevel <ub8>,
sortcols <ub4>,
cusize <ub4>,
analyze_amt <ub4>,
analyze_rows <ub4>,
analyze_minrows <ub4>,
mincusize <ub4>,
maxcusize <ub4>,
mincurows <ub4>,
align <ub4>,
rowlocks <ub4>,
maxcuhpctfree <ub4>,
guarantee_rll <ub4>,
cla_stride <ub4>,
dict_cla_stride <ub4>,
wt_factor <ub4>
SQL> oradebug doc event name ccmp_debug
ccmp_debug: columnar compression debug event
Usage
-------
ccmp_debug
memcheck <ub4>,
dmlclose <ub4>,
lobupdates <ub4>,
diaglevel <ub4>,
projectonly <ub4>,
colcheck <ub4>,
minmaxcheck <ub4>,
debug_hpk <ub4>,
debug_ozip <ub4>,
subcu_pmethod <ub4>,
subcu_mmarr_ppct <ub4>,
subcu_hist_ppct <ub4>,
subcu_indenc_cpct <ub4>,
subcu_loop <ub4>,
debug_pcode <ub4>,
imc_row_buffer_off <ub4>
SQL> oradebug doc event name inmemory_nobasic
inmemory_nobasic: disable KDZCF_IMC_BASIC implementation
Usage
-------
inmemory_nobasic
SQL> oradebug doc event name inmemory_nohybrid
inmemory_nohybrid: disable KDZCF_IMC_HYBRID implementation
Usage
-------
inmemory_nohybrid
SQL> oradebug doc event name ccmp_align
ccmp_align: columnar compression enable alignment
Usage
-------
ccmp_align
SQL> oradebug doc event name ccmp_countstar
ccmp_countstar: columnar compression enable count(*) optimization
Usage
-------
ccmp_countstar
SQL> oradebug doc event name ccmp_dumpunaligned
ccmp_dumpunaligned: columnar compression dump dbas of unaligned CUs
Usage
-------
ccmp_dumpunaligned
SQL> oradebug doc event name ccmp_rbtree
ccmp_rbtree: columnar compression switch back to rb tree
Usage
-------
ccmp_rbtree
SQL> oradebug doc event name inmemory_force_ccl
inmemory_force_ccl: inmemory force column compression levels
Usage
-------
inmemory_force_ccl
maxulevel <ub4>,
pctcols <ub4>
SQL> oradebug doc event name columnar_cache_config
columnar_cache_config: flash cash configuration event
Usage
-------
columnar_cache_config
dict_reuse_threshold <ub4>
SQL> oradebug doc event name inmemory_imcu
inmemory_imcu: inmemory_imcu[<ulevel= nocomp|dml|query_low|query_high|capacity_low|capacity_high>]
Usage
-------
inmemory_imcu [ ulevel < invalid | nocomp | dml | query_low | query_high | capacity_low | capacity_high > ]
target_rows <ub4>,
source_maxbytes <ub4>
SQL> oradebug doc event name inmemory_nobitpacked_gd
inmemory_nobitpacked_gd: disable bit-packed GD codes in CU. Use ub4 instead
Usage
-------
inmemory_nobitpacked_gd
SQL> oradebug doc event name inmemory_dicthash
inmemory_dicthash: enable storage of dictionary hash values in IMCU
Usage
-------
inmemory_dicthash
SQL> oradebug doc event name inmemory_cache_joinopt
inmemory_cache_joinopt: inmemory cache join optimizations
Usage
-------
inmemory_cache_joinopt
cache_hash <ub4>,
cache_numbin <ub4>
SQL> oradebug doc event name inmemory_scan_joinopt
inmemory_scan_joinopt: join optimizations to use during scan
Usage
-------
inmemory_scan_joinopt
disable_cache_hash <ub4>,
disable_cache_numbin <ub4>
SQL> oradebug doc event name inmemory_compute_cachehash
inmemory_compute_cachehash: compute a hash vector when there is no cached hash
Usage
-------
inmemory_compute_cachehash
SQL> oradebug doc event name ifc_dump_block
ifc_dump_block: block rdba to dump in IFC
Usage
-------
ifc_dump_block
ifc_dump_rdba <ub4>
SQL> oradebug doc event name ifc_disable_scan_rid
ifc_disable_scan_rid: disable CC2 type scan when rowid is required
Usage
-------
ifc_disable_scan_rid
SQL> oradebug doc event name ifc_sim_version_mismatch
ifc_sim_version_mismatch: simulate IFC version mismatch error
Usage
-------
ifc_sim_version_mismatch
SQL> oradebug doc event name ifc_disable_col_crypto
ifc_disable_col_crypto: disable column level encryption/decryption
Usage
-------
ifc_disable_col_crypto
SQL> oradebug doc event name ifc_ulevel
ifc_ulevel: ifc_ulevel
Usage
-------
ifc_ulevel [ ifc ulevel <ub4> ]
ifc_analyzer_sample <ub4>
SQL> oradebug doc event name inmemory_prefixdict
inmemory_prefixdict: enable prefix compression on dictionary encoded IMCU
Usage
-------
inmemory_prefixdict
prefixdict_enable <ub4>,
prefixdict_savings <ub4>,
dict_ratio <ub4>
SQL> oradebug doc event name inmemory_disable_dsb
inmemory_disable_dsb: usage of stored DSB dictionary during scans
Usage
-------
inmemory_disable_dsb
disable_predicate <ub4>,
disable_projection <ub4>,
disable_aggregation <ub4>,
disable_adaptivity <ub4>
SQL> oradebug doc event name disable_skip_pdo
disable_skip_pdo: Disable skipping KAFPDO columns during projection
Usage
-------
disable_skip_pdo
SQL> oradebug doc event name inmemory_noime
inmemory_noime: disable usage of IME in queries
Usage
-------
inmemory_noime
Events in library PLSQL:
SQL> oradebug doc event name plsql_event
plsql_event: Support PL/SQL error number events
Usage
-------
plsql_event [ errno <ub4> ]
Events in library VPLIB:
oradebug doc event name
does not show any documentation.
oradebug doc event scope
Event scopes in library RDBMS:
SQL[] sql scope for RDBMS
QUEUE[] queue scope AQ
SQL> oradebug doc event scope sql
SQL: sql scope for RDBMS
Usage
-------
[SQL: sql_id <string>[20] ]
SQL> oradebug doc event scope queue
QUEUE: queue scope AQ
Usage
-------
[QUEUE: queue_name <string>[0] ]
oradebug doc event filter
Event filters in library DIAG:
------------------------------
occurence filter to implement counting for event checks
callstack filter to only fire an event when a function is on the stack.If the nofname option is used, then the event is fired only when the function is not on the stack
eq filter to only fire an event when a == b
ne filter to only fire an event when a != b
gt filter to only fire an event when a > b
lt filter to only fire an event when a < b
ge filter to only fire an event when a >= b
le filter to only fire an event when a <= b
anybit filter to only fire an event when (a & b) != 0
allbit filter to only fire an event when (a & b) == b
nobit filter to only fire an event when (a & b) == 0
bet filter to only fire an event when b <= a <= c
nbet filter to only fire an event when a < b or a > c
in filter to only fire an event when a is equal to any b .. p
nin filter to only fire an event when a is not equal to any b .. p
streq filter to only fire an event when string s1 = s2 (up to <len> characters)
strne filter to only fire an event when string s1 != s2 (up to <len> characters)
tag filter to only fire an event when a tag is set
Event filters in library RDBMS:
------------------------------
wait filter for specific wait parameters and wait duration
process filter to set events only for a specific process
px filter to check identity of the process for fault injection
Event filters in library GENERIC:
------------------------------
errarg filter to set error events only for a specific error argument
Event filters in library DIAG:
SQL> oradebug doc event filter occurence
occurence: filter to implement counting for event checks
Usage
-------
{occurence: start_after <ub4>,
end_after <ub4> }
SQL> oradebug doc event filter callstack
callstack: filter to only fire an event when a function is on the stack.If the nofname option is used, then the event is fired only when the function is not on the stack
Usage
-------
{callstack: fname <string>[64],
fprefix <string>[64],
maxdepth <ub4>,
nofname <string>[64] }
SQL> oradebug doc event filter eq
eq: filter to only fire an event when a == b
Usage
-------
{eq: a <ub8>,
b <ub8> }
SQL> oradebug doc event filter ne
ne: filter to only fire an event when a != b
Usage
-------
{ne: a <ub8>,
b <ub8> }
SQL> oradebug doc event filter gt
gt: filter to only fire an event when a > b
Usage
-------
{gt: a <ub8>,
b <ub8> }
SQL> oradebug doc event filter lt
lt: filter to only fire an event when a < b
Usage
-------
{lt: a <ub8>,
b <ub8> }
SQL> oradebug doc event filter ge
ge: filter to only fire an event when a >= b
Usage
-------
{ge: a <ub8>,
b <ub8> }
SQL> oradebug doc event filter le
le: filter to only fire an event when a <= b
Usage
-------
{le: a <ub8>,
b <ub8> }
SQL> oradebug doc event filter anybit
anybit: filter to only fire an event when (a & b) != 0
Usage
-------
{anybit: a <ub8>,
b <ub8> }
SQL> oradebug doc event filter allbit
allbit: filter to only fire an event when (a & b) == b
Usage
-------
{allbit: a <ub8>,
b <ub8> }
SQL> oradebug doc event filter nobit
nobit: filter to only fire an event when (a & b) == 0
Usage
-------
{nobit: a <ub8>,
b <ub8> }
SQL> oradebug doc event filter bet
bet: filter to only fire an event when b <= a <= c
Usage
-------
{bet: a <ub8>,
b <ub8>,
c <ub8> }
SQL> oradebug doc event filter nbet
nbet: filter to only fire an event when a < b or a > c
Usage
-------
{nbet: a <ub8>,
b <ub8>,
c <ub8> }
SQL> oradebug doc event filter in
in: filter to only fire an event when a is equal to any b .. p
Usage
-------
{in: a <ub8>,
b <ub8>,
c <ub8>,
d <ub8>,
e <ub8>,
f <ub8>,
g <ub8>,
h <ub8>,
i <ub8>,
j <ub8>,
k <ub8>,
l <ub8>,
m <ub8>,
n <ub8>,
o <ub8>,
p <ub8> }
SQL> oradebug doc event filter nin
nin: filter to only fire an event when a is not equal to any b .. p
Usage
-------
{nin: a <ub8>,
b <ub8>,
c <ub8>,
d <ub8>,
e <ub8>,
f <ub8>,
g <ub8>,
h <ub8>,
i <ub8>,
j <ub8>,
k <ub8>,
l <ub8>,
m <ub8>,
n <ub8>,
o <ub8>,
p <ub8> }
SQL> oradebug doc event filter streq
streq: filter to only fire an event when string s1 = s2 (up to <len> characters)
Usage
-------
{streq: s1 <string>[256],
s2 <string>[256],
len <ub4> }
SQL> oradebug doc event filter strne
strne: filter to only fire an event when string s1 != s2 (up to <len> characters)
Usage
-------
{strne: s1 <string>[256],
s2 <string>[256],
len <ub4> }
SQL> oradebug doc event filter tag
tag: filter to only fire an event when a tag is set
Usage
-------
{tag: tname <string>[64] }
Event filters in library RDBMS:
SQL> oradebug doc event filter wait
wait: filter for specific wait parameters and wait duration
Usage
-------
{wait: minwait <ub8>,
p1 <ub8>,
p2 <ub8>,
p3 <ub8>,
_actual_wait_time <ub8> default 'evargn(pos=1)',
_actual_wait_p1 <ub8> default 'evargn(pos=2)',
_actual_wait_p2 <ub8> default 'evargn(pos=3)',
_actual_wait_p3 <ub8> default 'evargn(pos=4)' }
SQL> oradebug doc event filter process
process: filter to set events only for a specific process
Usage
-------
{process: ospid <string>[20],
orapid <ub4>,
pname <string>[20],
con_id <ub8> }
SQL> oradebug doc event filter px
px: filter to check identity of the process for fault injection
Usage
-------
{px: slave_set <ub4>,
slave_num <ub4>,
local_slave_num <ub4>,
instance_id <ub4>,
dfo_number <ub4>,
oct <ub4>,
pxid <ub4> }
Event filters in library GENERIC:
SQL> oradebug doc event filter errarg
errarg: filter to set error events only for a specific error argument
Usage
-------
{errarg: arg1 <string>[50],
arg2 <string>[50],
arg3 <string>[50],
arg4 <string>[50],
arg5 <string>[50],
arg6 <string>[50],
arg7 <string>[50],
arg8 <string>[50] }
ORADEBUG DOC EVENT ACTION
Actions in library DIAG:
---------------------------
evfunc - Get posting function name
evfile - Get posting file name
evline - Get posting file line number as ub8
evfmt - Get trace / log format string
evargc - Get count of event check arguments as a ub8
evargn - Get event check argument value as ub8
evargp - Get event check argument value as void *
evargs
- Get event check argument as string, with optional format
errargs - Get error argument as string
errargn - Get error argument as ub8
errargp - Get error argument as pointer
errargc - Get count of error arguments as a ub8
sum
- Compute a1 + a2 + ... + a15 as ub8 (zero if all NULL)
trace
- trace to disk; apply format to string arguments
% is an argument placeholder
\n and \t are supported. Use double \ as escape
sub - Compute a1 - a2 as ub8
add - Compute a1 + a2 as ub8
mod - Compute a1 modulo a2 as ub8
div - Compute a1 / a2 as ub8
mul - Compute a1 * a2 as ub8
incr - Increment ptr by offset
decr - Decrement ptr by offset
refn
- Dereference ptr-to-number: *(ub<numsize>*)(((ub1*)<ptr>)) + <offset>)
refp
- Dereference ptr-to-ptr: *(ub1**)(((ub1*)<ptr>)) + <offset>)
refs
- Dereference ptr-to-string: *(oratext **)(((ub1*)<ptr>) + <offset>)
Length is optional; NULL-terminated string is assumed
refsl
- Dereference ptr-to-string: *(oratext **)(((ub1*)<ptr>) + <offset>)
with ptr-to-length: *(ub<lensize>*)(((ub1*)<ptr>) + <lenoffset>)
dumpFrameContext - Dump Frame Context contents
dumpBuckets
kgsfdmp
dumpDiagCtx
dumpDbgecPopLoc
dumpDbgecMarks
dumpGeneralConfiguration
dumpADRLockTable
shortstack
- get short stack (up to 256 characters)
showoffsets controls display of code offsets
skipframes can be used to overcome 256 char limit
dump_dis_action
dbgvci_action_signal_crash
Actions in library RDBMS:
---------------------------
incident - Create an Incident
sqlmon_dump - SQL Monitor Dump SGA Action
varaddr - Return address of a fixed PGA/SGA/UGA variable
username - Return user log-in name
sqlid - Return current SQL Id in character format
flashfreeze
oradebug - debug process using ORADEBUG
debugger - debug process using System Debugger
debug
- alias for 'debugger' - debug process using System Debugger
crash - crash process
kill_instance - killing RDBMS instance
controlc_signal - received 1013 signal
eventdump - list events that are set in the group
kdlut_bucketdump_action
kzxtDumpAction
dumpKernelDiagState
HMCHECK (async)
DATA_BLOCK_INTEGRITY_CHECK (async)
CF_BLOCK_INTEGRITY_CHECK (async)
DB_STRUCTURE_INTEGRITY_CHECK (async)
REDO_INTEGRITY_CHECK (async)
TRANSACTION_INTEGRITY_CHECK (async)
SQL_TESTCASE_REC (async)
SQL_TESTCASE_REC_DATA (async)
ORA_12751_DUMP
sqladv_dump_dumpctx
ORA_4030_DUMP
- dump summary of PGA memory usage, largest allocations
ORA_4036_DUMP - dump summary of PGA memory usage
HNGDET_MEM_USAGE_DUMP_NOARGS - dump hang detection memory usage
kcfis_action - kcfis actions
exadata_dump_modvers - Exadata dump module versions
QUERY_BLOCK_DUMP - Debug action for dumping a qbcdef tree
dumpADVMState - Dump contents of ADVM state
dumpASMState - Dump contents of ASM state
ASM_CHECK_DG (async) - Run check diskgroup
ASM_DUMP_KSTSS - Dump KST Trace and System State
ASM_MOUNT_FAIL_CHECK (async)
ASM_DGFDM_CHECK_NO_DG_NAME (async)
ASM_SYNC_IO_FAIL_CHECK (async)
ASM_DG_FORCE_DISMOUNT_CHECK (async)
ASM_ALLOC_FAIL_CHECK (async)
ASM_ADD_DISK_CHECK (async)
ASM_FILE_BUSY_CHECK (async)
ASM_TOOMANYOFF_FAIL_CHECK (async)
ASM_INSUFFICIENT_DISKS_CHECK (async)
ASM_INSUFFICIENT_MEM_CHECK (async)
KJZN_ASYNC_SYSTEM_STATE (async)
KSI_GET_TRACE - Get lmd0 traces for ksi issues
TRACE_BUFFER_ON - Allocate trace output buffer for ksdwrf()
TRACE_BUFFER_OFF
- Flush and deallocate trace output buffer for ksdwrf()
LATCHES - Dump Latches
XS_SESSION_STATE - Dump XS session state
PROCESSSTATE - Dump process state
SYSTEMSTATE - Dump system state
INSTANTIATIONSTATE - Dump instantiation state
CONTEXTAREA - Dump cursor context area
HEAPDUMP
- Dump memory heap (1-PGA, 2-SGA, 4-UGA, +1024-Content)
SGA_SUMMARY
- Dump SGA Summary(<=1-SGA, 2-Large Pool, 4-Streams, 8-Java, 16-Extents)
POKE_LENGTH - Set length before poking value
POKE_VALUE - Poke a value into memory
POKE_VALUE0 - Poke 0 value into memory
GLOBAL_AREA
- Dump fixed global area(s) (1=PGA/2=SGA/3=UGA, add +8 for pointer content)
REALFREEDUMP - Dump PGA real free memory allocator state
FLUSH_JAVA_POOL - Flush Java pool
PGA_DETAIL_GET
- Ask process to publish PGA detail info (level is pid)
PGA_DETAIL_DUMP
- Dump PGA detail information for process (level is pid)
PGA_DETAIL_CANCEL - Free PGA detail request (level is pid)
PGA_SUMMARY - Summary of PGA memory usage, largest allocations
MODIFIED_PARAMETERS - Dump parameters modifed by session (level unused)
ERRORSTACK
- Dump state (ksedmp). Use INCIDENT action to create incident
CALLSTACK - Dump call stack (level > 1 to dump args)
RECORD_CALLSTACK
- Record or dump call stack, level = #frames (level += 1000000 go to trc)
BG_MESSAGES - Dump routine for background messages
ENQUEUES
- Dump enqueues (level >=2 adds resources, >= 3 adds locks)
KSTDUMPCURPROC
- Dump current process trace buffer (1 for all events)
KSTDUMPALLPROCS
- Dump all processes trace buffers (1 for all events)
KSTDUMPALLPROCS_CLUSTER
- Dump all processes (cluster wide) trace buffers (1 for all events)
KSKDUMPTRACE - Dumping KSK KST tracing (no level)
DBSCHEDULER - Dump ressource manager state
LDAP_USER_DUMP - Dump LDAP user mode
LDAP_KERNEL_DUMP - Dump LDAP kernel mode
DUMP_ALL_OBJSTATS - Dump database objects statistics
DUMPGLOBALDATA - Rolling migration DUMP GLOBAL DATA
HANGANALYZE - Hang analyze
HANGANALYZE_PROC - Hang analyze current process
HANGANALYZE_GLOBAL - Hang analyze system
HNGDET_MEM_USAGE_DUMP - dump hang detection memory usage
GES_STATE - Dump DML state
RACDUMP - Dump RAC state
OCR - OCR client side tracing
CSS - CSS client side tracing
CRS - CRS client side tracing
SYSTEMSTATE_GLOBAL - Perform cluster wide system state dump (via DIAG)
DUMP_ALL_COMP_GRANULE_ADDRS
- MMAN dump all granule addresses of all components (no level)
DUMP_ALL_COMP_GRANULES
- MMAN dump all granules of all components (1 for partial list)
DUMP_ALL_REQS
- MMAN dump all pending memory requests to alert log
DUMP_TRANSFER_OPS - MMAN dump transfer and resize operations history
DUMP_ADV_SNAPSHOTS
- MMAN dump all snapshots of advisories (level unused)
CONTROLF - DuMP control file info
FLUSH_CACHE
- Flush buffer cache without shuting down the instance
SET_AFN - Set afn # for buffer flush (level = afn# )
SET_ISTEMPFILE
- Set istempfile for buffer flush (level = istempfile )
FLUSH_BUFFER - Reuse block range without flushing entire cache
BUFFERS - Dump all buffers in the buffer cache at level l
SET_TSN_P1
- Set tablespace # for buffer dump (level = ts# + 1)
BUFFER
- Dump all buffers for full relative dba <level> at lvl 10
BC_SANITY_CHECK
- Run buffer cache sanity check (level = 0xFF for full)
SET_NBLOCKS - Set number of blocks for range reuse checks
CHECK_ROREUSE_SANITY - Check range/object reuse sanity (level = ts#)
DUMP_PINNED_BUFFER_HISTORY
- kcb Dump pinned buffers history (level = # buffers)
REDOLOGS - Dump all online logs according to the level
LOGHIST
- Dump the log history (1: dump earliest/latest entries, >1: dump most recent 2**level entries)
REDOHDR - Dump redo log headers
LOCKS - Dump every lock element to the trace file
GC_ELEMENTS - Dump every lock element to the trace file
FILE_HDRS - Dump database file headers
FBINC
- Dump flashback logs of the current incarnation and all its ancestors.
FBHDR - Dump all the flashback logfile headers
FLASHBACK_GEN - Dump flashback generation state
KTPR_DEBUG
- Parallel txn recovery (1: cleanup check, 2: dump ptr reco ctx, 3: dump recent smon runs)
DUMP_TEMP - Dump temp space management state (no level)
DROP_SEGMENTS - Drop unused temporary segments
TREEDUMP
- Dump an index tree rooted at dba BLOCKDBA (<level>)
KDLIDMP - Dump 11glob inodes states (level = what to dump)
ROW_CACHE - Dump all cache objects
LIBRARY_CACHE
- Dump the library cache (level > 65535 => level = obj @)
CURSORDUMP - Dump session cursors
CURSOR_STATS - Dump all statistics information for cursors
SHARED_SERVER_STATE - Dump shared server state
LREG_STATE - Dump listener registration state
JAVAINFO - Dump Oracle Java VM
KXFPCLEARSTATS - Clear all Parallel Query messaging statistics
KXFPDUMPTRACE - Dump Parallel Query in-memory traces
KXFXSLAVESTATE
- Dump PX slave state (1: uga; 2: current cursor state; 3: all cursors)
KXFXCURSORSTATE - Dump PX slave cursor state
WORKAREATAB_DUMP - Dump SQL Memory Manager workarea table
OBJECT_CACHE - Dump the object cache
SAVEPOINTS - Dump savepoints
RULESETDUMP - Dump rule set
FAILOVER - Set condition failover immediate
OLAP_DUMP - Dump OLAP state
AWR_FLUSH_TABLE_ON
- Enable flush of table id <level> (ids in X$KEWRTB)
AWR_FLUSH_TABLE_OFF
- Disable flush of table id <level> (ids in X$KEWRTB)
AWR_DEBUG_FLUSH_TABLE_ON
- Enable debug of flushing the table with id <level> (ids in X$KEWRTB)
AWR_DEBUG_FLUSH_TABLE_OFF
- Disable debug of flushing the table with id <level> (ids in X$KEWRTB)
ASHDUMP - Dump ASH data (level = # of minutes)
ASHDUMPSECONDS - Dump ASH data (level = # of seconds)
HM_FW_TRACE - DIAG health monitor set tracing level
IR_FW_TRACE - DIAG intelligent repair set/clear trace
GWM_TRACE - Global Services Management set/clear trace
GWM_TEST - Global Services Management set/clear GDS test
GLOBAL_BUFFER_DUMP - Request global buffer dump (level 1 = TRUE)
KDFSDMP - Dump dbfs c-api states (level = what to dump)
DEAD_CLEANUP_STATE - Dump dead processes and killed sessions
IMDB_PINNED_BUFFER_HISTORY
- Dump IMDB pinned buffer history (level = (dump_level << 16 | num_buffers))
SLOCK_DUMP - Dump s-lock resources globally
STATE_OBJECT_DELETION_TIME - Dump state object deletion times
HEAPDUMP_ADDR
- Heap dump by address routine (level > 1 dump content)
POKE_ADDRESS - Poke specified address (level = value)
CURSORTRACE
- Trace cursor by hash value (hash value is address)
RULESETDUMP_ADDR - Dump rule set by address
kewmdump - Dump Metrics Metadata and Memory
con_id - Return Container Id as UB8
DBGT_SPLIT_CSTSTRING
DUMP_SWAP - dump system memory and swap information
ALERT_SWAP - issue alert message about system swap percentage
DUMP_PATCH - dump patch information
dumpBucketsRdbms
dumpKSIPCState - Dump KSIPC State
dumpKSTBuffers - Dump KST Buffers
rfrdm_dump_state - Dump DG Broker State
FLUSH_DBREPLAY_CAPTURE_BUFFER - Flush Database Replay capture buffer
Actions in library GENERIC:
---------------------------
xdb_dump_buckets
dumpKGERing - Dump contents of KGE ring buffer
dumpKGEIEParms - Dump memory around internal error parameters
dumpKGEState - Dump KGE state information for debugging
Actions in library CLIENT:
---------------------------
kpuActionDefault - dump OCI data
kpuActionSignalCrash
- crash and produce a core dump (if supported and possible)
kpudpaActionDpapi - DataPump dump action
oradebug doc component
Components in library DIAG:
--------------------------
diag_uts Unified Tracing Service (dbgt, dbga)
uts_vw UTS viewer toolkit (dbgtp, dbgtn)
diag_adr Automatic Diagnostic Repository (dbgr)
ams_comp ADR Meta-data Repository (dbgrm)
ame_comp ADR Export/Import Services (dbgre)
ami_comp ADR Incident Meta-data Services (dbgri)
diag_ads Diagnostic Directory and File Services (dbgrf, sdbgrf, sdbgrfu, sdbgrfb)
diag_hm Diagnostic Health Monitor ((null))
diag_ips Diagnostic Incident Packaging System ((null))
diag_dde Diagnostic Data Extractor (dbge)
diag_fmwk Diagnostic Framework (dbgc)
diag_ilcts Diagnostic Inter-Library Compile-time Service (dbgf)
diag_attr Diagnostic Attributes Management ((null))
diag_comp Diagnostic Components Management ((null))
diag_testp Diagnostic component test parent (dbgt)
diag_testc1 Diagnostic component test child 1 ((null))
diag_testc2 Diagnostic component test child 2 ((null))
KGSD Kernel Generic Service Debugging (kgsd)
diag_events Diagnostic Events (dbgd)
diag_adl Diagnostic ARB Alert Log (dbgrl, dbgrlr)
diag_vwk Diagnostic viewer toolkit (dbgv)
diag_vwk_parser Diagnostic viewer parser (dbgvp, dbgvl)
diag_vwk_uts Diagnostic viewer for UTS traces and files (dbgvf)
diag_vwk_ams Diagnostic viewer for AMS metadata (dbgvm)
diag_vwk_ci Diagnostic viewer for command line (dbgvci)
kghsc KGHSC Compact Stream (kghsc)
dbgxtk DBGXTK xml toolkit (dbgxtk)
KDIZOLTP ADV HIGH Index (kdizoltp)
Components in library RDBMS:
--------------------------
SQL_Compiler SQL Compiler ((null))
SQL_Parser SQL Parser (qcs)
SQL_Semantic SQL Semantic Analysis (kkm)
SQL_Optimizer SQL Optimizer ((null))
SQL_Transform SQL Transformation (kkq, vop, nso)
SQL_MVRW SQL Materialized View Rewrite ((null))
SQL_VMerge SQL View Merging (kkqvm)
SQL_Virtual SQL Virtual Column (qksvc, kkfi)
SQL_APA SQL Access Path Analysis (apa)
SQL_Costing SQL Cost-based Analysis (kko, kke)
SQL_Parallel_Optimization SQL Parallel Optimization (kkopq)
Vector_Processing Vector Processing (kkevp)
SQL_Plan_Management SQL Plan Managment (kkopm)
SQL_Plan_Directive SQL Plan Directive (qosd)
SQL_Optimizer_Stats SQL Optimizer Statistics (qos)
SQL_Optimizer_Stats_Advisor SQL Optimizer Statistics Advisor (qosadv)
SQL_Quarantine SQL Quarantine (qsfc)
SQL_Code_Generator SQL Code Generator (qka, qkn, qke, kkfd, qkx)
SQL_Parallel_Compilation SQL Parallel Compilation (kkfd)
SQL_Expression_Analysis SQL Expression Analysis (qke)
SQL_Rowsets_Setup SQL Rowsets Setup (qknr)
MPGE MPGE (qksctx)
ADS ADS (kkoads)
ICDT_Compile In Memory CDT Compilation (qks3t)
Shard_Sql Shard Sql (kkoshd)
AQP AQP (kkodp, qesdp, qersc)
PTF_Comp Polymorphic Table Functions Compilation (qksptf)
SQL_Execution SQL Execution (qer, qes, kx, qee)
Parallel_Execution Parallel Execution (qerpx, qertq, kxfr, kxfx, kxfq, kxfp)
PX_Messaging Parallel Execution Messaging (kxfp)
PX_Group Parallel Execution Slave Group (kxfp)
PX_Affinity Parallel Affinity (ksxa)
PX_Buffer Parallel Execution Buffers (kxfpb)
PX_Granule Parallel Execution Granules (kxfr)
PX_Control Parallel Execution Control (kxfx)
PX_Table_Queue Parallel Execution Table Queues (kxfq)
PX_Scheduler Parallel Execution Scheduler (qerpx)
PX_Queuing Parallel Execution Queuing (kxfxq)
PX_Blackbox Parallel Execution Blackbox (kxf)
PX_PTL Parallel Execution PTL (kxft)
PX_Expr_Eval Parallel Execution Expression Evaluation ((null))
PX_Selector Parallel Execution PX Selector (qerpsel)
PX_Overhead Parallel Execution Overhead (qerpx, kxfr, kxfx, kxfp)
Bloom_Filter Bloom Filter (qerbl, qesbl)
Time_Limit Query Execution Time Limit (opiexe, qerst)
ICDT_Exec In Memory CDT Execution (qes3t, kxtt)
EXECUTE_TEMP_TABLE Execute Temp Table (kxtt)
SQL_Trace SQL Trace (kxst, xpl)
PTF_Exec Polymorphic Table Functions Execution (qerptf)
Result_Cache Result Cache (qesrc, qerrc)
PGA_Manage PGA Memory Management ((null))
PGA_Compile PGA Memory Compilation ((null))
PGA_IMM PGA Memory Instance Manage ((null))
PGA_CMM PGA Memory Cursor Manage ((null))
PGA_ADV PGA Memory Advisor ((null))
rdbms_dde RDBMS Diagnostic Data Extractor (dbke)
VOS VOS (ks)
hang_analysis Hang Analysis (ksdhng)
background_proc Background Processes (ksb, ksbt)
system_param System Parameters (ksp, kspt)
ksu Kernel Service User (ksu)
ksutac KSU Timeout Actions ((null))
ksv_trace Kernel Services Slave Management (ksv)
file File I/O (ksfd, ksfdaf)
ksq Kernel Service Enqueues (ksq)
ksolt_trace Kernel Services Lightweight Threads (ksolt)
KSIM Kernel Service Instance Management (ksim)
KSIM_GRPOP Kernel Service Instance Management Group Operation ((null))
KSIPC VOS IPC (ksipc)
KSMSQ Message queue services (ksmsq)
KSMSQ_MQL Message Queueing Layer ((null))
KSRMA ksrma (ksrma)
KSRMF ksrmf (ksrmf)
KSIPC_AM Active Messaging ((null))
KSIPC_GRP KSIPC Group Services ((null))
KSIPC_SN KSIPC Shared Nothing ((null))
KSIPC_KV KSIPC Key Value ((null))
KSIPC_TOPO KSIPC Topology Services ((null))
KSIPC_PR KSIPC Path Record ((null))
KSIPC_IPCLW IPC LightWeight ((null))
KSIPC_IPCOR IPC Core Functionality ((null))
KSIPC_SHREG KSIPC Shared Registration ((null))
KSIPC_ASPC KSIPC Address space Map ((null))
KSIPCENV KSIPC Memory Allocations on Different Sockets (ksipcenv)
KSXP Cross Instance IPC (KSXP)
LREG Listener Registration (kml)
ksupd KSU Planned Draining (ksupd)
state_object State Objects (kss)
sess_signature Session Signature (ksusgn)
sql_mon SQL Monitor (keswx)
sql_mon_deamon SQL Monitor Deamon ((null))
sql_mon_query SQL Monitor Query ((null))
CACHE_RCV Cache Recovery (kcv, kct, kcra, kcrp, kcb)
DLF Delayed Log Force ((null))
MBR Multi-Block Read ((null))
DIRPATH_LOAD Direct Path Load (kl, kdbl, kpodp)
DIRPATH_LOAD_BIS Direct Path Kpodpbis Routine (kpodp)
RAC Real Application Clusters ((null))
GES Global Enqueue Service ((null))
KSI Kernel Service Instance locking (ksi)
RAC_ENQ Enqueue Operations ((null))
DD GES Deadlock Detection ((null))
RAC_BCAST Enqueue Broadcast Operations ((null))
RAC_FRZ DLM-Client Freeze/Unfreeze (kjfz)
KJOE DLM Omni Enqueue service (kjoe)
GCS Global Cache Service (kjb)
GCS_BSCN Broadcast SCN (kjb, kcrfw)
GCS_READMOSTLY GCS Read-mostly (kjb)
GCS_READER_BYPASS GCS Reader Bypass (kjb)
GCS_DELTAPUSH GCS Delta Push (kjb)
GCS_PCL2 Persistent cluster flash cache (kjbfp)
GSIPC Global Enqueue/Cache Service IPC ((null))
RAC_RCFG Reconfiguration ((null))
RAC_DRM Dynamic Remastering ((null))
RAC_MRDOM Multiple Recovery Domains ((null))
MRDOM_ESM Multiple/PDB Domains - Enter/Exit Server Mode (kjs, kjfz)
CGS Cluster Group Services (kjxg)
CGSIMR Instance Membership Recovery (kjxgr)
RAC_WLM Work Load Management (wlm)
RAC_MLMDS RAC Multiple LMS (kjm)
RAC_KA Kernel Accelerator (kjk)
RAC_LT RAC Latch Usage ((null))
RAC_SLOCK SLOCK Optimisation ((null))
KJSC RAC global stats (kjsc)
LMHB Heartbeat Monitoring (kjfm)
db_trace RDBMS server only tracing ((null))
kst server trace layer tracing (kst)
ddedmp RDBMS Diagnostic Data Extractor Dumper (dbked)
cursor Shared Cursor (kxs, kks)
Bind_Capture Bind Capture Tracing ((null))
KKSH Cursor Hash Table Tracing (kksh)
KSM Kernel Service Memory (ksm)
KSE Kernel Service Error Manager (kse)
explain SQL Explain Plan (xpl)
rdbms_event RDBMS Events (dbkd)
LOB_INODE Lob Inode (kdli)
rdbms_adr RDBMS ADR (dbkr)
ASM Automatic Storage Management (kf)
KFK KFK (kfk)
KFKIO KFK IO (kfkio)
KFKIO_COUNT KFK IO count ((null))
KFKIO_CANCEL KFK IO cancel ((null))
KFKIO_HARD KFK IO hard errors ((null))
KFKIO_SPLIT KFK IO split ((null))
KFKIO_MISC KFK IO miscellaneous ((null))
KFKSB KFK subs (kfksubs)
KFKSB_LIB KFK subs libraries ((null))
KFKSB_DM KFK subs disk management ((null))
KFKS KFK SAGE (kfks)
KFN ASM Networking subsystem (kfn)
KFNU ASM Umbillicus (kfnm, kfns, kfnb)
KFNS ASM Server networking (kfns)
KFNC ASM Client networking (kfnc)
KFNOR KFN orion (kfnor)
KFIS ASM Intelligent Storage interfaces (kfis)
KFM ASM Node Monitor Interface Implementation (kfm)
KFMD ASM Node Monitor Layer for Diskgroup Registration (kfmd)
KFMS ASM Node Monitor Layers Support Function Interface (kfms)
KFFB ASM Metadata Block (kffb)
KFFD ASM Metadata Directory (kffd)
KFZ ASM Zecurity subsystem (kfz)
KFC ASM Cache (kfc)
KFR ASM Recovery (kfr)
KFE ASM attributes (kfe)
KFDP ASM PST (kfdp)
KFG ASM diskgroups (kfg)
KFGB ASM diskgroups background (kfgb)
KFDS ASM staleness registry and resync (kfds)
KFIA ASM Remote (kfia)
KFIAS ASM IOServer (kfias)
KFIAC ASM IOServer client (kfiac)
KFFSCRUB ASM Scrubbing (kffscrub)
KFIO ASM translation I/O layer (kfio)
KFIOER ASM translation I/O layer (kfioer)
KFV ASM Volume subsystem (kfv)
KFVSU ASM Volume Umbilicus (kfvsu)
KFVSD ASM Volume Background (kfvsd)
KFVIOC ASM Volume Cell Storage (kfvioc)
KFDX ASM Exadata interface (kfdx)
KFZP ASM Password File Layer (kfzp)
KFA ASM Alias Operations (kfa)
KFF KFF (kff)
KFD ASM Disk (kfd)
KFDVA ASM Virtual ATB (kfdva)
KFTHA ASM Transparent High Availability (kftha)
KFFG ASM File Group (kffg)
KFFS ASM Split Mirror Operations (kffs)
KFIOS KFIO Simple (kfios)
DML DML Drivers (ins, del, upd)
Health_Monitor Health Monitor ((null))
DRA Data Repair Advisor ((null))
DIRACC Direct access to fixed tables (kqfd)
PART Partitioning (kkpo, qespc, qesma, kkpa, qergi)
PART_IntPart Interval Partitioning ((null))
PART_Dictionary Partitioning Dictionary (kkpod)
LOB_KDLW Lob kdlw (kdlw)
LOB_KDLX Lob xfm (kdlx)
LOB_KDLXDUP Lob dedup (kdlxdup)
LOB_KDLRCI Lob rci (kdlrci)
LOB_KDLA SecureFile Archive (kdla)
SQL_Manage SQL Manageability (kes)
SQL_Manage_Infra Other SQL Manageability Infrastructure (kesai, kesqs, kesatm, kesutl, kessi, keswat, keswts, keswsq)
SQL_Tune SQL Tuning Advisor (kest)
SQL_Tune_Auto SQL Tuning Advisor (auto-tune) (kestsa)
Auto_Tune_Opt Auto Tuning Optimizer (kkoat)
SQL_Tune_Index SQL Tuning Advisor (index-tune) (kestsi)
SQL_Tune_Plan SQL Tuning Advisor (plan node analysis) (kestsp)
SQL_Tune_Px SQL Tuning Advisor (parallel execution) (kestsa)
SQL_Tune_Fr SQL Tuning Advisor (fix regression) (kestsa)
SQL_Tune_Stats SQL Tuning Advisor (statistics advisor) (kestss)
SQL_Tune_Exa SQL Tuning Advisor (Exadata) (kestsaExa)
SQL_Test_Exec SQL Test-Execute Service (kestse)
SQL_Perf SQL Performance Analyzer (kesp, keswpi)
SQL_Repair SQL Repair Advisor (kesds)
SQL_trace_parser SQL trace parser (kesstp)
SQL_Analyze SQL Analyze (qksan)
SQL_DS SQL Dynamic Sampling Services (qksds)
SQL_DDL SQL DDL (atb, ctc, dtb)
KKP KKP Manager (kkp)
RAT_WCR Real Application Test: Workload Capture and Replay (kec)
Spatial Spatial (md)
Spatial_IND Spatial Indexing (mdr)
Spatial_GR Spatial GeoRaster (mdgr)
Text Text (dr)
rdbms_gc RDBMS Diagnostic Generic Configuration (dbkgc)
XS XS Fusion Security (kzx)
XSSESSION XS Session (kzxs)
XSPRINCIPAL XS Principal (kzxu)
XSSECCLASS XS Security Class (kzxc, kzxsp)
XSXDS XS Data Security (kzxd)
XSVPD XS VPD ((null))
XSXDB_DEFAULT XS XDB ((null))
XS_MIDTIER XS Midtier (kpuzxs)
XSNSTEMPLATE XS Namespace template (kzxnt)
XSACL XS ACL (kzxa)
XSADM XS Administrative operation (kzxm, kzxi)
AQ Streams Advanced Queuing (kwq, kkcn, kpon, kpoaq, kpce, kpcm, kpun, kpuaq, kws)
AQ_DEQ Streams Advanced Queuing Dequeue (kwqid, kwqdl)
AQ_BACK Streams Advanced Queueing Background (kwsbg, kwsbsm)
AQ_TM Streams Advanced Queuing Time Manager (kwqit, kwqmn)
AQ_CP Streams Advanced Queuing Cross Process (kwscp, kwsipc)
AQ_LB Streams Advanced Queuing Load Balancer (kwslb, kwslbbg)
AQ_NTFN Streams Advanced Queuing Notification (kpond, kkcne)
AQ_NTFNP12C Streams Advanced Queuing pre-12c Notification (kwqic)
AQ_TMSQ Streams Advanced Queuing Time Manager for Sharded Queue (kwsbtm, kwsbjc, kwsbit)
AQ_MC Streams Advanced Queuing Message Cache (kwsmc, kwssh, kwsmb, kwsmsg, kwssb, kwschnk, kwscb, kwsdqwm, kwssbsh)
AQ_PT Streams Advanced Queuing Partitioning (kwspt)
AQ_SUB Streams Advanced Queuing Subscription (kwssi, kwssa, kwsnsm, kwsnsme)
AQ_OPT Streams Advanced Queuing OPT (kwssub)
AQ_DLY Streams Advanced Queuing delay (kwsdly)
KSFM Kernel Service File Mapping (ksfm)
KXD Exadata specific Kernel modules (kxd)
KXDAM Exadata Disk Auto Manage (kxdam)
KCFIS Exadata Predicate Push (kcfis)
NSMTIO Trace Non Smart I/O (nsmtio)
KXDBIO Exadata Block level Intelligent Operations (kxdbio)
KXDRS Exadata Resilvering Layer (kxdrs)
KXDOFL Exadata Offload (kxdofl)
KXDMISC Exadata Misc (kxdmisc)
KXDCM Exadata Metrics Fixed Table Callbacks (kxdcm)
KXDBC Exadata Backup Compression for Backup Appliance (kxdbc)
DV Database Vault (kzv)
ASO Advanced Security Option ((null))
RADM Real-time Application-controlled Data Masking (kzradm)
SVRMAN Server Manageability (ke)
AWR Automatic Workload Repository (kew)
ASH Active Session History (kewa)
METRICS AWR metrics (kewm)
REPOSITORY AWR Repository (kewr)
FLUSH AWR Snapshot Flush (kewrf)
PURGE AWR Snapshot Purge (kewrps)
AWRUTL AWR Utilities (kewu)
AUTOTASK Automated Maintenance Tasks (ket)
MMON MMON/MMNL Infrastructure (keb)
SVRALRT Server Generated Alert Infrastructure (kel)
IUT IUT Infrastructure (keiut)
OLS Oracle Label Security (zll)
AUDITNG Database Audit Next Generation (aud, kza, kzft, aus, aop, ttp)
Configuration ANG Configuration (aud, kza, kzft, aus, aop, ttp)
QueueWrite ANG Queue Write (aud, kza, kzft, aus, aop, ttp)
FileWrite ANG File Write (aud, kza, kzft, aus, aop, ttp)
RecordCompose ANG Record Compose (aud, kza, kzft, aus, aop, ttp)
DBConsolidation ANG Database Consolidation (aud, kza, kzft, aus, aop, ttp)
SYS_Auditing ANG SYS Auditing (aud, kza, kzft, aus, aop, ttp)
KJCI KJCI Cross Instance Call (kjci)
KJZ KJZ - DIAG (kjz)
KJZC KJZC - DIAG Communication Layer (kjzc)
KJZD KJZD - DIAG Main Layer (kjzd)
KJZF KJZF - DIAG Flow Control Layer (kjzf)
KJZG KJZG - DIAG Group Services Layer (kjzg)
KJZH KJZH - DIAG API Layer (kjzh)
KJZM KJZM - DIAG Membership Layer (kjzm)
SEC Security (kz)
CBAC Code-Based Access Control (kzc)
VPD Virtual Private Database (kzr)
GDSI Generic Directory Services Integration (kzlg)
dbop DBOP monitoring (keomn)
dbop_gen DBOP generic service (keomg)
dbop_deamon DBOP monitoring Deamon (keomg)
dbop_comp DBOP composite type (keomm)
em_express EM Express (kex)
orarep orarep (ker)
Data Data Layer (kd, ka)
KDS Kernel Data Scan (kds)
KDSRID Fetch By Rowid (kdsgrp, kdsgnp)
KDSFTS Full Table Scan (kdsttgr, kdstgr)
KDSCLU Cluster Table Scan (kdsics, kdscgr)
KDWF Kernel Data Worker Framework (kdwf)
IMOLTP_KV InMemory OLTP KeyValue (kdkv)
MEMOPT_FI MEMOPTIMIZE FOR WRITE (kdfi)
RAT Real Application Testing (kec)
RAT_MASK Real Application Testing: Masking (kesm, kecprm)
BA Backup Appliance (kbrs)
KBC BA Containers (kbc)
connection_broker Connection Broker (kmp)
KRA Kernel Recovery Area Function (kra)
KRA_SQL KRA SQL Tracing ((null))
KRB Kernel Backup Restore (krb)
KRB_THREAD KRBBPC Thread Switches ((null))
KRB_IO KRB I/O ((null))
KRB_INCR KRB Incremental Restore ((null))
KRB_PERF KRB Performance Tracing ((null))
KRB_BPOUTPUT Detailed Backup Piece Output ((null))
KRB_BPVAL Detailed Block List During Restore Validate ((null))
KRB_FLWRES Details on Restore Flow ((null))
KRB_FLWCPY Details on krbydd Flow ((null))
KRB_FLWBCK Details on Backup Flow ((null))
KRB_FLWUSAGE RMAN Feature Usage ((null))
KRB_OPTIM Unused Space Compression ((null))
KRBABR Auto Block Media Recovery (krbabr)
KRC Recovery Block Change Tracking (krc)
KRC_CHANGES Recovery Block Change Tracking CHANGES ((null))
IM in-memory ((null))
IM_transaction IM transaction layer ((null))
IM_Txn_PJ IM Txn Private Journal (ktmpj)
IM_Txn_SJ IM Txn Shared Journal (ktmsj)
IM_Txn_JS IM Txn Journal Scan (ktmjs)
IM_Txn_Conc IM Txn Concurrency (ktmc)
IM_Txn_Blk IM Txn Block (ktmb)
IM_Txn_Read IM Txn Read (ktmr)
IM_Txn_ADG IM Txn ADG (ktma)
IM_space IM space layer ((null))
IM_data IM data layer (kdm)
IM_populate IM populating (kdml)
IM_background IM background (kdmr)
IM_scan IM scans ((null))
IM_journal IM journal ((null))
IM_dump IM dump ((null))
IM_FS IM faststart ((null))
IM_optimizer IM optimizer (kdmo)
IM_GD IM GD (kdmgd)
IM_ADO IM ADO (kdmado)
IM_IME IM IME (kdmime)
IM_Dictionary IM Dictionary and Cache (kdmd)
IM_Verification IM Verification (kdmv)
xdb_wallet XDB Wallet (kzs)
PROGINT Programmatic Interfaces (kp)
OCI OCI (oci, kpk, kpn)
OPI OPI (opi)
RPI RPI (rpi, kpr)
NPI NPI (npi, nco, kpfs)
Two_Task Two Task (osn, ksn)
PROGINT_PLSQL Programmatic Interfaces to/from PL/SQL (kkx, psd, pckl, plswa)
Two_Phase Two-phase commit (k2)
Conn_Pool Connection Pool (kppl)
TSM Transparent Session Migration (kpm, kps)
PROGINT_MISC Progint Miscellaneous (kpo, kpbf, kpin)
KDFS DBFS C-API (kdfs)
OLAP OLAP Analytic Workspace (xs)
OLAP_Paging OLAP Paging Manager (xspg, xsdb)
STREAMS Replication (knl)
STREAMS_CAPTURE Streams Capture (knlc)
STREAMS_PROPAGATION Streams Propagation ((null))
STREAMS_PROPAGATION_SENDER Streams Propagation Sender (knlcsv)
STREAMS_PROPAGATION_RECEIVER Streams Propagation Receiver (knanr)
STREAMS_APPLY Streams Apply (kna)
STREAMS_APPLY_COORDINATOR Streams Apply Coordinator (knac)
STREAMS_APPLY_READER Streams Apply Reader (knalf)
STREAMS_APPLY_SERVER Streams Apply Server (knas)
Space Space (ktd, kte, kts, ktf, ktt)
Search_Cache Search Cache (ktspsc)
CONTEXT Oracle Text (dr, kci)
CONTEXT_INDEX Oracle Text Index (drs, drg, drn, drl, dre)
CONTEXT_QUERY Oracle Text Query (drex, drp, dry, drw)
rdbms_uts RDBMS Unified Tracing Service (UTS) (dbkt)
MIRA_RCV MIRA Recovery (krd, krp, krr)
reg_cache Registration Caches (kssmc)
OFS Kernel Services Oracle File System ((null))
OFS_KSFS OFS File System (ksfs)
OFS_KSFSD OFS File System Dispatcher (ksfsd)
OFS_KSFSM OFS File System Metadata (ksfsm)
OFS_KSFSC1 OFS File System Callback (ksfsc1)
OFS_SKOFS OFS File System Implementation (skofs)
SQL_Compare_Plans SQL Compare Plans (keplan)
Components in library GENERIC:
--------------------------
Generic_VOS Generic VOS ((null))
VOS_Heap_Manager VOS Heap Manager ((null))
VOS_Latches VOS Latches ((null))
VOS_GST VOS Generic Stack Trace (kgds)
XML XML (qmxt, qmxq)
Generic_XDB Generic XDB ((null))
XDB_Repository XDB Repository (qme)
XDB_Protocols XDB Protocols (qmh, qmf, qmn)
XDB_Query XDB Query (qmxtra, qerxp)
XDB_XMLIndex XDB XMLIndex (qmxtri, qmixq)
XDB_Schema XDB Schema (qmxtri, qmixq)
XDB_XOB XDB XOB (qmx)
XDB_CSX XDB CSX (qmcx)
XDB_CSX_ENCODING XDB CSX ENCODING (qmcxe, qmcxm)
XDB_CSX_DECODING XDB CSX DECODING (qmcxd)
XDB_CSX_SELFCON XDB CSX SELFCON (qmcxe)
XDB_CSX_PRINT XDB CSX PRINT (qmxrs, qmxp, kolace, kolars)
XDB_CSX_TOKENMGR XDB CSX TOKENMGR (qmtm)
XDB_Default XDB Default ((null))
XDB_MEMORY XDB MEMORY (qmu)
LOB LOB (koll, kola)
LOB_Refcount LOB Refcount (kolr)
LOB_Default LOB Default (koll, kole, kokl, koxs)
LOB_DBLINK LOB DBLink (koll, kokl, kpolobr, kkxlr)
LOB_TEMPORARY LOB Temporary (kola, koklt)
LOB_API LOB API (kpolob, kkxlr, kokle, koklc)
KGH KGH Memory Allocator (kgh)
KGF ASM Automatic Storage Management (kgf)
LIBCACHE LIBCACHE (kgl, kql)
LCO_Status_DDL Change of Lib-Cache-Obj Status during DDL ((null))
OBJECTS OBJECTS ((null))
OBJECTS_DDL OBJECTS DDL (kokt)
OBJECTS_Types OBJECTS Types (kot, ko, ort)
OBJECTS_Images OBJECTS Images (koke, kot, kad)
OBJECTS_Anydata OBJECTS Anydata (kokla, kolo, kot, kad)
OBJECTS_Streams OBJECTS Streams (koxs)
OBJECTS_Dict OBJECTS Dictionary (kkdo, qcdo)
OBJECTS_Semanal OBJECTS Semantic Analysis (koks, qcso, qcto)
OBJECTS_Default OBJECTS Default ((null))
OBJECTS_Tables OBJECTS Tables (kkbo)
KGFPM PATCH repository (kgfpm)
KGFDVF Voting File Interface (kgfdvf)
Shared_Objects Shared Object Manager (pes)
SO_Loader Native Code Loader (pesld)
Direct_NFS Direct NFS Client (kgnfs, kgodm, skgnfs)
KGSC Session Cache for Cursors ((null))
KGSC_KQD Session Cache for KQD Cursors ((null))
KGSC_BUN Session Cache for KQD Bundled Cursors ((null))
KGSC_KKS Session Cache for KKS Cursors ((null))
KGSC_PLS Session Cache for PLSQL Cursors ((null))
KGSC_CONS Session Cache for Constraint Cursors ((null))
KGSC_TRIG Session Cache for Trigger Cursors ((null))
KGSC_JOX Session Cache for JOX shortname translation Cursors ((null))
KDI Index Layer (kdi)
KDIADHI Index Layer Compress Advanced High ((null))
KDIADLO Index Layer Compress Advanced Low ((null))
KDIL Index Load (kdil)
KDILADHI Index Load Compress Advanced High ((null))
KDILADLO Index Load Compress Advanced Low ((null))
KDIS Index Split (kdis)
KDISADHI Index Split Compress Advanced High ((null))
KDISADLO Index Split Compress Advanced Low ((null))
KDXT Index Reorg (kdxt)
KDXTADHI Index ADLO Compress Advanced High ((null))
KDXTADLO Index Reorg Compress Advanced Low ((null))
KDIM Index Coalesce (kdim)
KDIMADHI Index Coalesece Compress Advanced High ((null))
KDIMADLO Index Coalesece Compress Advanced Low ((null))
KDIF Index Scan (kdif)
KDIFADHI Index Scan Compress Advanced High ((null))
KDIFADLO Index Scan Compress Advanced Low ((null))
KDIZADHI Advanced High Index Codec (kdizoltp)
KDIZADLO Advanced Low Index Codec ((null))
KDIDML Index DML ((null))
KDIDMLADHI Index DML Compress Advanced High ((null))
KDIDMLADLO Index DML Compress Advanced Low ((null))
KDIGDR Index Ghost Data Removal ((null))
KDIGDRBR Index Ghost Data Removal Branch ((null))
KDIGDRLF Index Ghost Data Removal Leaf ((null))
Components in library CLIENT:
--------------------------
Client_KPU Client KPU ((null))
KPU_Memory KPU Memory ((null))
KPU_TTC KPU TTC ((null))
KPU_Relational KPU Relational ((null))
KPU_Objects KPU Objects ((null))
KPU_LOBS KPU LOBS ((null))
progint_appcont Prog Interfaces Application Continuity ((null))
progint_appcont_rdbms Prog Interfaces Application Continuity RDBMS-side ((null))
SQLLDR_Load SQLLDR Load (ul)
DPAPI_Load DPAPI Load (kpudp)
dbfs_client_profiler dbfs_client profiler ((null))
Components in library LIBCELL:
--------------------------
Client_Library Client Library ((null))
Disk_Layer Disk Layer ((null))
Network_Layer Network Layer ((null))
Connect_Layer Connect Layer ((null))
IPC_Layer IPC Layer ((null))
Components in library ORANET:
--------------------------
TNSLSNR OraNet Listener ((null))
NET_NSGR Network Service Generic Registration ((null))
NET_NSGI TNI Network Service Generic Listener User-defined class ((null))
CMAN OraNet Connection Manager ((null))
NET OraNet Services ((null))
NET_NI Network Interface Layer ((null))
NET_NS Network Session Layer ((null))
NET_NT Network Transport Layer ((null))
NET_NTM Network Transport Mailbox Layer ((null))
NET_NTP Network Transport IPC Layer ((null))
NET_NTT Network Transport TCP/IP Layer ((null))
NET_NTUS Network Transport Unix Domain Sockets Layer ((null))
NET_NL Network Library ((null))
NET_NA Network Authentication ((null))
NET_NZ Network Zecurity ((null))
NET_NTZ Network SSL ((null))
NET_NU Network Trace Route Utility ((null))
NET_NN Network Names ((null))
Components in library ADVCMP:
--------------------------
ADVCMP_MAIN Archive Compression (kdz)
ADVCMP_COMP Archive Compression: Compression (kdzc, kdzh, kdza)
ADVCMP_DECOMP Archive Compression: Decompression (kdzd, kdzs)
ADVCMP_DECOMP_HPK Archive Compression: HPK (kdzk)
ADVCMP_DECOMP_PCODE Archive Compression: Pcode (kdp)
Components in library PLSQL:
--------------------------
PLSQL_Apps PL/SQL Apps (di, pi, plitblm, scm, std, textio, wpiutil)
PLSQL_Utl_File PL/SQL Utl File (pifi)
PLSQL_Codegen PL/SQL Codegen ((null))
PLSQL_COG_IDL_Gen PL/SQL Codegen IDL Gen (pdw)
PLSQL_COG_Infrastructure PL/SQL Codegen Infrastructure (pdz)
PLSQL_COG_Native PL/SQL Codegen Native (pdn)
PLSQL_COG_Optimizer PL/SQL Codegen Optimizer (pdx)
PLSQL_COG_MCode_Gen PL/SQL Codegen MCode Gen (pdy)
PLSQL_Code_Execution PL/SQL Code Execution (pb, pd, pe, pf, plst, pri)
PLSQL_Stack_Frames PL/SQL Runtime Stack Frame (pfrstk)
PLSQL_External_Proc PL/SQL External Proc (pef, ociextp)
PLSQL_IDL PL/SQL IDL (pdt, pt)
PLSQL_ILMS PL/SQL ILMS (pgm)
PLSQL_KNLDE PL/SQL KNLDE (pbbicd, pbp3g, pbs, pbt3g, peibp)
PLSQL_KG_Interface PL/SQL KG Interface (bam, hep, hsh, lis, par, phdr, pk)
PLSQL_Infrastructure PL/SQL Infrastructure (pci, pcm, ph, pl, pncutil, pp, ps, pu, tre)
PLSQL_PSD PL/SQL PSD ((null))
PLSQL_PSD_Generic PL/SQL PSD Generic (psd, pso, psu)
PLSQL_PSD_Standalones PL/SQL PSD Standalones (p2c, pls, psx)
PLSQL_Semantics PL/SQL Semantics (ph2, pha, phn)
PLSQL_Syntax PL/SQL Syntax (ph1)
Components in library XDK:
--------------------------
XDK_Parser XDK Parser ((null))
XDK_FSM_Parser XDK FSM Parser (LpxFSM)
XDK_Schema_Validator XDK Schema Validator ((null))
XDK_Xslt_Engine XDK Xslt Engine ((null))
Components in library VPLIB:
--------------------------
Vector_Translate Vector Translate (qkaxl, qerxl, qesxl, evaxl)
Vector_Aggregate Vector Aggregate (qergv, qesgv, evavgby)
Vector_PX Vector PX (qesxlp)
Again it's a SQLDeveloper report. But the structure is so simple, it can be implemented in any preferred tool.
When a specific tracefile name is selected, the file is presented as text and BLOB. The content is identical, just BLOBs can be downloaded which is useful for huge tracefiles, whereas the CLOB representation is simple to directly read small tracefiles. 
