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
  • Invalid 0x1
  • Fully Cached 0x2
  • Inserting 0x4
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

Copyright© 2020 HCL Technologies Limited