Examine the parameters:
Users complain that their sessions for certain transactions hang. You investigate and discover that some users
fail to complete their transactions, causing other transactions to wait on row-level locks.
Which two actions would you take to prevent this problem? (Choose two.)
A.
Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction.
B.
Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.
C.
Set a limit in the profiles of blocking users to control the number of data blocks that can be accessed in a
session.
D.
Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other
sessions.
E.
Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users.
Why BC, not DE?
I agree D because resource plan is used and E as well because resource_limit is true
I think DE