Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index vs. table scans in statspack reports
Hi Rick,
Not sure if it is relevant in your case as it sounds like you may be limited to system wide changes only but you may want to take a look at Cary Millsaps new book "optimizing oracle performance" published by O'Reilly. It looks at how to identify the right business processes to tune rather than system wide reports and then he shows how to obtain the correct data to analyse using the wait interface and.... well anyway you get the picture.
kind regards
Pete
-- Pete Finnigan email:pete_at_petefinnigan.com Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details.Received on Fri Nov 28 2003 - 10:52:19 CST