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