Oracle sparse files

[Joe J_1]

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

[TwoProc]

IS this a TEMP table file?

[Jeff Schussele · Accepted solution]

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

[Joe J_1]

Yes! these are temp files

[TwoProc]

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