Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i Linux and raw devices

Re: Oracle 9i Linux and raw devices

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Mon, 14 Apr 2003 10:02:03 +0200
Message-ID: <b7dpr1$9eu$1@news.mch.sbs.de>


Hi,

the clue with largefiles on 32bit-Unix-OS has always been the lseek call, which takes the offset in bytes. This limited the file size to 2GB (signed integer). Most OS came around this by introducing a new call lseekb (or similar), which takes the offset in 512-byte-Blocks, thus breaking the 2GB-Limit by far.

On Linux there's a call llseek, which takes 2 pos parameters. see man page. I believe Oracle to take advantage of this feature.

At least on my Oracle 9.2 on Suse 7.3, datafiles are opened with largefile open("/oracle/orav92/oradata/sb9/users01.dbf", O_RDWR|O_SYNC|O_LARGEFILE) = 8
:
:
_llseek(8, 43220992, [43220992], SEEK_SET) = 0

"Andreas" <ast1200_at_netscape.net> wrote in message news:3E9844E5.7070909_at_netscape.net...
> What is maximum size of datafile created on raw device (Linux IA32)?
>
> -AST
>
Received on Mon Apr 14 2003 - 03:02:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US