FULLEST_SEG_TEMPDB

Fullest tempdb database segments

ROWID

(DBNAME, SEGNAME)

Columns

Name Data Type Description
DBNAME string(32) Database name
SEGNAME string(68) Segment name
TOTALSIZEMB double Total allocated size, in megabytes
USEDMB double Amount of space used, in megabytes
USEDPCT double % of total allocated size that is used
INSTANCEID long Instance ID; 0 = non-CE

Requirements

Attributes: None
Minimum database version: 12.5.0.3