Home » RDBMS Server » Performance Tuning » memory sizng on (Win 64 bit, 9.2.0.8)
memory sizng on [message #290723] Mon, 31 December 2007 04:47 Go to next message
oraclestew
Messages: 13
Registered: December 2007
Location: Warrington, UK
Junior Member
Hi, i have 16GB of physical memory on my 64 bit Windows OS, and want to assign the max (4GB) to Oracle. I have added the \3G swicth to the boot.ini file but i want to know what memory parameters to set. Currently my SGA_Max_Size is 1.6GB. I can have up to 800 concurrent users. I am intending toi upgrade to 10G soon, but am getting memory issues and would like to know if there is a quick fix. Cheers Stew

Report message to a moderator

Re: memory sizng on [message #290724 is a reply to message #290723] Mon, 31 December 2007 05:01 Go to previous message
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
First read How to Identify Performance Problem and Bottleneck.

We don't size from the RAM we have, we size from the workload we have.

Regards
Michel

Report message to a moderator

Previous Topic: help on indexes
Next Topic: same sql but different responce time
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 23 20:35:43 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.