2020-07-23
update TABLE_LOCK问题
5M有一条简单的update语句,每次只更新一条记录,
update table t set T.A = :1 , T.B = :2 , T.C = :3 WHERE 1 = 1 AND T.PHON_NUM = :4 AND T.E = :5 AND T.F = :6
T表数据量大概五千万,where条件有走索引
这个语句从AWR看大概每小时执行两百次
SELECT s.username,decode(l.type, ‘TM’, ‘TABLE LOCK’, ‘TX’, ‘ROW LOCK’, NULL) LOCK_LEVEL,o.owner,o.object_name,o.object_type,s.sid,s.serial#
FROM gvlock l, dba_objects o WHERE l.sid = s.sid AND l.id1 = o.object_id(+) AND s.username is NOT NULL
用这个语句抓取频繁出现该语句,是否正常?
收藏
分享
3条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏


评论
