Re: DBA_TEMP_FILES.MAXBYTES is wrong

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_at_mail.ee> 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_at_gmail.com>
> To: "ORACLE-L" <oracle-l_at_freelists.org>
> 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?
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Regards
Zhu Chao
www.cnoug.org <http://www.cnoug.org>

--
http://www.freelists.org/webpage/oracle-l