Snapshot Information Level Application |
API Structure(s) sqlm_appl sqlm_stmt |
Monitor Group Statement Statement |
Resettable |
No |
|
Event Information Level Statement |
API Structure(s) sqlm_stmttext_event |
|
API Element Name Element Type |
stmt_length gauge |
Description: This is the number of bytes of "Statement Text".
Usage: If you are coding your own applications that access the database system monitor, you need to know the length of the statement text so you can process the monitor data in the buffer.
For dynamic SQL statements, the value of this element will be less than or equal to the value of the sqlstmtsz configuration parameter (see the Administration Guide).
For file-based event monitors, the value of this element will not exceed the size of the event monitor buffer less the size of the other information in the sqlm_stmttext_event structure.
For static SQL statements, this length will be zero since statement text is not returned for static statements.
[ Top of Page | Table of Contents | Glossary | Index ]