Search notes:

v$dbfile

Compare v$dbfile with v$datafile:
--
--  The resultset of the following query should be empty:
--
(  select name from v$datafile minus select name from v$dbfile  ) union all
(  select name from v$dbfile   minus select name from v$datafile);
Github repository oracle-patterns, path: /Installed/dynamic-performance-views/dbfile/compare-to-datafile.sql

See also

Oracle Dynamic Performance Views

Index