List Of Dynamic Perfomance View-Oracle 10g

Dynamic v$ Performance Views

select * from v$archive_dest;

Select * from v$archive_dest_status;

Select * from v$archive_gap;

Select * from v$archive_processes;

Select * from v$archived_log;

Select * from v$bh;

Select * from v$buffer_pool;

Select * from v$buffer_pool_statistics;

Select * from v$controlfile

Select * from v$controlfile_record_section

Select * from v$database

Select * from v$datafile

Select * from v$datafile_header

Select * from v$dataguard_status

Select * from v$db_object_cache

Select * from v$enqueue_stat

Select * from v$event_name

Select * from v$eventmetric

Select * from v$filemetric

Select * from v$filestat

Select * from v$fixed_table

Select * from v$fixed_view_definition

Select * from v$instance

Select * from v$latch

Select * from v$librarycache

Select * from v$lock

Select * from v$locked_object

Select * from v$log

Select * from v$log_history

Select * from v$logfile

Select * from v$logmnr_contents

Select * from v$logstdby

Select * from v$managed_standby

Select * from v$mystat

Select * from v$nls_parameters

Select * from v$nls_valid_values

Select * from v$object_usage

Select * from  v$open_cursor

Select * from v$option

Select * from v$parameter

Select * from v$pgastat

Select * from v$process

Select * from v$pwfile_users

Select * from v$recover_file

Select * from v$reserved_words

Select * from v$resource_limit

Select * from v$rollname

Select * from v$rollstat

Select * from v$session

Select * from v$session_event

Select * from v$session_longops

Select * from v$session_wait

Select * from v$session_wait_history

Select * from v$sessmetric

Select * from v$sesstat

Select * from v$sga

Select * from v$sga_dynamic_components

Select * from v$sga_resize_ops

Select * from v$sgastat

Select * from v$sort_segment

Select * from v$sort_usage

Select * from v$spparameter

Select * from v$sql

Select * from v$sql_bind_capture

Select * from v$sql_bind_data

Select * from v$sql_cursor

Select * from v$sql_plan

Select * from v$sql_text_with_newlines

Select * from v$sql_workarea

Select * from v$sqlarea

Select * from v$sqltext

Select * from v$sqltext_with_newlines

Select * from v$standby_log

Select * from v$statname

Select * from v$sysaux_occupants

Select * from  v$sysmetric

Select * from v$sysmetric_history

Select * from v$sysstat

Select * from v$system_event

Select * from v$tempfile

Select * from v$tempseg_usage

Select * from v$tempseg_usage

Select * from v$tempstat

Select * from v$thread

Select * from v$timer

Select * from v$timezone_names

Select * from v$transaction

Select * from v$transportable_platform

Select * from  v$undostat

Select * from  v$version

Select * from  v$waitstat

Select * from v$nfs_clients

Select * from v$nfs_open_files

Select * from v$nfs_locks

Select * from v$iostat_network

Backup and Recovery

Select * from v$rman_backup_subjob_details

Select * from v$rman_backup_job_details

Select * from v$backup_set_details

Select * from v$backup_piece_details

Select * from v$backup_copy_details

Select * from $backup

Select * from v$recovery_status

Select * from v$recovery_file_status

Select * from v$backup_set

Select * from v$backup_piece

Select * from v$backup_datafile

Select * from v$backup_redolog

Select * from v$backup_corruption

Select * from v$backup_device
Select * from v$backup_spfile
Select * from v$backup_sync_io
Select * from v$backup_async_io

Select * from v$recover_file
Select * from v$rman_status
Select * from v$rman_output
Select * from v$backup_datafile_details
Select * from v$backup_controlfile_details
Select * from v$backup_archivelog_details
Select * from v$backup_spfile_details
Select * from v$backup_datafile_summary
Select * from v$backup_controlfile_summary
Select * from v$backup_archivelog_summary
Select * from v$backup_spfile_summary
Select * from v$backup_set_summary
Select * from v$recovery_progress

Select * from v$rman_backup_type
Select * from v$rman_configuration

Dataguard

