Oracle's primary system tables and system views

ORACLEprimary system tables and system views 1.system Tables 

ORACLEthe system parameters of the database are stored in the database and can beSQLPLUS, to the userSYSto query. A few important tables or views are as follows:V$controlfile: Control the information of the file;V$datafile: Information of data files;V$log: Log file information;v$process: information about the processor;v$session: Session information;v$transaction: Transaction information;V$resource: resource information;V$SGA: Information for the system global zone.  

The 'v$' in the view name above is just the character in the view name. There are many more, similar to the view or table above, located in: $ORACLE _home/rdbms/admin/catalog. SQL file. These views or tables can be queried in SQLPLUS with a SELECT statement.  

2. Data dictionary View 

Sys User, in the View view.

Tables and columns 

Dba_tables,all_tables , and user_tables Show general information about database tables. dba_tab_columns,all_tab_columns and user_tab_columns Displays information about the columns for each database table.  

user_tab_comments Table Comment user_col_comments column comment

Note:dba_objects,all_objects , and user_objects Display information about the schema object, including the table.  

Integrity constraints

Dba_constraints,all_constraints , and user_constrainst Display general information about constraints.  

Dba_cons_columns,all_cons_columns , and user_cons_columns Display general information about the related constraints of the column.  

View 

Dba_views,all_views and user_views.  

Note:dba_objects,all_objects , and user_objects Display information about the schema object, including the view.  

Sequence

Dba_sequences,all_sequences and user_sequences.  

Note:dba_objects,all_objects , and user_objects Display information about the schema object, including the sequence.  

Synonyms 

Dba_synonyms,all_synonyms and user_synonyms.  

Note:dba_objects,all_objects , and user_objects Display information about the schema object, including synonyms.  

Index 

Dba_indexs,all_indexs,user_indexs,dba_ind_columns, all_ind_columns and user_ind_columns.  

User 

Dba_users.  

Role 

Dba_roles.  

Table Space Quotas 

Dba_ts_quotas.  

Configuration table 

Dba_profiles.  

Table Space 

Dba_tablespaces.  

Data files 

Dba_data_files.  

Paragraph 

Dba_segments,user_segment.  

Rollback segment

Dba_rollback_segs,v$rollname,v$rollstat.

Oracle's primary system tables and system views