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.)

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.



Leave a Reply 3

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


Eric

Eric

Why BC, not DE?

D

D

I agree D because resource plan is used and E as well because resource_limit is true