ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle 常用性能视图一览表(10g)

Oracle 常用性能视图一览表(10g)

原创 Linux操作系统 作者:beatony 时间:2011-07-29 11:20:50 0 删除 编辑
 

Oracle 常用性能视图一览表(10g)

分类: Oracle 其它特性 15人阅读 评论(0) 收藏 举报
--*************************************
-- Oracle 常用性能视图一览表(10g)

--*************************************


Advisors
    Information related to cache advisors
  1. v$pga_target_advice                      v$shared_pool_advice         
  2. v$pga_target_advice_histogram            v$java_pool_advice           
  3. v$mttr_target_advice                     v$streams_pool_advice(10.2)  
  4. v$px_buffer_advice                       v$sga_target_advice(10.2)    
  5. v$db_cache_advice                        v$advisor_progress(10.2)     
v$pga_target_advice v$shared_pool_advice v$pga_target_advice_histogram v$java_pool_advice v$mttr_target_advice v$streams_pool_advice(10.2) v$px_buffer_advice v$sga_target_advice(10.2) v$db_cache_advice v$advisor_progress(10.2)
/***********************************************************************************************************************/
ASM 
  1. v$asm_alias(10.1)                        v$asm_diskgroup_stat(10.2)  
  2. v$asm_client(10.1)                       v$asm_file(10.1)            
  3. v$asm_disk(10.1)                         v$asm_operation(10.1)       
  4. v$asm_disk_stat(10.2)                    v$asm_template(10.1)        
  5. v$asm_diskgroup(10.1)                                                
v$asm_alias(10.1) v$asm_diskgroup_stat(10.2) v$asm_client(10.1) v$asm_file(10.1) v$asm_disk(10.1) v$asm_operation(10.1) v$asm_disk_stat(10.2) v$asm_template(10.1) v$asm_diskgroup(10.1)
/***********************************************************************************************************************/
Backup/recovery
    Information related to database backups and recovery, including last backup, archive logs,
    state of files for backup, and recovery
  1. v$archive                v$backup_archivelog_details(10.2)                 
  2. v$archived_log                           v$backup_archivelog_summary(10.2)                 
  3. v$archive_dest                           v$backup_controlfile_details(10.2)                
  4. v$archive_dest_status                    v$backup_controlfile_summary(10.2)                
  5. v$archive_gap                            v$backup_copy_details(10.2)                       
  6. v$archive_processes                      v$backup_copy_summary(10.2)                       
  7. v$backup                                 v$backup_files(10.1)                              
  8. v$backup_async_io                        v$backup_piece_details(10.2)                      
  9. v$backup_corruption                      v$backup_set_details(10.2)                        
  10. v$backup_datafile                        v$backup_set_summary(10.2)                        
  11. v$backup_device                          v$backup_spfile                                   
  12. v$backup_piece                           v$backup_spfile_details(10.2)                     
  13. v$backup_redolog                         v$backup_spfile_summary(10.2)                     
  14. v$backup_set                             v$datafile_header                                 
  15. v$backup_sync_io                         v$flash_recovery_area_usage(10.2)                 
  16. v$block_change_tracking                  v$flashback_database_log(10.1)                    
  17. v$copy_corruption                        v$flashback_database_stat(10.1)                   
  18. v$database_block_corruption              v$obsolete_backup_files                           
  19. v$database_incarnation                   v$offline_range                                   
  20. v$datafile_copy                          v$proxy_archivelog_details(10.2)                  
  21. v$deleted_object                         v$proxy_archivelog_summary(10.2)                  
  22. v$fast_start_servers                     v$proxy_copy_details(10.2)                        
  23. v$fast_start_transactions                v$proxy_copy_summary(10.2)                        
  24. v$instance_recovery                      v$recovery_file_dest(10, 1)                       
  25. v$mttr_target_advice                     v$restore_point(10.2)                             
  26. v$proxy_archivedlog                      v$rman_backup_job_details(10.2)                   
  27. v$proxy_datafile                         v$rman_backup_subjob_details(10.2)                
  28. v$rman_configuration                     v$rman_backup_type(10.2)                          
  29. v$recovery_file_status                   v$rman_encryption_algorithms(10.2)                
  30. v$recovery_log               v$rman_output(10.1)                               
  31. v$recovery_progress                      v$rman_status(10.1)                               
  32. v$recovery_status                        v$unusable_backupfile_details(10.2)               
  33. v$recover_file                                                                             
