syssessiontempspaceusage
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 |
Example:
select * from syssessiontempspaceusage
sid 53
flags 0x00000861
partition 0x001001A4
table stores_demo:userabc:foo
allocated_pages 8