Oracle 视图 V$TEMP_EXTENT_POOL 官方解释，作用，如何使用详细说明

网络编程 Oracle 视图 V$TEMP_EXTENT_POOL 官方解释，作用，如何使用详细说明 10-15

本站中文解释

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
`TABLESPACE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the tablespace
`FILE_ID`	`NUMBER`		Absolute file number
`EXTENTS_CACHED`	`NUMBER`		Number of extents that have been cached
`EXTENTS_USED`	`NUMBER`		Number of extents that are actually being used
`BLOCKS_CACHED`	`NUMBER`		Number of blocks that are cached
`BLOCKS_USED`	`NUMBER`		Number of blocks that are used
`BYTES_CACHED`	`NUMBER`		Number of bytes that are cached
`BYTES_USED`	`NUMBER`		Number of bytes that are used
`RELATIVE_FNO`	`NUMBER`		Relative file number
`CON_ID`	`NUMBER`		The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

编辑：一起学习网

标签：视图,概要,状态,还可以,空间