Hi,
Tanel.
Tanel, For sparse file, ls -l will not show the actual file. as oracle tempfiles. For example, in solaris 10/redhat 3. In linux redhat as3:
SQL> create temporary tablespace tmp tempfile '/tmp/a.dbf' size 20001m autoextend on maxsize 40001m;
Tablespace created.
SQL> ! ls -l /tmp/a.dbf -rw-r----- 1 oracle dba 20972584960 May 31 08:24 /tmp/a.dbf
SQL> ! df -k /tmp Filesystem 1k-blocks Used Available Use% Mounted on /dev/sda5 2055600 32996 1918184 2% /tmp On 5/31/05, Tanel Põder <tanel.poder.003@xxxxxxx> wrote:
'ls -ls' shows the real size of file in filesystem blocks on most modern unixes as well...
Tanel.
-- //www.freelists.org/webpage/oracle-l