There are two primary aspects to software licensing:  production and consumption.  Each aspect requires proper management and support capabilities in order to maximize the benefits:

Oracle on Demand, What’s That All About?
Maybe you have worked with Oracle for a long time, maybe you are new, but if you have not worked with Oracle On Demand, here are few things you may want to know.
You can monitor cell and Exadata functionality specific wait events as you would normally in 11gR2, but some key additional wait events have been added to provide additional detailed information.

The events above are cell-related wait events, but there are also Flash Cache related events as well, with the scripts provided in a subsection below.


Storage indexes are unique Exadata structures whose goal is to reduce the amount of IO returned and required from the Exadata cell. When queries run in which storage indexes are eligible, Oracle tracks minimum and maximum predicate values and stores these into 1Mb memory regions in each cell.

Parallel Query

Parallel query works the same on Exadata as it does on non-Exadata 11gR2.  With Exadata, which you’ve cost-justified based on your database’s performance requirements, business-criticality, or some other reason, you want to get the most performance out of your investment, so exploiting the benefits of parallel query is important.

What is DBFS?

DBFS stands for Database File System, and it’s Oracle’s method for housing an operating system-like file-system within an Oracle relational database.  It has its roots with iFS, but its functionality and capabilities have been extended.  Here are some reasons why DBFS is a good thing:


What is SQL Compiler Tracing?

SQL compiler tracing is a method to generate trace files that indicate what steps and actions the cost-base optimizer (CBO) used to determine a SQL statement’s execution plan.  It is an extension of the 10053 trace that’s been around for years, enhanced in 11g to provide arguably easier syntax and additional features.

What is SQL Test Case Builder?

SQL Test Case Builder is a diagnostic tool in 11g, back-ported to 10g, that is designed to be able to obtain a reproducible test case for developers, DBAs, or Oracle Support. 


Starting with 11g, Oracle introduced a new tool to add to the performance optimizer’s toolkit called “Real Time SQL Monitoring”.  Real Time SQL Monitoring, or just “SQL Monitoring”, enables you to measure the performance of SQL statements while they are executing.  SQL Monitoring is enabled any time a statement runs in parallel or when it consumes more than 5 seconds of CPU or IO time.


Exadata Smart Scan processing is one of the key components of Exadata's "secret sauce". It enables certain operations to be offloaded to the storage cell, reducing the amount of work required on the database tier nodes and reducing the impact of shipping blocks over the storage interconnect. Scripts are provided in this that can be used to monitor your own Exadata environment.