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)
/************************************************************************************************************/
 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)
/************************************************************************************************************/
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
/************************************************************************************************************/
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
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
/************************************************************************************************************/
Control files
Information related to instance control files
V$ Views:     

1.v$controlfile
2.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
/************************************************************************************************************/
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
RAC Views:

1.v$bh
2.v$active_instances
/************************************************************************************************************/
Direct Path Operations
Information related to the SQL*Loader direct load option
V$ Views:

 1.v$loadistat
2.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
/************************************************************************************************************/
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
/************************************************************************************************************/
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)
/************************************************************************************************************/
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)
/************************************************************************************************************/
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
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
/************************************************************************************************************/
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
/************************************************************************************************************/
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
/************************************************************************************************************/
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
/************************************************************************************************************/
Object Usage
 Information related to object use and dependencies
V$ Views:

 1.v$object_dependency
2.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
/************************************************************************************************************/
 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
/************************************************************************************************************/
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
/************************************************************************************************************/
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)
/************************************************************************************************************/
Replication and materialized views
 Information related to replication and materialized views
V$ Views:

 1.v$mvrefresh
2.v$replprop
3.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
/************************************************************************************************************/
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
/************************************************************************************************************/
Security/privilegesInformation 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)
/************************************************************************************************************/
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)
/************************************************************************************************************/
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
/************************************************************************************************************/
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
/************************************************************************************************************/
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)
/************************************************************************************************************/
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
/************************************************************************************************************/
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)
/************************************************************************************************************/
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
/************************************************************************************************************/
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/25313300/viewspace-754107/，如需轉載，請註明出處，否則將追究法律責任。