Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Utlizing /3GB and /PAE to go beyong 2GB limitaion of WIndows 32 bit

Re: Utlizing /3GB and /PAE to go beyong 2GB limitaion of WIndows 32 bit

From: bdbafh <bdbafh_at_gmail.com>
Date: Mon, 17 Sep 2007 03:18:35 -0000
Message-ID: <1189999115.869566.73280@57g2000hsv.googlegroups.com>

zigzag..._at_yahoo.com wrote:
> awe_window_memory
>
> I am using Windows 2000 Advanced Server and my database version is
> Oracle 9.2.0.6 32 bit.
>
> I have read many articles on metalink on using /3GB and /PAE (AWE) on
> metalink. While I understand how memory allocation works, when there
> is only database instance using AWE, it is not clear what happens
> when I have multiple database instances using AWE.
>
> Let us say I have set awe_window_memory=512M (in bytes) in registery.
> My db_block_buffers * db_block_size = 2GB.
>
> For one instance, 512M bytes of memory will come from lower 3GB area.
> 1.5GB of buffer cache will come from above 4GB (PAE) area.
>
> 1. For second database, will additional 512M bytes of memory come from
> lower 3GB area, or is the same AWE memory window (512M) is used for
> both database instances. I know additional 1.5GB buffer cache will
> come above 4GB area, but not clear about lower 3GB area. Will 512M +
> 512M =1024M has been taken from lower 3GB area.
> 2. Another question, how does one monitor how much memory is being
> utilized below 3GB and how much above 4GB. Is there any way to get
> this information from windows tool such as perfmon or using Oracle
> data dictionary views?
>
> Thanks,

Perhaps upgrading to Oracle 10g R2 on an x86-64 OS on an x86-64 processor is worth investigating.

-bdbafh Received on Sun Sep 16 2007 - 22:18:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US