Exadata’s Best Kept Secret: Storage Indexes

Although many electrons have been expended discussing Exadata’s features, storage indexes tend to figure last, with a vague mention of row elimination in heavily clustered data. Even Oracle’s Exadata software user guide devotes barely half a page to them. Unlike the better known smart scanning features though, storage indexes have an important advantage: rather than offloading workload to storage cells, they eliminate the need to do the I/O at all. Here are some sample statistics taken from an actual production system:

Environment Variables in Grid Control User Defined Metrics

Emerson wrote: “Foolish consistency is the hobgoblin of small minds”. I love this quote, because it allows me to announce a presentation titled “7 Sins of Concurrency” and then show up with only 5. There are places where consistency is indeed foolish, while other times I wish for more consistency. Here is a nice story that illustrates both types of consistency, or lack of.

Exadata Technology Blogs

I hear lots of feedback on Exadata front asking for more and more technical information and I often refer them to some material online. I think I should reference couple credible resources for the readers of our blog in addition to our own Exadata content and Oracle’s own Exadata Technology section.

Pythian Implements Oracle Exadata at LinkShare Corporation

The Pythian Group Inc., the preeminent remote database infrastructure services company and a Platinum member of the Oracle PartnerNetwork (OPN) today announced the implementation of the Sun Oracle Database Machine at LinkShare Corporation, a division of Rakuten, Inc, and launch of its Oracle Exadata services practice.

Beware the /var/tmp/.oracle Hidden Directory!

A few months ago, we had a test instance complaining that it couldn’t write to ASM. This was an single (non-RAC) instance on Oracle Enterprise Linux 5, using ASM for the storage.We ended up booting the server altogether, after which everything came up nicely. We filed an SR with Oracle Support, who directed us to Note 391790.1 (Unable To Connect To Cluster Manager Ora-29701). This note lists the cause, quite simply, as…

Page 65 of 139« First...102030...6364656667...708090...Last »