Posts Categorized: Technical Blog
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.
This part will go over the 2nd “P”, partitioning. Learning about Oracle’s partitioning has gotten me more interested in how MySQL’s partitioning works, and I do hope that MySQL partitioning will develop to the level that Oracle partitioning does, because Oracle’s partitioning looks very nice (then again, that’s why it costs so much I guess).
At Kscope this year, I attended a half day in-depth session entitled Data Warehousing Performance Best Practices, given by Maria Colgan of Oracle. These are my notes from the session, which include comparisons of how Oracle works (which Maria gave) and how MySQL works (which I researched to figure out the difference, which is why this blog post took a month after the conference to write).