Now the Oracle REST Data Services 3.0 Early Adopter is available, let us have a look how it’s to be installed in Weblogic 12c!
I’ve ommitted the installation or upgrade of Apex here as there is plenty of documentation on that topic, and the ORDS can be applied for other uses than being an Apex Listener since v2.0.4.
Download the Application Express and ORDS 3.0 installer from the Oracle (more...)
I’ve spent a few days playing with patching 22.214.171.124 with the so called “Database Patch for Engineered Systems and Database In-Memory”. Lets skip over why these not necessarily related feature sets should be bundled together into effectively a Bundle Patch.
First I was testing going from 126.96.36.199.1 to BP2 or 188.8.131.52.2. Then as soon as I’d done that of course BP3 was released.
I was at a talk recently, and there was an update by Jason Arneil about adding columns to tables with DEFAULT values in Oracle 12C. The NOT NULL restriction has been lifted and now Oracle cleverly intercepts the null value and replaces it with the DEFAULT meta-data without storing it in the table. To repeat the 11G experiment I ran recently:
SQL> alter table ncha.tab1 add (filler_default char(1000) default 'EXPAND' not (more...)
Recently, I’ve been engaged in a conversation on the OTN community pages about upgrading Oracle GoldenGate 12c from 184.108.40.206.0 to the 220.127.116.11.0. During the discussion I mentioned that you can upgrade using the Oracle Universal Installer (OUI) that is now available with Oracle GoldenGate 12c. The upgrade process I’m going to show you here is an in-place upgrade of Oracle GoldenGate 12c for Oracle Database 12c.
I’ve previously discussed the new Zone Map database feature and how they work in a similar manner to Exadata Storage indexes. Just like Storage Indexes (and conventional indexes for that manner), they work best when the data is well clustered in relation to the Zone Map or index. By having the data in the table […]
With the release of the Oracle Database 18.104.22.168 there was a number of new features and options. Most of the publicity has been around the in-Memory option. But there was lots of other features for the DBA and a few for the developer.
One of the new SQL functions is the APPROX_COUNT_DISTINCT(). This function is different to the tradition count distinct, COUNT(DISTINCT expression), in that is performs an approximate count distinct. (more...)
With Basic Compression, you cannot drop a column.
create table t1
table T1 created.
alter table t1 drop column col2;
SQL Error: ORA-39726: unsupported add/drop column operation on compressed tables
39726. 00000 - "unsupported add/drop column operation on compressed tables"
*Cause: An unsupported add/drop column operation for compressed table
*Action: When adding a column, do not specify a default value.
DROP column is only supported in the form (more...)
We’ve had issues with RAC one-node and OEM for a very long time. One really vexing issue has to do with incorrect instance status after a relocation.
EM12c: Scan Listener Shows Down Status In EM Console After Relocation (Doc ID 1932744.1) has instructions for fixing the issue. It boils down to this:
There is an OMS parameter called oracle.sysman.db.rac.ReconfigProcessingEnable that is not set under normal circumstances for Real Application Clusters because (more...)
Last week I attended the East Coast Oracle User Group conference, also known as ECO, in Raleigh, NC. This being my first time at ECO, it was a good event for being a two day conference. The low-key environment provided a nice, comfortable environment for interaction between the speakers and those in attendance. If you ever have the chance to catch this conference, it would be a good one to attend.
What you can expect (more...)
Just a quick note that I posted slides for the 2 talks I did at ECO in Raleigh this week:
In-Memory In Action (without Tanel Poder) :)
Great crowd. I really enjoyed myself.
Note: You can also find other presentations on my Whitepapers/Presentations page via the link at the top of the screen.
As shared by a well known Oracle and Big Data performance geek!
SQL> ALTER SYSTEM SET inmemory_size = 5T SCOPE=spfile;
ALTER SYSTEM SET inmemory_size = 5T SCOPE=spfile
ERROR at line 1:
ORA-32005: error while parsing size specification [5T]
SQL> ALTER SYSTEM SET inmemory_size = 5120G SCOPE=spfile;
A good question from Robert Thorneycroft I thought warranted its own post. He asked: “I have a question regarding bitmapped indexes verses index compression. In your previous blog titled ‘So What Is A Good Cardinality Estimate For A Bitmap Index Column ? (Song 2)’ you came to the conclusion that ‘500,000 distinct values in a 1 […]
In Part I, I discussed how Zone Maps are new index like structures, similar to Exadata Storage Indexes, that enables the “pruning” of disk blocks during accesses of the table by storing the min and max values of selected columns for each “zone” of a table. A Zone being a range of contiguous (8M) blocks. I […]
In this post I want to show some example of using a new feature in 12c for selecting the first X number of records from the results set of a query.
See the bottom of this post for the background and some of the reasons for this post.
Before we had the 12c Database if we only wanted to see a subset or the initial set of records from the results of a query we (more...)
In earlier versions of the Enterprise Manager it was already possible to recover faulted instances of webservices. Like for instance when a service that the instance depends on is down, the instance will throw a fault and stop processing. When the underlying service is up again, you could go back to the faulted instance and use recovery to have it continue from the step it faulted on.
Now with the introduction of 12c the Error (more...)
The following steps are what I did for installing 22.214.171.124 on Windows.
1. Download the Oracle installation ZIP files from the Oracle Downloads page.
2. Unzip the two 12c downloads files into the same directory.
3. Go to the newly created directory (it is probably called 'database') and you will find a file called setup.exe. Double click on this file.
After a couple of seconds you will see the Oracle Database (more...)
Sometimes, a few pictures (or in this case index block dumps) is better than a whole bunch of words :) In my previous post, I introduced the new Advanced Index Compression feature, whereby Oracle automatically determines how to best compress an index. I showed a simple example of an indexed column that had sections of index entries that were […]
I was upgrading an Exadata test database from 126.96.36.199 to 188.8.131.52 and I came across a failure scenario I had not encountered before. I’ve upgraded a few databases to both 184.108.40.206 and 220.127.116.11 for test purposes, but this was the first one I’d done on Exadata. And the first time I’d encountered such a failure.
I started the upgrade after checking with the (more...)
I’ve finally managed to find some free time in the evening to write a new blog piece :) This will have to be the record for the longest time between parts in a series, having written Part IV of this Index Compression series way way back in February 2008 !! Here are the links to the previous articles […]
I started looking into In-Memory on RAC this week. Data can be distributed across RAC nodes in a couple of different ways. The default is to spread it across the available nodes in the cluster. So if you had a 2 node cluster, roughly 50% of the data in your table or partition would be loaded into the column store in each of the 2 instances.
SYS@dw1> alter table kso.skew inmemory;