How to allocate more memory on Oracle installed on Linux

[Sina]

Hi everyone.

I'm running oracle 8i on Redhat Linux 6.2 and under instances SGA memory show that it only is set to 70 Meg.

How can I allocate more memory for Oracle?

thank you all.

 

[carp]

Modify your init.ora file and bounce the instance.
Which parameters you change will depend on which area of the SGA you have determined needs more memory.

 

[jimbopalmer]

I use Solaris unix, and find that I can give about 1/4 of RAM to the SGA, if you do not have specific needs more block buffers is good. The one thing you can't give for your heart's desire is your heart. - Lois McMaster Bujold

 

[Sina]

Thank you all for the response.

I thought there was a gui I could use to increase the memory, but now I will increate the block_buffers in init.ora to about 550.

Now is it ok if I leave the database name to be the default?

Thank you.

 

[lfoata]

You can name the instance the way you like, but DBAs usually stick to 4 characters long name and try to make the name somewhat meaningfull. It is also usually in upper case.
You can rename the database by backing up the controlfile, edit it to modify the db name and restart. You may find the comlete procedure on metalink. Too bad I.T. is not cash business

Luc Foata
Unix sysadmin, Oracle DBA

 

[Sina]

Hello all,

I have increased all the parameters as suggested in the book and also init.ora file.

I have 1 gig ram in the server and Set the parameters in the init.ora file to match a larg size database.

Still after restarting the oracle instances (server) the total SGA under instance shows about 66 Meg.

Is that mean, that oracle is set to use only 66 meg of ram?

and if yes, how can I allocate more memory to it.
considering the changes in the init.ora file did not make any difference.

Thank you all.

 

[lfoata]

There are a few parameters in your init file that will have an impact on the amount of memory Oracle uses for its daemons or connections.
share_pool_size
db_block_buffers
java_pool_size
sort_area_size

and more.

Depending on the use you do of your database, 66 megs of SGA may be enough. If it is a DW you are building then increase the parameters.

Maybe you could post your init file ? Too bad I.T. is not cash business

Luc Foata
Unix sysadmin, Oracle DBA