--************************************* -- 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