If I understand you correctly, you have 2Gb of RAM in the Windows
server.
So this is 2 Gb of memory for *all* processes. Also Windows will always
reserve 50 percent of memory for itself, in your case 1 Gb.
Setting the /3Gb switch without 3Gb or more RAM in the server doesn't
make sense.
Likely your SGA is way too big, Oracle recommends using not more than
one third of physical RAM, for obvious reasons: if you exceed that, the
O/S going to page like hell.
Likely your problem (apart from the fact that Windows doesn't scale
well) is an application problem: you don't use bind variables, and you
don't know how to tune sql-statements, and in order to 'tune' the
database, you have allowed to increase the SGA beyond any reasonable
limit.
Please investigate whether the SGA is bigger than about 600 Mb. If it
is, start revising the application and stop throwing hardware at the
problem. This is a workaround only: the problem will re-surface, and
you don't need workarounds, you need solutions.
--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Jan 12 2006 - 06:17:37 CST
