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

/***********************************************************************************************************************/

查看本欄目更多精彩內容：http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/