Initialization Parameters, 176 of 188

SQL_TRACE

Parameter type:	Boolean
Parameter class:	Static
Default value:	`FALSE`
Range of values:	`TRUE \| FALSE`
The value of `SQL_TRACE` disables or enables the SQL trace facility. Setting this parameter to `TRUE` provides information on tuning that you can use to improve performance. You can change the value using the `DBMS_SYSTEM` package.
CAUTION: Enabling the SQL trace facility for the entire instance using this initialization parameter can have a severe performance impact. Try to enable the facility for specific sessions using the `ALTER` `SESSION` statement. If you must enable the facility on an entire production environment, you can minimize performance impact by Maintaining at least 25% idle CPU capacity Maintaining adequate disk space for the `USER_DUMP_DEST` location Striping disk space over sufficient disks
Note: If you change the value of this parameter by using the `ALTER` `SESSION` `SET SQL_TRACE` statement, the resulting change will not be reflected in the `V$PARAMETER` dynamic performance view. Therefore, this parameter is not considered dynamic. For information on the `ALTER` `SESSION` statement, see also Oracle8i SQL Reference. See Also: Oracle8i Designing and Tuning for Performance for more information about performance diagnostic tools.