What are common Oracle tables and views?

We all know that the system parameters related to the Oracle database are stored in the Oracle database. We can use SQLPLUS to query with user sytem. The following articles describe Oracle tables and related views that we often use.

1. Several important Oracle tables or views are as 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 Oracle tables can be queried using the SELECT statement in SQLPLUS.

2. Data Dictionary View

Tables 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 information about schema objects, including Oracle tables.

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.

Configure an Oracle table

DBA_PROFILES.

Tablespace

DBA_TABLESPACES.

Data Files

DBA_DATA_FILES.

Segment

DBA_SEGMENTS and USER_SEGMENT.

Rollback segment

DBA_ROLLBACK_SEGS, V $ ROLLNAME, V $ ROLLSTAT

The above content describes the Oracle tables and related views that we often use. We hope to help you in this regard.