Oracle’s 18.104.22.168 was released a few weeks ago (You can download it from OTN here: Oracle 22.214.171.124 Download). While technically a minor point release, it contains a couple of major features that would normally be rolled out in a more substantial version change like 12cR2 or perhaps V13. Of course the most highly anticipated feature is a new option (Oracle In-Memory Option) that provides a column (more...)
I keep hearing about “Center of Excellence”. The term makes no sense to me. What does it mean? The middle (center) of wonderfulness? A place (center) where one goes to become excellent? Lately I’ve been hearing it used to describe our lab which is just a collection of computer equipment. In our case it’s a bunch of Oracle Engineered Systems. Our lab is really cool because we have a bunch of bad ass toys. I (more...)
Just a quick post on a new Exadata feature called Zone Maps. They’re similar to storage indexes on Exadata, but with more control (you can define the columns and how the data is refreshed for example). People have complained for years that storage indexes provided no control mechanisms, but now we have a way to exert our God given rights as DBA’s to control yet another aspect of the database. Here’s a link to the (more...)
I saw this very odd statement on an SAP system last week.
SELECT /*+ AVOID_FULL ("/bic/xxx") */ * FROM "/BIC/XXX" WHERE "/BIC/XXX"=:A0
I had never seen that hint before so I thought I’d do a little investigation. First I did a quick check on a test case to see if it worked.
SYS@DEMO1> select /*+ avoid_full(a) */ count(*) from kso.skew a where col1=234657; COUNT(*) ---------- 32 SYS@DEMO1> @x (more...)
The Oracle 11g parameter parallel_degree_limit is designed to put a cap on the maximum DOP for a statement.
The Oracle Data Base Reference 11g Release 2 (11.2) says this:
A numeric value for this parameter specifies the maximum degree of parallelism the optimizer can choose for a SQL statement when automatic degree of parallelism is active. Automatic degree of parallelism is only enabled if PARALLEL_DEGREE_POLICY is set to AUTO or LIMITED.
But that’s not (more...)
Last week I did a webinar on 12c Adaptive Optimization. The talk was recorded. The slides are here: 12c Adaptive Optimization V2 PDF. The recording can be found here: 12c Adaptive Optimization Recording. There were a number of follow up questions and emails so I thought I’d summarize here. Since (more...)
The APPEND_VALUES hint was introduced in 11.2 to allow direct path inserts with variables using the VALUES clause. i.e.
INSERT INTO XYZ (COL1, COL2) VALUES (:A, :B);
The feature was designed to allow bulk inserting via arrays of 100′s or 1000′s of records in a single insert statement. (more...)