Archive for September, 2009

Is plan_hash_value a final say?

September 13, 2009  |   Blog,CBO,Performance tuning,RAC,Uncategorized   |     |   6 Comments

I was reviewing a performance issue with a client recently. Problem is that increased global cache waits causing application slowdown affecting few critical business functions. Using one of my script gc_traffic.sql > and graphing the results with Excel spreadsheet, it is established that there is a marked increase in GC traffic today compared to week earlier. Similar jobs runs every day and so comparing two week days is sufficient to show the GC ...