RE: pga_aggregate_target

The formula in the book is just another form of hit ratio IMO.

As Mark suggested, just check the max allocated a few times, or check it historically if you are running statspack.

Set the pga_aggregate_target to that value plus a margin you feel comfortable with, and then monitor and adjust as needed.

9i gives you tools for managing memory that just didn't exist in previous versions.

Jared

On Mon, 2003-12-29 at 05:04, Jeffrey Beckstrom wrote:
> Will look at what you suggest. The Oracle docs suggest you using a formula based on amount of system memory. However, this is not the only database on the server.
>
> >>> Mark.Bobak_at_il.proquest.com 12/26/03 3:29:26 PM >>>
> Jeffrey,
>
> If you are simply looking at a conversion from 8i to 9iR2, and you're not
> going to be implementing a bunch of new 9i features (that could affect PGA
> usage), then it's probably reasonably straightforward. You can look at
> 'session pga memory' and 'session pga memory max' statistics in V$SESSTAT to
> get an idea of current PGA memory consumption in 8i. The 'max' statistic
> is probably more interesting in terms of total aggregate memory consumption

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