Common dynamic performance views of ORACLE

The common dynamic performance view V $ FIXED_TABLE in ORACLE is used to list all available dynamic performance views and dynamic performance tables. V $ INSTANCE is used to obtain detailed information about the current routine. V $ SGA is used to obtain more detailed information about SGA. V $ PARAMETER is used to obtain detailed information about initialization parameters. V $ VERSION is used to obtain detailed information about the oracle VERSION. V $ OPTION is used to display the installed oracle options. TRUE indicates that this option has been installed, and FALSE indicates that this option is not installed. V $ SESSION is used to display SESSION details. V $ PROCESS is used to display information about all oracle-related processes (including background and server processes ). V $ BGPROCESS is used to display detailed information of background processes. V $ DATABASE is used to obtain detailed information about the current DATABASE (such as the DATABASE name, log mode, and creation time ). V $ CONTROLFILE is used to obtain information about all the control files of the current database. V $ DATAFILE is used to obtain detailed information about all data files in the current database. V $ DBFILE is used to obtain the data file number and name. V $ LOGFILE is used to display information about redo log members. V $ LOG is used to display detailed information about a LOG group. V $ THREAD is used to obtain detailed information about the redo THREAD. V $ LOCK is used to display the LOCK information. V $ LOCKED_OBJECT is used to display the locked database objects. V $ ROLLNAME and V $ rollstat v $ ROLLNAME the dynamic performance view is used to display undo segments in the online status, while V $ ROLLSTAT is used to display undo segment statistics. By performing a connection query between the two, the detailed statistics of the undo segment can be displayed. V $ TABLESPACE is used to display the TABLESPACE information. V $ TEMPFILE is used to display temporary files contained in the current database.