ORACLE common views and table collation
The beginning of v$
V$database database information
V$datafile data file information
V$controlfile control file information
V$logfile redo log information
V$instance database instance information
V$log 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 controls the information recorded in each part of the file
V$thread thread information
Information recorded in the header of the v$datafile_header data file
V$archived_log archive log information
Setting information of v$archive_dest archive log
DML DDL result information of v$logmnr_contents archive log analysis
Dictionary file information for v$logmnr_dictionary log analysis
Log list information for v$logmnr_logs log analysis
V$tablespace tablespace information
V$tempfile temporary file information
IUnip O statistics for v$filestat data files
V$undostat Undo data information
V$rollname online rollback segment information
V$session session Information
V$transaction transaction information
V$rollstat rollback segment statistics
V$pwfile_users privileged user Information
Resources and related information accessed by sql statements currently queried by v$sqlarea
V$sql and v$sqlarea have basically the same relevant information.
V$sysstat database system status information
The beginning of all_
Information of all users in the all_users database
Information about all objects in the all_objects database
All default audit settings information for all_def_audit_opts
All the table object information of all_tables
Information about all database object indexes in all_indexes
The beginning of session_
Role information for session_roles session
Permission information for session_privs session
The beginning of index_
Setting up and storing information of index_stats index
Pseudo table
Pseudo-list information of dual system
The beginning of dba_
Dba_users database user information
Dba_segments segment information
Dba_extents datazone 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
Dba_rollback_segs rollback segment information
Dba_ts_quotas user tablespace quota information
Dba_free_space database free space information
Dba_profiles database user resource limit information
System permission information of dba_sys_privs user
Object permission information for dba_tab_privs users
Column object permission information for dba_col_privs users
Role information for dba_role_privs users
Dba_audit_trail audit trail record information
Dba_stmt_audit_opts Audit Settings Information
Dba_audit_object object audit result information
Dba_audit_session session audit result information
Index information for dba_indexes user mode
The beginning of user_
User_objects user object Information
All resource object information for user_source database users
Table segment information of user_segments user
Table object information for user_tables users
Table column information for user_tab_columns users
Two other common examples involved in this are as follows:
1. Query which table a field belongs to in oracle
Sql code
Select table_name,owner from dba_tab_columns t where t.COLUMN_NAME like upper ('% username%')
2. Query the number of columns of a table in oracle
Sql code
Select count (*) from user_tab_columns where table_name= upper ('sys_operate')
Note: the function upper is used in both examples because the table name has to be capitalized here, otherwise the result is not correct.
Object constraint information for user_constraints users
System permission information of the current user of user_sys_privs
Object permission information for the current user of user_tab_privs
Table column permission information for the current user of user_col_privs
Role permission information of the current user in user_role_privs
Index information of user_indexes user
Table column information corresponding to the index of the user_ind_columns user
Table column information corresponding to the constraints of user_cons_columns users
All cluster information of user_clusters users
Content information contained in the cluster of user_clu_columns users
Information about user_cluster_hash_expressions hash clusters
The 9 most important dynamic performance views of oracle
V$session + v$session_wait (functions are integrated in 10g, make do with one.)
V$process
V$sql
V$sqltext
V$bh (rather x$bh)
V$lock
V$latch_children
V$sysstat
V$system_event
Several sets of important performance views by component
Over view of System
V$sysstat, v$system_event, v$parameter
The current situation of a session
V$process, v$session, v$session_wait, v$session_event, v$sesstat
The situation of SQL
V$sql, v$sqlarea, v$SQL_PLAN, V$SQL_PLAN_STATISTICS, v$sqltext_with_newlines
Latch / lock / ENQUEUE
V$latch, v$latch_children, v$latch_holder, v$lock, V$ENQUEUE_STAT, V$ENQUEUE_LOCK
IO
V$segstat, v$filestat, v$tempstat, v$datafile, v$tempfile
Shared pool / Library cache
V$Librarycache, v$rowcache, x$ksmsp
A few advice is also good.
V$db_cache_advice, v$PGA_TARGET_ADVICE, v$SHARED_POOL_ADVICE
