V$DBFILE

V$DBFILE displays all datafiles making up the database. This view is retained for historical compatibility. Use of V$DATAFILE is recommended instead.

Column	Datatype	Description
FILE#	NUMBER	File identifier
NAME	VARCHAR2(513)	Name of the file

Note:

SQL> select * from V$DBFILE; FILE# NAME ---------- ------------------------------------------------------------ 1 /u02/oracle_data/mydb/system01.dbf 2 /u02/oracle_data/mydb/undotbs01.dbf 3 /u02/oracle_data/mydb/undotbs02.dbf 4 /u02/oracle_data/mydb/cwmlite01.dbf 5 /u02/oracle_data/mydb/drsys01.dbf 6 /u02/oracle_data/mydb/odm01.dbf 7 /u02/oracle_data/mydb/tools01.dbf 8 /u02/oracle_data/mydb/users01.dbf 9 /u02/oracle_data/mydb/xdb01.dbf 10 /u02/oracle_data/mydb/prod_anal01.dbf 11 /u02/oracle_data/mydb/atlas01.dbf

Oracle data dictionary views

Oracle dynamic performance views