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

本站中文解释

Oracle的视图V$TEMPSTAT是一个动态视图,它可以用来查看用于临时表空间的使用统计信息。该视图描述每个用于临时表空间的会话的使用情况,包括缓存的总大小、未使用的空间大小、总的文件块数量及其他信息。

使用V$TEMPSTAT视图时,可以得到每个会话使用的临时表空间信息,如会话ID、文件块数量以及使用空间大小等等。要使用V$TEMPSTAT视图,需要在SQLPlus 中执行以下命令:

SELECT * FROM V$TEMPSTAT;

官方英文解释

V$TEMPSTAT displays information about file read/write statistics.

Column Datatype Description

FILE#

NUMBER

Number of the file

PHYRDS

NUMBER

Number of physical reads done

PHYWRTS

NUMBER

Number of times DBWR is required to write

PHYBLKRD

NUMBER

Number of physical blocks read

PHYBLKWRT

NUMBER

Number of blocks written to disk, which may be the same as PHYWRTS if all writes are single blocks

SINGLEBLKRDS

NUMBER

Number of single block reads

READTIM

NUMBER

Time (in hundredths of a second) spent doing reads if the TIMED_STATISTICS parameter is true; 0 if false

WRITETIM

NUMBER

Time (in hundredths of a second) spent doing writes if the TIMED_STATISTICS parameter is true; 0 if false

SINGLEBLKRDTIM

NUMBER

Cumulative single block read time (in hundredths of a second)

AVGIOTIM

NUMBER

Average time (in hundredths of a second) spent on I/O, if the TIMED_STATISTICS parameter is true; 0 if false

LSTIOTIM

NUMBER

Time (in hundredths of a second) spent doing the last I/O, if the TIMED_STATISTICS parameter is true; 0 if false

MINIOTIM

NUMBER

Minimum time (in hundredths of a second) spent on a single I/O, if the TIMED_STATISTICS parameter is true; 0 if false

MAXIORTM

NUMBER

Maximum time (in hundredths of a second) spent doing a single read, if the TIMED_STATISTICS parameter is true; 0 if false

MAXIOWTM

NUMBER

Maximum time (in hundredths of a second) spent doing a single write, if the TIMED_STATISTICS parameter is true; 0 if false

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

See Also:

“TIMED_STATISTICS”


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