Batch and DSS workloads on your Exadata X6 Database Machine are causing performance problems for OLTP workloads at certain times of the day. There are five RAC databases performing OLTP I/O. Two of them also perform batch I/O. There is another RAC database that performs only DSS I/O. You are asked to resolve this problem so that the OLTP workload will not suffer when competing with the batch or DSS workloads. You decide to use the I/O resource manager. Which is the best way to solve this problem? 

Answer options:

A. Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to create the OLTP category and map all OLTP- oriented consumer groups in all databases to it.
B. Use the Database Resource Manager to give the OLTP category the highest priority and use EXADCLI calling EXACLI to create the OLTP category on all the cells.
C. Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to give the OLTP consumer group the highest priority on all databases.
D. Create a database plan using EXADCLI calling EXACLI to give OLTP I/O the highest priority from all six databases.

C

You can manage I/O resources based on categories by creating a category plan. You can add any number of categories, or modify the predefined categories. You should map consumer groups to the appropriate category for all databases that use the same cell storage. Any consumer group without an explicitly specified category defaults to the OTHER category. References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-iorm.htm