Just a quick note to say I’m leaving today for San Francisco to attend Oracle OpenWorld. I’ll be making my presentation on Thursday at 14:30, in Room 304. Look for IOUG: Oracle Database 11g –The Perfection of a Masterpiece (Session ID: S291070).
With Oracle SE/SEOne, you can really stretch your Oracle licensing dollar: an 8-way box with a pair of quad-core processors can be licensed with SEOne (in the US) for $10k, and $2k/year for support (sold on a per-chip basis too). Now imagine running it on an 80-core chip!
The 11g platforms are now coming out fast and furious, In addition to the previously-released platforms.So download away, after checking your platform certification first, of course. Links to platforms in this post.
In my previous blog entry, I explained why I would expect Result Cache not to scale well. Unfortunately, at the time that blog entry was written, I had no access to hardware with more than two cores. That left me in an everything-but-the-proof state. Since then, I got a chance to re-run my test cases on a quad-core CPU, moving one step forward. Here is what I got:
This is another tool in the same toolkit as archiver. I just saw a great blog post on it athttp://blog.arabx.com.au/?p=883. Documentation can be found athttp://mysqltoolkit.sourceforge.net/doc/mysql-checksum-filter.html. This is an invaluable tool for ensuring your replicated tables are staying in sync, something that MySQL replication does not do. Tables will drift and if you are dealing with…
Apparently somebody who reads blogs regularly found one that said Fedora 8 bombed because he couldn’t install oracle on it. So I took on the challenge. I have to say installing Fedora 8 was the most difficult part of the challenge. The workaround given is to patch the libmawt.so with sed (!). The link in this post has all the gory details, but how do you do it for the oracle installer? The jre is compressed and there is no libmawt.so or any other .so to be found.. Here’s how in a nutshell…
Everyone puts lip service to the concept of keeping versions consistent between servers but it is consistently one of the most broken best practices I see amongst my clients. The problems with such inconsistency are legion, and I’ll point out a few here. Mismatch between production and development: Development environments are often neglected, particularly when…
Welcome to the 70th edition of Log Buffer, the weekly review of database blogs.
Thinking I had something new, I wrote this article about recovering deleted files. However, it turns out Frits Hoogland had already blogged about recovery of deleted files on linux, as Frits pointed out in a comment on my blog, where he also mentioned a metalink note on this matter. The procedure outlined in the note describes how to recover the deleted file and put it in the same location as the deleted file. The problem is that it doesn’t include offlining/onlining the file, so the database ends up with two distinct copies of the file.
So you have accidentally removed a datafile from your production database? First thing, DON’T PANIC! There’s an easy way to recover deleted datafiles, for as long as your database remains up. The procedure, outlined here, works on linux, however this method conceivably can work for other platforms.