tempfile on solaris 2.7

From: G.Ong <onggs_at_acslink.aone.net.au>
Date: Tue, 27 Nov 2001 21:51:57 +1100
Message-ID: <d4KM7.36387$li3.290250@ozemail.com.au>

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 - 04:51:57 CST