Blog

Automatic Degree of Parallelism in Oracle 11gR2

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. See http://docs.oracle.com/cd/E14072_01/server.112/e10837/parallel.htm#CACEEBJJ. Parallel execution in Oracle allows a single database operation to apply multiple CPU and IO resources (i.e., processes) to work together to retrieve the results.  Parallel execution […]

Read More

Parallel Execution and Partitioning

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. See http://docs.oracle.com/cd/E14072_01/server.112/e10837/parallel.htm#CACEEBJJ. Parallel execution in Oracle allows a single database operation to apply multiple CPU and IO resources (i.e., processes) to work together to retrieve the results.  Parallel execution […]

Read More

Measuring Parallel Execution

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. See http://docs.oracle.com/cd/E14072_01/server.112/e10837/parallel.htm#CACEEBJJ. Parallel execution in Oracle allows a single database operation to apply multiple CPU and IO resources (i.e., processes) to work together to retrieve the results. Parallel execution […]

Read More

Settings that Impact Parallel Execution in Oracle 11gR2

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. See http://docs.oracle.com/cd/E14072_01/server.112/e10837/parallel.htm#CACEEBJJ. Parallel execution in Oracle allows a single database operation to apply multiple CPU and IO resources (i.e., processes) to work together to retrieve the results. Parallel execution […]

Read More

SQL Result Set Cache in Oracle 11gR2

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 […]

Read More

Exadata Smart Flash Cache: Centroid Webinar Follow-Up

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. Question: How do I increase the effectiveness of Smart Flash Cache? This is sort of an open-ended […]

Read More

Hybrid Columnar Compression: Querying with Predicates and Decompression

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 […]

Read More

Software Licensing – Extended Capabilities for Support and Management

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: Consumption:  In order to maximize internal software license usage, sufficient availability must be balanced with the cost of additional license purchases. Production:  If software licenses are part of a company’s product […]

Read More

Oracle On Demand

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. Background I have worked with Oracle Applications for over 15 years.  Involved with everything from […]

Read More

Monitoring Exadata with Wait Events

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. […]

Read More

Whatever we ask them to do, we know they'll deliver a solution and not leave us hanging.

Tony Deller Manager Data Center Technical Engineering