Exadata Performance Improvement Tips
Exadata Performance Improvement Tips Few considerations need to be taken care while dealing with performance tuning in Exadata. 1. Cell.smart_scan_capable 2. Write Back Flash Cache mode 3. Exadata Flash Cache Compression 4. Cell Server Calibration 5. Disk Scrubbing schedule 6. SQL quarantine 7. SQL level performance improvement 8. Huge Pages 9. Exafusion for OLTP 1.CELL.SMART_SCAN_CAPABLE=TRUE To take advantage of Exadata features we need to set CELL.SMART_SCAN_CAPABLE=TRUE on the ASM disk groups in which tablespaces are created. In Exadata Grid Disks are presented to ASM where setting CELL.SMART_SCAN_CAPABLE=TRUE on ASM disk groups all the smart scan operations like predicate filtering, column projection, bloom filter etc are performed at cell storage server. In Exadata and ‘cell smart table scan’ and ‘cell smart index scans’ are used, then you can check the proportion of reads that are actually using SmartScan.: ‘cell physical IO bytes eligible ...