64-bit Oracle

64-bit Oracle

Post by Jay Kyl » Mon, 02 Nov 1998 04:00:00



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

 
 
 

64-bit Oracle

Post by B.Sc Yassir Khogal » Mon, 02 Nov 1998 04:00:00


Hello,

Can you please state your OS...as well as your Hardware configuration...?

BOB & VLM as well as 64-bit are old options, As a matter of fact as old as
Server7.3 .
To make actual use of 64-bit you need to have a TRUE 64-bit OS, as well as
TRUE 64-bit I/O Controllers...!
Until this moment there is Only Digital Provides True 64-bit OS as well as
Hardware that actually fully benefits from the 64-bit performance gains
which you are talking about...!


>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&


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

`
end

 
 
 

64-bit Oracle

Post by B.Sc Yassir Khogal » Mon, 02 Nov 1998 04:00:00


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

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

1. 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:


>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&


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

`
end
 
 
 

64-bit Oracle

Post by David Lor » Tue, 03 Nov 1998 04:00:00


Er, No.  HP does as well.  So does Nintendo come to that.



Quote:> Hello,

> Can you please state your OS...as well as your Hardware configuration...?

> BOB & VLM as well as 64-bit are old options, As a matter of fact as old
as
> Server7.3 .
> To make actual use of 64-bit you need to have a TRUE 64-bit OS, as well
as
> TRUE 64-bit I/O Controllers...!
> Until this moment there is Only Digital Provides True 64-bit OS as well
as
> Hardware that actually fully benefits from the 64-bit performance gains
> which you are talking about...!

 
 
 

64-bit Oracle

Post by Jay Kyl » Tue, 03 Nov 1998 04:00:00


I know that Digital has this feature available to it, HP also has it, and
SUN is just getting it in place now. As far as full end-to-end 64-bit, I
believe the only Oracle specific issue is memory addressability so that the
SGA can be larger than 3 gigs, or any single Oracle process for that matter.

What I'm looking for is anyone using any of these platforms utilizing
features specific to the 64-bit option provided by Oracle. Is there any
experience out there with it and how would you rate it compared to the
32-bit version(s).

For example, does a large SGA (say 10-12 gigs) provide any performance
improvements over a smaller SGA (say 512MB) for a 500 gig table in a
warehouse environement, etc.

FYI The warehouse I'm working on is a SUN Enterprise 10000

Jay Kyle


>Er, No.  HP does as well.  So does Nintendo come to that.



>> Hello,

>> Can you please state your OS...as well as your Hardware configuration...?

>> BOB & VLM as well as 64-bit are old options, As a matter of fact as old
>as
>> Server7.3 .
>> To make actual use of 64-bit you need to have a TRUE 64-bit OS, as well
>as
>> TRUE 64-bit I/O Controllers...!
>> Until this moment there is Only Digital Provides True 64-bit OS as well
>as
>> Hardware that actually fully benefits from the 64-bit performance gains
>> which you are talking about...!

 
 
 

64-bit Oracle

Post by Kent Millig » Tue, 03 Nov 1998 04:00:00




|> Hello,
|>
|> Can you please state your OS...as well as your Hardware configuration...?
|>
|> BOB & VLM as well as 64-bit are old options, As a matter of fact as old as
|> Server7.3 .
|> To make actual use of 64-bit you need to have a TRUE 64-bit OS, as well as
|> TRUE 64-bit I/O Controllers...!
|> Until this moment there is Only Digital Provides True 64-bit OS as well as
|> Hardware that actually fully benefits from the 64-bit performance gains
|> which you are talking about...!

Uh... AS/400 is every bit 64-bit enabled from hardware to software to
operating system to DB2/400 and has been for a couple of years.  In fact,
existing  AS/400 applications that ran on the non-RISC models were optimized
for 64-bit speed and performance WITHOUT the need for rewrites or lengthy
recompiles.

I don't think that all software running on Digital is fully
64-bit enabled today like the AS/400.

Kent Milligan, DB2/400 Solutions Team
AS/400 Partners In Development

GO HAWKEYES!!
(opinions stated are not necessarily those of my employer)

 
 
 

64-bit Oracle

Post by B.Sc Yassir Khogal » Wed, 04 Nov 1998 04:00:00


I'm talking about Oracle & 64-bit ...!

Oracle Started using 64-bit since Oracle 7.1 ....?
Only ORACLE SERVER7 on Digital UNIX supported this feature.
HP-UX10 only on Server7 7.3 started supporting this feature, But worth
mentioning that HP K class & D Class did not have Controllers to support
64-bit ....!


>Er, No.  HP does as well.  So does Nintendo come to that.



>> Hello,

>> Can you please state your OS...as well as your Hardware configuration...?

>> BOB & VLM as well as 64-bit are old options, As a matter of fact as old
>as
>> Server7.3 .
>> To make actual use of 64-bit you need to have a TRUE 64-bit OS, as well
>as
>> TRUE 64-bit I/O Controllers...!
>> Until this moment there is Only Digital Provides True 64-bit OS as well
>as
>> Hardware that actually fully benefits from the 64-bit performance gains
>> which you are talking about...!

begin 666 Yassir Khogaly.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DMH;V=A;'D[66%S<VER#0I&


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

