DBA HIST Views


Describe of all DBA_HIST views 11.2.0.1
    https://sites.google.com/site/oraclemonitor/dba-hist-desc-all

related: monitoring I/O with metrics and ASH

related: putting queries together

real time:  real time

                                                               
DBA_HIST_ACTIVE_SESS_HISTORY
DBA_HIST_ASH_SNAPSHOT                                                          
DBA_HIST_BASELINE                                                              
DBA_HIST_BASELINE_DETAILS                                                      
DBA_HIST_BASELINE_METADATA                                                     
DBA_HIST_BASELINE_TEMPLATE                                                     
DBA_HIST_BG_EVENT_SUMMARY                                                      
DBA_HIST_BUFFERED_QUEUES                                                       
DBA_HIST_BUFFERED_SUBSCRIBERS                                                  
DBA_HIST_BUFFER_POOL_STAT                                                      
DBA_HIST_CLUSTER_INTERCON                                                      
DBA_HIST_COLORED_SQL                                                           
DBA_HIST_COMP_IOSTAT                                                           
DBA_HIST_CR_BLOCK_SERVER                                                       
DBA_HIST_CURRENT_BLOCK_SERVER                                                  
DBA_HIST_DATABASE_INSTANCE                                                     
DBA_HIST_DATAFILE                                                              
DBA_HIST_DB_CACHE_ADVICE                                                       
DBA_HIST_DISPATCHER                                                            
DBA_HIST_DLM_MISC                                                              
DBA_HIST_DYN_REMASTER_STATS                                                    
DBA_HIST_ENQUEUE_STAT                                                          
DBA_HIST_EVENT_HISTOGRAM         -- histograms                                               
DBA_HIST_EVENT_NAME                                                            
DBA_HIST_FILEMETRIC_HISTORY              - alerts?                                           
DBA_HIST_FILESTATXS                                                            
DBA_HIST_IC_CLIENT_STATS                                                       
DBA_HIST_IC_DEVICE_STATS                                                       
DBA_HIST_INSTANCE_RECOVERY                                                     
DBA_HIST_INST_CACHE_TRANSFER                                                   
DBA_HIST_INTERCONNECT_PINGS                                                    
DBA_HIST_IOSTAT_DETAIL                                                         
DBA_HIST_IOSTAT_FILETYPE                                                       
DBA_HIST_IOSTAT_FILETYPE_NAME                                                  
DBA_HIST_IOSTAT_FUNCTION                                                       
DBA_HIST_IOSTAT_FUNCTION_NAME                                                  
DBA_HIST_JAVA_POOL_ADVICE                                                      
DBA_HIST_LATCH                                                                 
DBA_HIST_LATCH_CHILDREN                                                        
DBA_HIST_LATCH_MISSES_SUMMARY                                                  
DBA_HIST_LATCH_NAME                                                            
DBA_HIST_LATCH_PARENT                                                          
DBA_HIST_LIBRARYCACHE                                                          
DBA_HIST_LOG                                                                   
DBA_HIST_MEMORY_RESIZE_OPS                                                     
DBA_HIST_MEMORY_TARGET_ADVICE                                                  
DBA_HIST_MEM_DYNAMIC_COMP                                                      
DBA_HIST_METRIC_NAME                                                           
DBA_HIST_MTTR_TARGET_ADVICE                                                    
DBA_HIST_MUTEX_SLEEP                                                           
DBA_HIST_OPTIMIZER_ENV                                                         
DBA_HIST_OSSTAT                                                                
DBA_HIST_OSSTAT_NAME                                                           
DBA_HIST_PARAMETER                                                             
DBA_HIST_PARAMETER_NAME                                                        
DBA_HIST_PERSISTENT_QUEUES                                                     
DBA_HIST_PERSISTENT_SUBS                                                       
DBA_HIST_PGASTAT                                                               
DBA_HIST_PGA_TARGET_ADVICE                                                     
DBA_HIST_PLAN_OPERATION_NAME                                                   
DBA_HIST_PLAN_OPTION_NAME                                                      
DBA_HIST_PROCESS_MEM_SUMMARY                                                   
DBA_HIST_RESOURCE_LIMIT                                                        
DBA_HIST_ROWCACHE_SUMMARY                                                      
DBA_HIST_RSRC_CONSUMER_GROUP                                                   
DBA_HIST_RSRC_PLAN                                                             
DBA_HIST_RULE_SET                                                              
DBA_HIST_SEG_STAT                                                              
DBA_HIST_SEG_STAT_OBJ                                                          
DBA_HIST_SERVICE_NAME                                                          
DBA_HIST_SERVICE_STAT                                                          
DBA_HIST_SERVICE_WAIT_CLASS                                                    
DBA_HIST_SESSMETRIC_HISTORY             - alerts?     , pretty much worthless unless interesting alerts set                                       
DBA_HIST_SESS_TIME_STATS                      - ??? doesn't look that intersting                                   
DBA_HIST_SGA                                                                   
DBA_HIST_SGASTAT                                                               
DBA_HIST_SGA_TARGET_ADVICE                                                     
DBA_HIST_SHARED_POOL_ADVICE                                                    
DBA_HIST_SHARED_SERVER_SUMMARY                                                 
DBA_HIST_SNAPSHOT                                                              
DBA_HIST_SNAP_ERROR                                                            
DBA_HIST_SQLBIND                                                               
DBA_HIST_SQLCOMMAND_NAME                                                       
DBA_HIST_SQLSTAT                                                               
DBA_HIST_SQLTEXT                                                               
DBA_HIST_SQL_BIND_METADATA                                                     
DBA_HIST_SQL_PLAN                                                              
DBA_HIST_SQL_SUMMARY                                                           
DBA_HIST_SQL_WORKAREA_HSTGRM  
   - low opt sz, high opt sz, opt execs, one  pass exexs, multi pass execs
DBA_HIST_STAT_NAME                                                             
DBA_HIST_STREAMS_APPLY_SUM                                                     
DBA_HIST_STREAMS_CAPTURE                                                       
DBA_HIST_STREAMS_POOL_ADVICE                                                   
DBA_HIST_SYSMETRIC_HISTORY           - alerts?                                              
DBA_HIST_SYSMETRIC_SUMMARY                                                     
DBA_HIST_SYSSTAT                                                               
DBA_HIST_SYSTEM_EVENT                                                          
DBA_HIST_SYS_TIME_MODEL                                                        
DBA_HIST_TABLESPACE_STAT                                                       
DBA_HIST_TBSPC_SPACE_USAGE                                                     
DBA_HIST_TEMPFILE                                                              
DBA_HIST_TEMPSTATXS                                                            
DBA_HIST_THREAD                                                                
DBA_HIST_TOPLEVELCALL_NAME                                                     
DBA_HIST_UNDOSTAT                                                              
DBA_HIST_WAITCLASSMET_HISTORY   - alerts?                                                
DBA_HIST_WAITSTAT                                                              
DBA_HIST_WR_CONTROL                                                            

other: jobs
          rman monitoring
          metrics and load current