ORACLE_TRACE_ENABLE

Parameter type	Boolean
Default value	false
Parameter class	Dynamic: ALTER SESSION, ALTER SYSTEM
Range of values	true | false

To enable Oracle Trace collections for the server, set ORACLE_TRACE_ENABLE to true. This setting alone does not start an Oracle Trace collection, but it allows Oracle Trace to be used for the server.

With ORACLE_TRACE_ENABLE set to true, you can perform Oracle Trace collection of server event data in any of the following ways:

• By using Oracle Trace Manager, which is supplied with the Oracle Diagnostic Pack
• By using the Oracle Trace command line interface, which is supplied with the server
• By specifying a collection name in the ORACLE_TRACE_COLLECTION_NAME parameter

  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_NAME"