Home » RDBMS Server » Performance Tuning » memory sizng on (Win 64 bit,
memory sizng on [message #290723] Mon, 31 December 2007 04:47 Go to next message
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: 65079
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.


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

Current Time: Thu Jul 20 19:42:29 CDT 2017

Total time taken to generate the page: 0.08738 seconds