1Z0-052 · Question #119
You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committing their transactions though they are not performin
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #119. The question stem and answer options stay visible for context.
Question
You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committing their transactions though they are not performing any activity for a long time. As a result, SQL statements need to wait for rowlevel locks. Which two actions could you take to prevent this locking problem in the future? (Choose two.)
Options
- ADecrease the IDLE_TIME resource limit in the profile assigned to the blocking users.
- BUse Database Resource Manager to automatically log out sessions that block others and are idle
- CSet the limit in the profile of blocking users to control the number of blocks to be accessed in a session.
- DDecrease the maximum number of interested transaction list (ITL) slots for the segments on which the
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.