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.
See also: 

A very nice one today - The myth of “keeping up”. I see myself in every line of that blog but I need something stronger to change. What that should be? “John isn’t keeping up either” doesn’t work… it’s a John’s problem!
See also: 

Everything started 10 days ago when PSU (powersupply) of my desktop went belly up. I tested that it was definitely PSU - I checked with the tester that standby +5V was there but shortening contacts 14 and 15 didn’t start it (these are the contacts that are used in ATX to turn it on). I […]

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

No comments.
See also: humor

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!
See also: