07 2021 档案

摘要:In single instance environment, when a deadlock happens, it often reports ORA-60, see Document 15476.1 FAQ: Detecting and Resolving Locking Conflicts 阅读全文
posted @ 2021-07-29 09:40 阿西吧li 阅读(1412) 评论(0) 推荐(0) 编辑
摘要:很简单的sql: select * from (select * from issue.db_infoorder by creator_date) where rownum<10 执行计划如下: 此查询需要12秒左右。 创建索引 create index idx_time on db_info(cr 阅读全文
posted @ 2021-07-04 20:06 阿西吧li 阅读(346) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示