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
,