Oracle教程 2023-02-24

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

V$TEMPSEG_USAGE视图用于查看临时表空间的使用情况。它包含了每个临时表空间分配，使用，剩余和最大可使用大小等信息。

我们可以使用V$TEMPSEG_USAGE这个视图来检查ORACLE是否有足够的临时表空间可用于处理查询和更新操作，以及在使用排序等数据库操作时需要的大量的临时表空间，最大避免排序空间溢出的情况发生。

使用语句：
SELECT * FROM V$TEMPSEG_USAGE;

V$TEMPSEG_USAGE describes temporary segment usage.

Column	Datatype	Description
`USERNAME`	`VARCHAR2(128)`	User who requested temporary space
`USER`	`VARCHAR2(128)`	This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in `USERNAME`.
`SESSION_ADDR`	`RAW(4 \| 8)`	Session address
`SESSION_NUM`	`NUMBER`	Serial number of session
`SQLADDR`	`RAW(4 \| 8)`	Address of SQL statement
`SQLHASH`	`NUMBER`	Hash value of SQL statement
`SQL_ID`	`VARCHAR2(13)`	SQL identifier of SQL statement
`TABLESPACE`	`VARCHAR2(30)`	Tablespace in which space is allocated
`CONTENTS`	`VARCHAR2(9)`	Indicates whether tablespace is `TEMPORARY` or `PERMANENT`
`SEGTYPE`	`VARCHAR2(9)`	Type of sort segment: `SORT` `HASH` `DATA` `INDEX` `LOB_DATA` `LOB_INDEX`
`SEGFILE#`	`NUMBER`	File number of initial extent
`SEGBLK#`	`NUMBER`	Block number of the initial extent
`EXTENTS`	`NUMBER`	Extents allocated to the sort
`BLOCKS`	`NUMBER`	Extents in blocks allocated to the sort
`SEGRFNO#`	`NUMBER`	Relative file number of initial extent
`TS#`	`NUMBER`	Tablespace 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
`SQL_ID_TEMPSEG`	`VARCHAR2(13)`	SQL identifier of the SQL statement that created the temporary segment

分享到：