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. 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%. So, if you have lots of sessions, each with modest requirements, that will not be a factor. If, on the other hand, your database supports just a few connections, and each has significant PGA memory requirements, then you may need to consider that limitation.
Hope that helps, -Mark -----Original Message----- From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED] Sent: Fri 12/26/2003 2:34 PM To: Multiple recipients of list ORACLE-L Cc: Subject: pga_aggregate_target Starting an upgrade project for 8i to 9i R2. How can I come up with a reasonable starting value for the pga_aggregate_target parameter? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113
<<winmail.dat>>
