sa_remove_tracing_data( log_session_id )

If there are no records for the specified log_session_id, the procedure has no effect. The procedure has no return values.

You must have the DIAGNOSTICS system role, and the MANAGE PROFILING system privilege.

Causes a commit upon completion, even if no records were found for the specified log_session_id.

• Diagnostic tracing tables

This example permanently deletes from the diagnostic tracing tables all records pertaining to the logging session ID 1.

CALL sa_remove_tracing_data( 1 );