1z0-070 Exam Dumps | Batch and DSS workloads on your Exadata X6 Database Machine are causing performance problems for OLTP

<< Prev Question Next Question >>

Question 6/90

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 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.

Question 6/90

LEAVE A REPLY

Download PDF File