Oracle System Table knowledge

Source: Internet
Author: User
System Parameters of the Oracle database are stored in the database. You can use SQLPLUS to query the system parameters in SYSYTEM. 1. Several important tables or views are as follows:

System Parameters of the Oracle database are stored in the database. You can use SQLPLUS to query the system parameters in SYSYTEM. 1. Several important tables or views are as follows:

System Parameters of the Oracle database are stored in the database. You can use SQLPLUS to query the system parameters in SYSYTEM.

1. Several important 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 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 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, V $ ROLLSTAT

,

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.