What would be the best way to ensure that batch Jobs do not impact performance of online
queries that use the same database?
A.
Configure IORM to disable Flash Cache usage for batch workload.
B.
Build a Database Resource Management Plan, giving priority to query workload.
C.
Deploy Instance Caging to control batch jobs.
D.
Configure and enable Parallel Query.
E.
Configure resource plans by using the I/O Resource Manager on the storage cells, giving
priority to query workload.
Explanation:
Using the Database Resource Manager, you can distribute available processing
resources by allocating percentages of CPU time to different users and applications. In a data
warehouse, a higher percentage may be given to ROLAP (relational on-line analytical processing)
applications than to batch jobs.
Incorrect:
not C:
In addition to controlling I/O utilization on the Exadata storage cells, Oracle also allows you to limit
CPU resource utilization on the compute nodes using a technique called instance caging.
B