Search

Top 60 Oracle Blogs

Recent comments

August 2014

Exadata Zone Maps

Just a quick post on a new Exadata feature called Zone Maps. They’re similar to storage indexes on Exadata, but with more control (you can define the columns and how the data is refreshed for example). People have complained for years that storage indexes provided no control mechanisms, but now we have a way to exert our God given rights as DBA’s to control yet another aspect of the database. Here’s a link to the 12.1.0.2 documentation which resides in the Data Warehousing Guide: Zone Map Documentation

Zone Maps are restricted to Exadata storage by the way (well probably they work on ZFS and Pillar too). Have a look at the Oracle error messages file:

Can you justify your data ?

People ask me to justify use of Delphix. I can understand. Delphix is new and often, most of my friends who are DBAs respond with “I can copy a database myself. So Delphix can copy 10 TB in 10 minutes with 0.0001 TB space. That’s a neat parlor game magic trick, so what?”  Well that’s missing the whole boat. The question won’t be why you should use Delphix but “can you  justify working without Delphix?”

Delphix is amazingly positioned at nexus of data concerns right now – the right place at the right time :

New Oracle Bug alert (Bug 19384287)

Heads up to all the folks running 11.2.0.4 and above if you're using function-based indexes! There's a new Oracle bug 19384287. I'll fill you in with a complete post over at Toad World.

Styling the Squarespace Flatiron

My earlier post on Facebooking the Squarespace Flatiron shows how you never
really leave your site's index page when viewing the gallery pages in your
index collection. How then do you write CSS...



Read the full post at www.gennick.com/database.

Styling the Squarespace Flatiron

My earlier post on Facebooking the Squarespace Flatiron shows how you never
really leave your site's index page when viewing the gallery pages in your
index collection. How then do you write CSS...



Read the full post at www.gennick.com/database.

Gmail and the Mystery of Auntie Spam

Are you member of an email group only to find Gmail sending some of the
messages to spam? Tired of alwys checking for those and missing out on the
discussions? Fret no longer. There is a solution. 



Read the full post at www.gennick.com/database.

Gmail and the Mystery of Auntie Spam

Are you member of an email group only to find Gmail sending some of the
messages to spam? Tired of alwys checking for those and missing out on the
discussions? Fret no longer. There is a solution. 



Read the full post at www.gennick.com/database.

To PDB or not to PDB : The final decision

After yesterday’s to PDB or not to PDB post, I decided the answer was “to PDB”. Here’s what I did…

What is Delphix ? (video presentation)

#555555;">According to a recent IDC study, on average Delphix

  • pays for itself in 4.3 months
  • 461% ROI over 5 years
  • 96.8% reduction in database storage
  • $50 Million predicted annual benefit for organizations over 75,000 employees

#555555;">Delphix is used by over 100 of the Fortune 500.

#555555;">What is Delphix? Why is Delphix important? What problems does Delphix solve in the industry?

#555555;">Here is a slide deck I put together for KSCOPE :

To PDB or not to PDB

I’m about to start a Proof of Concept (POC) for a 12c upgrade of one of our databases. The production database in question is running on Oracle Linux inside a VMware virtual machine, so the starting point I’ve been given for the POC is a clone of the whole VM…

Probably the biggest decision I’ve got to make is “to PDB or not to PDB” *. I mentioned it on Twitter earlier and got some conflicting opinions. I guess the pros and cons of the PDB approach go something like this in my head.

Pros: