table_list

Total of partitions (indices and fragments) for a table.

table_list

column sysmastertable description
dbsname infx database table created in
tabname infx the name of the table
owner infx the owner of the table
created_datetime infx the date and time the table was created
lockreqs sysptprof number of requests for locks on this partition
lockwts sysptprof number of locks waited for on this partition
deadlks sysptprof number of dead locks on this partition
lktouts sysptprof number of times locks timed out on this partition
isreads sysptprof number of isread calls
iswrites sysptprof number of iswrite calls
isrewrites sysptprof number of isrewrite calls
isdeletes sysptprof number of isdelete calls
bufreads sysptprof number of buffers read
bufwrites sysptprof number of bufferss written
seqscans sysptprof sequential scans on this partition
pagreads sysptprof pages read from this partition
pagwrites sysptprof pages written to this partition
ti_nextns systabinfo number of extents allocated
ti_fextsize systabinfo first extent size allocation
ti_nextsiz systabinfo next extent size allocation
ucount sysactptnhdr number of user threads using this table
ocount sysactptnhdr number of uesr threads with this table open
ownername infx who owns the table
objectname infx name of this database object
dbspacename infx name of storage space this partition is in
hex_partnum infx table partnum in hex digits
created_datetime infx date and time partition was created
fextsiz_kb infx infx calculates this
nextsiz_kb infx infx calculates this
total_kb infx infx calculates this
used_kb infx infx calculates this
free_kb infx infx calculates this
data_kb infx amount of data page storage
idx_kb infx amount of index page storage
tabid infx mapped back to systables in original databae
totio_buf infx total number (reads+writes) of buffer i/o
totio_pag infx total number of page i/o
shortname infx abbreviated name for this partition

partition list

Detailed statistics about each partition of a table or index. Use this when you want the complete breakdown of a table.

partition_list

column sysmastertable description
dbsname sysptprof database of the partition
tabname infx the name of the table this partition belongs to
partnum sysptprof internal number
lockreqs sysptprof number of requests for locks on this partition
lockwts sysptprof number of locks waited for on this partition
deadlks sysptprof number of dead locks on this partition
lktouts sysptprof number of times locks timed out on this partition
isreads sysptprof number of isread calls
iswrites sysptprof number of iswrite calls
isrewrites sysptprof number of isrewrite calls
isdeletes sysptprof number of isdelete calls
bufreads sysptprof number of buffers read
bufwrites sysptprof number of bufferss written
seqscans sysptprof sequential scans on this partition
pagreads sysptprof pages read from this partition
pagwrites sysptprof pages written to this partition
ucount sysactptnhdr number of user threads using this partition
ocount sysactptnhdr number of user threads with this partition open
ti_partnum systabinfo internal number
ti_flags systabinfo flags describing the table
ti_rowsize systabinfo size, in bytes of one row
ti_ncols systabinfo number of columns in the partition
ti_nkeys systabinfo number of keys in the partition
ti_nextns systabinfo number of extetns allocated
ti_pagesize systabinfo page size of the storage space where the partition is located
ti_created systabinfo time stamp when partition was created
ti_serialv systabinfo next serial value
ti_fextsize systabinfo first extent size allocation
ti_nextsiz systabinfo next extent size allocation
ti_nptotal systabinfo total number of pages allocated to this partition
ti_npused systabinfo total number of pages used in this partition
ti_npdata systabinfo number of pages that are storing data
ti_octptnm systabinfo octal representation of table partnum
ti_nrows systabinfo number of rows in this partition
ownername infx who owns the table
objectname infx name of this table or index
dbspacename infx name of storage space this partition is in
hex_partnum infx table partnum in hex digits
created_datetime infx date and time partition was created
fextsiz_kb infx infx calculates this
nextsiz_kb infx infx calculates this
total_kb infx infx calculates this
used_kb infx infx calculates this
free_kb infx infx calculates this
data_kb infx amount of data page storage
idx_kb infx amount of index page storage
tabid infx mapped back to systables in original databae
totio_buf infx total number (reads+writes) of buffer i/o
totio_pag infx total number of page i/o
shortname infx abbreviated name for this partition