Cloning ORACLE_HOME…
At the company I work for now, we used to simply copy oracle homes over another machine and/or path, recreate some links and relink. Works very well for 9i including RAC. With 10g and CRS it stopped working - it was a mess registering CRS resources afterwards. Another disadvantage was that Oracle inventory wasn’t [...]

In yesterday’s post, “VLDB with ASM?”, I showed problems with ASM mirroring for high volume database. Today, I want to emphasize that you should be very careful placing flash recovery area (FRA) on ASM diskgroup with normal or high redundancy.
The reason is the same as before. Whenever all or majority of disks in a failure [...]

Today I’ve been on the first day of the ASM course/workshop led by Martin Gosejacob. He is quite good and knows the stuff. Since I’ve been playing with it before and installed the practice clusters for it, I kind of knew general content. Nevertheless, I got enough new and interesting pieces of information. Today [...]

Update: This is relevant to RAC environments.
Fast Application Notifications mechanism was introduced in 10g as development of TAF (Transparent Application Failover). While the most important benefits are from using FAN on the client side, it’s possible to receive notifications on the server and react appropriately. The beauty of it is simplicity.
Setting up custom server-side callout [...]

Yesterday, one of my collegues asked why he couldn’t see anything in v$object_monitoring view when he enabled monitoring of indexes. I was scratching my head trying to remeber the trick because I recalled that I’d had a similar problem and reason wasn’t obvious. I couldn’t help him at that time as my memory didn’t [...]

Today I met Goran Bogdanovic whom I got to know from Oracle-L list. We’ve had mass of beer at the Hofbraukeller and spent few hours chatting nicely about life, Oracle and whatever came to our mind. Thanks Goran for nice time that let me relax a bit after a tough day.

…ORACLE was the world’s fastest computer in 1953…

No comments.

Until some time I trully believed that Oracle doesn’t store NULL in Oracle b-tree index. Apparently, this is not exactly true, i.e. false. Oracle doesn’t store null values in index ONLY and ONLY when ALL columns in the index are null. If any of the index columns has not null value, the key is put [...]

Hit bug 4604970 in our DW environment. This is really bad one and you might not notice that your query returns wrong result until you get negative number on your payslip end of month.
Some one-offs are available and workaround is _GBY_HASH_AGGREGATION_ENABLED=FALSE. Good luck with 10.2!

I got so excited about ORADEBUG feature I described in the previous post that completely forgot to mention the main news of the day - the second day of Tom’s seminar. It was an excellent day packed with lot of useful tricks and tips plus I cleaned quite a few things in my mind. The [...]