试题详情
- 多项选择题 You receive complaints from users regarding the high waiting time for their transactions. Oninvestigation， you find that some users are not committing their transactions though they are notperforming 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（）
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
关注下方微信公众号，在线模考后查看
热门试题
- The EMP table has t
- 假设需要在Windows的命令行工具中使
- Given： class C
- Given: Whatistheres
- Note the following
- Which of
- 你定义了一个对象类型myOBJ，要基于该
- Which statemen
- Which clause would y
- 序列的用途是什么？
- Evaluatethefollowing
- Which NLS parameter
- Examine the&en
- TheEMPtablecontainst
- Where can̳
- Youexecutedthefollow
- In a database with t
- The EMPLOYEES table
- In which
- Evaluatethefollowing