Re: Sparse TEMP files

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Mon, 8 Jul 2002 14:10:17 +1000
Message-ID: <agb3a7$mq2$1@lust.ihug.co.nz>

I rather thought one of the contributing factors to making the file sparse was that Oracle hadn't formatted the blocks in the file. But the first use of them would indeed have to format those blocks, and that would indeed slow the first query/queries down.

I may indeed be completely off my rocker, and would welcome being put right on this. Being a Microsoft duffer at heart, all the technicalities of sparseness rather sail straight over my head. Might as well be talking about Emu Pie for all I know about it.

Regards
HJR "Yong Huang" <yong321_at_yahoo.com> wrote in message news:b3cb12d6.0207071952.314015fd_at_posting.google.com...
> Karen <abvk_at_ureach.com> wrote in message
news:<3D27E270.D86488D9_at_ureach.com>...
> > b) the performance
> > will be slower for the first queries that use the tablespace.
>
> I'd like to know why the first use of a sparse tempfile would be
> slower than if the file were actually filled with data. If it *is*
> indeed true, it's probably not because the "holes" have to be written
> with real data; it may be because the inode pointers have to point
> somewhere instead of nowhere? Do you have a benchmark or a theoretical
> proof?
>
> Yong Huang
Received on Sun Jul 07 2002 - 23:10:17 CDT