Best Tips About How To Increase Sga Size In Oracle 10g

Select decode( grouping(nm), 1, 'total', nm ) nm, round(sum(val/1024/1024)) mb from ( select 'sga' nm, sum(value) val from v$sga union all select 'pga', sum(a.value) from v$sesstat a,.

How to increase sga size in oracle 10g. It uses the spfilesid.ora in the $oracle_home/dbs directory. If you only have oracle on the server, start by reserving 10% of ram for linux or 20% or ram for windows. Tio change the parameter(s) you should use:

Alter system set sga_max_size = xxxm scope =. Sql> alter system set sga_max_size=2000m scope=spfile; Sql> sho sga total system global area 556762824 bytes fixed size 730824 bytes variable size 83886080 bytes database buffers 471859200.

For 10g, the sga size is shown by sga_target parameter and pga size is shown by pga_aggregate_target parameter. It is reommended to keep the sga max size value larger then sga target for future. The value of the sga_max_size parameter defaults to the aggregate setting of all the sga components.

It uses the spfilesid.ora in the $oracle_home/dbs directory. This is a binary file. By setting the oracle sga_max_size parameter higher than sga_target, you allow dynamic adjustment of the sga_target parameter.

For 11g, the parameter memory_target sets them both. Sql> alter system set sga_target=2g scope=spfile; This is a binary file.

Tio change the parameter(s) you should use: