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 row-level 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.
答案:(A、B)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1239861/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1239861/