What is Parallel Execution?
At a very high level, parallel execution is a means for Oracle to “divide and conquer” the process of fetching data Oracle tables.  
 
What is Parallel Execution?
At a very high level, parallel execution is a means for Oracle to “divide and conquer” the process of fetching data Oracle tables.  
 
What is SQL Result Set Caching?

Like the name suggesting, SQL Result Set Caching provides a mechanism to cache result sets of a SQL query in the memory; specifically, in a memory structure inside the shared pool. This is not to be confused with caching database blocks in the buffer cache; SQL Result Set Caching caches results of SQL statements. The goal is to reduce round trips to the database and improve performance.

 

Centroid's October 25th, 2011 webinar that covered Exadata Smart Flash Cache generated a number of questions. In this blog I'll do my best to answer these questions, and I'll list the questions exactly as posed during the webinar.

 

In our October 11, 2011 Webinar on the topic of Exadata Hybrid Columnar Compression, we presented several real-world examples of HCC in action.  In one of these, when testing query performance against HCC tables, we got what we thought was an unexpected result when applying a query predicate in a query against a table compressed for query high.

 

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.