I have recently stumbled upon V$SESSION_CONNECT_INFO view and discovered that it provides interesting information about client-side software and settings. Using this view in Oracle 11g you can simplify collecting some statistics about database clients. Here is what can be extracted.
If this post seems a bit like an “advertorial”, please believe me — it’s not. Well, at least it’s not an advertisement for Pythian in any way. What it is, however, is a post about a longstanding business partner of Pythian’s who run a very useful service I think more of you should know about. Rest assured there is nothing “in it” for me or for Pythian for writing this.
It is now evening after the first day at the AUSOUG Conference in Perth, Australia. This is my first time attending AUSOUG, and I have found it much smaller and more personal than others I have attended. I was fortunate to present right after the opening session, so I could relax and enjoy the rest of my day. The exhibition hall was open all day, so I went there between sessions. No matter how many times I tell myself that I don’t need more stuff, I always find things at the exhibit hall that I want. Today, I picked up a red Red Hat hat.
For some reason, the advertising slogan, “Getting there is half the fun,” keeps going through my mind. Well, I certainly would not describe my trip to Perth, Australia as “fun”. I’m pretty tired. And, I’m presenting at the AUSOUG National Conference Series 2007 at 10:30 tomorrow morning.
Welcome to the 71st edition of Log Buffer, the weekly review of database blogs.
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…