Maximum filesize limit

[Erwin Vodegel_2]

Hello,

We are installing Oracle 9.2.06 and we have very large files (table files). We want to extend the maximum filesize limit to 500Gb.

Which kernel parameter do I have to modify? Which actions do I have to take?

Thanks in advance,
Erwin

[Patrick Wallek]

What version of the OS are you running? What version of the VxFS filesystem?

If you are running appropriate versions of both, you just need to make sure that you have the largefiles option turned on for your filesystems.

[Patrick Wallek]

Have a look at this DOC for more info:

Title: Supported file and file system sizes for JFS and HFS
Document ID: KBQA00000131
http://www2.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000080076711

[James R. Ferguson · Accepted solution]

Hi Erwin:

Whether or not this is posssible will depend upon your release and your JFS (VxFS) versions. For details, see the white paper, here:

http://docs.hp.com/en/5971-2383/5971-2383.pdf

You will need to enable 'largefiles' for the filesystem in question. See the manpages for 'fsadm_vxfs' for more details, too.

Regards!

...JRF...

[Robert-Jan Goossens_1]

Hi Erwin,

You should take a look at the memory advice given in this doc.

http://docs.hp.com/en/5971-2383/5971-2383.pdf

Regards,
Robert-Jan

[Erwin Vodegel_2]

He Robert,

You gave the same answer as James :-)

Best regards,
Erwin

[Erwin Vodegel_2]

I can compare the table that is within the pdf document.