AWS / Azure / GCP Cloud | Database | Data Analytics | LakeHouse | Machine Learning | Shrenik Parekh

Enable smart scan for ASM Disk group while creating disk group in Exadata SQL> CREATE DISKGROUP data HIGH REDUNDANCY DISK 'o/*/DATA*' ATTRIBUTE 'AU_SIZE' = '4M',           'content.type' = 'data',           'cell.smart_scan_capable'='TRUE',           'compatible.rdbms'='11.2.0.2',           'compatible.asm'='11.2.0.3'; Ref.: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-administering-asm.htm#SAGUG20526 Check cell smart scan is enables for ASM disk or not:  Make sure to connect ASM instance, if you connect to DB instance you won't find value. SELECT dg.name AS diskgroup, SUBSTR(a.name,1,24) AS name, SUBSTR(a.value,1,24) AS value FROM V$ASM_DISKGROUP dg, V$ASM_ATTRIBUTE a WHERE dg.group_number = a.group_number and a.NAME = 'cell.smart_scan_capable'; EXADATA - Importance of Cellinit.ora and Celli...