OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » RAM

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RAM [message #131757]

Tue, 09 August 2005 05:47

orant1
Messages: 28
Registered: June 2005

Junior Member

I increased RAM from 1G to 2G on server. Which parameters in which files I should repair for better performance of Oracle database?

Thanks

[Updated on: Tue, 09 August 2005 05:48]

Report message to a moderator

Re: RAM [message #132004 is a reply to message #131757]

Wed, 10 August 2005 06:54

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

Just by increasing the ram performance will not increase, SO to increase the performance of database by increasing the ram on server u have to make changes in the parameter of init.ora (i.e paramater file). Prameter related to SGA should be changed so you must know the component of SGA.

Below are the parameter of init.ora that u have to change (i.e increase the value) after adding RAM to the server .

LOG_BUFFER
db_cache_size
java_pool_size
shared_pool_size
SORT_AREA_SIZE

i hope things should work for you now. Smile

From:- Sunilkumar

Report message to a moderator

Re: RAM [message #132161 is a reply to message #131757]

Thu, 11 August 2005 03:14

orant1
Messages: 28
Registered: June 2005

Junior Member

Hi,

Thanks for your help.
I will have to study the component of SGA.
Can I calculate the right size for each of them.

Report message to a moderator

Re: RAM [message #132211 is a reply to message #132161]

Thu, 11 August 2005 06:23

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

SQL>show sga <--- this Will give u size of sga.
&
From init.ora u can get size of component, that you have to change.

But remember if your database is on linux or unix o/s than u have to set some kernal perameter of o/s so that u can have effect of change made to the parameter in init.ora file.

That means on linux when u add ram for database for better performance at that time u have to reset o/s kernel paramete as well as init.ora parameter.

note :- On windiows 2000 server or XP u dont have to bother regarding the kernel parameter only change in init.ora will solve your problem.

From :- sunilkumar

Report message to a moderator

Previous Topic:	oracle replication
Next Topic:	Problem in STARTingUP database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 08:54:17 CST 2025