Oracle
1Z0-338 · Question #88
How would you ensure that batch jobs don't impact the performance of online queries that use the same database?
The correct answer is D. Build a Database Resource Management Plan, giving priority to query workloads. See the full explanation below for the reasoning.
Question
How would you ensure that batch jobs don't impact the performance of online queries that use the same database?
Options
- AConfigure resource plans by using the I/O Resource Manager on the storage cells, giving priority to
- BConfigure and enable Parallel Query.
- CDeploy Instance Caging to control batch jobs.
- DBuild a Database Resource Management Plan, giving priority to query workloads.
- EConfigure IORM to disable Flash Cache usage for batch workloads.
How the community answered
(56 responses)- A13% (7)
- B7% (4)
- C2% (1)
- D75% (42)
- E4% (2)
Community Discussion
No community discussion yet for this question.