Welcome to Log Buffer, the weekly roundup of database industry news.
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:
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.
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.
A short post marks Pythian’s 195th edition of Log Buffer, a blog of blogs encapsulating what’s going on in the world of database administration.
We’re well into summer and almost at our 200th edition of Log Buffer, a blog of blogs about the database world.
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.
In this series of articles (part 2 here and part 3 here), we’ll explore the major components of Exadata and the Oracle Database Machine and take a peek at how they’re designed with performance and scalability in mind.
Welcome to Log Buffer, the weekly roundup of DBA industry happenings.
A few months ago, we had a test instance complaining that it couldn’t write to ASM. This was an 188.8.131.52 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…