188.You receive complaints from users regarding the high waiting time for their transactions. On inv

188.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 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.
答案：AB
解析：
A:正确，IDLE_TIME:没有活动的时间，单位分，idle_time 只是计算服务器进程
B:正确
C:错误，这里说的是logical_reads_per_session，这个与锁没啥关系
D:错误,这个是说的事务槽，事务槽太小的话可能造成itl等待，因此大的并发操作的时候最好增加足够的itl，所以这里不能是减小
数据块的内容和参数
1.块头
存储数据块的地址、表目录、行目录和事务槽，头部从上往下增长
2.数据区
  位于数据块的底部，当插入行的时候从下向上增长
3.空闲区
  位于中间，最初始是连续的，当删除和插入后导致碎片化，smon会进行合并空闲区的操作
数据槽
  记录了事务信息，回滚段的入口，事务类型