Archiving and RAM allocation ??

[GKramer]

Hi,

Using an UNIX machine (Sun 8) and Oracle 9i-64bits archiving of the 4 databases installed on this machine allocate approx 400 Mb each!! How to adjust them (downwards)?? ( max RAM on this machine is 2 Gb ).

Anyone.....

Gkramer
The Netherlands

[TimHall]

Hi.

You need to reduce the size of the following parameters:

SHARED_POOL_SIZE
DB_CACHE_SIZE
JAVA_POOL_SIZE
LARGE_POOL_SIZE

You can do this in one of several ways:

1) If you are using Enterprise Manager reset them on the Instance->Configuration section on the Memory tab.

2) If you are using an init.ora file change them here and restart the instance.

3) If you are using an SPFILE do something like:

ALTER SYSTEM SET SHARED_POOL_SIZE=70M SCOPE=SPFILE;
ALTER SYSTEM SET DB_CACHE_SIZE=32M SCOPE=SPFILE;
ALTER SYSTEM SET LARGE_POOL_SIZE=16M SCOPE=SPFILE;
ALTER SYSTEM SET JAVA_POOL_SIZE=16M SCOPE=SPFILE;

Then bounce (restart) your instance.

Some of these parameters are dynamic in Oracle9i, but shrinking the SHARED_POOL_SIZE can take ages so I still prefer to bounce the instance if I can.

Obviously, you need to pick sizes that are relevant for your workload on each instance.

Cheers

Tim...

[GKramer]

Tim,

Thank you for your reply, I checked the param's you suggested and counted the total amount of the SGA and PGA and you where right. Together with the other processes running it was approx 400 Mb per DB.

Now the task to find the right values per param per load on the database(s).

Thanks again!

GKramer
The Netherlands.