What would be the best way to ensure that batch Jobs do not impact performance of online queries that use the same database?

The correct answer is B. Build a Database Resource Management Plan, giving priority to query workload. 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)…

I/O Resource Management (IORM)

Question

Options

AConfigure IORM to disable Flash Cache usage for batch workload.
BBuild a Database Resource Management Plan, giving priority to query workload.
CDeploy Instance Caging to control batch jobs.
DConfigure and enable Parallel Query.
EConfigure resource plans by using the I/O Resource Manager on the storage cells, giving priority

How the community answered

(49 responses)

A
6% (3)
B
73% (36)
C
14% (7)
D
2% (1)
E
4% (2)

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

Topics

#IORM#DBRM#batch workload#online query priority

Community Discussion

No community discussion yet for this question.

Full 1Z0-485 Practice