View the Exhibit and examine the output for the query on V$IOSTAT_FUNCTION.Which two
statements are true about the interpretation of the output? (Choose two.)
A.
The I/O statistics are only for the single block read and write operations.
B.
The I/O statistics are for single block or multi-block read and write operations.
C.
If there is a conflict of I/Ofunctions, the I/O is placed in the bucket with the lower
FUNCTION_ID.
D.
If there is a conflict of I/O functions, the I/O is placed in the bucket with the higher
FUNCTION_ID.
B and C
SMALL_READ_MEGABYTES NUMBER Number of single block megabytes read
SMALL_WRITE_MEGABYTES NUMBER Number of single block megabytes written
LARGE_READ_MEGABYTES NUMBER Number of multiblock megabytes read
LARGE_WRITE_MEGABYTES NUMBER Number of multiblock megabytes written
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
http://docs.oracle.com/cd/B28359_01/server.111/b28274/instance_tune.htm
An I/O can be issued by various Oracle processes with different functionalities. The top database functions are classified in the V$IOSTAT_FUNCTION view. In cases when there is a conflict of I/O functions, the I/O is placed in the bucket with the lower FUNCTION_ID. For example, if XDB issues an I/O from the buffer cache, the I/O would be classified as an XDB I/O because it has a lower FUNCTION_ID value. Any unclassified function is placed in the Others bucket. You can display the FUNCTION_ID hierarchy by querying the V$IOSTAT_FUNCTION view
B and C