v$archive v$backup_archivelog_details(10.2) v$archived_log v$backup_archivelog_summary(10.2) v$archive_dest v$backup_controlfile_details(10.2) v$archive_dest_status v$backup_controlfile_summary(10.2) v$archive_gap v$backup_copy_details(10.2) v$archive_processes v$backup_copy_summary(10.2) v$backup v$backup_files(10.1) v$backup_async_io v$backup_piece_details(10.2) v$backup_corruption v$backup_set_details(10.2) v$backup_datafile v$backup_set_summary(10.2) v$backup_device v$backup_spfile v$backup_piece v$backup_spfile_details(10.2) v$backup_redolog v$backup_spfile_summary(10.2) v$backup_set v$datafile_header v$backup_sync_io v$flash_recovery_area_usage(10.2) v$block_change_tracking v$flashback_database_log(10.1) v$copy_corruption v$flashback_database_stat(10.1) v$database_block_corruption v$obsolete_backup_files v$database_incarnation v$offline_range v$datafile_copy v$proxy_archivelog_details(10.2) v$deleted_object v$proxy_archivelog_summary(10.2) v$fast_start_servers v$proxy_copy_details(10.2) v$fast_start_transactions v$proxy_copy_summary(10.2) v$instance_recovery v$recovery_file_dest(10, 1) v$mttr_target_advice v$restore_point(10.2) v$proxy_archivedlog v$rman_backup_job_details(10.2) v$proxy_datafile v$rman_backup_subjob_details(10.2) v$rman_configuration v$rman_backup_type(10.2) v$recovery_file_status v$rman_encryption_algorithms(10.2) v$recovery_log v$rman_output(10.1) v$recovery_progress v$rman_status(10.1) v$recovery_status v$unusable_backupfile_details(10.2) v$recover_file
/***********************************************************************************************************************/   
Caches
    Information related to the various caches, including objects, library, cursors, and the dictionary
V$ Views:     
  1. v$access                                v$sga                               
  2. v$buffer_pool                           v$sgastat                           
  3. v$buffer_pool_statistics                v$sga_current_resize_ops            
  4. v$db_cache_advice                       v$sga_dynamic_components            
  5. v$db_object_cache                       v$sga_dynamic_free_memory           
  6. v$java_pool_advice                      v$sga_resize_ops                    
  7. v$librarycache                          v$sgainfo                           
  8. v$library_cache_memory                  v$shared_pool_advice                
  9. v$pgastat                               v$shared_pool_reserved              
  10. v$pga_target_advice                     v$system_cursor_cache               
  11. v$pga_target_advice_histogram           v$subcache                          
  12. v$rowcache                              v$java_library_cache_memory(10.1)   
  13. v$rowcache_parent                       v$process_memory(10.2)              
  14. v$rowcache_subordinate                  v$sga_target_advice(10.2)           
  15. v$session_cursor_cache                                                      
