Oracle9i and 8GB RAM on Win2k Adv. Srv.

hi_neil_at_yahoo.com (Neil) wrote in message news:<85c46a2b.0301081156.64b1f222_at_posting.google.com>...
> We currently running 8.1.6.3 patch 8 on Win2K Adv. Srv. SP2.
> Hardware is compaq quad 900 MHz and 8GB RAM
> We are able to use more than 4 GB RAM with the switches in
> Boot.ini(/3GB /PAE) and AWE_WINDOW_MEMORY registry parameter.
> Currently, we are in a process of testing migration to 9.2.0.2.1.
> Oracle is not able to recognize more than 4GB of RAM with same tweaks
> to boot.ini and AWE_WINDOW_MEMORY registry parameter.
>
> Any suggestions...

To s.kapitsa:
Datacenter is not needed to see 8GB, AdvSrv is enough Dan

To Neil:

Oracle9i Release Notes Addendum
Release 2 (9.2.0.1.0) for Windows
Part Number A97617-01

3. Very Large Memory (VLM) and DB_BLOCK_SIZE With a large DB_BLOCK_SIZE initialization parameter value, the default AWE_WINDOW_MEMORY registry value of 1 GB may not be sufficient to start the database. Out of memory errors display on configurations where the number of least recently used (LRU) latches is high. As a general guideline, increase the AWE_WINDOW_MEMORY registry value by 20 percent.

For example, if DB_BLOCK_SIZE is set to 8 K, AWE_WINDOW_MEMORY is set to 1 GB, and the number of LRU latches is set to 32 (16 processor computer), database startup fails with out of memory errors 27102 and 34. Increasing the AWE_WINDOW_MEMORY value to 1.2 GB fixes the out-of-memory errors.

See Also:
"VLM Instance Tuning" in Chapter 4, "Oracle9i Architecture on Windows" of Oracle9i Database Getting Started for Windows Received on Thu Jan 09 2003 - 21:45:35 CST