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…

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…

Heavy swapping observed on system in last 5 mins

As I was refreshing a dev database and checking out the alert log I noticed the following message:

To make sure it wasn’t to do with the refresh I looked at other database alert logs and history and found that this message has been constantly appearing in all logs for the last 6 months…