syssscelem
The syssscelem table provides information about Statement Cache Entries.
| Column | Type | Description |
|---|---|---|
| uniqid | integer | Unique id of element |
| lru | integer | Index of lru queue |
| hash | integer | Hash value of cached entry |
| ref_cnt | integer | Num threads referencing the statement |
| hits | integer | Num times element used |
| flag | integer |
|
| valid | integer | Valid 1, Invalid 0 |
| locked | integer | Locked 1, Unlocked 0 |
| heap_ptr | bigint | Address of memory heap for cache entry |
| database | char(128) | Database name |
| user | char(32) | User |
| stmtstring | char(16000) | Statement string |
| queryplan | char(16000) | Query plan |