Analysis of Common tables and views starting with dba _, user _, v $ _, all _, session _, and index _ in oracle

Dba_users Database user Information dba_segments table segment information dba_extents data zone starting with dba _, user _, v $ _, all _, session _, and index _ in oracle information dba_objects database object information dba_tablespaces database tablespace information dba_data_files Data File Settings information dba_temp_files temporary data file information rollback segment information user tablespace quota information dba_free_space database idle space information dba_profiles database user resource limit information dba_sys_privs user's system permission information dba_tab_privs user's object permission information dba_col_privs user's column object permission information; user's role information dba_audit_trail audit trace information audit settings information dba_audit_object audit results information dba_audit_session audit result information dba_indexes user mode index information starting with user _ www.2cto.com user_objects user object information user_source database user's all resource Object Information user_segments user's table segment information user_tables user's table Object Information the table column information of user_tab_columns also involves two common examples: 1. query which table SQL code select table_name, owner from dba_tab_columns t where t for a field in oracle. COLUMN_NAME like upper ('% username %'); select table_name, owner from dba_tab_columns t where t. COLUMN_NAME like upper ('% username %'); 2. query the number of columns in a table in oracle: www.2cto.com SQL code select count (*) from user_tab_columns where table_name = upper ('sys _ operate'); select count (*) from user_tab_columns where table_name = upper ('sys _ operate'); note: the upper function is used in both examples because the table name must be capitalized, otherwise, the result is incorrect. 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 permission information user_role_privs current user's role permission information 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 content information user_cluster_hash_expressions hash Column cluster information 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 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 recorded in the control file each part of the information is www.2cto.com v $ thread information v $ information recorded in the datafile_header data file header v $ archived_log archiving log information v $ archive_dest archiving log setting information v $ logmnr_contents archiving log analysis DML DDL result information v $ dictionary file information for logmnr_dictionary Log Analysis v $ log list information for logmnr_logs Log Analysis 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 statistics v $ pwfile_users privileged user information v $ sqlarea resources accessed by the currently queried SQL statements and related information v $ SQL and v $ sqlarea are basically the same related information v $ sysstat database system status information all _ all_users all user information all_objects all objects information all_def_audit_opts all default audit settings information all_tables all table Object Information all_indexes all database object index information session _ start session_roles session role information session_privs session permission information index _ start with index_stats index settings and storage Information pseudo table www.2cto.com dual system pseudo list information nine most important dynamic performance views of oracle v $ session + v $ session_wait (functions are integrated in 10 Gb, calculate one .) v $ processv $ sqlv $ sqltextv $ bh (prefer x $ bh) v $ lockv $ latch_childrenv $ sysstatv $ system_event depends on the group of important performance views 1. system over viewv $ sysstat, v $ system_event, v $ parameter 2. the current situation of a session v $ process, v $ session, v $ session_wait, v $ session_event, v $ sesstat 3. SQL v $ SQL, v $ sqlarea, v $ SQL _PLAN, V $ SQL _PLAN_STATISTICS, v $ sqltext_with_newlines 3. latch/lock/ENQUEUEv $ latch, v $ latch_children, v $ latch_holder, v $ lock, V $ ENQUEUE_STAT, V $ ENQUEUE_LOCK www.2cto.com 4. IO v $ segstat, v $ filestat, v $ tempstat, v $ datafile, v $ tempfile 5. shared pool/Library cacev $ Librarycache, v $ rowcache, x $ ksmsp 6. several advice are also good v $ db_cache_advice, v $ PGA_TARGET_ADVICE, v $ SHARED_POOL_ADVICE author hope Zhidong