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,
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-lReceived on Mon Feb 09 2009 - 12:33:36 CST