OraFAQ Forum: Server Administration » RAM Allocation for SGA

Home » RDBMS Server » Server Administration » RAM Allocation for SGA

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

RAM Allocation for SGA [message #109373]

Thu, 24 February 2005 00:19

Suman Dasgupta
Messages: 22
Registered: August 2004

Junior Member

Hi
I have a problem.. In my database Server I want to use 1/2 of my machine's physical RAM for SGA and the remaining half for Windows 2000 Server(OS) and other Oracle Processes.. How do I do it.. My server's RAM is 5GB.
Thankx in advance
Suman

Report message to a moderator

Re: RAM Allocation for SGA [message #109464 is a reply to message #109373]

Thu, 24 February 2005 14:00

Edward Stoever
Messages: 58
Registered: August 2002

Member

Buy this book. It's the cheapest, most complete explanation you will get. If you cannot afford that, at the least, you need to learn to use the v$db_cache_advice dynamic performance view. You have to turn the advice on and let it run a while. It is one of 9i's best features.

Edward Stoever

Report message to a moderator

Re: RAM Allocation for SGA [message #109469 is a reply to message #109373]

Thu, 24 February 2005 18:50

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

Assign 2.5GB to the SGA?

Report message to a moderator

Re: RAM Allocation for SGA [message #109563 is a reply to message #109373]

Sat, 26 February 2005 01:12

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>I want to use 1/2 of my machine's physical RAM for SGA
Try it, if you want to get INTO problems.
Allocating huge SGA will not necessary help anything.

Report message to a moderator

Previous Topic:	Help!! Can't connect local DB
Next Topic:	ODBC finetuning for Oracle 10g connectivity on Intel HT CPU running Windows 2003 Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 03:02:33 CST 2025