Major ORACLE system tables and data dictionary views

Document directory

• Tables and columns
• Integrity constraints
• View
• Sequence
• Synonym
• Index
• User
• Role
• Tablespace quota
• Configuration table
• Tablespace
• Data Files
• Segment
• Rollback segment

1. System Table

System Parameters of the ORACLE database are stored in the database. You can use SQLPLUS to query the system parameters in SYSYTEM. Several important tables orViewAs follows:

V $ controlfile: control file information;
V $ datafile: data file information;
V $ log: log File Information;
V $ process: processor information;
V $ session: session information;
V $ transaction: transaction information;
V $ resource: resource information;
V $ sga: information about the global zone of the system.

The 'v $ 'in the view name above is only a character in the view name. Similar to the preceding view or table, there are still many, located:
$ ORACLE_HOME/RDBMS/ADMIN/CATALOG. SQL file.

These views or tables can be queried using the SELECT statement in SQLPLUS.

2. Data Dictionary view charts and columns

DBA_TABLES, ALL_TABLES, and USER_TABLES display general information about database tables.

DBA_TAB_COLUMNS, ALL_TAB_COLUMNS, and USER_TAB_COLUMNS display the column information of each database table.

Note: DBA_OBJECTS, ALL_OBJECTS, and USER_OBJECTS display the information of the mode 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 column-related constraints.

View

DBA_VIEWS, ALL_VIEWS, and USER_VIEWS.

Note: DBA_OBJECTS, ALL_OBJECTS, and USER_OBJECTS display the information of the mode object, including the view.

Sequence

DBA_SEQUENCES, ALL_SEQUENCES, and USER_SEQUENCES.

Note: DBA_OBJECTS, ALL_OBJECTS, and USER_OBJECTS display the information of the mode object, including the sequence.

Synonym

DBA_SYNONYMS, ALL_SYNONYMS, and USER_SYNONYMS.

Note: DBA_OBJECTS, ALL_OBJECTS, and USER_OBJECTS display the information of the mode 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.

Tablespace quota

DBA_TS_QUOTAS.

Configuration table

DBA_PROFILES.

Tablespace

DBA_TABLESPACES.

Data Files

DBA_DATA_FILES.

Segment

DBA_SEGMENTS and USER_SEGMENT.

Rollback segment

DBA_ROLLBACK_SEGS, V $ ROLLNAME, and V $ ROLLSTAT.