Common DBA tables and views in Oracle Database

Technorati label: Oracle

Start with DBA _
Dba_usersDatabaseUser 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
Dba_temp_files temporary data file information
Dba_rollback_segs rollback segment information
Dba_ts_quotas user tablespace quota Information
Dba_free_space idle space information of the database
Dba_profiles database user resource limit information
Dba_sys_privs user's system permission information
Dba_tab_privs object permission information
Column object permission information of dba_col_privs users
Dba_role_privs user's role information
Dba_audit_trail audit trail record information
Dba_stmt_audit_opts audit settings
Dba_audit_object audit result information
Dba_audit_session audit result information
Index information of dba_indexes user mode
Start with user _
User_objects user object information
User_source information of all resource objects of database users
User_segments user's table segment information
User_tables user's table Object Information
Table column information of user_tab_columns
User_constraints object constraint information
User_sys_privs system permission information of the current user
User_tab_privs object permission information of the current user
User_col_privs table column permission information of the current user
User_role_privs role permission information of the current user
User_indexes user index information
Table column information corresponding to the index of user_ind_columns
Table column information corresponding to the constraints of the user_cons_columns user
User_clusters all cluster information of the user
Content of the user_clu_columns user's cluster
User_cluster_hash_expressions information of the hash Cluster
Starting with V $
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
V $ SGA database SGA Information
V $ parameter initialization parameter information
V $ process database server process information
V $ bgprocess background process information of the database
V $ controlfile_record_section information of each part of the control file
V $ thread Information
V $ datafile_header information recorded in the Data File Header
V $ archived_log archive log information
V $ archive_dest configuration information for archiving logs
V $ dml ddl result information of logmnr_contents archive log analysis
V $ dictionary file information of logmnr_dictionary Log Analysis
V $ logmnr_logs log list information for 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 $ sqlareaSQLResources accessed by statements and related information
V $ SQL and V $ sqlarea are basically the same related information.
V $ sysstat database system status information
Start with all _
Information of all users in the all_users Database
Information of all objects in the all_objects Database
All_def_audit_opts all default audit settings
All table objects in all_tables
All_indexes information of all database object Indexes
Start with Session _
Session_roles session role information
Session_privs session permission information
Start with index _
Index_stats index settings and storage Information
Pseudo table
Dual System pseudo list information

OracleThe nine most important dynamic performance views
V $ session + V $ session_wait (functions are integrated in 10 Gb, so we can calculate one .)
V $ Process
V $ SQL
V $ sqltext
V $ BH (prefer x $ BH)
V $ lock
V $ latch_children
V $ sysstat
V $ system_event
Important performance views by group

1. Over view of system
V $ sysstat, V $ system_event, V $ Parameter

2. 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/enqueue
V $ latch, V $ latch_children, V $ latch_holder, V $ lock, V $ enqueue_stat, V $ enqueue_lock

4. Io
V $ segstat, V $ filestat, V $ tempstat, V $ datafile, V $ tempfile

5. Shared Pool/library Cache
V $ librarycache, V $ rowcache, x $ ksmsp

6. A few advice are also good
V $ db_cache_advice, V $ pga_target_advice, V $ shared_pool_advice