Storage Administration - Oracle Exadata Recipes: A Problem-Solution Approach - page 283

Tablespace created.

SYS @ visx1>

6. Now, identify a table to conduct a full table scan against what will qualify for Exadata

Smart Scan. In the following test, we will create two new tables for demonstration
purposes, MMT_SS and MMT_NOSS :

SYS @ visx1> create table apps.mmt_ss
tablespace ts1 nologging
as select /*+ full (mmt) */ * from inv.mtl_material_transactions mmt
/

Table created.

SYS @ visx1>

SYS @ visx1> create table apps.mmt_noss
tablespace ts2 nologging
as select /*+ full (mmt) */ * from inv.mtl_material_transactions mmt
/

Table created.

SYS @ visx1>

■ recipes in Chapter 15 discuss Smart Scan in detail. please refer to these recipes for additional details about
exadata Smart Scan.

Note

7. Once your tables are identified, run a query against them that performs a full table scan.

Start by querying your table stored in the DATA_CM01 disk group with cell.smart_scan_
capable=TRUE .

8. Next, execute a query that will benefit from Smart Scan:

APPS @ visx1> select count(1) from (
2 select /*+ full (x) */ *
3 from mmt_ss x)
4 ;

COUNT(1)
----------
8783431
Elapsed: 00:00:03.30