Check out this article by Vikram Das about how to read OS environment variables using PL/SQL. I did not know that!
Monthly Archives: March 2009
Many people have asked me that how come I’m not an Oracle ACE yet. From this week I am an Oracle ACE Director. Here’s a link to my profile. Its pretty big honor to be recognized by Oracle Corp at … Continue reading
Oracle has done some major improvements in the diagnosability infrastructure in version 11g. Here’s one little detail. Before Oracle 11g it is possible to access the alert log via SQL using an external table or a pipelined function which in … Continue reading
Riyaj Shamsudeen wrote an excellent article about systematic latch contention troubleshooting. Especially if the latch contention problem is ongoing, looking into system wide stats (like v$latch.sleep columns) is not the best idea in busy systems. This may sometimes lead you … Continue reading
Anyone who’s looked into Oracle X$ tables, knows that their names are really complicated and quite unreadable (and non-pronouncable), such X$KZSRT, X$KCPXPL, X$KQFSZ and so on. A few years ago at some conference someone came up with a thought that … Continue reading
I thought to post about another new interest of mine, TimestTen, as I’ve worked with it in past and I have become a fan of it, especially after Oracle bought the company. Oracle has announced that TimesTen in-memory database will … Continue reading
There’s a recent thread in Oracle-L about deadlocks and a recommendation to dump various instance information when the deadlock happens. A deadlock trace dumps some useful things automatically, but sometimes you want more, especially in RAC environment. So is it … Continue reading