本站中文解释
Oracle视图 V$TEMP_EXTENT_POOL 用于显示临时表空间中各个扩展的池的概要信息。该视图可以查看每个池的当前的块数、最大的块数和最大使用百分比。
此外，它还能够查看池的类型（未增长、增长和不可增长），还可以查看池的状态和状态的时间戳。
使用方法：
可以使用SELECT语句从V$TEMP_EXTENT_POOL视图中查询临时表空间中各个池的概要信息，例如：
SELECT temp_space, pool_type, blocks, max_blocks, per_of_max FROM v$temp_extent_pool;
官方英文解释
V$TEMP_EXTENT_POOL displays the state of temporary space cached and used for the instance. Note that loading of the temporary space cache is lazy and that instances can be dormant.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the tablespace |
|
|
|
Absolute file number |
|
|
|
|
Number of extents that have been cached |
|
|
|
|
Number of extents that are actually being used |
|
|
|
|
Number of blocks that are cached |
|
|
|
|
Number of blocks that are used |
|
|
|
|
Number of bytes that are cached |
|
|
|
|
Number of bytes that are used |
|
|
|
|
Relative file number |
|
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
