Re: max file size for DB block 16k and 32K?

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 6 Jan 2010 12:29:10 +0000
Message-ID: <7765c8971001060429y8aa1e28ya137cfaead665ee9_at_mail.gmail.com>

2^22 * (block_size) so 64 and 128gb respectively. This obviously assumes that

1. you are using smallfile tablespaces and
2. the os doesn't impose a lower limit.

There's a section in the docs for your version called database limits that contains this and other useful info.

Niall

On Wed, Jan 6, 2010 at 11:50 AM, dba1 mcc <mccdba1_at_yahoo.com> wrote:

> We have ORACLE 10.2.0.4 X86_64 on Redhat server. I knew for 8k DB block
> size max file size is 32 GB.
>
> Does anyone know for 16K and 32K what is max file size?
>
> Does max file size different on X86 and X86_64 version?
>
> Thanks.
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 06 2010 - 06:29:10 CST