回复 6# db2china2 我建议你自己找个独立的环境,亲自动手做个测试:1、重启数据库,开启快照,收集get snap for db 关注下面的一些选项Locks held currently = 0Lock ...
显示全部回复 6# db2china2 我建议你自己找个独立的环境,亲自动手做个测试:
1、重启数据库,开启快照,收集get snap for db
关注下面的一些选项
Locks held currently = 0Lock waits = 0
Time database waited on locks (ms) = Not Collected
Lock list memory in use (Bytes) = 2256
Deadlocks detected = 0
Lock escalations = 0
Exclusive lock escalations = 0
Agents currently waiting on locks = 0
Lock Timeouts = 0
Number of indoubt transactions = 0
2、间隔几次,发起DML操作,
3、再次收集快照信息,与第一次的收集的信息进行对比
自己实际操作下,不就清楚了。
收起