Oracle
1Z0-043 · Question #83
You work as a database administrator at certkiller.com. In your production database, you observe that users' transactions are consuming a lot of resource and you plan to impose resource restrictions…
The correct answer is A. CPU usage B. degree of parallelism E. idle time for blocking sessions. See the full explanation below for the reasoning.
Question
You work as a database administrator at certkiller.com. In your production database, you observe that users' transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager? (Choose three.)
Options
- ACPU usage
- Bdegree of parallelism
- Cnumber of open cursors
- Dnumber of sorts performed
- Eidle time for blocking sessions
- Fnumber of disk I/O operations performed
- Gnumber of memory I/O operations performed
How the community answered
(27 responses)- A85% (23)
- C4% (1)
- D4% (1)
- G7% (2)
Community Discussion
No community discussion yet for this question.