Select * from v$dataguard_config
Select * from v$dataguard_status
Select * from v$managed_standby
Select * from v$logstdby
Select * from v$logstdby_stats
Select * from v$logstdby_transaction
Select * from v$logstdby_process
Select * from v$logstdby_progress
Select * from v$logstdby_state

Streams

Select * from v$streams_apply_coordinator

Select * from v$streams_apply_server
Select * from v$streams_apply_reader

Select * from v$streams_capture
Select * from v$streams_transaction

Select * from v$streams_message_tracking

 

Rac

Select * from v$cluster_interconnects
Select * from v$configured_interconnects

Select * from v$dynamic_remaster_stats
Select * from v$dlm_misc
Select * from v$dlm_latch
Select * from v$dlm_convert_local
Select * from v$dlm_convert_remote
Select * from v$ges_enqueue
Select * from v$ges_blocking_enqueue
Select * from v$dlm_all_locks
Select * from v$dlm_locks
Select * from v$dlm_ress
Select * from v$global_blocked_locks

ASM

Select * from v$asm_template
Select * from v$asm_alias

Select * from v$asm_file
Select * from v$asm_client
Select * from v$asm_diskgroup
Select * from v$asm_diskgroup_stat

Select * from v$asm_disk

Select * from v$asm_disk_stat
Select * from $asm_disk_iostat
Select * from v$asm_operation

Select * from v$asm_attribute

 

Concurrency and SQL Tuning

Select * from v$session
Select * from v$waitclassmetric
Select * from v$waitclassmetric_history
Select * from v$waitstat
Select * from v$wait_chains

Select * from v$lock
Select * from v$sql
Select * from v$sqlarea
Select * from v$sesstat
Select * from v$mystat
Select * from v$sess_io
Select * from v$sysstat
Select * from v$statname
Select * from v$osstat
Select * from v$active_session_history
Select * from v$active_sess_pool_mth
Select * from v$session_wait
Select * from v$session_wait_class
Select * from v$system_wait_class
Select * from v$transaction
Select * from v$locked_object

Select * from v$latch

Select * from v$latch_children
Select * from v$latch_parent
Select * from v$latchname
Select * from v$latchholder
Select * from v$latch_misses
Select * from v$enqueue_lock
Select * from v$transaction_enqueue
Select * from v$sys_optimizer_env
Select * from v$ses_optimizer_env
Select * from v$sql_optimizer_env
Select * from v$sql_plan
Select * from v$sql_plan_statistics

Select * from v$sql_plan_statistics_all

 

Memory Tuning 

Select * from v$sga
Select * from v$sgastat
Select * from v$sgainfo

Select * from v$sga_current_resize_ops
Select * from v$sga_resize_ops
Select * from v$sga_dynamic_components

Select * from v$sga_dynamic_free_memory
Select * from v$pgastat
Select * from v$sql_workarea_histogram
Select * from v$pga_target_advice_histogram                                              
Select * from v$pga_target_advice
Select * from v$memory_current_resize_ops
Select * from v$memory_resize_ops
Select * from v$memory_dynamic_components
Select * from v$library_cache_memory
Select * from v$shared_pool_advice
Select * from v$java_library_cache_memory
Select * from v$java_pool_advice
Select * from v$streams_pool_advice

Workload Repository Views




Select * from V$ACTIVE_SESSION_HISTORY - Displays the active session history (ASH) sampled every second.

select * from V$METRIC - Displays metric information.

select * from V$METRICNAME - Displays the metrics associated with each metric group.

select * from V$METRIC_HISTORY - Displays historical metrics.

select  *  from V$METRICGROUP - Displays all metrics groups.

select * from  DBA_HIST_ACTIVE_SESS_HISTORY - Displays the history contents of the active session history.

select * from DBA_HIST_BASELINE - Displays baseline information.

select * from DBA_HIST_DATABASE_INSTANCE - Displays database environment information.

select * from DBA_HIST_SNAPSHOT - Displays snapshot information.

select * from DBA_HIST_SQL_PLAN - Displays SQL execution plans.

select * from DBA_HIST_WR_CONTROL - Displays AWR settings.