Which four objectives are achieved by using Resource Manager tomanage multiple
concurrent user sessions that are competing for resources?(Choose four.)
A.
distributing available CPU by allocating percentages of CPU time to different users and
applications
B.
limiting the degree of parallelism of any operation performed by members of a group of
users
C.
limiting queries based on resource consumption of runaway sessions or calls that
consume more than a specified amount of CPU, physical I/O, logical I/O, or elapsed time
D.
limiting the number of concurrent sessions for a user
E.
limiting the number of user sessions allowed to be concurrently active within a group of
users
F.
limiting the number of parallel executions that can be executed by a user
imo A,B,C,E
F sounds strange, limiting the number of parallel executions?
DRM can limit the degree of parallelism or the number of parallel servers consumed by a group…
I agree with vasya. F is not accurate the docs says:
Limit the number of parallel execution servers that a group of users can use. This ensures that all the available parallel execution servers are not allocated to only one group of users.
correct: A,B,C,E
https://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm.htm#ADMIN11842
Based on https://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm.htm#ADMIN11842
C is wrong because it states that sessions are limited by “elapsed time”. The doc does not reference “elapsed time”, only the CPU and I / O.
D is wrong because it states that there is a limit of sessions per user. Correct is limit of active sessions per user
ABEF – Right