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.


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:

Installing Oracle on Fedora 8

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 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 or any other .so to be found.. Here’s how in a nutshell…

Page 210 of 257« First...102030...208209210211212...220230240...Last »