Oracle教程

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

本站中文解释

V$FILESTAT是Oracle的视图，用于查看表空间的空间利用情况。它由属性构成：

（1）TS#：表空间号(#)；
（2）NAME：表空间的名称；
（3）TOTAL_SPACE：总空间；
（4）USED_SPACE：已用空间；
（5）FREE_SPACE：剩余空间。

使用方法：
通过V$FILESTAT视图查询表空间的空间利用情况，可使用下面语句来实现：

SELECT TS#, NAME, TOTAL_SPACE, USED_SPACE, FREE_SPACE
FROM V$FILESTAT
WHERE TS# = ;

其中表示要查询的表空间号。

官方英文解释

V$FILESTAT displays the number of physical reads and writes done and the total number of single-block and multiblock I/Os done at file level.

As of Oracle Database 10g Release 2 (10.2), this view also includes reads done by RMAN processes for backup operations.

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

OPTIMIZED_PHYBLKRD

NUMBER

Number of physical reads from Database Smart Flash Cache blocks

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


数据运维技术 » Oracle 视图 V$FILESTAT 官方解释，作用，如何使用详细说明
分享到：

相关推荐