You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 Exadata Database Machine. You decide to examine the relevant metrics on all the cells, to see whether the I/O rate has improved for this category compared to last week, and whether waits and wait time have been reduced. You issue this command on the first cell: 

You examine the output from the first cell which contains: 

Which two sets of metrics would you use to determine whether the I/O performance has improved for the OLTP category for the duration of the one-hour measurement period? 

Answer options:

A. CT_IO_RQ_SM, CT_IO_RQ_LG, CT_IO_RQ_SM_SEC, and CT_IO_RQ_LG_SEC
B. CT_IO_UTIL_SM and CT_IO_UTIL_LG
C. CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC
D. CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ

D

✑ CT_IO_RQ_SM The cumulative number of small I/O requests issued by the category for hard disks. A large value indicates a heavy I/O workload from this category. ✑ CT_IO_RQ_LG The cumulative number of large I/O requests issued by the category for hard disks. A large value indicates a heavy I/O workload from this category. ✑ CT_IO_WT_SM_RQ The average IORM wait time per request for small I/O requests issued to hard disks by an IORM category. ✑ CT_IO_WT_LG_RQ The average IORM wait time per request for large I/O requests issued to hard disks by an IORM category. Incorrect Answers: A: CT_IO_RQ_SM_SEC - This metric is derived from CT_IO_RQ_SM. It specifies the rate of small I/O requests issued by the category for hard disks. Its units are number of I/O requests per second. A large value indicates a heavy I/O workload from this category in the past minute. B: CT_IO_UTIL_SM - The percentage of disk resources utilized by small requests from this category. References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-monitoring.htm