Which two actions would you take to prevent this problem?

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.

Download Printable PDF. VALID exam to help you PASS.

One thought on “Which two actions would you take to prevent this problem?

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.