Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How Use /Fastdetect /3GB switch for Utlizing > 2G RAM

585864Feb 18 2008 — edited Feb 19 2008

DB : 10.2.0
OS : Microsoft Server 2003
Processor : 2xDual Core Intel Xeon
Physical Memory : 4G (But showing 3.5G)

i want to configure my databse for utlizing 3g RAM ( using 3gb switch in boot.ini file 1G for OS Kernal and 2G for user related applications proces i.e ORACLE.EXE and lsnrctl etc.

After changing parameter USE_INDIRECT_DATA_BUFFERS=TRUE in init.ora file. what value i have to cinfigure for DB_BLOCK_BUFFERS=XXXXXX
and how i can update registery for AWE_WINDOW_MEMORY

how i adjust SGA and PGA for establishing Aproximatly 400 sessios.

Boot.ini file is as : (it is work or not)

[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Microsoft Windows Server 2003 " /noexecute=optin /fastdetect /3GB /Userva=3030

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 18 2008

Added on Feb 18 2008

#general-database-discussions

4 comments

3,026 views