RE: what do I tune?

What do you want to achieve?

The more parallel you run the more some of your waits will go up, but the elapsed time may drop a little or a lot. Also you need to balance it with the total load on your server. If it is a query that is run a lot when there are a lot of users on the system you could max out your server. If it is during a down time for batch, that may not be a problem. Also keep track of your explain plan as you bump up parallelism, it can change.

> -----Original Message-----
> From: Gene Gurevich [mailto:g_u_r_e_v_i_c_h_at_yahoo.com]
> Sent: Tuesday, July 24, 2001 11:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: what do I tune?
>
>
> 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: Page, Bruce
  INET: Bruce.Page_at_BellSouth.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).