On Mon, May 24, 2010 at 10:15:40AM -0500, Matt Lawrence wrote: > So, with that introduction, I'm looking for pointers to good articles on > tuning Oracle 10 & 11 on RHEL 5. I've already spent several hours
I'd suggest you look at the data you can get out of the AWR (Automated Workload Repository) reports. Properly interpreted, the AWR reports can help pinpoint problems. Tuning the underlying system when you have bad queries causing lots of I/O won't help. http://www.oracle.com/technology/deploy/performance/pdf/tips_perf_awr_sql_report.pdf http://www.dba-oracle.com/t_awr_report.htm _______________________________________________ Tech mailing list [email protected] http://lopsa.org/cgi-bin/mailman/listinfo/tech This list provided by the League of Professional System Administrators http://lopsa.org/
