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

Home -> Community -> Usenet -> c.d.o.server -> Re: Bitmap index and Init parameter for optimization

Re: Bitmap index and Init parameter for optimization

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 22 Aug 2002 19:10:04 +1000
Message-ID: <PD199.11964$g9.39326@newsfeeds.bigpond.com>


Hi again Epicentre team A,

No parameter *must* be set as such.

Depending on your database version, the BITMAP_MERGE_AREA_SIZE parameter can be tweaked to allow more memory for the processing of bitmap indexes. Increasing this from the 1M (?) default gives the session more memory to sort the bitmap entries from the various bitmap indexes as they get merged. Note this memory is assigned to the session's PGA and can be changed at the session level.

In 9i, the PGA_AGGREGATE_TARGET parameter will dynamically allocate as much memory as resources and requirements allow. As a result all the *_SIZE parameters are deemed to be somewhat redundant (although you can choose not to set the PGA_blah and tweak manually as before).

Cheers

Richard
"Epicentre team A" <oracle_at_epicentre.fr> wrote in message news:ak0jmi$qm5$1_at_wanadoo.fr...
> Hi
>
> What parameters in Init<SID>.ora must be modified when using one or more
> bitmap index.
>
> Salutations
> Epicentre Team A
>
>
Received on Thu Aug 22 2002 - 04:10:04 CDT

Original text of this message

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