Oracle 视图 DBA_HIST_IC_DEVICE_STATS 官方解释，作用，如何使用详细说明
本站中文解释
DBA_HIST_IC_DEVICE_STATS视图是Oracle数据库中使用的一种特殊类别的视图，用于报告每个实例和每个控制文件中所有磁盘卷组的I/O设备相关信息。它包含了磁盘组的名称和它在数据库负载中的统计信息，主要包括DB_BLOCK_GETS, DB_BLOCK_ CHANGES, READ_TIME, WRITE_TIME, READ_SERV_COPY_TIME, WRITE_SERVE_COPY_TIME等。
使用DBA_HIST_IC_DEVICE_STATS视图，可以监控和剂量分析服务器的I/O性能，从而能够从I/O瓶颈的角度优化性能。
官方英文解释
DBA_HIST_IC_DEVICE_STATS displays operating system information about the usage of interconnect devices by the machine.
This usage contains Oracle usage but is not limited to it. The quality of the information depends on the operating system.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Unique snapshot ID |
|
|
|
|
Database ID for the snapshot |
|
|
|
|
Instance number for the snapshot |
|
|
|
|
Name of the device (same as |
|
|
|
|
IP address of the device (same as |
|
|
|
Network mask |
|
|
|
|
Flags |
|
|
|
|
Maximum transmission unit |
|
|
|
|
Number of bytes received since operating system start time |
|
|
|
|
Number of packets received since operating system start time |
|
|
|
|
Number of receive errors since operating system start time |
|
|
|
|
Number of receive messages that were dropped |
|
|
|
|
Number of receive buffer overruns experienced |
|
|
|
|
Number of receive errors due to frame error |
|
|
|
|
Number of bytes sent since operating system start time |
|
|
|
|
Number of packets sent since operating system start time |
|
|
|
|
Number of send errors since operating system start time |
|
|
|
|
Number of send messages that were dropped |
|
|
|
|
Number of send buffer overruns experienced |
|
|
|
|
Number of send errors due to carrier lost |
|
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
|
The ID of the container that
|
