Re: ORACLE 9i - memory usage

From: Jagjeet Singh <jagjeet.malhi_at_gmail.com>
Date: 29 May 2006 09:46:36 -0700
Message-ID: <1148921196.242296.208100@j73g2000cwa.googlegroups.com>

Hi Dave,

In Oracle 9i : it will allocate 7GB at startup and you can later resize/increase your total

                     sga [ show sga ] to 20 GB.

                     BUT

                   if you have configured pga_agg*_target and if
required and oracle
                   sees space between settings [ Actual allocated SGA
and MAX_SGA_SIZE
                    then it can give more memory to pga_agg*_target

In Oracle 10g : Oracle will startup again using 7GB and can increase any parameter

                        shared_pool,db_Cache,java_  till 20gb.

                       mean in 9i only pga_agg* can increase and in 10g

all the parameters.

Regards,
Js Received on Mon May 29 2006 - 11:46:36 CDT