Use oracle System tables to eliminate inefficient graphical interfaces

Use the oracle system table to get rid of the inefficient graphical interface 1. The system table system parameters of the ORACLE database are stored in the database. You can use SQLPLUS to perform queries using the user SYSYTEM. Several important tables or views are as follows: www.2cto.com 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 in 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 many other views and tables in the $ ORACLE_HOME/RDBMS/ADMIN/CATALOG. SQL file. These views or tables can be queried using the SELECT statement in SQLPLUS. 2. The data dictionary view shows general information about database tables in www.2cto.com tables and columns DBA_TABLES, ALL_TABLES, and USER_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. 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. Synonyms: 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. Table space quota DBA_TS_QUOTAS. Configure DBA_PROFILES. Table space DBA_TABLESPACES. Data File DBA_DATA_FILES. DBA_SEGMENTS and USER_SEGMENT. Www.2cto.com: DBA_ROLLBACK_SEGS, V $ ROLLNAME, and V $ ROLLSTAT. Appendix: Start With dba ..... dba_users Database User Information dba_segments table segment information dba_extents data zone information dba_objects database object information dba_tablespaces database tablespace information dba_data_files Data File Settings information temporary data file information rollback segment information manual user tablespace quota Information dba_free_space idle space information dba_profiles database user resource restriction information dba_sys_privs user's system permission information dba_tab_privs user's object permission information column object permission information user's role information dba_audit_trail Audit tracking record information audit settings information dba_audit_object Object audit result information dba_audit_session session audit result information dba_indexes user mode index information user_start user_objects user object information user_source database user all resource Object Information user_segments user table segment information user_tables User table Object Information user_tab_columns user's table column information user_constraints user's object constraint information user_sys_privs current user's system permission information user_tab_privs current user's object permission information user_col_privs current user's table column list permission information user_role_privs current user's role permission information user_indexes user's index information user_ind_columns user's index corresponding table column information user_cons_columns user's constraint corresponding table column information user_clusters user's all cluster information user_clu_columns user's cluster information information contained in the user_cluster_hash_expressions hash cluster v $ start with v $ database information v $ datafile data file information v $ controlfile Control File Information v $ logfile redo log information v $ instance database instance information v $ log group information v $ loghist log history information www.2cto.com v $ sga database SGA information v $ parameter initialization parameter information v $ process database server process information v $ bgprocess database background process Information v $ controlfile_record_section information of each part in the control file v $ thread information v $ information recorded in the datafile_header data file header v $ archived_log archive log information v $ archive_dest setting information v $ dml ddl result information of logmnr_contents archive log analysis v $ dictionary file information of logmnr_dictionary Log Analysis v $ logmnr_logs log analysis log list information v $ tablespace information v $ tempfile temporary file information v $ filestat data file I/O statistics v $ undostat Undo data information v $ rollname online rollback segment information v $ session information v $ transaction information v $ rollstat rollback segment statistical information v $ pwfile_users privileged user information v $ sqlarea resources accessed by the currently queried SQL statements and related information v $ SQL and v $ sqlarea have basically the same related information v $ sysstat database system status information all _ start all_users database all user information all_objects database all object information all_def_audit_opts all default audit settings information all_tables all table Object Information all_indexes all database object Indexes session _ start with session_roles session role information session_privs session permission information index _ start with index_stats index settings and storage Information pseudo table dual system pseudo list information