Re: what do I tune?

Hi,

itrprof SQL Analyzer can do what you asked. itrprof: http://www.unal-bilisim.com/products/itrprof/itrprof.html

24/7/01 06:56:29, Gene Gurevich <g_u_r_e_v_i_c_h_at_yahoo.com> wrote:

>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).
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: danisment.unal_at_unal-bilisim.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).