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_UBER limit in the profiles assigned to blocking users.
C. Set a limit in the prof les of blacking 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.
D is correct but I’m not sure of B.
I think D and A are correct.
ITL can reduce lock contention
http://www.dba-oracle.com/art_dbazine_nanda_segment_transaction_slot_internals.htm