本站中文解释
V$TEMP_SPACE_HEADER视图显示临时表空间的信息。它是这些视图（V$TABLESPACE、V$TEMPFILE、V$TEMP_SPACE_USAGE和V$SESSION）的综合，V$TEMP_SPACE_HEADER视图收集有关当前临时表空间暂用情况的信息。
使用方法:
1、查询临时表空间的使用情况:
SELECT TABLESPACE_NAME, USED_BLOCKS, FREE_BLOCKS, MAX_BLOCKS
FROM V$TEMP_SPACE_HEADER;
2、查看当前活动会话的临时表空间使用情况：
SELECT b.TABLESPACE_NAME,
b.USED_BLOCKS,
b.FREE_BLOCKS,
b.MAX_BLOCKS
FROM V$TEMP_SPACE_HEADER b, V$SESSION s
WHERE s.TEMPORARY_TABLESPACE = b.TABLESPACE_NAME;
官方英文解释
V$TEMP_SPACE_HEADER displays aggregate information per file per LOCALLY MANAGED temporary tablespace regarding how much space is currently being used and how much is free as identified in the space header.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the temporary tablespace |
|
|
|
Absolute file number |
|
|
|
|
How many bytes are in use |
|
|
|
|
How many blocks are in use |
|
|
|
|
How many bytes are free |
|
|
|
|
How many blocks are free |
|
|
|
|
The relative file number for the file |
|
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
