What is SQL Monitoring?

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.

 
What is Oracle’s Execution Plan?

An Oracle execution plan is a detailed set of steps showing how Oracle will access the requested data.

 
Oracle has waived the extended support fee for E-Business Suite 11i again and this time until November 2013.  This extension now spans the entire three years of the Extended Support period, December 2010 – November 2013. This is a two-year extension to the initial waiver for the first year of the Extended Support fees. 

This is great news for many customers who want to maximize their investment from their ERP implementations while planning on a Release 12 or Fusion Applications upgrade or implementation later in the Release 11i Extended Support period. 

 
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 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.