Archive for September, 2009
Is plan_hash_value a final say?
September 13, 2009 | Blog,CBO,Performance tuning,RAC,Uncategorized | admin | 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 ...
