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

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 Received on Sun Feb 09 2003 - 02:26:00 CET