v$access v$sga v$buffer_pool v$sgastat v$buffer_pool_statistics v$sga_current_resize_ops v$db_cache_advice v$sga_dynamic_components v$db_object_cache v$sga_dynamic_free_memory v$java_pool_advice v$sga_resize_ops v$librarycache v$sgainfo v$library_cache_memory v$shared_pool_advice v$pgastat v$shared_pool_reserved v$pga_target_advice v$system_cursor_cache v$pga_target_advice_histogram v$subcache v$rowcache v$java_library_cache_memory(10.1) v$rowcache_parent v$process_memory(10.2) v$rowcache_subordinate v$sga_target_advice(10.2) v$session_cursor_cache
Cache fusion / rac
  1. v$active_instances                      v$ges_blocking_enqueue      
  2. v$bh                                    v$ges_convert_local         
  3. v$cluster_interconnects(10.2)           v$ges_convert_remote        
  4. v$configured_interconnects(10.2)        v$ges_enqueue               
  5. v$cr_block_server                       v$ges_latch                 
  6. v$current_block_server(10.1)            v$ges_resource              
  7. v$gc_element                            v$ges_statistics            
  8. v$gcshvmaster_info                      v$hvmaster_info             
  9. v$gcspfmaster_info                      v$instance_cache_transfer   
  10.                                         v$resource_limit            
v$active_instances v$ges_blocking_enqueue v$bh v$ges_convert_local v$cluster_interconnects(10.2) v$ges_convert_remote v$configured_interconnects(10.2) v$ges_enqueue v$cr_block_server v$ges_latch v$current_block_server(10.1) v$ges_resource v$gc_element v$ges_statistics v$gcshvmaster_info v$hvmaster_info v$gcspfmaster_info v$instance_cache_transfer v$resource_limit
/***********************************************************************************************************************/
Control files
    Information related to instance control files
V$ Views:     
  1. v$controlfile                  
  2. v$controlfile_record_section   
v$controlfile v$controlfile_record_section
/***********************************************************************************************************************/
Cursors/SQL statements
Information related to cursors and SQL statements, including the open cursors, statistics, and actual SQL text
V$ Views: 
  1. v$open_cursor                   v$session_cursor_cache                                           
  2. v$sql                                   v$sql_shared_cursor                                              
  3. v$sqlarea                               v$sql_shared_memory                                              
  4. v$sqltext                               v$sql_workarea                                                   
  5. v$sqltext_with_newlines                 v$sql_workarea_active                                            
  6. v$sql_bind_data                         v$sql_workarea_histogram                                         
  7. v$sql_bind_metadata                     v$system_cursor_cache v$mutex_sleep(10.2)                        
  8. v$sql_cursor                            v$mutex_sleep_history(10.2)(FOR those dubious shared latches)    
  9. v$sql_optimizer_env                     v$sql_bind_capture(10.1)                                         
  10. v$sql_plan                              v$sql_join_filter(10.2)                                          
  11. v$sql_plan_statistics                   v$sql_area_plan_hash(10.2)                                       
  12. v$sql_plan_statistics_all               v$sqlstats(10.2)                                                 
  13. v$sql_redirection                       v$sys_optimizer_env(10.1)                                        
  14.                                         v$vpd_policy                                                     
v$open_cursor v$session_cursor_cache v$sql v$sql_shared_cursor v$sqlarea v$sql_shared_memory v$sqltext v$sql_workarea v$sqltext_with_newlines v$sql_workarea_active v$sql_bind_data v$sql_workarea_histogram v$sql_bind_metadata v$system_cursor_cache v$mutex_sleep(10.2) v$sql_cursor v$mutex_sleep_history(10.2)(FOR those dubious shared latches) v$sql_optimizer_env v$sql_bind_capture(10.1) v$sql_plan v$sql_join_filter(10.2) v$sql_plan_statistics v$sql_area_plan_hash(10.2) v$sql_plan_statistics_all v$sqlstats(10.2) v$sql_redirection v$sys_optimizer_env(10.1) v$vpd_policy
/***********************************************************************************************************************/
Database instances
    Information related to the actual database instance
V$ Views: 
  1. v$active_instances                      v$sga                           
  2. v$bgprocess                             v$sgastat                       
  3. v$database                              v$blocking_quiesce(10.2)        
  4. v$instance                              v$client_stats(10.1)            
  5. v$process                                                               
v$active_instances v$sga v$bgprocess v$sgastat v$database v$blocking_quiesce(10.2) v$instance v$client_stats(10.1) v$process
RAC Views:
  1. v$bh                
  2. v$active_instances  
