By default, the workload capture feature is not enabled in Oracle Database 10g Release 2 (10.2). You can enable or disable this feature by
specifying the PRE_11G_ENABLE_CAPTURE initialization parameter.
@$ORACLE_HOME/rdbms/admin/wrrenbl.sql
The wrrenbl.sql script calls the ALTER SYSTEM SQL statement to set the PRE_11G_ENABLE_CAPTURE initialization parameter to TRUE.
To disable workload capture, run the wrrdsbl.sql script at the SQL prompt:
@$ORACLE_HOME/rdbms/admin/wrrdsbl.sql