Enabling and Disabling SQL Trace

To enable or disable trace logging for the selected session:

  1. Navigate to the required session in the sessions list.
  2. Choose Enable Sql Trace/Disable Sql Trace on the shortcut menu or click the corresponding toolbar button.
  3. 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.

Note

Enabling and disabling SQL trace is allowed for the users connected as SYSDBA only.