topic Oracle sparse files in Operating System - HP-UX

Oracle sparse files

Joe J_1 — Thu, 20 Oct 2005 10:04:59 GMT

Hello all

How would HP-UX handle a request from a database server (such as Oracle) to
access "sparse" files if the file system is "full"?
Also, why does an oracle sparse file show 4G with the ll command and 0 with the bdf command?

Is there a way to turn this off or is there a fix for this?

Thanks
Joe

Re: Oracle sparse files

TwoProc — Thu, 20 Oct 2005 10:08:22 GMT

IS this a TEMP table file?

Re: Oracle sparse files

Jeff Schussele — Thu, 20 Oct 2005 11:00:39 GMT

Hi Joe,

This is not a problem. The bdf shows the true "usage", whereas the ll command will show the true filespace allocation.
You can do the same thing with a prealloc command. This is just basically filespace allocation and bdf recognizes that the space cannot be used by anything else.

HTH,
Jeff

Re: Oracle sparse files

Joe J_1 — Thu, 20 Oct 2005 12:31:17 GMT

Yes! these are temp files

Re: Oracle sparse files

TwoProc — Thu, 20 Oct 2005 12:32:43 GMT

This is normal for TEMP files. See Jeff's note.