what do I tune?

From: Gene Gurevich <g_u_r_e_v_i_c_h_at_yahoo.com>
Date: Tue, 24 Jul 2001 08:13:40 -0700
Message-ID: <F001.00353550.20010724075629@fatcity.com>

Hi all:

I am trying to tune some queries. I ran them all in one stream (in sequence) and then ran them in several
(up to 64) parallel streams. I got a snapshot of
the system for each run. I see some of the waits went up significantly when I switched from 2 parallel streams to 64: buffer busy wait, db file seq read, enqueue waits, latch free waits and many more. Now some of this increases may be OK, some may be not. My question is how do I decide which of these waits are a problem and should be looked into and which are normal and can be safely ignored. Are there any quantative rules that I could use?

thank you for any insight

Gene

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  INET: g_u_r_e_v_i_c_h_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Received on Tue Jul 24 2001 - 10:13:40 CDT