CodePudding user response:
Give you add:- the DBA/ALL/USER/V_ $/GV_ $/SESSION/INDEX at the beginning of the vast majority view is
- DBA_TABLES for dbas have or can access all the relational tables,
- ALL_TABLES means a user has or can access all of the relational tables,
- all USER_TABLES means a user have relational tables,
- when a user for the database itself when the DBA, DBA_TABLES ALL_TABLES equivalent,
- DBA_TABLES & gt;=ALL_TABLES & gt;=USER_TABLES
- it is important to note in the ORACLE database is case sensitive, and the three default data in the table are capitalized, so pay attention to when queried lowercase data may cause can't find,
SELECT * FROM dba_views WHERE view_name LIKE 'DBA %';
SELECT * FROM dba_views WHERE view_name LIKE '%' ALL;
SELECT * FROM dba_views WHERE view_name LIKE 'USER %';
SELECT * FROM dba_views WHERE view_name LIKE 'V_ $%'; - for an instance of view
SELECT * FROM dba_views WHERE view_name LIKE 'GV_ $%'; - a global view, according to multiple instances environment
SELECT * FROM dba_views WHERE view_name LIKE 'SESSION %';
SELECT * FROM dba_views WHERE view_name LIKE 'INDEX %';
SELECT count (1) the FROM dba_tables;
SELECT count (1) the FROM all_tables;
SELECT count (1) the FROM user_tables;
- V $/GV $at the beginning of the vast majority are V_ $/GV_ $table alias
SELECT * FROM dba_synonyms WHERE synonym_name LIKE 'V $%';
SELECT * FROM dba_synonyms WHERE synonym_name LIKE 'GV $%';
- X $no corresponding X_ $
SELECT * FROM dba_synonyms WHERE synonym_name LIKE 'X $%';
- the DBA that are widely used in the beginning of the view have
Select * from dba_users; Information - the database user
Select * from dba_roles; - role information
Select * from dba_segments; - table segment information
Select * from dba_extents; - data area information
Select * from dba_objects; - a database object information
Select * from dba_lobs; - lob data information
Select * from dba_tablespaces; - the database table space information
Select * from dba_data_files; - data file Settings information
Select * from dba_temp_files; - temporary data file information
Select * from dba_rollback_segs; - rollback segment information
Select * from dba_ts_quotas; - the user table space quota information
Select * from dba_free_space; - a database of free space information
Select * from dba_profiles; Database user resources limit information
Select * from dba_sys_privs; - the user's system access information
Select * from dba_tab_privs; - the user has the object permission information
Select * from dba_col_privs; - the user has a column object permission information
Select * from dba_role_privs; - the user with the role of information
Select * from dba_audit_trail; - audit tracking information
Select * from dba_stmt_audit_opts; - audit Settings information
Select * from dba_audit_object; - object audit results information
Select * from dba_audit_session; - audit results information session
Select * from dba_indexes; - user mode index information
- ALL at the beginning of the view that are widely used in the
Select * from all_users; - a database of all users information
Select * from all_objects; All the object - database information
Select * from all_def_audit_opts; - all the default audit setting information
Select * from all_tables; - all the table object information
Select * from all_indexes; - all database objects indexed information
Select * from all_tab_comments; - query all users table, view, etc.
Select * from all_col_comments; - query all users table column name and comments.
Select * from all_tab_columns; - information such as the table column name query all users (but not in detail note)
- ALL at the beginning of the view that are widely used in the
Select * from user_objects; - the user object information
Select * from user_source; - all the resources database user object information
Select * from user_segments; - table of user information
Select * from user_tables; - the user table object information
Select * from user_tab_columns; - the user table column information
Select * from user_constraints; - the user object constraint information
Select * from user_sys_privs; - the current user's system access information
Select * from user_tab_privs; - the current user object permission information
Select * from user_col_privs; - the current user's table column permission information
Select * from user_col_comments; - this user's query table column name and comments
Select * from user_role_privs; - the role of the current user permission information
Select * from user_indexes; - the user's index information
Select * from user_ind_columns; - the user the index of the corresponding table column information
Select * from user_cons_columns; - the user the constraints of the corresponding table column information
Select * from user_clusters; - all of the user's cluster information
Select * from user_clu_columns; - user cluster contains content information
Select * from user_cluster_hash_expressions; - a hash cluster information
- V $which are frequently used at the beginning of alias has
Select * from v $database; - the database information
Select * from v $datafile; - data file information
Select * from v $controlfile; - the control file information
Select * from v $logfile; - redo log information
Select * from v $instance; - the database instance information
Select * from v $log; - log group information
Select * from v $loghist; - log history information
Select * from v $sga; SGA - database information
Select * from v $parameter; - initialization parameter information
Select * from v $process; - database server process information
Select * from v $bgprocess; - database background process information
Select * from v $controlfile_record_section; - all the parts of the control file record information
Select * from v $thread; - thread information
Select * from v $datafile_header; - data file header information recorded by
Select * from v $archived_log; - archive log information
Select * from v $archive_dest; - the setting of archive log information
Select * from v $logmnr_contents; - archive log analysis results of the DML DDL information
Select * from v $logmnr_dictionary; - log analysis dictionary file information
Select * from v $logmnr_logs; - the list of log log analysis information
Select * from v $in tablespace; - table space information
Select * from v $tempfile as expected; - the temporary file information
Select * from v $filestat; - data file I/O statistics
Select * from v $undostat; - Undo data information
Select * from v $rollname; - online rollback segment information
Select * from v $session; - session information
Select * from v $transaction; - the transaction information
Select * from v $rollstat; - rollback segment statistics
Select * from v $pwfile_users; - privileged user information
Select * from v $sqlarea; - the current query SQL statements that accessed resources and related information
Select * from v $SQL; - the same as the v $sqlarea basic information
Select * from v $sysstat; State information database system,
- SESSION that are widely used in the beginning of the view have
Select * from session_roles; nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull