Oracle system tables and views

1. System tables

The system parameters of the Oracle database are stored in the database and can be queried by the user Sysytem through Sqlplus. 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. Similar to the view or table above, there are many more, located at:

$ORACLE _home/rdbms/admin/catalog. SQL file.

These views or tables can be queried in sqlplus with a SELECT statement.

2. Data dictionary 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 display information about the columns of each database table.

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 system tables and views