Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sparse TEMP files
"Liggs" <liggs_at_hotmail.com> wrote in message news:<afv89t$cl3$1_at_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.
Right after it's created, it should be much less than 1MB, not 10MB. I tested on Solaris 2.6, Oracle 8.1.7.2, a tempfile of any size is 128KB (ls -s gives the blocks of size 512 bytes). On Solaris 2.6, Oracle 9i, it's 96KB. On Solaris 8 Oracle 8.1.7.0, it's 96KB.
Yong Huang Received on Fri Jul 05 2002 - 11:45:59 CDT