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
阅读全文
摘要:很简单的sql: select * from (select * from issue.db_infoorder by creator_date) where rownum<10 执行计划如下: 此查询需要12秒左右。 创建索引 create index idx_time on db_info(cr
阅读全文