Re: pga_aggregate_target

Yes, they are in kilobytes, as I wrote in my message before.

If you check the source of v$pgastat you see that for statistics in bytes then QESMMSGAVL (value) column is multiplied by QESMMSGAMU which is 1024 (to get bytes from kilobytes).

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, December 28, 2003 7:44 AM

> It would appear that the values for _smm_max_size and _smm_px_max_size
> are specified in K, though not explicitly.
>
> In a test 9.2.0.4 database:
>
> pga_aggregate_target = 25165824
>
> _smm_max_size = 1228
> _smm_px_max_size = 7371
>
> Anyone know this for sure?
>
> Jared
>
>
> On Sat, 2003-12-27 at 08:59, Tanel Poder wrote:
> > > Also, consider that any single serial session will never get more than
5%
> > of
> > > pga_aggregate_target. For parallel operations, total is limited to
30%.
> >
> > The maximum can be controlled using "_smm_max_size" parameter which
states
> > how many kilobytes a serial session can use for its workarea operations.
The
> > default is 5% from pga_aggregate_target.
> > "_smm_px_max_size" controls max workarea for parallel slaves,
respectfully
> > (default is 30% from pga_aggregate_target).
> >
> > These parameters are unsupported (as you know) and have no effect when
set
> > at session level - alter system has to be used for changing them (tested
on
> > 9.2.0.4 on W2k).
> >
> > Tanel.
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Tanel Poder
> > INET: tanel.poder.003_at_mail.ee
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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.net
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).