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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: known problems with parallel_automatic_tuning ????

Re: known problems with parallel_automatic_tuning ????

From: <cjgait_at_earthlink.net>
Date: Tue, 22 Aug 2000 16:24:57 -0400
Message-Id: <10597.115293@fatcity.com>


Karl,

What version of the DB? There are some problems with PQO that are very specific for version.

On 20 Aug 2000, at 19:34, karl craven wrote:

> listers,
> does anybody know of any major or in actual fact even minor problems
> with regards to the use of the parallel_automatic_tuning and
> parallel_adaptive_multi_user init.ora parameters.
>
> i have a 4 way sun 450 with a massive 2gb of ram and oracle with the
> above parameters set at true has decided that i can run at least 43
> parallel query slaves.
>
> now with the developers love for sort_area_size=3D64mb and
> sort_area_retained at the same time, you can imagine that im having
> some paging issues.
>
> eg current swith rate hangs around 1300 - 4000 ops ..... doooooh !
>
> having done this, its also decided that a large_pool_size of 64mb seems
> quite suitable. eeeem looking at v$sgastat tells me that there is 57mb
> free. vi time.
>
> basically im finding that these 2 params are causing massive problems
> for my box and i'd love any insight/thoughts into how the number of
> parallel query slaves is deduced.
>
> otherwise its back to setting the ol' min and max parameters manually.
>
> many tks
> kc
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail =96 Free email you can access from anywhere!
> http://mail.yahoo.com/
> --
> Author: karl craven
> INET: karl_craven_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 Aug 22 2000 - 15:24:57 CDT

Original text of this message

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