Free Oracle Tips   HTML Text AOL

Free Oracle App Server Tips   HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

Remote Oracle

Custom Oracle Training

Oracle Tips by Burleson

Easy Oracle Automation
Chapter 4 - Automatic Workload Repository and Automatic Database Diagnostic Monitor

The AWR and ASH Wait Event Tables

• wrh$_event_name
   

• wrh$_metric_name
   

• wrh$_sessmetric_history
   

• wrh$_sys_time_model
   

• wrh$_sys_time_model_bl
   

• wrh$_sysmetric_history
   

• wrh$_sysmetric_summary
   

• wrh$_sysstat                                                  
   

• wrh$_sysstat_bl
   

• wrh$_system_event                                       
   

• wrh$_system_event_bl
   

• wrh$_waitclassmetric_history        
   

• wrh$_waitstat
   

• wrh$_waitstat_bl

The dba_hist views will be examined next as they are used to create time-series performance reports.  The next section will begin with an overview of the dba_hist views, as they are used to create time-series performance reports. Examples of custom Oracle Database 10g performance exception reports will be given that can be generated from these views.

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA