本案例来自东区某客户,数据库版本rac 11.2.0.4。有一条并发很高的sql,不定时的会产生大量的latch free,sql执行时间比正常时段有大概100倍的性能衰减。
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 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 set join conversion SJC systatedump truncate 磁盘组无法mount
-
近期文章
近期评论