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?
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
Explanation:
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