sysptprof table

The sysptprof table lists information about a tblspace. Tblspaces correspond to tables.

Profile information for a table is available only when a table is open. When the last user who has a table open closes it, the tblspace in shared memory is freed, and any profile statistics are lost.

The following table provides information about the columns in the sysptprof table:
Column Type Description
dbsname char(128) Database name
tabname char(128) Table name
partnum integer Partition (tblspace) number
lockreqs integer Number of lock requests
lockwts integer Number of lock waits
deadlks integer Number of deadlocks
lktouts integer Number of lock timeouts
isreads integer Number of isreads
iswrites integer Number of iswrites
isrewrites integer Number of isrewrites
isdeletes integer Number of isdeletes
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

Copyright© 2019 HCL Technologies Limited