0

We are having oracle 11g2 database on Solaris 10. We have all data files under single mount point say /u001 and we make the sum of bytes of all data files which is more than the physical used size of mount point /u001 Please suggest is this possible? Below is the All data files are under mount point /u001 

select sum (bytes)/1024/1024/1024 from dba_data_files 
204 GB

And the physical size of the mount point is 

df- h /u001 
            size   used    avil    capacity mounted on  
####/u001   685G   67G     531G     12%     /u001

Please do suggest is this possible

Improve this question
11
  • Are you sure all data files are located at /u01? Is there an /u02?
    – Nils
    Sep 19, 2019 at 11:07
  • Yes that is what i am wondering for the results.Do i need to check for the fragmentation
    – Ora-dba
    Sep 19, 2019 at 11:28
  • I am just wondering... do you use sparse files? What is the storage-backend for /u01?
    – Nils
    Sep 19, 2019 at 11:43
  • Show the whole output of select file_name, file_id, bytes from dba_data_files;, please.
    – Lenniey
    Sep 19, 2019 at 11:43
  • Hi its big output i can not put her due to security issue. how do i find sparse files?
    – Ora-dba
    Sep 19, 2019 at 11:57

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .