Datafile Size

From: Nagaraj S <nagaraj.chk_at_gmail.com>
Date: Tue, 10 Feb 2009 00:03:36 +0530
Message-ID: <e921f8570902091033m3b50eca3hc1211ba9a9c1e72e_at_mail.gmail.com>



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;

FILE_NAME


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

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

/DATA/ORACLE/datafiles/sysaux01.dbf

SYSAUX                                     310                  0 NO



bash-3.00$ pwd

/DATA/ORACLE/datafiles/

bash-3.00$ du -sh sysaux01.dbf

 830M sysaux01.dbf

bash-3.00$

How this is possible?

Regards,
Naga

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 09 2009 - 12:33:36 CST

Original text of this message