在oracle sql优化中,往往只关注逻辑读的消耗,而忽略了join消耗的时间,特别是高频值进行join关联出大量rows的场景。往往join消耗的时间会比扫描对象消耗的逻辑读物理读更耗时。 继续阅读
ACD Active Change Directory AMDU ASM asm disk ASM恢复 asm文件 asm磁盘头 AT bbed block prefetch CBO COD Continuing Operations Directory crash Disk directory disk header drop database EXADATA file directory filter FST gc buffer busy acquire gdb JPPD ksfqpn LGWR library cache lock ohasd ORA-00600[4193] ORA-00600[16703] ORA-04030 ORA-04031 ORA-15042 Predicate Move-Around PST push subquery Query transformations rac rebalance row cache lock smon truncate view merge 磁盘组无法mount
-
近期文章
近期评论