Advertisement

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...

Lost Patches in Upgrade

 

I was recently working on an upgrade of the cluster from 11g - 12c and ended up in a peculiar situation. The ora inventory did not get updated but the...

12c GRID - changes to oraenv script

 

If you have moved to or planning to move to 12c-GI, then you need to be careful with your existing scripts. Oracle changed the way environment is set using the...

Page 1 of 39123»