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. > > ----- Original Message ----- > From: "Greg Norris" <spikey.mcmarbles@xxxxxxxxx> > To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx> > Sent: Monday, May 30, 2005 8:55 PM > Subject: Re: DBA_TEMP_FILES.MAXBYTES is wrong > > > > My guess would be that the files are sparse. What are the results of > > 'du -k'? Does it match up with the 'ls -l' output? > > -- > //www.freelists.org/webpage/oracle-l > -- Regards Zhu Chao www.cnoug.org <http://www.cnoug.org> -- //www.freelists.org/webpage/oracle-l