Oracle教程 2023-03-24

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

Oracle视图DBA_TEMP_FREE_SPACE用于报告可用临时表空间的大小，查询用户当前可用于创建临时内存表的空间。在使用本视图之前，必须先将其置于可用状态。用户可以使用语句“ALTER SESSION ENABLE RESOURCE_LIMIT”来做出此设置。

要查询当前用户的可用大小，可以执行以下SQL语句：

SELECT sum (bytes) FROM dba_temp_free_space WHERE user_name = USER;

上述查询将获得与当前用户相关的不同临时表空间中的可用空间大小。

DBA_TEMP_FREE_SPACE displays temporary space usage information at tablespace level.

Column	Datatype	NULL	Description
`TABLESPACE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the tablespace
`TABLESPACE_SIZE`	`NUMBER`		Total size of the tablespace, in bytes
`ALLOCATED_SPACE`	`NUMBER`		Total allocated space, in bytes, including space that is currently allocated and used and space that is currently allocated and available for reuse
`FREE_SPACE`	`NUMBER`		Total free space available, in bytes, including space that is currently allocated and available for reuse and space that is currently unallocated
`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 tempfile belongs

分享到：