How to increase SGA Size ?

[vr76413]

Hello all

Sun 5.8/Oracle9.2.0.1

This is my current SGA Settings..

SQL> show sga

Total System Global Area 320308312 bytes
Fixed Size 730200 bytes
Variable Size 285212672 bytes
Database Buffers 33554432 bytes
Redo Buffers 811008 bytes


To install Oracle 9.2.0.2 patch I need to increase Shared_pool_size and JAva_pool_size to atleast 150M each.

My current Shared_pool_size=117440512 and JAva_pool_size =117440512.

Now , if i inccrease both shared_pool_size and JAva_pool_size to 150M, then my Total SGA Size will be around 400MB. But init.ora file parameter shows SGA_MAX_SIZE = 320308312 bytes.

So will that be a problem, if i increase the Shared_Pool_size and Java_pool_size ?....


basically how do increase the Whole SGA Size ?....from 320MB to say 500MB ?....

Thanks
Ram

 

[HariOmGupta]

Hi Ram,

For increasing the size of SGA, you have to change the SGA_MAX_SIZE, JAVA_POOL_SIZE in your init.ora file only.

You cannot change the JAVA_POOL_SIZE and SGA_MAX_SIZE using the SQL command.

It is recommanded that JAVA_POOL_SIZE must be less than the Shared_pool_size and it's depend on your java utility programs only.

Cheers
Hari Om

 

[vr76413]

thanks hari om...

How do we calculate the funky numbering we see for all these parameters ?...

like for eg. 32M = 323459083 bytes stuff like that ?..

How is the Math done ?....can anyone give me exactly how we can come up exact number to put in init.ora file for a say 150MB?...

i have some idea like 150 *1024 * 1024 or something like that.

Can anyone explain how it is done ?...