Posts by Marc Fielding
Congratulations to Chris Marlowe of Oppenheimer Funds and Bill Mitchell of Alliant Energy, attendees to my Exadata session yesterday. Both are lucky winners of the a flight with the inimitable Sean D Tucker and the Oracle Challenger. For those of you who missed the session, keep your eyes on this blog for a recording, coming soon.
I was looking at the Exadata page on OTN and noticed something interesting: instead of the “Sun Oracle Database Machine”, it’s now headlined as the “Oracle Exadata Database Machine”.
With the release of the 22.214.171.124 patchset, Oracle has stopped releasing sets of individual patches, but instead is packaging it as a self-contained, complete software install. I can see many benefits to this method, and quite frankly am wondering why it took so long to come about.
Welcome to the third installment of a series describing the Oracle Exadata platform. In part 1 we talked about hardware components, and in part 2 went on to discuss software. We now move on to how these components are packaged and licensed.
As I work on putting together slides, I’d like to remind you all of my Oracle OpenWorld 2010 presentation, a customer case study migrating a complex data warehouse environment to Exadata. I’ll be presenting along with Michael Aldrich of LinkShare and Aiman al-Khammash of Oracle, and focusing on our own experience with Exadata, lessons learned, and advice for others choosing to implement Exadata.
As of this afternoon, version 126.96.36.199.1 of Oracle’s Exadata storage server software, is out in the wild. This is the first publicly available version of the 188.8.131.52 branch, a major release including a full OS image with an update to Oracle Enterprise Linux 5.5. A number of bugs causing cell server crashes and hangs have been fixed, including 9472035, 9870117, and 9722560.
en creating an index, Oracle versions 10g and above automatically compute optimizer statistics. And even before that, 9i had a COMPUTE STATISTICS clause to accomplish the same thing. Not only does it save the time and effort of running DBMS_STATS, but it also saves the disk I/O involved in such an operation, since all rows are available in the course of index creation.
I’m not aware of any TPC results for Exadata V2. However a TPC-C test was run in late 2009 using a Sun F5100 flash array on Sun T5540 servers, setting a record for the benchmark that still stands. The Oracle wiki has a great overview of the various benchmarks and what they actually measure.
We’re in the process of applying Exadata Bundle Patch 5, and ran into an issue I wanted to share.The system didn’t have a XDB user, and likely because of this, the two “alter package” commands invalidated the dbms_metadata objects. The subsequent recompilations all failed. On advice from Oracle support, we ended up backing out the patch and re-applying without running these “alter package” commands, and confirmed that DBMS_METADATA works fine. So if you don’t have XDB installed, skip the “alter package” commands. I hope the README is updated soon.
My article Making the Most of Oracle Exadata in the August 2010 issue of the NoCOUG Journal has come out. It covers Exadata’s feature set, and then dives deeper, discussing how to make the best use of its capabilities. For those of you not subscribers of the print edition, it’s also available electronically.