topic Re: File size getting limited in Operating System - HP-UX

File size getting limited

MAYIANAN — Tue, 31 Jul 2007 05:19:48 GMT

Hi all,

When i try to extract records from oracle the file size in unix is getting limited to 2GB. The actual size should be 9GB.Is this an oracle error or unix error?

i just extract like

connect
spool
select query
spool off

-Mayilvahanan

Re: File size getting limited

Pete Randall — Tue, 31 Jul 2007 05:30:52 GMT

The most likely cause would be that the filesystem is set to "nolargefiles", thus limiting the size of files which can be created in it. Run "fsadm" to check:

# fsadm /opt
fsadm: /etc/default/fs is used for determining the file system type
largefiles
# fsadm /
fsadm: /etc/default/fs is used for determining the file system type
nolargefiles

Pete

Re: File size getting limited

Robert-Jan Goossens — Tue, 31 Jul 2007 05:35:53 GMT

Hi,

Could be the filesystem has not been set to enable largefiles >2GB

with OnlineFFS
# fsadm -F vxfs /filesystem
# fsadm -F vxfs -o largefiles /filesystem

without OnlineJFS
# fsadm -F vxfs /dev/vgXX/lvolX
# umount /filesystem
# fsadm -F vxfs -o largefiles /dev/vgXX/lvolX

Regards,
Robert-Jan

Re: File size getting limited

Yogeeraj_1 — Tue, 31 Jul 2007 07:59:38 GMT

hi,

You should enable largefiles support on the file system as mentioned. If this cannot be done immediately, you may wish to create a new file system using SAM and enable the largerfiles support there itself. Then once mounted, you can proceed with the spool operation.

Also, to get a better performance, it is preferrable not to echo the output to the current session screen.

good luck!

kind regards
yogeeraj

Re: File size getting limited

Dennis Handly — Wed, 01 Aug 2007 05:59:43 GMT

I don't think you need OnlineJFS to do this, at least on 11.23.