Oracle 11g Architecture-Data dictionary

The name of the Oracle data dictionary consists of a prefix and a suffix, using the _ connection, meaning the following:

Dba_: Contains all object information for a DB instance

V$_: Dynamic view of the current instance, including views used by system management and system optimization

User_: Recording user's object information

GV_: Dynamic view of all instances in a distributed environment, including views for system management and system optimization use

All_: Record the object information that the user is authorized to access to the object information machine

Basic Data dictionary

A table describing the logical storage structure and the physical storage structure, including tables that describe information about other data objects:

Data dictionary Name	Description
Dba_tablespaces	Information about the Tablespace
Dba_ts_quotas	All user table space limits
Dba_free_space	Free partitioning in all table spaces
Dba_segments	Describe the storage space for all segments in the database
Dba_extents	Information for all partitions in the database
Dba_tables	Description of all data tables in the database
Dba_tab_columns	columns for all tables, views, and clusters
Dba_views	Information for all views in the database
Dba_synonyms	Information about synonyms
Dba_sequences	All user sequence Information
Dba_constraints	Constraint information for all user tables
Dba_indexs	Description of all indexes in the data table
Dba_ind_columns	Columns with compressed indexes on all tables and clusters
Dba_triggers	Trigger information for all users
Dba_source	All user stored procedure information
Dba_data_files	Querying information about database files
Dba_tab_grants/privs	Querying for information about object authorization
Dba_objects	Database All Objects
Dba_users	Information about all users in the database

Common Dynamic Performance views

Provides information about memory and disk operations that users can read only and cannot modify

Data dictionary Name	Description
V$database	Describe relevant information about the database
V$datafile	Data file information used by the database
V$log	Extracting information about redo log groups from a control file
V$logfile	Information about the instance resetting the log group file name and its location
V$archived_log	Record basic information for archived log files
V$archived_dest	Log path information for archived log files
V$controlfile	Describe information about the control file
V$instance	Record the basic information of an instance
V$system_parameter	Displays the parameter information that is currently valid for the instance
V$sga	Show the size of the SGA area of an instance
V$sgastat	Statistical information about SGA usage
V$parameter	Record values for all items in the initialization parameter file
V$lock	Set all information for an object lock by accessing a database session
V$session	There's a conversation message.
V$sql	Log details of SQL statements
V$sqltext	Record statement information for an SQL statement
V$bgprocess	Show background process information
V$process	Information about the current process

Oracle 11g Architecture-Data dictionary