- 最后登录
- 2018-11-1
- 在线时间
- 377 小时
- 威望
- 29
- 金钱
- 6866
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 891
- 精华
- 4
- 积分
- 29
- UID
- 1
|
3#
发表于 2013-12-4 13:34:25
- RECOMMENDATION 1: Application Analysis, 55% benefit (96585 seconds)
- ACTION: Significant row contention was detected in the TABLE
- "ILEARN_TRA.TRAINING_BAG_CLASS" with object id 67213. Trace the cause
- of row contention in the application logic using the given blocked
- SQL.
- RELEVANT OBJECT: database object with id 67213
- RATIONALE: The SQL statement with SQL_ID "fxd86ruy8y4y8" was blocked on
- row locks.
- RELEVANT OBJECT: SQL statement with SQL_ID fxd86ruy8y4y8
- update training_bag_class tbc set tbc.FEE_APP_STATUS = :1 where
- tbc.id=:2
- RATIONALE: The SQL statement with SQL_ID "1hnru9s260qdy" was blocked on
- row locks.
- RELEVANT OBJECT: SQL statement with SQL_ID 1hnru9s260qdy
- update training_bag_class set
- doc_app_status='A',last_update_by=:1,last_update_date=sysdate where
- id=:2 and site_id=:3 and is_deleted='N'
- RATIONALE: The SQL statement with SQL_ID "63g5j9n03wkj9" was blocked on
- row locks.
- RELEVANT OBJECT: SQL statement with SQL_ID 63g5j9n03wkj9
- update training_bag_class tbc set
- tbc.status='F',last_update_by=:1,last_update_date=sysdate where
- tbc.id =:2
- RATIONALE: The SQL statement with SQL_ID "4ct8nu9suh2dt" was blocked on
- row locks.
- RELEVANT OBJECT: SQL statement with SQL_ID 4ct8nu9suh2dt
- update training_bag_class set fee_app_status=:1,
- last_update_by = :2,
- last_update_date = sysdate where
- id = :3 and is_deleted='N'
- RATIONALE: The SQL statement with SQL_ID "0g35rvcnvb348" was blocked on
- row locks.
- RELEVANT OBJECT: SQL statement with SQL_ID 0g35rvcnvb348
- update training_bag_class set doc_app_status=:1,
- last_update_by = :2,
- last_update_date = sysdate where
- id = :3 and is_deleted='N'
-
复制代码 不合理的交叉update, 需要应用配合调整 |
|