Re: Database Size Limit with Oracle 10g Standard Edition

From: gym dot scuba dot kennedy at gmail <kennedyii_at_verizon.net>
Date: Fri, 24 Apr 2009 11:33:34 GMT
Message-ID: <ishIl.2581$b11.568_at_nwrddc02.gnilink.net>


"Mladen Gogala" <mladen_at_bogus.email.com> wrote in message news:gsqif9$l73$1_at_solani.org...
> 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).
>
>
>
> --
> http://mgogala.freehostia.com

I thought Mauve sped up index processing? Jim Received on Fri Apr 24 2009 - 06:33:34 CDT

Original text of this message