v$bh v$active_instances
/***********************************************************************************************************************/
Direct Path Operations
    Information related to the SQL*Loader direct load option
V$ Views: 
  1. v$loadistat    
  2. v$loadpstat    
v$loadistat v$loadpstat
/***********************************************************************************************************************/
Distributed/
    Heterogeneous Services
V$ Views:
  1. v$dblink                                 v$hs_agent      
  2. v$global_transaction                     v$hs_parameter  
  3. v$global_blocked_locks                   v$hs_session    
v$dblink v$hs_agent v$global_transaction v$hs_parameter v$global_blocked_locks v$hs_session
/***********************************************************************************************************************/      
Fixed view
    Information related to the v$ tables themselves
V$ Views: 
  1. v$fixed_table              
  2. v$fixed_view_definition    
  3. v$indexed_fixed_column     
v$fixed_table v$fixed_view_definition v$indexed_fixed_column
/***********************************************************************************************************************/
General
    General information related to various system information
V$ Views:     
  1. v$dbpipes                               v$timezone_names                   
  2. v$context                               v$type_size                        
  3. v$globalcontext                         v$_sequences                       
  4. v$license                               v$version                          
  5. v$option                                v$db_transportable_platform(10.2)  
  6. v$reserved_words                        v$transportable_platform(10.1)     
  7. v$timer                                 v$scheduler_running_jobs(10.2)     
v$dbpipes v$timezone_names v$context v$type_size v$globalcontext v$_sequences v$license v$version v$option v$db_transportable_platform(10.2) v$reserved_words v$transportable_platform(10.1) v$timer v$scheduler_running_jobs(10.2)
/***********************************************************************************************************************/      
I/O
    Information related to I/O, including files and statistics
V$ Views:      
  1. v$dbfile                                                              v$sysaux_occupants(10.1)    
  2. v$filestat                              v$tablespace                
  3. v$waitstat                              v$temp_histogram(10.1)      
  4. v$tempstat                              v$temp_space_header         
  5. v$file_histogram(10.1)                  v$tempfile                  
  6. v$filemetric(10.1)                      v$tempseg_usage             
  7. v$filemetric_history(10.1)                                          
v$dbfile v$sysaux_occupants(10.1) v$filestat v$tablespace v$waitstat v$temp_histogram(10.1) v$tempstat v$temp_space_header v$file_histogram(10.1) v$tempfile v$filemetric(10.1) v$tempseg_usage v$filemetric_history(10.1)
/***********************************************************************************************************************/      
Latches/locks Information related to latches and locks
V$ Views:     
  1. v$enqueue_lock                          v$latch_misses          
  2. v$enqueue_stat                          v$latch_parent          
  3. v$event_name                            v$lock                  
  4. v$file_cache_transfer                   v$locked_object         
  5. v$global_blocked_locks                  v$resource              
  6. v$latch                                 v$resource_limit        
  7. v$latchholder                           v$transaction_enqueue   
  8. v$latchname                             v$_lock                 
  9. v$latch_children                        v$_lock1                
  10.                                         v$enqueue_statistics    
v$enqueue_lock v$latch_misses v$enqueue_stat v$latch_parent v$event_name v$lock v$file_cache_transfer v$locked_object v$global_blocked_locks v$resource v$latch v$resource_limit v$latchholder v$transaction_enqueue v$latchname v$_lock v$latch_children v$_lock1 v$enqueue_statistics
RAC Views: 
  1. v$cr_block_server           v$ges_enqueue      
  2. v$gcshvmaster_info                      v$hvmaster_info    
  3. v$gcspfmaster_info                      v$ges_latch        
  4. v$gc_element                            v$ges_resources    
  5. v$ges_blocking_enqueue                                     
