Re: 64-bit Oracle

From: B.Sc Yassir Khogaly <yassir_at_khogaly.freeserve.co.uk>
Date: 1998/11/01
Message-ID: <71i5mp$2m7$1@newsreader1.core.theplanet.net>#1/1

As a matter of fact if you want some of the full history of VLM "64-bit Option" , See Digital UNIX yeeeeeb......please see attached article. Oracle Corporate Support
Problem Repository

Prob# 1010862.6 SETTING UP VLM (VERY LARGE MEMORY SYSTEM OPTION) ON DIG
Soln# 2058890.6 SETTING UP VLM (VERY LARGE MEMORY SYSTEM OPTION)
Prob# 1010862.6 SETTING UP VLM (VERY LARGE MEMORY SYSTEM OPTION) ON DIG

Problem ID          : 1010862.6
Affected Platforms  : Digital Unix
Affected Products   : Oracle7 Server
Affected Components : RDBMS V07.XX
Affected Oracle Vsn : V07.XX

Summary:
SETTING UP VLM (VERY LARGE MEMORY SYSTEM OPTION) ON DIGITAL UNIX +=+

Problem Description:

When setting up VLM (Very Large Memory System Option), how do you use the 64 bit option?

This document describes which versions of VLM are available and how to enable it on different versions of Oracle for Digital UNIX.

+==+

Diagnostics and References:

{6172.6,Y,100} VERY LARGE MEMORY SYSTEM OPTION (VLM) 2. Soln# 2058890.6 SETTING UP VLM (VERY LARGE MEMORY SYSTEM OPTION)

Solution ID         : 2058890.6
For Problem         : 1010862.6
Affected Platforms  : Digital Unix
Affected Products   : Oracle7 Server
Affected Components : RDBMS V07.XX
Affected Oracle Vsn : V07.XX

Summary:
SETTING UP VLM (VERY LARGE MEMORY SYSTEM OPTION) +=+

Setting up VLM (Very Large Memory System Option)

Oracle                 What Functionality    Enabling
Version                is Available          VLM
=========================================================================
7.1.4 with Patch 51    VLM, BOB max of       uses environment
                                             variable to enable
                       1,900,000 blocks      VLM - under csh use
                                             setenv HUGE_SGA=0x400000000

7.1.6.2                VLM, BOB max of       uses environment variable to
                       1,900,000 blocks      enable VLM - under csh use
                                             setenv HUGE_SGA=0x400000000

7.1.6 with 'patch 54'  OPS, VLM, BOB with    does not use environment
                                             variable

EFT patch              virtually no max      uses init.ora parameter
                                             will not be released
                                             for # of  buffers

_huge_sga_base_address=0x400000000
                                             as an official patch

7.2.2                  OPS, VLM, BOB with    uses init.ora parameter
                                             virtually no max

_huge_sga_base_address=0x400000000
                                             for # of buffers

Future releases will be the same as 7.2.2 except when VLM is officially productized, the init.ora parameter _huge_sga_base_address will become a non-underscore parameter (huge_sga_base_address).

UNIX Kernel Parameters:

# for 1GB of memory, use the following:
# vm-maxvas=10737418240
# for 8GB of memory, use the following:

vm-maxvax=8589934592
vm-vapentries=400

# for large memory systems, reduce the memory usage by Unified Buffer Cache:
ubc-minpercent=1
ubc-maxpercent=2

rt:
aio-max-num = 512
aio-max-percent = 2

proc:
max-proc-per-user=1024
max-threads-per-user = 1024

# for 1GB of memory, use the following:
# max-per-proc-data-size=10737418240
# max-per-proc-address-space=10737418240
#
# for 8GB of memory, use the following:

max-per-proc-data-size=8589934592
max-per-proc-address-space=8589924592

OTHER:

Set the following process settings in the .login of the user account:

        limit datasize unlimited
        limit stacksize unlimited
        limit memoryuse unlimited
        limit addressspace unlimited

+==+

References:

Jay Kyle wrote in message <71i2o8$qaa$1_at_news.bctel.net>...

>Does anyone have experience with the 64-bit option of Oracle 8. I'm trying
>to find out if it's actually working out as a viable performance option for
>Oracle in a Data Warehouse. Are there any "gotcha's " when using it, etc.
>
>Jay Kyle
>
>

begin 666 Yassir Khogaly.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DMH;V=A;'D[66%S<VER#0I& M3CI987-S:7(@2VAO9V%L>0T*5$E43$4Z4V5N:6]R($]R86-L92!$0D$-"E1% M3#M(3TU%.U9/24-%.BLT-"@P*3$X,2 T-C T,#0R#0I414P[0T5,3#M63TE# M13HK-#0T,3$Y,#8W-S8-"D%$4CM(3TU%.CL[.SM+96YT.SM%;F=L86YD#0I, M04)%3#M(3TU%.T5.0T]$24Y'/5%53U1%1"U04DE.5$%"3$4Z2V5N=#TP1#TP M045N9VQA;F0-"E523#IH='1P.B\O=W=W+FMH;V=A;'DN9G)E97-E<G9E+F-O M+G5K#0I54DPZ:'1T<#HO+W=W=RYA965U+F]R9RYU:PT*14U!24P[4%)%1CM) M3E1%4DY%5#IY87-S:7) :VAO9V%L>2YF<F5E<V5R=F4N8V\N=6L-"E)%5CHQ <.3DX,3$P,50Q-S(W-#E:#0I%3D0Z5D-!4D0-"@`` `
end Received on Sun Nov 01 1998 - 00:00:00 CST