Diagnostic and Tuning Tools(3)

statspack报告，对数据库做一次全面的体检。
参考书：《Oracle database 10g performance tuning tips & techniques 》
《Your Performing toolkit》 TOM大师


DD and Special Views


dba_tables,dba_tab_columns
dba_clusters
dba_indexes,index_stats
index_histogram,dba_tab_histograms


This statistical information is static until you reexecute dbms_stats.
重新执行一次这个包，这些信息才会改变。


Systemwide Statistics全局性的信息
v$sysstat,v$sgastat,v$event_name,v$system_event


Session-Related Statistics会话级别的信息
v$statname,v$sesstat,v$session
v$session_event,v$event_name,v$session_wait;


实验：
conn hr/hr
select sid,serial#,username from v$session
desc v$sesstat
select * from v$sesstat where sid=12;
统计指标是164，VALUE是6，什么含义呢？就查询v$statname了。


Oracle Wait Events
等待资源。
v$event_name
v$session_event:Waits for an event for each session that had to wait.
v$session_wait:Waits for an event for current active sessions that are waiting.
v$system_event:Total waits for an event,all sessions together.