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

本站中文解释

V$TEMPFILE视图存储临时文件,给用户提供此信息的连接。用户可以通过V$TEMPFILE视图查看与临时表空间相关的实例增加的临时文件的信息。

使用V$TEMPFILE视图的方法:
1. 打开SQL*Plus,输入权限账号与密码,以conncect 命令连接数据库。
2. 输入:SELECT * FROM V$TEMPFILES;
3. 执行上述命令后,就可以查看那些有关临时表空间的信息了,例如文件名,所在目录,文件大小等。

官方英文解释

V$TEMPFILE displays temp file information.

Column Datatype Description

FILE#

NUMBER

Absolute file number

CREATION_CHANGE#

NUMBER

Creation System Change Number (SCN)

CREATION_TIME

DATE

Creation time

TS#

NUMBER

Tablespace number

RFILE#

NUMBER

Relative file number in the tablespace

STATUS

VARCHAR2(7)

Status of the file (OFFLINE|ONLINE)

ENABLED

VARCHAR2(10)

Enabled for read and/or write

BYTES

NUMBER

Size of the file in bytes (from the file header)

BLOCKS

NUMBER

Size of the file in blocks (from the file header)

CREATE_BYTES

NUMBER

Creation size of the file (in bytes)

BLOCK_SIZE

NUMBER

Block size for the file

NAME

VARCHAR2(513)

Name of the file

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$TEMPFILE 官方解释,作用,如何使用详细说明