Oracle Exam 1Z0-062 Topic 1 Question 54 Discussion

Actual exam question for Oracle's 1Z0-062 exam

Question #: 54
Topic #: 1

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

AIncrease the maximum number of ITL slots for segments on which a blocking user performs a transaction.

BDecrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.

CSet a limit in the proles of blocking users to control the number of data blocks that can be accessed in a session.

DUse Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions.

EDecrease the IDLE_TIME resource limit in the profiles assigned to blocking users.

Show Suggested Answer

Suggested Answer: B, D

by Dean at May 04, 2022, 02:01 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-062 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!