Re: Windows 2000: Use of more than 2GB RAM per Instance

Casi Schmid wrote:

> Dear all
>
> Got Oralce Enterprise Edition 8.1.7.4.5 on several Windows 2000 Advanced
> Server boxes with more than 2GB RAM installed - details:
>
> boot.ini
> multi(0)disk(0)rdisk(0)partition(2)\WINNT="Microsoft Windows 2000 Advanced
> Server 3 GB" /fastdetect /3GB
>
> initSID.ora
> db_block_buffers = 65000
> shared_pool_size = 200000000
> large_pool_size = 52428800
> java_pool_size = 67108864
> log_buffer = 131072
> db_block_size = 16384
>
> select * from v$sga:
> NAME VALUE
> -------------------- ----------
> Fixed Size 75804
> Variable Size 334192640
> Database Buffers 1064960000
> Redo Buffers 139264
>
> Questions:
> --------------------------------
>
> - do you have experiences in running instances on windows having an SGA
> greater than 2GB?
> - which settings are you using?
> - what problems have you ecountered using such a big SGA size on Windows
> that is still a 32-Bit OS?
>
> best regards from snowy Switzerland
>
> Casi

Bigger is not always better. In many cases larger equals slower. Just because you have the RAM doesn't mean you should use it. And as Sybrand has pointed out here numerous times Oracle's recommendation is that you use, at most 1/3.

That said you are limited by choice of operating system anyway unless you want to get into areas that I expect are not supported by Oracle but still you need to keep in mind the 1/3 recommendation.

My thinking, based on your post, is that you are hung up on size without having actually done any examination of v_$ views and benchmarking and determining that you need it. So I would expect that if you continue down this path your Oracle databases will get slower and be more prone to exceptions.

Go to http://tahiti.oracle.com and perform basic research on SGA sizing and tuning.

PS: Your cross-post to c.d.o. has been deleted.

Daniel Morgan Received on Sun Feb 09 2003 - 00:39:01 CST