Re: DBA_TEMP_FILES.MAXBYTES is wrong

  • From: zhu chao <zhuchao@xxxxxxxxx>
  • To: tanel.poder.003@xxxxxxx
  • Date: Tue, 31 May 2005 08:32:49 +0800

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

Other related posts: