RE: Query Tuning Help

PMFJI
>>How about optimizer parameters

(optimizer_index_caching,optimizer_index_cost_adj)? optimizer_index_caching=0 <<Are these reasonable values? optimizer_index_cost_adj=100

<sorry for the space everyone ms outlook 101 is a class I *badly* need like how do I reply in plain text with indentation to an html message>

Um no probably not. O_i_c says (in Niall english) what percentage of my index blocks are likely to be in memory rather than on disk. The *baseline* for this is BCHR (or say 80). O_I_C_A says how expensive are index reads compared to datafile reads. This is more difficult but comparing the average wait for dbfile scattered read to dbfile sequential read might give some clue. For my dbs 80 and 66 are better values.

Niall

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  INET: niall.litchfield_at_dial.pipex.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).