Large memory support on 9.2.0.4 / W2K Adv Svr

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 6 Sep 2003 12:57:50 -0700
Message-ID: <1ac7c7b3.0309061157.42b51ee5@posting.google.com>

Wow. I'm impressed.

Large memory support didn't work at all on W2K Advanced Server for 8.1.7.4.x patchsets (at least 81741, 81746).

I finally got around to testing it on 9.2.0.4 today, and much to my delight, it worked. No errors, could connect, etc. Not that I want to run with a 1 GB PGA, 1.5 GB buffer cache, but, I could.

Software:
MS W2K Adv Svr (SP4)
Large memory support enabled in boot.ini (/3GB option) Oracle 9i R2 + 9.2.0.4 (Standard Edition)

Hardware:
Dell PowerEdge 2650
2 x 2.4 GHz Xeons (hyperthreading disabled) 6 GB physical memory (all that this puppy will hold) PowerVault 220S (dual channel)
14 drives across 4 channels

D:\> echo IFILE=D:\Oracle\Admin\mysid\pfile\initmysid_large.ora >
d:\oracle\ora92\database\initmysid.ora
D:\> oradim -edit -sid mysid -pfile
D:\Oracle\Admin\mysid\pfile\initmysid_large.ora

/* init parameters
java_pool_size=134217728
large_pool_size=67108864
shared_pool_size=134217728
db_cache_size=1610612736
pga_aggregate_target=1073741824
*/

D:\Oracle\Ora92\bin>sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Sat Sep 6 15:35:46 2003

SQL> connect / as sysdba
Connected.
SQL> set pages 9999
SQL> show parameter area_size

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

bitmap_merge_area_size               integer     1048576
create_bitmap_area_size              integer     8388608
hash_area_size                       integer     4194304
sort_area_size                       integer     4194304
workarea_size_policy                 string      AUTO

SQL> show parameter pool_size

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

java_pool_size                       big integer 134217728
large_pool_size                      big integer 67108864
olap_page_pool_size                  integer     33554432
shared_pool_size                     big integer 134217728

SQL> show parameter pga

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

pga_aggregate_target                 big integer 1073741824

SQL> show parameter db_cache_size

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

db_cache_size                        big integer 1610612736

SQL> select trunc(sum(value)/1048576) from v$sga;

TRUNC(SUM(VALUE)/1048576)

SQL> host pslist -m oracle

Process memory detail for NY-ORCL-001:

Name Pid VM WS WS Pk Priv Faults NonP Page PageFile
oracle 828 360628 272956 282936 269888 109120 51 131 269888
oracle 928 265152 178480 202580 177092 121307 49 131 177092
oracle 844 377840 96528 98144 313088 25962 50 137 313088
oracle 1480 171740 24352 26316 118508 7738 44 90 118508
oracle 848 502444 88484 88572 414864 23694 17 131 414864
oracle 860 501760 87760 90328 413188 23394 16 131 413188
oracle 1464 500588 87892 90460 412984 23425 15 131 412984
oracle 804 463372 96680 96680 411836 24906 13 90 411836
oracle 1840 2044640 241752 241752 1980244 61800 67 137 1980244 << mysid

Querying information for mybox...

System information for \\mybox:

Uptime:                    9 days, 9 hours, 28 minutes, 25 seconds
Kernel version:            Microsoft Windows 2000, Multiprocessor Free
Product type:              Advanced Server
Product version:           5.0
Service pack:              4
Kernel build number:       2195
Registered organization:   myemployer
Registered owner:          OracleDBA
Install date:              8/16/2002, 3:41:18 PM
IE version:                5.0100
System root:               C:\WINNT
Processors:                2
Processor speed:           2.3 GHz
Processor type:            x86 Family 15 Model 2 Stepping 4,
GenuineIntel
Physical memory:           5632 MB
Volume Type       Format     Label                      Size      
Free   Free
    A: Removable                                                      
     0%
    C: Fixed      NTFS       Dell Server             10.0 GB     3.4
GB    34%
    D: Fixed      NTFS       OraHome                  6.9 GB     1.8
GB    25%
    E: Fixed      NTFS       RedoA                    4.0 GB     1.8
GB    45%
    F: Fixed      NTFS       RedoB                    4.0 GB     1.9
GB    48%
    G: Fixed      NTFS       OraData01               64.4 GB    21.1
GB    33%
    H: Fixed      NTFS       Oradata02               64.4 GB    25.0
GB    39%
    I: Fixed      NTFS       Ext_0_01                16.9 GB     8.2
GB    48%
    J: Fixed      NTFS       Ext_0_02                16.9 GB     5.3
GB    31%
    K: Fixed      NTFS       Ext_0_03                16.9 GB     6.7
GB    39%
    L: Fixed      NTFS       Ext_0_04                16.9 GB     7.0
GB    41%
    M: Fixed      NTFS       Ext_1_09                16.9 GB     6.4
GB    38%
    N: Fixed      NTFS       Ext_1_10                16.9 GB     5.9
GB    35%
    O: Fixed      NTFS       Ext_1_11                16.9 GB     6.7
GB    40%
    S: Fixed      NTFS       Stage                   68.4 GB     4.5
GB     7%
    X: CD-ROM                                                         
     0%
OS Hot Fix    Installed
KB823559      8/13/2003
KB823980      8/13/2003
Q147222       8/16/2002
Q816093       4/26/2003

ServicePackUninstall 8/16/2002

The uptime being low is due to a UPS that decided that the servers needed rebooting twice daily.

Time to put some more memory in the Intel boxes.

Paul Received on Sat Sep 06 2003 - 14:57:50 CDT

Large memory support on 9.2.0.4 / W2K Adv Svr - it works.