Exam 1z0-062 topic 1 question 286 discussion

Actual exam question from Oracle's 1z0-062

Question #: 286
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.)

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.

Show Suggested Answer

Suggested Answer: DE 🗳️

by khan at April 2, 2019, 12:02 a.m.

Comments

Submit Cancel

khan

Highly Voted 6 years, 3 months ago

think, DE If a user exceeds the CONNECT_TIME or IDLE_TIME session resource limit, then the database rolls back the current transaction and ends the session. When the user process next issues a call, the database returns an error. https://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310

upvoted 11 times

...