ORACLE_TRACE_FACILITY_NAME

Parameter type	String
Syntax	ORACLE_TRACE_FACILITY_NAME = {ORACLED | ORACLEE | ORACLESM | ORACLEC}
Default value	ORACLED
Parameter class	Static

ORACLE_TRACE_FACILITY_NAME specifies the event set that Oracle Trace collects. The value of this parameter, followed by the .fdf extension, is the name of the Oracle Trace product definition file. That file must be located in the directory specified by the ORACLE_TRACE_FACILITY_PATH parameter. The product definition file contains definition information for all the events and data items that can be collected for products that use the Oracle Trace data collection API.

The Oracle server has multiple event sets and therefore multiple product definition files:

• ORACLE is the ALL event set
• ORACLED is the DEFAULT event set
• ORACLEE is the EXPERT event set
• ORACLESM is the SUMMARY event set
• ORACLEC is the CACHEIO event set

Oracle Corporation recommends that you use the DEFAULT event set for Oracle server collections, ORACLED.

See Also: Oracle9i Database Performance Tuning Guide and Reference for more information on the Oracle Trace facility and on setting this parameter "ORACLE_TRACE_COLLECTION_PATH"