v$cr_block_server v$ges_enqueue v$gcshvmaster_info v$hvmaster_info v$gcspfmaster_info v$ges_latch v$gc_element v$ges_resources v$ges_blocking_enqueue
/***********************************************************************************************************************/      
Log Miner Information related to Log Miner
V$ Views:     
  1. v$logmnr_callback                       v$logmnr_process                 
  2. v$logmnr_contents                       v$logmnr_region                  
  3. v$logmnr_dictionary                     v$logmnr_session                 
  4. v$logmnr_latch                          v$logmnr_stats                   
  5. v$logmnr_logfile                        v$logmnr_transaction             
  6. v$logmnr_logs                           v$logmnr_dictionary_load(10.2)   
  7. v$logmnr_parameters                                                      
v$logmnr_callback v$logmnr_process v$logmnr_contents v$logmnr_region v$logmnr_dictionary v$logmnr_session v$logmnr_latch v$logmnr_stats v$logmnr_logfile v$logmnr_transaction v$logmnr_logs v$logmnr_dictionary_load(10.2) v$logmnr_parameters
/***********************************************************************************************************************/      
Metrics Information related to Metrics (ALL New in 10g!)
V$ Views: 
  1. v$metricname                            v$sessmetric                
  2. v$servicemetric                         v$sysmetric                 
  3. v$eventmetric                           v$sysmetric_history         
  4. v$filemetric                            v$sysmetric_summary         
  5. v$filemetric_history                    v$threshold_types           
  6. v$servicemetric_history                 v$waitclassmetric           
  7.                                         v$waitclassmetric_history   
v$metricname v$sessmetric v$servicemetric v$sysmetric v$eventmetric v$sysmetric_history v$filemetric v$sysmetric_summary v$filemetric_history v$threshold_types v$servicemetric_history v$waitclassmetric v$waitclassmetric_history
/***********************************************************************************************************************/                                              
Multithreaded/shared servers
    Information related to multithreaded and parallel servers, including connections, queues,dispatchers, and shared servers
V$ Views:      
  1. v$circuit                                     v$reqdist                    
  2. v$dispatcher                            v$shared_server              
  3. v$dispatcher_rate                       v$shared_server_monitor      
  4. v$queue                                 v$dispatcher_config(10.1)    
  5. v$queueing_mth                                                       
v$circuit v$reqdist v$dispatcher v$shared_server v$dispatcher_rate v$shared_server_monitor v$queue v$dispatcher_config(10.1) v$queueing_mth
/***********************************************************************************************************************/      
Object Usage
     Information related to object use and dependencies
V$ Views:     
  1. v$object_dependency    
  2. v$object_usage         
v$object_dependency v$object_usage
/***********************************************************************************************************************/       
Overall system
    information related TO THE overall system performance v$ tables : 
  1. v$global_transaction            v$tempfile                  
  2. v$shared_pool_reserved                  v$temporary_lobs            
  3. v$resumable                             v$temp_extent_map           
  4. v$sort_segment                          v$temp_extent_pool          
  5. v$tempseg_usage                         v$temp_space_header         
  6. v$statname                              v$transaction               
  7. v$sys_optimizer_env                     v$alert_types(10.1)         
  8. v$sys_time_model                        v$event_histogram(10.1)     
  9. v$sysstat                               v$osstat(10.1)              
  10. v$system_cursor_cache                   v$system_wait_class(10.1)   
  11. v$system_event                          v$temp_histogram(10.1)      
  12.                                         v$xml_audit_trail           
v$global_transaction v$tempfile v$shared_pool_reserved v$temporary_lobs v$resumable v$temp_extent_map v$sort_segment v$temp_extent_pool v$tempseg_usage v$temp_space_header v$statname v$transaction v$sys_optimizer_env v$alert_types(10.1) v$sys_time_model v$event_histogram(10.1) v$sysstat v$osstat(10.1) v$system_cursor_cache v$system_wait_class(10.1) v$system_event v$temp_histogram(10.1) v$xml_audit_trail
/***********************************************************************************************************************/
Parallel Query Information related to the Parallel Query option
V$ Views:      
  1. v$execution                             v$pq_tqstat            
  2. v$parallel_degree_limit_mth             v$px_process           
  3. v$pq_sesstat                            v$px_process_sysstat   
  4. v$pq_slave                              v$px_session           
  5. v$pq_sysstat                            v$px_sesstat           
