Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Differences in DB sizes

DBQuestJul 8 2016 — edited Jul 8 2016

Hi,

I want to know size of my database. I have used below query, it is showing 83GB.

SELECT sum((df.bytes/(1024*1024*1024)) )t

   FROM dba_data_files df;


But when i checked in home directory as below, it is showing different size


[oracle@mydb ~]$ df -H .

Filesystem             Size   Used  Avail Use% Mounted on

/dev/mapper/VG_home-LV_home

                        43G    21G    20G  52% /home

Kindly clarify why both are showing different values and which value i need to consider for size my database.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2016
Added on Jul 8 2016
9 comments
1,425 views