Snapshot Information Level Application |
API Structure(s) This data item immediately follows the sqlm_appl stucture in the returned data buffer. |
Monitor Group Statement |
Resettable |
No |
|
Event Information Level Statement |
API Structure(s) sqlm_stmttext_event |
|
API Element Name Element Type |
see API Structure(s) (Snapshot) stmt_text (Event) information |
Description: This is the text of the dynamic SQL statement.
Usage: This statement text helps you identify what the application was executing when the snapshot was taken. Or it is the text of the statement that was most recently processed, if no statement was being processed right at the time the snapshot was taken.
If multiple statements are prepared before being executed, only the text of the last prepared statement, or the text of an EXECUTE IMMEDIATE statement, will be provided for snapshots.
For the event monitor, this is the dynamic SQL statement for which the statement event is being recorded, if "Statement Operation" is PREPARE or EXECUTE IMMEDIATE.
The maximum size of the dynamic SQL statement that can be returned to you is determined by the sqlstmtsz configuration parameter (see the Administration Guide for more information). The actual size of the statement returned to you is provided by "Statement Length".
See "Section Number" for information on how to query the system catalog tables to obtain static SQL statement text that is not provided due to performance considerations.
[ Top of Page | Table of Contents | Glossary | Index ]