Re: Increased server process memory usage for Oracle 8i

"Matthew Crump" <crumpm_at_britannic.co.uk> wrote in news:3b7cdd16$0$230$ed9e5944_at_reading.news.pipex.net:

> We are in the process of evaluating Oracle 8.1.7.0.0 with a view to
> upgrading from our current Oracle 8.0.5.2.1, due to the latter now
> being desupported on our server platform.
>
> Our databases reside on an IBM Numa-Q platform running Dynix/ptx 4.4.8
>
> I have compared the memory usage of the UNIX server process associated
> with a SQL*NET client/server connection between the two database
> versions.
>
> In both cases I merely connected to the database using SQL*PLUS and
> performed no further operations.
>
> The connection to a 8.0.5.2.1 database had a resident set size of
> 8.4Mb, the connection to an 8.1.7.0.0 database had a resident set size
> of 12.6Mb, a 50% increase.

To accurately check the memory usage of the clients you need to sum the UGA/PGA components of each connection.

If you are also considering the SGA then make sure to check the java_pool_size. It's default is 20M.

Also examine all of the parameters, some default values have increased dramatically.
> My question is, has anyone else who has upgraded from 8.0 to 8.1
> noticed a significant increase in the memory usage of server processes
> for client/server processes ?.

Keep in mind that 8.0.5 is approaching 4 years old now. Machines have changed pretty dramatically in that time. All applications are requireing more memory today vs. 4 years ago.

-- 
Robert Fazio
Senior Technical Advisor
dbabob_at_yahoo.com