V$DBFILE definition in Oracle Database 11.2
V$DBFILE

select
  FILE#,                                   -- FILE# NUMBER
  NAME                                     -- NAME VARCHAR2(513)
from
  GV$DBFILE
where
  inst_id = USERENV('Instance')

home |  up