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
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: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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

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


Current Time: Sat Dec 10 16:38:54 CST 2016

Total time taken to generate the page: 0.10392 seconds