Starting or stopping a trace session

Start a trace session so that event tracing information is recorded to the tracing targets, and stop a trace event session when you are finished recording information.

Prerequisites

You must have the MANAGE ANY TRACE SESSION system privilege.

Task

Execute an ALTER TRACE EVENT SESSION statement that specifies the required state of the trace session: START or STOP.

For example, the following statement starts the trace session named my_session:
ALTER TRACE EVENT SESSION my_session STATE = START;
The following statement stops the trace session named my_session:
ALTER TRACE EVENT SESSION my_session STATE = STOP;

Results

Once started, the session runs until it is explicitly stopped or until the database is shut down.

Next

View the contents of the diagnostic log file by using the dbmanageetd utility.

Starting or stopping a trace session

Task

See also