介绍
V$IOSTAT_FUNCTION视图让我们能够查询数据库函数(或方法)的磁盘I/O情况,例如LGWR进程和DBWR进程等。
视图详情
字段名 | 字段类型 | 描述 | 译 | 备注 |
FUNCTION_ID | NUMBER | Function ID | 功能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 | 功能名称: RMAN 数据库写进程 数据库日志写进程 数据库归档进程 XDB 流AQ 数据泵 实例恢复 缓冲区缓存读 直接路径读 直接路径写 Smart Scan 归档管理器 其他 | |
SMALL_READ_MEGABYTES | NUMBER | Number of megabytes read via single block read requests | 请求单块读取的字节数,以MB为单位 | |
SMALL_WRITE_MEGABYTES | NUMBER | Number of megabytes written via single block write requests | 请求单块写入的字节数,以MB为单位 | |
LARGE_READ_MEGABYTES | NUMBER | Number of megabytes read via multiblock read requests | 请求多块读取的字节数,以MB为单位 | |
LARGE_WRITE_MEGABYTES | NUMBER | Number of megabytes written via multiblock write requests | 请求多块写入的字节数,以MB为单位 | |
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 | 同步I/O等待的数量 | |
WAIT_TIME | NUMBER | Total synchronous I/O wait time (in milliseconds) | 总I/O等待时间,以毫秒为单位 |
评论区