Re: 2GB data file on Oracle 7.3.4

From: Silvio Seifert <silvio.seifert_at_gmx.net>
Date: 2000/07/15
Message-ID: <8kqg13$oi6$15$2@news.t-online.com>#1/1

On Wed, 12 Jul 2000 14:01:33 GMT, faisal_qasim_at_writeme.com wrote:

This is usally not an Oracle limit, but some Unix limit caused by the current ulimit settings. An other stupid reason is lack of free disk space, btw.

The next limit is usally 2 GB, the limit in size for a single file of lot's of filesystems.

Only after all that, the Oracle limits will be reached. As far as I remember from memory, Oracle can manage about 4,000,000 blocks per datafile. so the maximum datafile size depends on the DB_BLOCK_SIZE. With 2k you will get a maximum of 8 GB per datafile, with 4k the maximum will be around 16 GB and so on.

Regards,

>Dear all,
>
>I am getting error while trying to create 2GB Oracle 7.3.4 database
>file on AIX 4.3.3. While 982MB is the max. I could create.
>
>Is there a limit defined in Oracle and how can this be changed? Will it
>be beneficial to have one big file?
>
>
>Regards
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Silvio Seifert
Foehrer Strasse 34
65199 Wiesbaden
Germany Received on Sat Jul 15 2000 - 00:00:00 CDT