性能调优---找到发生锁等待较多的表，优化处理

database sysmaster;
select dbsname,tabname,
sum(pf_rqlock) as locks,
sum(pf_wtlock) as lockwaits,
sum(pf_deadlk) as deadlocks
from sysactptnhdr,systabnames
where pf_wtlock > 0
and systabnames.partnum = sysactptnhdr.partnum
group by dbsname,tabname
order by lockwaits desc;