Oracle教程

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

本站中文解释

Oracle视图V$IOSTAT_FUNCTION_DETAIL显示特定CISC功能的I/O状态信息。这个可选的状态信息在V$IOSTAT视图中看不到，但是在V$IOSTAT_FUNCTION_DETAIL视图中可以查看。

使用V$IOSTAT_FUNCTION_DETAIL视图可以帮助数据库管理员更好地理解I/O情况，因此可以对系统进行更有效的运作优化。

以下是使用V$IOSTAT_FUNCTION_DETAIL视图的步骤：

1. 打开SQL Plus会话，登录到Oracle数据库。

2. 执行以下查询：
“`SQL
SELECT FUNCTION, STATISTICS, VALUE
FROM V$IOSTAT_FUNCTION_DETAIL
ORDER BY FUNCTION, STATISTICS;
“`

3. 根据FUNCTION，STATISTICS和VALUE列来查看I/O情况。

官方英文解释

V$IOSTAT_FUNCTION_DETAIL displays disk I/O statistics for database functions (such as the LGWR and DBWR), broken down by file type.

Column Datatype Description

FUNCTION_ID

NUMBER

Function ID

FUNCTION_NAME

VARCHAR2(18)

Function name:

  • RMAN

  • DBWR

  • LGWR

  • ARCH

  • XDB

  • Streams AQ

  • Data Pump

  • Recovery

  • Buffer Cache Reads

  • Direct Reads

  • Direct Writes

  • Smart Scan

  • Archive Manager

  • Others

FILETYPE_ID

NUMBER

File type ID

FILETYPE_NAME

VARCHAR2(28)

File type name:

  • Control File

  • Data File

  • Log File

  • Archive Log

  • Temp File

  • Data File Backup

  • Data File Incremental Backup

  • Archive Log Backup

  • Data File Copy

  • Flashback Log

  • Data Pump Dump File

  • Other

SMALL_READ_MEGABYTES

NUMBER

Number of megabytes read via single block read requests

SMALL_WRITE_MEGABYTES

NUMBER

Number of megabytes written via single block write requests

LARGE_READ_MEGABYTES

NUMBER

Number of megabytes read via multiblock read requests

LARGE_WRITE_MEGABYTES

NUMBER

Number of megabytes written via multiblock write requests

SMALL_READ_REQS

NUMBER

Number of single block read requests

SMALL_WRITE_REQS

NUMBER

Number of single block write requests

LARGE_READ_REQS

NUMBER

Number of multiblock read requests

LARGE_WRITE_REQS

NUMBER

Number of multiblock write requests

NUMBER_OF_WAITS

NUMBER

Number of synchronous I/O waits by functionality

WAIT_TIME

NUMBER

Total synchronous I/O wait time (in milliseconds)

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$IOSTAT_FUNCTION_DETAIL 官方解释，作用，如何使用详细说明
分享到：

相关推荐