Oracle中常用动态视图

oracle哪些动态性能视图是必须掌握的？

会话类：v$session v$process

SQL类：v$sql v$sqlarea

等待类：v$session_wait，v$system_event

锁：v$locked_objects

备份类：v$rman*

热点：v$bh

基本是所有视图我觉得都应该掌握，如果根据常用的，先参考如上所列吧。

以下视图都可以了解下：

1.DBA_OBJECTS

2.DBA_TABLES

3.DBA_SEGMENTS

4.DBA_TAB_COLUMNS

5.DBA_INDEXES

6.DBA_IND_COLUMNS

7.DBA_CONSTRAINTS

8.DBA_VIEWS

9.DBA_SYNONYMS

10.DBA_PROCEDURES

11.DBA_SOURCE

12.DBA_DEPENDENCIES

13.V$SYSSTAT

14.V$SYSTEM_EVENT

15.V$SEGMENT_STATISTICS

16.V$SQL

17.v$database

18.v$instance

19.v$sysmetric_summary

20.v$session

21.v$process

22.v$transaction

23.v$lock

24.v$session_longops

25.v$session_event

26.v$active_session_history

27.dba_hist_active_sess_history

28.dba_hist_sqlstat

29.dba_hist_sql_plan

30.v$sqlarea

31.v$sqltext

32.DBA_HIST_SNAPSHOT

33.DBA_HIST_SEG_STAT

34.DBA_HIST_SYSTEM_EVENT

35.DBA_HIST_SYSSTAT