Oracle Database-related data dictionary for performance problem analysis, oracle-related data
The nine most important dynamic performance views of oracle!
V $ session + v $ session_wait
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. System over view
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