(GO) Oracle's Common Data dictionary

One, the Oracle data dictionary is composed of the following views mainly:1The user view is prefixed with user_ and is used to record information about the users object2The . All view is prefixed with All_ to record information about the user object and the object information that is authorized to access it3The . DBA view is prefixed with Dba_ to record information for all objects of the DB instance4The . v$ view is prefixed with v$ to record performance statistics related to database activity5The . gv$ view is prefixed with gv$ to record dynamic information for all instances in a distributed environment Ii. Oracle Common data Dictionary1the. Basic Data dictionary name Description dba_tables All table information for all Users dba_tab_columns field information for all users ' tables Dba_views All view information for all users dba_synonyms all synonym information for all users dba_sequences all the user's sequence information dba_constraints all user's table constraint information            Dba_ind_columns all user-indexed field information dba_triggers All user's trigger information dba_sources stored procedure information for all users dba_segments The use of spatial information for all users ' segments dba_extents the extended information for all user segments dba_objects basic information for all user objectsCatAll the base tables that the current user can access tab but all the base tables, views, synonyms, and so on that the user created dict the information for all tables that make up the data dictionary 2. Database component-related data dictionary database component Data Dictionary table or view description database V$datafile record System Runtime table space Dba_tabl                Espaces Record system table space basic information dba_free_space Record system table space free space information control file V$controlfile                  Record the basic information of the system control file V$control_record_section record the information of the document segment in the system control file V$parameter Record the basic information of the system parameters data file Dba_data_files record system data file and table space basic information V$filestat record              Data file information from the control file V$datafile_header the basic Information section of the header of the record data file dba_segments the basic information area of the record segment Dba_extents logs the basic information log of the data area V$thread The basic information of the logging thread v$l                OG logs the basic information of log files V$logfile log file summary information archive V$archived_log                     Record the basic information of the archived log file V$archived_dest record the path information database instance of the archive log file v$instance            Record the basic information of an instance  V$system_parameter record instance current valid parameter information memory structure V$SGA record SGA area information V$sgastat                          Record the details of the SGA V$db_object_cache record the size information of the object cache V$sql                      Log the details of the SQL statement V$sqltext record the statement information for the SQL statement V$sqlarea Log SQL basic information for SQL area background process v$bgprocess Show background process information V$session Display current session information3. Common dynamic Performance View name Description v$fixed_table Displays a description of the currently released fixed object v$instance displays information about the current instance V$latch Display latch Statistics V$librarycache displays statistics about library cache performance V$rollstat displays the name of the online rollback segment V$rowcache Displays the statistics of the Active data dictionary v$ SAG record SGA Information V$sgastat record the details of the SGA V$sort_usage show the size of the staging segment and the session V$sqltext record The statement information for the SQL statement V$sqlarea records the SQL basic information for the SQL area V$stsstat displays the basic instance Statistics V$system_event displays the total wait time for an event V$wai TSTAT Display Block Competition statistics

Transferred from: http://www.cnblogs.com/linjiqin/p/3148746.html

(GO) Oracle's Common Data dictionary