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:
Summary
Set CELL.SMART_SCAN_CAPABLE=TRUE on ASM disk groups which reside on Exadata Grid Disks.
1050 Wilshire Drive,
Suite 170,
Troy, MI 48084
Phone: (248) 465-9533
Toll free: 1-877-868-1753
Email: [email protected]
© Centroid, Inc. All rights reserved. Contact Privacy Policy Terms of Use CCPA Policy
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.
© Centroid, Inc. All rights reserved. Contact Privacy Policy Terms of Use CCPA Policy