the 1st time 3 nodes RAC

it was a chance to modify existing RAC environment, especially on production.

existing environment is 2 nodes rac on solaris 9 with oracle clusterware 10.2.0.3
users asks me to add it become 3 nodes.

the preparation was taken about 1 months, it was testing environment trying to test with some workloads...etc.

and finally they said...it is ok than pls do it on production...
starting from 00:00AM I played with the node addition....
some small trouble was found due to corruption on 2nd node's inventory.
we fixed it by simply copy an xml file from 1st node to 2nd node, and continue.

but after a days we successfully add the 3rd node, I got an message that the node 1 & 2 has been restarting .... hmmmmmmmm amazing.....

digging to the alert log and crs log... open metalink and start browsing .... found some nice bugs......

huh..mann live so so so hard :(

ujang
jakarta - indonesia

hints - how it could help ??

I have a database with 2 nodes RAC on Linux Itanium 64 bit of course.

users always ask me " why my query so slow, when it is on 9i database it is not too slow". the I'm digging into "what make it slow".

I found I nice SQL which is something like this:

select .....
function_get(....).....
function_get(....).....
function_get(....).....
from (select ........
from ( select .....
from a, b)
)

it almost full day I played with the query....
trial and error was done... by add some hints ....

and finally I resolved by some hints with add a cumulative index ....

/*+ first_rows leading(a b) use_nl(a b) use_index(a a_xxxx_idx_0011) use_concat NO_PUSH_SUBQ(a) */

wowww.... it's so long.... look like train....

I dont think so this is due to oracle database, but it should rely on application design problem :(


ujang
jakarta - indonesia