DBA_
2012.02.16 13:30

DBA HIST Views - 11.2.0.1

댓글 0조회 수 28281
?

단축키

이전 문서

다음 문서

+ - Up Down Comment Print
?

단축키

이전 문서

다음 문서

+ - Up Down Comment Print
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
                                                               
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                                                       
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                                                            



번호 분류 제목 글쓴이 날짜
9 PRACTICE SQL*Plus에서 &(Ampersand)/특수문자/Escape 사용법  secret 김형조 2013.09.27
8 FUNCTIONS 함수목록   김형조 2012.02.21
» DBA_ DBA HIST Views - 11.2.0.1   김형조 2012.02.16
6 PRACTICE Not Exists 를 이용한 차집합 데이터 Insert   관리자 2012.02.12
5 PRACTICE 열->행 변환 사례 3   관리자 2012.02.12
4 PRACTICE WMSYS.WM_CONCAT vs ListAgg [1]   관리자 2012.02.12
3 PRACTICE 오라클 여러 행을 1개의 문자열로 SELECT   관리자 2012.02.12
2 PRACTICE 행 -> 열 변환 사례 2   관리자 2012.02.12
1 PRACTICE 열->행 변환 사례 1   관리자 2012.02.12
Board Pagination ‹ Prev 1 Next ›
/ 1
Designed by hikaru100

나눔글꼴 설치 안내


이 PC에는 나눔글꼴이 설치되어 있지 않습니다.

이 사이트를 나눔글꼴로 보기 위해서는
나눔글꼴을 설치해야 합니다.

설치 취소

SketchBook5,스케치북5

SketchBook5,스케치북5

SketchBook5,스케치북5

SketchBook5,스케치북5

O R A C L E L A B 로그인 :)