Re: tempfile on solaris 2.7

On Tue, 27 Nov 2001 21:51:57 +1100, "G.Ong" <onggs_at_acslink.aone.net.au> wrote:

IIRC, it is created as a sparse file. Basically the INODE info is updated and the actual segments are allocated as needed.When you create it basically only directory type information is updated. The actual space is not allocated so thats why a tempfile creates so fast.

>Hello,
>
>I like to ask some questions about tempfile.
>
>We are using solaris 2.7 + rdbms 8.6.3.
>
>When a temporary tablespace with tempfile was created eg 1000M, the file is
>created + is visible at unix level ie. "ls -l" shows the file + size.
>However, "df -k" (or "du -ks" ) of that filesystem/directory does not show
>space being used (ie showed about 100K being used only).
>
>1)I know Oracle doesn't initialise tempfile, but what is the difference
>between ls -l and df -k ?
>2) However can I force Oracle to initialise the file (apart from running a
>query with a big sort) ?
>
>TIA,
>Ghee
>
>
Received on Tue Nov 27 2001 - 06:17:25 CST