Overview

Scripts

Scripts that are specific to exadata monitoring:

Cell Usage

Flash Cache Content

To see if an object is in the flash cache, we have to know its:

object number

Tablespace number

Database name

once we have that, we can check in the call using the CellCli:

Furthermore, we see that the hitcount in the storage cell is ony: 160, where in SQL query is 477. The reason is the fact that the load was distributed among all 3 cells. We can check that using dcli to query all cells:

In total is 477, just like the SQL query.

Smart Scan

We can see if a query is using the Smart Scan capabilities of the exadata by observing the execution plan:

Query plan using Smart Scan

As you can see above, the query is using the: “TABLE ACCESS STORAGE FULL” which is a sign of using the Smart Scan capabilities. Other indication is the wait time statistics:

Wait time statistics

As you can see, the “Cell smart Table scan” takes the majority of the time. (2.59 seconds out of 2.80 seconds)