Execution Information

 

This category describes the type and status of SQL commands being executed by each user.

Figure: Session Information: Execution Information

 

Column Name

Description

Connection ID:

The ID of the session.

Current SQL Command

The most recently executed SQL command and the command status. The command status can be the following:

[PRE] - The SQL command is being prepared.

[EXEC] - The SQL command is being executed from SQLExecute call.

[EXDIR] - The SQL command is being executed from SQLExecDirect call.

[FETCH] - The operation is in the fetch data phase.

[EXIT] - The SQL command is finished with the prepare, execute or fetch operation.

Time of Current SQL Command

The time when the most recently used SQL command was executed.

Table: Execution Information


Related topic:

Display Mode of SQL Command Monitor
Monitoring Database Sessions