View database file information using several special views of Oracle

In Oracle, if your data storage adopts the file format, you can log on to the Oracle host and find the database storage directory to view the database file information. However, if you do not know where the file is stored or the logon permission of the host is not available, how do you know the configuration of the database file? In this case, you need some special views for help.

If you log on to a DBA such as sys, You can see three views: V $ CONTROLFILE, V $ DATAFILE, and V $ LOGFILE. The first view can view the control file information. The control file is the pivot of Oracle Database Operations. The control file is used to operate the other two files. Data files are the places where Oracle data is stored. The log FILE is a REDO log FILE that we often call a REDO log FILE. In Oracle's data integrity, redo file is an important means.

The three views contain not only the file name, but also many other database attributes.