Oracle教程 2023-04-06

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

Oracle视图DBA_TEMP_FILES显示每个数据库的临时文件的状态和空间使用情况，用户可以使用该视图来查看临时文件的实际分配空间(ALLOCATED_SPACE)，已使用空间(USED_SPACE)和剩余空间(FREE_SPACE)。查看大小，位置，状态等信息

可以使用下列语句查看DBA_TEMP_FILES视图：

SELECT * FROM dba_temp_files;

DBA_TEMP_FILES describes all temporary files (tempfiles) in the database.

Column	Datatype	NULL	Description
`FILE_NAME`	`VARCHAR2(513)`		Name of the database temp file
`FILE_ID`	`NUMBER`		File identifier number of the database temp file
`TABLESPACE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the tablespace to which the file belongs
`BYTES`	`NUMBER`		Size of the file (in bytes)
`BLOCKS`	`NUMBER`		Size of the file (in Oracle blocks)
`STATUS`	`VARCHAR2(7)`		File status: `OFFLINE` `ONLINE` `UNKNOWN`
`RELATIVE_FNO`	`NUMBER`		Tablespace-relative file number
`AUTOEXTENSIBLE`	`VARCHAR2(3)`		Indicates whether the file is autoextensible (`YES`) or not (`NO`)
`MAXBYTES`	`NUMBER`		maximum size of the file (in bytes)
`MAXBLOCKS`	`NUMBER`		Maximum size of the file (in Oracle blocks)
`INCREMENT_BY`	`NUMBER`		Default increment for autoextension (in Oracle blocks)
`USER_BYTES`	`NUMBER`		Size of the useful portion of the file (in bytes)
`USER_BLOCKS`	`NUMBER`		Size of the useful portion of the file (in Oracle blocks)
`SHARED`	`VARCHAR2(12)`		Type of tablespace this file belongs to: `SHARED`: For shared tablespace `LOCAL_FOR_RIM`: Local temporary tablespace for RIM (read-only) instances `LOCAL_FOR_ALL`: Local temporary tablespace for all instance types
`INST_ID`	`NUMBER`		Instance ID of the instance to which the temp file belongs. This column has a NULL value for temp files that belong to shared tablespaces.

分享到：