syssesprof

The syssesprof table lists cumulative counts of the number of occurrences of user actions such as writes, deletes, or commits.
Column Type Description
sid integer Session ID
lockreqs integer Number of locks requested
locksheld integer Number of locks currently held
lockwts integer Number of times waited for a lock
deadlks integer Number of deadlocks detected
lktouts smallint Number of deadlock time-outs
logrecs integer Number of logical-log records written
isreads integer Number of reads
iswrites integer Number of writes
isrewrites integer Number of rewrites
isdeletes integer Number of deletes
iscommits integer Number of commits
isrollbacks integer Number of rollbacks
longtxs integer Number of long transactions
bufreads integer Number of buffer reads
bufwrites integer Number of buffer writes
seqscans integer Number of sequential scans
pagreads integer Number of page reads
pagwrites integer Number of page writes
total_sorts integer Number of total sorts
dsksorts integer Number of sorts that did not fit in memory
max_sortdiskspace integer Maximum space used by a sort
logspused integer Number of bytes of logical-log space used by current transaction of session
maxlogsp integer Maximum number of bytes of logical-log usage for any single transaction since the session started

Copyright© 2019 HCL Technologies Limited