Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub
REFRN30477

V$IOFUNCMETRIC

V$IOFUNCMETRIC displays I/O statistics information by database function for the most recent time interval period.

Column Datatype Description
BEGIN_TIME DATE Begin time for the metric value
END_TIME DATE End time for the metric value
INTSIZE_CSEC NUMBER Size of the time period
FUNCTION_ID NUMBER Function ID
FUNCTION_NAME VARCHAR2(18) Function name
SMALL_READ_MBPS NUMBER Single block megabytes read per second
SMALL_WRITE_MBPS NUMBER Single block megabytes written per second
LARGE_READ_MBPS NUMBER Multiblock megabytes read per second
LARGE_WRITE_MBPS NUMBER Multiblock megabytes written per second
SMALL_READ_IOPS NUMBER Single block read requests per second
SMALL_WRITE_IOPS NUMBER Single block write requests per second
LARGE_READ_IOPS NUMBER Multiblock read requests per second
LARGE_WRITE_IOPS NUMBER Multiblock write requests per second
AVG_WAIT_TIME NUMBER Average wait time (in milliseconds)

Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF