topic Oracle DATA file Size in Operating System - Linux

Oracle DATA file Size

Nikee Reddy — Fri, 01 Oct 2004 10:32:16 GMT

Hello,

We have installed Oracle 9205 on SUSE LINUX Enterprise 8 IA64 bit environment.

Here my question is, what is the maximum datafile size is this environment will support
(2GB, 4 GB, 8GB or more)???

Thanks,
Nikee

Re: Oracle DATA file Size

xyko_1 — Fri, 01 Oct 2004 10:58:10 GMT

Hi,

this document is a litle bit old but ...

http://www.suse.de/~aj/linux_lfs.html

Hope it helps.

Regards,
Xyko

Re: Oracle DATA file Size

HGN — Mon, 04 Oct 2004 12:59:13 GMT

Hi

The link below has info about the datafile size

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:833627037644

Hope this helps

Rgds

Gopi

Re: Oracle DATA file Size

Johannes Krackowizer_1 — Tue, 05 Oct 2004 10:05:45 GMT

hi,

there are possible limits.
some filesystems limits for filesystem size or maximum file size.
if have Oracle 9i on AIX running. the maximum filesize is 4TB or 64TB i don't know (i don't worry 4TB are quite enough and my largest filesystem on the machine is only about 20GB). The Orcale people told me not to make to large db files. the said limit it to 4GB per file and split larger db's over 2,3 or more files if needed (larger files cost very much performence, more smaller files don't consume so much performence, i don't know why but they are right). it's very simple thru oracle enterprise Manager Console to add files to the db if needed.

but if you like to create some huge files (>4GB) please post what kernel and what filesystem do you use, so i can tell you your limits.

Johannes