Database size after Duplicat

[big]

[ErmanArslansOracleBlog]

Check the OS.. Filesystem size report depends from OS to Os.. From Filesytem to filesystem...

Check the DB size using SQL ...

[big]

Hi,
Yes thank you.

===============on DEV========================================
SQL> select sum (bytes/(1024*1024*1024)) from v$datafile;
SUM(BYTES/(1024*1024*1024))
---------------------------
                 508.529297
=========================On PROD=================================
SQL> select sum (bytes/1024*1024*1024)) from v$datafile;
SUM(BYTES/(1024*1024*1024))
---------------------------
                 509.592773
Then they are nearly the same if not mistaken. So on DEV we have some supplementary expired dbf files.

How can I identify and delete them without risk for our DB?

Thanks.

[ErmanArslansOracleBlog]

what do you mean by supplementary expired datafiles?
use v$datafile to check your datafiles.