Enabling and Disabling SQL Trace
To enable or disable trace logging for the selected session:
- Navigate to the required session in the sessions list.
- Choose Enable Sql Trace/Disable Sql Trace from the shortcut menu or click the corresponding toolbar button.
- The dialog asking if the SQL trace has to be enabled/disabled for the session with the specified Sid will appear. Click Yes to enable/disable SQL trace.
Enabling and disabling SQL trace is allowed for the users connected as SYSDBA only.