Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Index vs. table scans in statspack reports

Re: Index vs. table scans in statspack reports

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Fri, 28 Nov 2003 16:52:19 +0000
Message-ID: <KZXi+5BD13x$Qx1H@peterfinnigan.demon.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US