Re: Implementing ADDRESS WINDOWING EXTENSIONS (AWE) for increased memory

On Thu, Feb 7, 2008 at 12:08 PM, M Rafiq <rafiq9857_at_hotmail.com> wrote:

> I just applied the following 2 coomands and restarted database without
> any issues. It is Window 2003 with 4GB ram. No other changes made to any
> other parameter or any file.
>
> SQL> ALTER SYSTEM SET SGA_MAX_SIZE = 1500M SCOPE = SPFILE;
> System altered.
> SQL> ALTER SYSTEM SET SGA_TARGET = 1500M SCOPE = SPFILE;
> System altered.
>
>
> Instance_Name Host_Name Db_version startup_time Status
> Db_Status
> --------------- ------------ ---------- ------------------ ----------
> ----------
> ABC WINDOWS2003 10.1.0.4.0 07-FEB-08 11:43:24 OPEN
> ACTIVE
> SQL> show parameter sga
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> lock_sga boolean FALSE
> pre_page_sga boolean FALSE
> sga_max_size big integer 1577058304
> sga_target big integer 1577058304
> SQL>
>
>
> Regards
> Rafiq
>

Rafiq,

If the /3GB flag isn't set, I'd bet a hefty sum that if you throw 300 dedicated server sessions at that with enough usage to work the pga, populate the buffer cache and the shared pool ... and you'd see ora-4031 errors and TNS: internal restriction exceeded messages during connection attempts.

The OS limit for the oracle.exe process isn't 2*1024*1024*1024 bytes. Its much lower.
It also kicks in for the virtual memory, not the committed memory.

This brings back memories, albeit not fond ones.

good luck.

Paul

> ------------------------------
> Date: Wed, 6 Feb 2008 14:44:19 -0800
> From: jkstill_at_gmail.com
> To: davidg.oraclel_at_live.com
> Subject: Re: Implementing ADDRESS WINDOWING EXTENSIONS (AWE) for increased
> memory
> CC: oracle-l_at_freelists.org
>
>
>
> From the ML Note:
>
> The size of this window is defined by a registry setting in the HOME key for
> Oracle (HKLM\Software\Oracle\Homex) called AWE_WINDOW_MEMORY. By default,
>
> this value is 1GB, so if this value is not set in the registry,
> AWE_WINDOW_MEMORY will be 1GB.
>
>
> This is set on a per instance basis.
>
>
> On Feb 1, 2008 1:22 PM, David Grosser <davidg.oraclel_at_live.com> wrote:
>
> Hi,
>
> I'm trying to implement ADDRESS WINDOWING EXTENSIONS (AWE) to take
> advantage of all of the memory on my server. The server details are:
> Windows server 2003 enterprise edition, 4 processors, 8 GB memory, Oracle
> 10.2.0.1.
>
> I tried to implement awe according to metalink note *225349.1 *but my
> instance is not coming up. I did the following:
>
> - added switches /PAE and /3GB to the boot.ini
> - removed sga_target from the spfile
> added USE_INDIRECT_DATA_BUFFERS=TRUE to the spfile
> - added DB_BLOCK_BUFFERS to the spfile
>
> The error I get when I start the database is :
> ORA-27102: out of memory
> OSD-00034: additional error information
> O/S-Error: (OS 8) Not enough storage is available to process this command.
>
> I've tried raising and lowering the memory but nothing works.
>
> Has anyone implemented AWE? If so, how did you get it to work?
>
> Thanks,
> David Grosser
> DBA
> NSTAR Electric and Gas
>
>
>
>
> ------------------------------
> Need to know the score, the latest news, or you need your Hotmail(R)-get
> your "fix". Check it out. <http://www.msnmobilefix.com/Default.aspx>
>
>
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>
> ------------------------------
> Shed those extra pounds with MSN and The Biggest Loser! Learn more.<http://biggestloser.msn.com/>
>

-- 
-----------------------------------------------------------------
USADA and WADA are broken and not worth fixing. Boycott professional sports.
Avoid patronizing their advertisers. Don't buy tickets to NBA, NFL, MLBB,
NHL and especially Pro Cycling.

--
http://www.freelists.org/webpage/oracle-l