ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-052 All Questions

View all questions & answers for the 1z0-052 exam
Go to Exam

Exam 1z0-052 topic 3 question 33 discussion

Actual exam question from Oracle's 1z0-052
Question #: 33
Topic #: 3
[All 1z0-052 Questions]

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

  • A. Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.
  • B. Use Database Resource Manager to automatically log out sessions that block others and are idle
  • C. Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.
  • D. Decrease the maximum number of interested transaction list (ITL) slots for the segments on which the blocking user performs the transaction.
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️
by thuthuysphn58 at April 4, 2025, 7:28 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel