Posts Categorized: Technical Blog
Oracle Exadata V2 is a very well balanced database machine combined with smart and innovative software. One of these innovative features is the Storage Index – a game changing feature in my opinion.As with any feature, there are intended use cases, limitations and caveats. Use it right, and amazing performance gains can be achieved. Use it wrong, and nothing will happen. This is what is great about storage indexes in particular. They are there, without any overhead. It’s only a question of how to leverage them, in addition or combination withevery other feature that Oracle Exadata has to offer.
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.
We settled down to some very interesting talks, the highlight for me being Tim Bunce’s talk on using Devel::NYTProf to Optimize your code. The rest of the day was dedicated in my opinion, to the future of DBs in with Nelson Ferraz giving an excellent presentation of his concepts for using Perl as to glue for a Data Warehouse application. Next on my agenda, Martin Berends reports on the present state of Perl 6 and interfaces database. Martin was quickly followed by Tim Bunce again who presented his proposal for the new Perl 6′s DBDI.
Larry Wall gave another of his unique keynote addresses at the first day of YAPCEU 2010 here in sunny Pisa (yes the place with the tower) This year was a little diversion from his usual pattern as Larry was assisted by his better half and his demon seed. Larry told us as a language designer his life is one of siting on the fence, not making up his mind until that one little voice in one ear (his better half) and that other little voice in the other ear (his demon seed) work it out somehow.
Welcome to Log Buffer, a weekly review of the database industry. This week’s issue Log Buffer #198 is generously published by Sam DeFilippis, who manages Oracle Notes blogs, with latest postings on Oracle GoldenGate.
The first non-development version of XML::XSS has been released on CPAN. The big delta since the last blog entry (XPathScript Reborn) is the re-introduction of templates, and a generous slathering of overloaded shortcuts for stylesheet definitions.
Log Buffer #197 marks the middle of summer, and the fact that we’re a mere two weeks away from our 200th edition.
Today marks my last day at Pythian. I have been at Pythian for almost three years. In those three years, Pythian’s already thriving MySQL practice has grown even more. I have worked with big and small clients alike, across many industries, managed a team of up to 4 DBAs, and learned a lot not just about MySQL, but what my goals are in general.