v$execution v$pq_tqstat v$parallel_degree_limit_mth v$px_process v$pq_sesstat v$px_process_sysstat v$pq_slave v$px_session v$pq_sysstat v$px_sesstat
/***********************************************************************************************************************/
Parameters
    Information related to various Oracle parameters, including initialization and NLS per session
V$ Views:    
  1. v$nls_parameters                        v$spparameter                   
  2. v$nls_valid_values                      v$system_parameter              
  3. v$obsolete_parameter                    v$system_parameter2             
  4. v$parameter                             v$parameter_valid_values(10.2)  
  5. v$parameter2                                                            
v$nls_parameters v$spparameter v$nls_valid_values v$system_parameter v$obsolete_parameter v$system_parameter2 v$parameter v$parameter_valid_values(10.2) v$parameter2
/***********************************************************************************************************************/      
Redo logs Information related to redo logs, including statistics and history
V$ Views: 
  1. v$log                   
  2. v$logfile               
  3. v$loghist               
  4. v$log_history           
  5. v$thread (rac related)  
v$log v$logfile v$loghist v$log_history v$thread (rac related)
/***********************************************************************************************************************/    
Replication and materialized views
    Information related to replication and materialized views
V$ Views:   
  1. v$mvrefresh     
  2. v$replprop      
  3. v$replqueue     
v$mvrefresh v$replprop v$replqueue
/***********************************************************************************************************************/    
Resource Manager Information related to resource management
V$ Views: 
  1. v$active_session_pool_mth       v$rsrc_plan                 
  2. v$active_session_pool_history           v$rsrc_plan_cpu_mth         
  3. v$rsrc_cons_group_history(10.2)         v$rsrc_plan_history(10.2)   
  4. v$rsrc_consumer_group                   v$rsrc_session_info(10.2)   
  5. v$rsrc_consumer_group_cpu_mth                                       
v$active_session_pool_mth v$rsrc_plan v$active_session_pool_history v$rsrc_plan_cpu_mth v$rsrc_cons_group_history(10.2) v$rsrc_plan_history(10.2) v$rsrc_consumer_group v$rsrc_session_info(10.2) v$rsrc_consumer_group_cpu_mth
/***********************************************************************************************************************/
Rollback segments And Undo
    Information on rollback segments, including statistics and transactions
V$ Views:     
  1. v$rollname      
  2. v$rollstat      
  3. v$transaction   
  4. v$undostat      
v$rollname v$rollstat v$transaction v$undostat
/***********************************************************************************************************************/
Security/privileges Information related to security
V$ Views: 
  1. v$enabledprivs           
  2. v$pwfile_users           
  3. v$vpd_policy             
  4. v$wallet(10.2)           
  5. v$xml_audit_trail(10.2)  
v$enabledprivs v$pwfile_users v$vpd_policy v$wallet(10.2) v$xml_audit_trail(10.2)
/***********************************************************************************************************************/
Sessions (includes some replication information and heterogeneous services)
    Information related to a session, including object access, cursors, processes, and statistics
V$ Views:      
  1. v$active_session_history                v$session_object_cache   
  2. v$mystat                                v$session_wait           
  3. v$process                               v$session_wait_class     
  4. v$sess_time_model                       v$session_wait_history   
  5. v$session                               v$sesstat                
  6. v$session_connect_info                  v$sess_io                
  7. v$session_cursor_cache                  v$ses_optimizer_env      
  8. v$session_event                         v$sessmetric             
  9. v$session_longops                       v$client_stats           
  10.                                         v$tsm_sessions(10.2)     
v$active_session_history v$session_object_cache v$mystat v$session_wait v$process v$session_wait_class v$sess_time_model v$session_wait_history v$session v$sesstat v$session_connect_info v$sess_io v$session_cursor_cache v$ses_optimizer_env v$session_event v$sessmetric v$session_longops v$client_stats v$tsm_sessions(10.2)
/***********************************************************************************************************************/                                                 
Services (all new for 10.1)  
  1. v$active_services      
  2. v$serv_mod_act_stats   
  3. v$service_event        
  4. v$service_stats        
  5. v$service_wait_class   
  6. v$services             
