Oracle教程

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

本站中文解释

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


数据运维技术 » Oracle 视图 V$TEMP_EXTENT_POOL 官方解释，作用，如何使用详细说明
分享到：

相关推荐