Oracle教程 2023-02-24

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

分享到：