Re: Datafile Size
- From: Nagaraj S <nagaraj.chk@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 Feb 2009 00:29:08 +0530
Also du -sh and ls -ltrh shows different output.
bash-3.00$ ls -ltrh
-rw-rw---- 1 oracle dba 1.5G Feb 9 08:09 sysaux01.dbf
bash-3.00$ du -sh sysaux01.dbf
830M sysaux01.dbf
SQL> select sum(space_usage_kbytes) from v$sysaux_occupants;
309504
On Mon, Feb 9, 2009 at 10:59 PM, Nagaraj S <nagaraj.chk@xxxxxxxxx> wrote:
> 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
>
Other related posts:
