The syssessiontempspaceusage table contains information about each session's temp space usage, includes both implicit and explicit temp tables.

Column Type Description
sid integer ID of the session which allocated temp space
flags char(10) Partition flags of the temp space partition
partition char(10) Partition number of the temp space partition
table lvarchar(290) Table name of the temp space partition
allocated_pages integer Number of pages allocated by the temp space partition


select * from syssessiontempspaceusage

sid              53
flags            0x00000861
partition        0x001001A4
table            stores_demo:userabc:foo
allocated_pages  8