Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Home
Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients

 

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

Inside the DBA_HIST Views

dba_hist_latch                                                                 

dba_hist_dlm_misc                                                              

dba_hist_latch_children                                                        

dba_hist_cr_block_server                                                       

dba_hist_latch_parent                                                          

dba_hist_current_block_server                                                  

dba_hist_latch_misses_summary                                                  

dba_hist_class_cache_transfer                                                  

dba_hist_librarycache                                                          

dba_hist_active_sess_history                                                   

dba_hist_db_cache_advice                                                       

dba_hist_tablespace_stat                                                       

dba_hist_buffer_pool_stat                                                      

dba_hist_log                                                                   

dba_hist_rowcache_summary                                                      

dba_hist_mttr_target_advice                                                     

dba_hist_sga                                                                   

dba_hist_tbspc_space_usage                                                     

dba_hist_sgastat                                                               

dba_hist_service_name                                                          

dba_hist_pgastat                                                               

dba_hist_service_stat                                                          

dba_hist_resource_limit                                                        

dba_hist_service_wait_class                                                    

dba_hist_shared_pool_advice                                                    

dba_high_water_mark_statistics                                                 

Table 4.12 - dba_hist views

These views are fully documented in the Oracle Database 10g Reference Manual. The following sections will focus more on the dba_hist views for time-series and exception reporting and related reports.


The above text is an excerpt from:

Easy Oracle Automation
Oracle10g Automatic Storage, Memory and Diagnostic Features

ISBN 0-9745993-6-0

by Dr. Arun Kumar R.
 


Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

 
 
 

Oracle performance tuning book

 

 

Oracle performance tuning software

 
Oracle performance tuning software
 
Oracle performance Tuning 10g reference poster
 
Oracle training in Linux commands
 
Oracle training Excel
 
 
 
 

 

email BC:


Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.