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


数据运维技术 » Oracle 视图 V$TEMPSEG_USAGE 官方解释,作用,如何使用详细说明