ALL POSTS

Tracking your Oracle client versions in 11g

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.

Keeping a Lid on Oracle Licensing Costs while Ensuring Compliance

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.

AUSOUG: Day One

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.

AUSOUG: Getting There is Half the Fun… NOT!

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.

Off to OpenWorld!

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).

Does Oracle 11g’s Result Cache Scale Poorly?

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:

MySQL Checksum

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…

Page 235 of 282« First Page...10...233234235236237...240...Last Page »