SOT: Re: Oracle 9i Linux and raw devices

"Mladen Gogala" <mgogala_at_adelphia.net> wrote in message news:pan.2003.04.13.04.22.11.519070_at_adelphia.net...
> On Sat, 12 Apr 2003 20:16:41 -0600, Andreas wrote:
>
> > ...
> > 64-bit File I/O
> > Linux supports 64-bit file I/O even on 32-bit platforms like Intel
> > Pentiumbased
> > servers. Oracle9iR2 supports 64-bit file offsets internally, hence there
are
> > no 2GB or 4GB limitations on data, log and control files. The limits on
number
> > of files per database (64K), number of blocks per file (4 million), and
> > maximum block size (16KB) are common to other Oracle platforms. Based on
these
> > limits, the maximum size for a database file is 64GB, and the maximum
database
> > size with 16KB blocks is 4 petabytes. ...
> >
> > is the raw device limit 4 PB?
>
>
> There is only one way to settle the dispute and that is to create
> a tablespace on a raw device with more then 2GB, populate it and
> then try to select from it. If you decide to be so kind, please
> let us know. I am not using Linux in production, so I'm not
> particularly interested. I'll wait for AMD Clawhammer or Intel
> Itanic, if Intel ever manages to salvage it from the performance
> iceberg that it has hit.
> --
> Mladen Gogala
>
> Light travels faster than sound.
> That is why some people appear bright
> until you hear them speak.
>
>

Itanium2 is out. HP-UX for IA64 is out. RHAS 2.1 for IA64 is out (IA64 is supplied by HP - interestingly enough). Oracle 9.2.0.2 for IA64 on HPUX and RHAS is out. Windows 2003 Server for IA64 is out and will support AMD Opteron in June.

I must say. It works rather nicely on HPUX so far, even though native code has to be compiled. No IA64 code on Itanium2 runs slower in most cases than on IA32 of same speed. The weblogic (java) stuff hums nicely. The AMD Opterons are just about out the door, nice thing is they have IA32 instruction sets so code does not have to recompile. However, IF you recompile you can take advantage of the IA64 instruction sets and get more performance.

ken k

ken k Received on Sun Apr 13 2003 - 00:02:14 CDT