Diagnostic and Tuning Tools(4)

TS and Tuning
Instance/database:
v$database
v$instance
v$option
v$parameter
v$backup
v$px_process_sysstat
v$process
v$waitstat
v$system_event
Disk:
v$datafile
v$filestat
v$log
v$log_history
v$dbfile
v$tempfile
v$tempstat
v$segment_statistics

Contention:
v$lock
v$rollname
v$rollstat
v$waitstat
v$latch
Memory:
v$buffer_pool_statistics
v$db_object_cache
v$librarycache
v$rowcache
v$sysstat
v$sgastat


User/Session
v$lock
v$open_cursor
v$process
v$transaction
v$px_sesstat
v$px_session
v$sesstat
v$session_event
v$sort_usage
v$session_wait
v$session
v$session_object_cache


每一个资深DBA手头都有一大堆脚本，都对这些了如指掌，也就是有自己的工具箱。


Level of Statics Collection
The initialization parameters that determine the level of statistic collection are:
1.STATISTICS_LEVEL
2.TIMED_STATISTICS
3.TIMED_OS_STATISTICS
4.DB_CACHE_ADVICE