Re: Database Size Limit with Oracle 10g Standard Edition

From: SEJ <>
Date: Thu, 30 Apr 2009 18:55:03 +0200
Message-ID: <49f9d82d$0$90274$>

I think we are talking about the free edition which have 4 GB limitation never heard about size limitation for SE.

"gym dot scuba dot kennedy at gmail" <> skrev i en meddelelse news:ishIl.2581$
> "Mladen Gogala" <> wrote in message
> news:gsqif9$l73$
>> On Thu, 23 Apr 2009 12:02:59 -0400, Dereck L. Dietz wrote:
>>> I haven't been able to find anything other than 11g specifications yet
>>> ...
>>> I remember once seeimg 10g specifications saying the maximum database
>>> size for the Oracle 10g Standard Edition was 500GB. Is that correct?
>>> Thanks.
>> I don't think so. On 32 bit Linux, the maximum oracle file size is 32GB
>> and you can have at least 65500 of them, which yields 2PB (with "P" as
>> in Petabyte) at the very least. Where did you come across that number?
>> If the platform is 64 bit, and it usually is, you can have larger file
>> system block on the XFS file system, and it will make those numbers even
>> larger. If you need really big files, do try XFS, it can have block sizes
>> of 16k or 32k. You can also make your database block larger which may
>> speed up your index processing (duck & cover).
>> --
> I thought Mauve sped up index processing?
> Jim
Received on Thu Apr 30 2009 - 11:55:03 CDT

Original text of this message