Profile cover photo
Profile photo
emad mansour
92 followers
92 followers
About
emad's posts

Post has attachment
Index (when and how to rebuild it)
Index should rebuild if blevel column in dba_indexes greater than 3 or you can query INDEX_STATS for lef_rows and del_lef_rows to know the percentage of deleted rows from the index. if the percentage is more than 20% but make sure to analyze index before ch...

Post has attachment

Post has attachment
OCR and Vote Migrate after Upgrade Cluster from 10 to 11gR2
1-set the ASM Compatibility compatibility attribute to 11.2.0.0 ALTER DISKGROUP <Diskgroup Name> SET ATTRIBUTE 'compatible.asm' = '11.2.0.0'; 2-Moving OCR ->crsctl query crs activeversion ->Create OCR and voting Diskgroup using asmca or command line ->ocrco...

Post has attachment
Wait while more posts are being loaded