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.
>>> [EMAIL PROTECTED] 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
