Re: Oracle9i and Red Hat Enterprise AS 3.0 max file size

From: DJ <nospamplease_at_goaway.com>
Date: Tue, 13 Apr 2004 22:25:12 +0100
Message-ID: <dVYec.219$zC5.164@newsfe1-win>

"FinnE" <finne_at_saic.com> wrote in message news:fae535f9.0404131110.6e073d6c_at_posting.google.com...
> We are trying to install a very large Oracle9i data warehouse on RHE
> AS 3.0. So far the largest OS file size we can successfully create is
> 3GB with an Oracle 8K DB_BLOCK_SIZE.
>
> A couple of questions:
> 1. Does the size of the DB_BLOCK_SIZE have anything to do with the OS
> file size limit? If so, if I increase the DB_BLOCK_SIZE to 16 or 32K
> what is the maximum file size that I can create?
> 2. What is the maximum file size that Red Hat Enterprise AS 3.0
> supports?
>
> We have RHE AS 3.0 installed on a 32bit x86 architecture and Oracle9i
> Enterprise Edition installed on top of it.
> Erin

Block size has nothing to do with os file size - have you enable large file support on whatever type of filesystem you use Received on Tue Apr 13 2004 - 16:25:12 CDT