V$SESSION + V$SESSION_WAIT (10g 已整合)V$PROCESSV$SQLV$SQLTEXT / V$SQLTEXT_WITH_NEWLINESV$BH (偏好 X$BH)V$LOCKV$LATCH_CHILDRENV$SYSSTATV$SYSTEM_EVENT| 場景 | 核心視圖 |
|---|---|
| 系統全局概覽 | V$SYSSTAT, V$SYSTEM_EVENT, V$PARAMETER |
| 單 Session 即時狀態 | V$PROCESS, V$SESSION, V$SESSION_WAIT, V$SESSION_EVENT, V$SESSTAT |
| 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 |
| I/O 分析 | V$SEGSTAT, V$FILESTAT, V$TEMPSTAT, V$DATAFILE, V$TEMPFILE |
| Shared Pool / Library Cache | V$LIBRARYCACHE, V$ROWCACHE, X$KSMSS |
| Advisor 建議 | V$DB_CACHE_ADVICE, V$PGA_TARGET_ADVICE, V$SHARED_POOL_ADVICE |
熟練掌握這組視圖,覆蓋 90%+ 性能診斷場景。