ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sa_conn_activity system procedure

Function 

Returns the most recently-prepared SQL statement for each connection to databases on the server.

Syntax 

sa_conn_activity

Permissions 

None

Side effects 

None

Description 

The sa_conn_activity procedure returns a result set consisting of the most recently-prepared SQL statement for each connection. This procedure is useful when the database server is busy and you want to obtain information about what SQL statement is prepared for each connection. This feature can be used as an alternative to request-level logging.

For information on the property these values are derived from, see Connection-level properties.