- About Us
- Events and Webinars
- Contact Us
The control-case was done with SYSTEM.MYOBJ, which has the following characteristics:
Let’s create a tablespace in the NOSSDATA_CM01 ASM disk group:
Now let’s create a copy of MYOBJ in this tablespace:
Let’s measure how large the new table is:
And finally, let’s test the same full-scan operation that yielded a 99%+ cell scan efficiency:
As we can see from the above test:
Set CELL.SMART_SCAN_CAPABLE=TRUE on ASM disk groups which reside on Exadata Grid Disks.
Centroid is a cloud services and technology company that provides Oracle enterprise workload consulting and managed services across Oracle, Azure, Amazon, Google, and private cloud. From applications to technology to infrastructure, Centroid’s depth of Oracle expertise and breadth of cloud capabilities helps clients modernize, transform, and grow their business to the next level.