Oracle ODA (Database Appliance) - Database upgrade using OAK
In this blog, I am going to discuss how to upgrade database on an ODA using 'oak' from 11.2.0.3 to 11.2.0.4. I will be mentioning what if - in case...
Monday, November 30, 2015
Oracle Database 12c - Statistics Gather Reporting
Database 12c came up with a brilliant feature of reporting of stats, i.e, you can run stats gather in reporting mode, rather than just running it. This will tell you...
Tuesday, November 3, 2015
Exadata - ExaWatcher configuration
Exawatcher is the elder brother or say sibling to OSWatcher on Exadata. It has additional diagnostics options for RDS logs/diags which are specific to Exadata only. In this blog we...
Tuesday, October 27, 2015
Oracle Database - 12c - Real-Time Database Operation Monitoring
In the latest release of Oracle - 12c, Oracle has come up with another brilliant feature for performance monitoring which is Real-Time Database Operation Monitoring. Real time Sql monitoring was introduced...
Thursday, October 22, 2015
Oracle Database - 12c - Data Pump Error during ORA-1031 during export of SYS tables
Issue occurs when you do a full export of your 12c (mine is 12.1.0.2) database with export of few SYS tables. This is when you do a consistent export using...
Saturday, October 17, 2015
12c - Histogram-Buckets Increased in
Oracle significantly increased the number of histogram buckets in 12c to 2048, that is an increase by 8 folds. In this blog, let's just prove that - I will use...
Tuesday, October 13, 2015
12c - Enable Unified Auditing
Oracle introduced Unified Auditing in 12c This however requires you to relink the binaries (oops downtime).. So if you are planning to get 12c and are going to use Unified...
Friday, October 9, 2015
RMAN vs ZFS Compression
Continuing from my Last blog on ZFS compression, this is the RMAN day. I wanted to bring about few statistics in performance (time and space) but this time - RMAN...
Wednesday, October 7, 2015
Remote Listener Cross Registration (across clusters)
Remote Listener Cross Registration (across clusters) can be really confusing to figure out. Let me explain - We were to migrate to a new engineered system environment from the old...
ZFS - Compression
ZFS compression is one of a real great things I like about ZFS, (apart from it's powerful cloning and snapshot abilities). ZFS compresses data on the fly. So what does...
Exadata - Two Seldom used attributes
Exadata is a one of the most powerful product from Oracle, probably the most powerful engineered system available for consumer business on the planet. Today I talk about few features...
