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