Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Sparse TEMP files

Sparse TEMP files

From: Liggs <liggs_at_hotmail.com>
Date: Wed, 3 Jul 2002 16:21:18 +0000 (UTC)
Message-ID: <afv89t$cl3$1@helle.btinternet.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US