Common Performance view for Oracle 10g

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

--Oracle Common Performance View list (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

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

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/