Drop diskgroup does not delete CRS resource and database dependency profile
删除diskgroup 之后无法启动数据库实例,报如下错:PRCR-1013 : Failed to start resource ora.gzdw.dbPRCR-1064 : Failed to start resource ora.gzdw.db on node jczc-1CRS-5017: The resource action "ora.GDATA.dg start" encountered the following error:ORA-15032: not all alterations performedORA-15017: diskgroup "GDATA" cannot be mountedORA-15040: diskgroup is incompleteDrop diskgroup does not delete CRS resource and database dependency profile
LATCH:ROW CACHE OBJECTS故障处理
I.症状: 业务侧反馈应用缓慢,我方发现数据库缓慢,并伴随有LATCH:ROW CACHE OBJECTS等待事件,数据库CPU过高。 II.解决方案: 通过如下分析是由于故障时段的业务增长并且大量硬解析,硬解析需要去获取数据字典资源,这需要获得latch(一种锁机制)若硬解析量太大,会造成严重的latch争用,占用非常...