1Z0-064 · Question #39
Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries. You want to set a…
The correct answer is B. limiting the amount of undo generated by operations performed by sessions created by the ERP D. allocating a lower percentage of CPU to sessions used by the REPORTING application than to E. limiting the physical I/O performed by the sessions or users of the ERP application that are. See the full explanation below for the reasoning.
Question
Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries. You want to set a priority for the workload generated by the ERP application and optimize resource usage for them. Which three objectives can be achieved by the Resource Manager? (Choose three.)
Options
- Alimiting the amount of time that a session is idle and blocking other sessions of the ERP
- Blimiting the amount of undo generated by operations performed by sessions created by the ERP
- Ccreating two resource plans with resource limits defined for the workload generated by the
- Dallocating a lower percentage of CPU to sessions used by the REPORTING application than to
- Elimiting the physical I/O performed by the sessions or users of the ERP application that are
How the community answered
(26 responses)- A15% (4)
- B77% (20)
- C8% (2)
Community Discussion
No community discussion yet for this question.