Datafile Size

From: Nagaraj S <>
Date: Tue, 10 Feb 2009 00:03:36 +0530
Message-ID: <>

Hi Gurus,

Kindly clarify my doubt on datafile size. I have noticed that the datafile size is different from OS level vs database. When I query to get the size of SYSAUX tablespace on database it showed me 310 MB, But on OS it showed me 830M.

SQL> select file_name,tablespace_name,bytes/1024/1024, maxbytes/1024/1024,AUTOEXTENSIBLE

  2 from dba_data_files where tablespace_name='SYSAUX' order by file_name;


TABLESPACE_NAME                BYTES/1024/1024 MAXBYTES/1024/1024 AUT

------------------------------ --------------- ------------------ ---


SYSAUX                                     310                  0 NO

bash-3.00$ pwd


bash-3.00$ du -sh sysaux01.dbf

 830M sysaux01.dbf


How this is possible?


Received on Mon Feb 09 2009 - 12:33:36 CST

Original text of this message