12.1.0.2 – Full Database Caching

One of the new features of 12.1.0.2 is full database caching. Some of the cynics out there might say “hey, this is how it used to work back in the pre 11 days” before this direct path read thingy. Lets see it in action.

We’ve created a table and set some dummy stats so…

12.1.0.1 to 12.1.0.2 Upgrade

Now that 12.1.0.2 is released and readily available lets see it in action adn upgrade an existing 12c database. I’ll be using the 12c Oracle Developoer Days VM as my lab. Download linuxamd64_12102_database_1of2.zip and linuxamd64_12102_database_1of2.zip Unzip the files into a staging area.

Once unzipped run “runInstaller” and follow the prompts. I’ll be running and…

Oracle Database 12c Release 1 (12.1.0.2) is Out

12.1.0.2 has landed. You can download from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html or edelivery.oracle.com The new features documentation can be found at Oracle Database 12c Release 1 (12.1.0.2) New Features New features (other than the widely advertised in-memory option) include: “Advanced Index Compression” “Approximate Count Distinct” “Attribute Clustering” “Automatic Big Table Caching” “FDA Support for CDBs” “Full Database Caching”…

Database Startup and Strange Semaphore Problem

One of our Netapp SnapManager database backup jobs was failing due to the instance being down on the first node of a 10G 4 node Solaris RAC. The backups are only configured to run off the first node so when I went to start up the instance I got the following error message:

After…

Number problems with JSON, Perl and DBD::Oracle

I’m developing a little Oracle reporting tool using Perl Dancer and Google Charts and I’ve hit an issue with JSON::XS output of number columns being quoted. Here’s a small example of the problem with the solution I found.

And now if we run this we get the number 1 with quotes – “1”. Thats…

Golden Gate Flat File Adapter

Oracle Golden Gate is a heterogeneous replication tool supporting a number of database technologies. So if your database is not supported (eg. Netezza, Greenplum) you have the option of using the flat file adapter plugin. Lets go through an example of setting this up. Files can be downloaded from OTN or edelivery.oracle.com. GG – 121200_fbo_ggs_Linux_x64_shiphome.zip…