Re: max file size for DB block 16k and 32K?
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Wed, 6 Jan 2010 12:29:10 +0000
2^22 * (block_size) so 64 and 128gb respectively. This obviously assumes
that
a) you are using smallfile tablespaces and
b) 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@xxxxxxxxx> 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.
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
