Database Files

OS- Windows , Version – 9i

TO DISPLAY THE NAMES & LOCATION OF ALL FILES OF A DATABASE.

Database files consists of Datafiles, Controlfiles, Redologfiles.

SQL> select name from v$controlfile;

SQL> Select member from v$logfile;

SQL> Select name from V$datafile