先看结论
支持度none
置信度medium
严重度major
静态性能风险维度独立报告呈现，不参与兼容评分
不支持
需按命中位置逐条评估改写
库侧 / 应用侧
库侧
需人工确认改造边界
应用侧
需人工确认改造边界
验证建议：全表 UPDATE 在迁移压测中单独评估锁等待、redo/事务日志和回滚窗口；确认是否确为批处理意图。
参考来源
- https://open.10086.cn/panweidb/home
- https://opengauss.org/en/user-practice/carrier/jiangsuyidong/
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SELECT.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/UPDATE.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DELETE.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Joins.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/optimizer-access-paths.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Literals.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Data-Type-Comparison-Rules.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/IN-Condition.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Logical-Conditions.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Pattern-matching-Conditions.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ROWNUM-Pseudocolumn.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/NVL.html
- https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Scalar-Subquery-Expressions.html