Oracle 常用性能视图一览表(10g)-阿里云开发者社区

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

Advisors
Information related to cache advisors

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

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

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:

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

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:

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:

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:

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:

v$bh              
v$active_instances

/***********************************************************************************************************************/
Direct Path Operations
Information related to the SQL*Loader direct load option
V$ Views:

v$loadistat  
v$loadpstat

/***********************************************************************************************************************/
Distributed/
Heterogeneous Services
V$ Views:

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:

v$fixed_table            
v$fixed_view_definition  
v$indexed_fixed_column

/***********************************************************************************************************************/
General
General information related to various system information
V$ Views:

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:

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:

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:

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:

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:

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:

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:

v$object_dependency  
v$object_usage

/***********************************************************************************************************************/
Overall system
information related TO THE overall system performance v$ tables :

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:

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:

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:

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:

v$mvrefresh   
v$replprop    
v$replqueue

/***********************************************************************************************************************/
Resource Manager Information related to resource management
V$ Views:

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:

v$rollname    
v$rollstat    
v$transaction 
v$undostat

/***********************************************************************************************************************/
Security/privileges Information related to security
V$ Views:

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:

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)

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:

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:

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:

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:

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:

v$segment_statistics     
v$segstat                
v$segstat_name           
v$statistics_level       
v$statname               
v$waitstat

/***********************************************************************************************************************/
Transactions Information related to transactions in general
V$ Views:

v$global_transaction     
v$logstdby_transaction   
v$resumable              
v$streams_transaction    
v$transaction            
v$transaction_enqueue

参照整理： Oracle Database 10g 性能调整与优化(尼米克 (Richard J.Niemiec))

快捷参考

有关性能优化请参考

Oracle硬解析与软解析

共享池的调整与优化(Sharedpool Tuning)

Buffercache 的调整与优化(一)

Oracle表缓存(cachingtable)的使用

有关ORACLE体系结构请参考

Oracle表空间与数据文件

Oracle密码文件

Oracle参数文件

Oracle联机重做日志文件(ONLINE LOG FILE)