Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Sparse TEMP files
Anybody else notice that Oracle 8i+ creates TEMP files as sparse files
?
It also adds it very quickly and oracle sees it as, eg 500mb, the 'ls -l'
Unix command sees it as 500Mb,
but the 'ls -s' doesn't, possibly saying 10Mb instead.
When someone does a query that needs all the TEMP tablespace, it expands it,
possibly to the full 500Mb.
Which is fine, unless you've filled the filesystem up in the meantime.
an OS 'cp' to 'cp' changes it to a normal file, but its still a bit naff and dangerous.
Alun Received on Wed Jul 03 2002 - 11:21:18 CDT