v$active_services v$serv_mod_act_stats v$service_event v$service_stats v$service_wait_class v$services
/***********************************************************************************************************************/      
Sorting Information related to sorting
V$ Views:     
  1. v$sort_segment           
  2. v$tempseg_usage          
  3. v$temp_extent_map        
  4. v$temp_extent_pool       
  5. v$temp_histogram(10.1)   
  6. v$temp_space_header      
  7. v$tempfile               
  8. v$tempstat               
v$sort_segment v$tempseg_usage v$temp_extent_map v$temp_extent_pool v$temp_histogram(10.1) v$temp_space_header v$tempfile v$tempstat
/***********************************************************************************************************************/      
Standby databases (DataGuard)
    Information related to standby databases
V$ Views:      
  1. v$dataguard_status                      v$dataguard_stats(10.2)        
  2. v$logstdby                              v$logstdby_process(10.2)       
  3. v$logstdby_stats                        v$logstdby_progress(10.2)      
  4. v$managed_standby                       v$logstdby_state(10.2)         
  5. v$standby_log                           v$logstdby_transaction(10.2)   
  6. v$dataguard_config(10.1)                                               
v$dataguard_status v$dataguard_stats(10.2) v$logstdby v$logstdby_process(10.2) v$logstdby_stats v$logstdby_progress(10.2) v$managed_standby v$logstdby_state(10.2) v$standby_log v$logstdby_transaction(10.2) v$dataguard_config(10.1)
/***********************************************************************************************************************/      
File mapping interface
    Information related to file mapping
V$ Views:     
  1. v$map_comp_list                               v$map_file_extent    
  2. v$map_element                           v$map_file_io_stack  
  3. v$map_ext_element                       v$map_library        
  4. v$map_file                              v$map_subelement     
v$map_comp_list v$map_file_extent v$map_element v$map_file_io_stack v$map_ext_element v$map_library v$map_file v$map_subelement
/***********************************************************************************************************************/        
Streams
Information related to streams
V$ Views:     
  1. v$aq                                    v$buffered_subscribers(10.1)       
  2. v$streams_apply_coordinator             v$propagation_receiver(10.1)       
  3. v$streams_apply_reader                  v$propagation_sender(10.1)         
  4. v$streams_apply_server                  v$rule(10.1)                       
  5. v$streams_capture                       v$rule_set(10.1)                   
  6. v$buffered_publishers(10.1)             v$rule_set_aggregate_stats(10.1)   
  7. v$buffered_queues(10.1)                 v$streams_transaction(10.2)        
v$aq v$buffered_subscribers(10.1) v$streams_apply_coordinator v$propagation_receiver(10.1) v$streams_apply_reader v$propagation_sender(10.1) v$streams_apply_server v$rule(10.1) v$streams_capture v$rule_set(10.1) v$buffered_publishers(10.1) v$rule_set_aggregate_stats(10.1) v$buffered_queues(10.1) v$streams_transaction(10.2)
/***********************************************************************************************************************/        
Statistics Information related to statistics in general
V$ Views:     
  1. v$segment_statistics       
  2. v$segstat                  
  3. v$segstat_name             
  4. v$statistics_level         
  5. v$statname                 
  6. v$waitstat                 
v$segment_statistics v$segstat v$segstat_name v$statistics_level v$statname v$waitstat
/***********************************************************************************************************************/   
Transactions Information related to transactions in general
V$ Views:    
  1. v$global_transaction       
  2. v$logstdby_transaction     
  3. v$resumable                
  4. v$streams_transaction      
  5. v$transaction              
  6. v$transaction_enqueue   

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22578826/viewspace-703461/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-05-18

  • 博文量
    192
  • 访问量
    458922