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