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.)
A.
limiting the amount of time that a session is idle and blocking other sessions of the ERP
application
B.
limiting the amount of undo generated by operations performed by sessions created by
the ERP application
C.
creating two resource plans with resource limits defined for the workload generated by
the applications and automatically changing resource plans based on the workload
D.
allocating a lower percentage of CPU to sessions used by the REPORTING application
than to those used by the ERP application
E.
limiting the physical I/O performed by the sessions or users of the ERPapplicationthat are
connected to the database
A,B,D
I’d say A,C,D
As for C
Allow a database to use different resource plans, based on changing workload requirements. You can dynamically change the resource plan, for example, from a daytime resource plan to a nighttime resource plan, without having to shut down and restart the instance.
https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN-GUID-04B4805A-A3B4-4B1E-B42D-01BAB4D4ECB4
ACD
B is wrong
imo ACD