`
end
 
 
 

64-bit Oracle

Post by B.Sc Yassir Khogal » Wed, 04 Nov 1998 04:00:00


Yes it does, But it depends also on your Database Structure (physical &
Logical).
Also I found it without effect where the clients application was not
utilising those resources because it was not designed to run BOB & VLM.
There are specific requirements to be met when it comes to warehouse design.

What I was trying to explain, 64-bit Option is Not a new feature to Oracle
Servers. It was available on 7.1 for Digital Unix.
and that to really see any performance gains It requires
1- TRUE 64-bit OS.
2-TRUE 64-bit Hardware "I/O Controllers & Disks"


>I know that Digital has this feature available to it, HP also has it, and
>SUN is just getting it in place now. As far as full end-to-end 64-bit, I
>believe the only Oracle specific issue is memory addressability so that the
>SGA can be larger than 3 gigs, or any single Oracle process for that
matter.

>What I'm looking for is anyone using any of these platforms utilizing
>features specific to the 64-bit option provided by Oracle. Is there any
>experience out there with it and how would you rate it compared to the
>32-bit version(s).

>For example, does a large SGA (say 10-12 gigs) provide any performance
>improvements over a smaller SGA (say 512MB) for a 500 gig table in a
>warehouse environement, etc.

>FYI The warehouse I'm working on is a SUN Enterprise 10000

>Jay Kyle


>>Er, No.  HP does as well.  So does Nintendo come to that.



>>> Hello,

>>> Can you please state your OS...as well as your Hardware
configuration...?

>>> BOB & VLM as well as 64-bit are old options, As a matter of fact as old
>>as
>>> Server7.3 .
>>> To make actual use of 64-bit you need to have a TRUE 64-bit OS, as well
>>as
>>> TRUE 64-bit I/O Controllers...!
>>> Until this moment there is Only Digital Provides True 64-bit OS as well
>>as
>>> Hardware that actually fully benefits from the 64-bit performance gains
>>> which you are talking about...!

begin 666 Yassir Khogaly.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DMH;V=A;'D[66%S<VER#0I&


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

`
end
 
 
 

64-bit Oracle

Post by David Lor » Wed, 04 Nov 1998 04:00:00


I know, I know.

I was taking about 8.05 on a V series with 11.0.

DEC, er sorry, digital may have been one of the first 64bit vendors, but
they are certainly not the only vendor to supply and support 64bit systems
that can run 64 bit Oracle. Times are moving fast.

I have no beef with other vendor / version combos, but what you said was
not strictly true, and anyway, I'm sure I saw a Personnal Oracle cartridge
for N64 in FNAC the other day....  :)



Quote:> I'm talking about Oracle & 64-bit ...!

> Oracle Started using 64-bit since Oracle 7.1 ....?
> Only ORACLE SERVER7 on Digital UNIX supported this feature.
> HP-UX10 only on Server7 7.3 started supporting this feature, But worth
> mentioning that HP K class & D Class did not have Controllers to support
> 64-bit ....!

 
 
 

64-bit Oracle

Post by Miroslav Postonjs » Sat, 07 Nov 1998 04:00:00


Hello Friends

Real 64bit-Hardware-Platforms are developed by Digital Equipment Corp.
http://www.digital.com on AlphaServer.
OS currently available are:
- OpenVMS Alpha
- Digital UNIX Alpha (my best known Unix-System)
- MS Windows NT Server 4.0 Alpha

Ciao
M.Postonjski + M.Eismann

B.Sc Yassir Khogaly schrieb:

> I'm talking about Oracle & 64-bit ...!

> Oracle Started using 64-bit since Oracle 7.1 ....?
> Only ORACLE SERVER7 on Digital UNIX supported this feature.
> HP-UX10 only on Server7 7.3 started supporting this feature, But worth
> mentioning that HP K class & D Class did not have Controllers to support
> 64-bit ....!


> >Er, No.  HP does as well.  So does Nintendo come to that.



> >> Hello,

> >> Can you please state your OS...as well as your Hardware configuration...?

> >> BOB & VLM as well as 64-bit are old options, As a matter of fact as old
> >as
> >> Server7.3 .
> >> To make actual use of 64-bit you need to have a TRUE 64-bit OS, as well
> >as
> >> TRUE 64-bit I/O Controllers...!
> >> Until this moment there is Only Digital Provides True 64-bit OS as well
> >as
> >> Hardware that actually fully benefits from the 64-bit performance gains
> >> which you are talking about...!


>   Senior Oracle DBA

>   Yassir Khogaly

>   Kent               Privat Sprache: +44(0)181 4604042
>   England            Sprache Mobiltel.: +44411906776
>   Weitere Informationen:
>   Version       2.1
>   Nachname      Khogaly
>   Vorname       Yassir
>   Etikett PrivatKent England
>   Revision      19981103T101900Z

 
 
 

1. Changes in 64 bit Oracle from 32 bit

Hi Guys,

I am working on a project where we are migrating a backup application
from 32 to 64 bit. For that I require information on what are the
changes Oracle has done in its 64 bit flavour. If anybody knows the info
or whereabouts of this info please mail me.

Regards,
Chiro


 Sent via Deja.com http://www.deja.com/
 Share what you know. Learn what you don't.

2. SQL MAIL WHEN USE HP OPEN MAIL

3. 32-bit Clients to 64-bit Oracle Server

4. Refreshing TreeView Data

5. Question regarding 64-bit Oracle

6. Conflict in replication

7. Solstice Backup and 64-bit Oracle?

8. Suspect database

9. 64-bit Oracle on Solaris 7 !

10. When Will 64-Bit Oracle for Linux Release?

11. 64-bit Oracle

12. 64 bit Oracle changes

13. Question regarding 64-bit Oracle