Profile

Cover photo
emad mansour
94 followers|4,386 views
AboutPostsPhotosVideos

Stream

emad mansour

Shared publicly  - 
 
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...
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...
1
Add a comment...

emad mansour

Shared publicly  - 
 
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...
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 usi...
1
Add a comment...
Have him in circles
94 people
‫زكريا العولقي‬‎'s profile photo
Tamer Omar's profile photo
‫محمد فرج‬‎'s profile photo
Farouk Taha's profile photo
Ahmed Fahmy's profile photo
ehab sayed's profile photo
sameh khedr's profile photo
Ghssan Lok's profile photo
Soufiane Gh's profile photo

emad mansour

Shared publicly  - 
 
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 usi...
1
Add a comment...

emad mansour

Shared publicly  - 
 
Delete Attachment files for Oracle E-Bus Suite 11i or R12
If you face issue with huge space for attachment files on Oracle E-Bus Suite and you need to delete it from Cloned instance to reclaim your space, Please follow below procedure: 1-select distinct (entity_name) from fnd_attach...
1
Add a comment...
People
Have him in circles
94 people
‫زكريا العولقي‬‎'s profile photo
Tamer Omar's profile photo
‫محمد فرج‬‎'s profile photo
Farouk Taha's profile photo
Ahmed Fahmy's profile photo
ehab sayed's profile photo
sameh khedr's profile photo
Ghssan Lok's profile photo
Soufiane Gh's profile photo
Links
Basic Information
Gender
Male
Apps with Google+ Sign-in
  • 건쉽배틀
  • Jungle Heat