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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: working with datafile > 2Gb in HadHat 7.3

Re: working with datafile > 2Gb in HadHat 7.3

From: ltiu <ltiu_at_alumni.sfu.ca>
Date: Thu, 29 Aug 2002 15:47:19 -0800
Message-ID: <F001.004C3724.20020829154719@fatcity.com>


If you can't do it in hardware, do it in software. Right?

ltiu

Ji, Richard wrote:

>There is no such hardware limitation like that. Those are the OS i.e.
>software limitations. For instance, the 2gb file size limit is because of
>the
>32 bit OS, actually, to be more specific, it's the 32 bit file system.
>You can have a 32bit OS kernel, but if your file system supports 64bit, then
>you can support >2gb files. Same thing for the memory.
>
>Richard Ji
>
>-----Original Message-----
>Sent: Thursday, August 29, 2002 5:59 PM
>To: Multiple recipients of list ORACLE-L
>
>
>OK. I stand corrected. You do need third party tools though. But I
>suppose engineers can always hack their way through hardware limitations
>to make thing work. Like the >4GB memory limit of intels - this is not
>more since I believe Windows 2K and XP have this feature(in software?)
>where it can access greater than 4GB memory..
>
>Philip Douglass wrote:
>
>
>
>>Uh... don't think so! -- we're running UnixWare 7 on Intel hardware
>>(Xeons) and large file support is a matter of enabling the largefiles
>>option on the Veritas (VxFS) filesystem. That being said, I only use 2Gig
>>datafiles because it seems foolhardy to me to use >2Gig datafiles unless
>>you have an obvious need for them. And if you do, then test it a lot! And
>>make sure all of your programs support large files too (some versions of
>>tar/cpio/gzip don't)
>>
>>-- Philip
>>
>>----- Original Message -----
>>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>>Sent: Thursday, August 29, 2002 2:43 PM
>>
>>
>>It doesn't really matter what OS you have. Intel hardware can only
>>handle 2Gb files sizes max. Even if the hardware can support large
>>files, it is still recommended that you do not have large datafiles. You
>>need to partition your tablespaces into multiple datafiles. This
>>facilitates backups and restores and you can put the datafiles into
>>different hard drives increasing i/o performance.
>>
>>ltiu
>>
>>Adriano Freire wrote:
>>
>>
>>
>>
>>
>>>Ok ltiu,
>>>REDHAT 7.3 kernel-2.4.18-10
>>>
>>>----- Original Message -----
>>>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>>>Sent: Thursday, August 29, 2002 1:18 PM
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>>What's HadHat 7.3?
>>>>
>>>>A new Linux distro pattered after RedHat 7.3?
>>>>
>>>>ltiu
>>>>
>>>>Adriano Freire wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>Gurus,
>>>>>
>>>>>I've some problems with datafiles > 2Gb in HadHat 7.3. I'm using
>>>>>datafile type ext3 and
>>>>>when i try create a datafile with 2Gb the database is catching.
>>>>>Anybody have the some problem?
>>>>>any suggestion?
>>>>>
>>>>>Thanks
>>>>>
>>>>>Adriano.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>--
>>>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>>>--
>>>>Author: ltiu
>>>>INET: ltiu_at_alumni.sfu.ca
>>>>
>>>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>>>>San Diego, California -- Public Internet access / Mailing Lists
>>>>--------------------------------------------------------------------
>>>>To REMOVE yourself from this mailing list, send an E-Mail message
>>>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>>>>the message BODY, include a line containing: UNSUB ORACLE-L
>>>>(or the name of mailing list you want to be removed from). You may
>>>>also send the HELP command for other information (like subscribing).
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: ltiu
>> INET: ltiu_at_alumni.sfu.ca
>>
>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>>San Diego, California -- Public Internet access / Mailing Lists
>>--------------------------------------------------------------------
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>>the message BODY, include a line containing: UNSUB ORACLE-L
>>(or the name of mailing list you want to be removed from). You may
>>also send the HELP command for other information (like subscribing).
>>
>>
>>
>>
>>
>>
>
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  INET: ltiu_at_alumni.sfu.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Aug 29 2002 - 18:47:19 CDT

Original text of this message

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