Oracle Dictionary Views

Get all the views

ALL_VIEWS
USER_VIEWS
DBA_VIEWS

Tablesapces Related Views

V$FILESTAT
V$DATAFILE
DBA_FREE_SPACE
DBA_SEGMENTS
DBA_TABLESPACE_GROUPS
DBA_TABLESPACES
DBA_DATA_FILES

Index and contraint related views

DBA_CONSTRAINTS
DBA_CONS_COLUMNS

Database Objects Related Views

DBA_OBJECTS
DBA_TABLES
DBA_EXTERNAL_TABLES
DBA_TAB_PARTITIONS
DBA_PART_TABLES
DBA_TAB_MODIFICATIONS
DBA_TAB_COLUMNS
DBA_VIEWS
DBA_MVIEWS
DBA_INDEXES
DBA_IND_COLUMNS
INDEX_STATS

Cache Related Views

v$result_cache_statistics
v$result_cache_memory
v$result_cache_objects
v$result_cache_dependency
v$client_result_cache_stats 

Incident Repair Related Views

v$ir_failure
v$ir_repair                                                                
v$ir_manual_checklist                                                      
v$ir_failure_set    



Health Monitor Related Views

v$hm_check
v$hm_check_param                        
v$hm_run                                                                   
v$hm_finding                                                               
v$hm_recommendation         
v$hm_info 


NFS configuration Related Views

v$nfs_clients
v$nfs_open_files
v$nfs_locks
v$iostat_network


Backup and Recovery Related Views

v$rman_backup_subjob_details
v$rman_backup_job_details
v$backup_set_details
v$backup_piece_details
v$backup_copy_details
$backup
v$recovery_status
v$recovery_file_status
v$backup_set
v$backup_piece
v$backup_datafile
v$backup_redolog
v$backup_corruption
v$backup_device
v$backup_spfile
v$backup_sync_io
v$backup_async_io
v$recover_file
v$rman_status
v$rman_output
v$backup_datafile_details
v$backup_controlfile_details
v$backup_archivelog_details
v$backup_spfile_details
v$backup_datafile_summary
v$backup_controlfile_summary
v$backup_archivelog_summary
v$backup_spfile_summary
v$backup_set_summary
v$recovery_progress
v$rman_backup_type
v$rman_configuration

Data Guard Related Views

v$dataguard_config
v$dataguard_status
v$managed_standby
v$logstdby
v$logstdby_stats
v$logstdby_transaction
v$logstdby_process
v$logstdby_progress
v$logstdby_state

Streams Related Views

v$streams_apply_coordinator
v$streams_apply_server
v$streams_apply_reader
v$streams_capture
v$streams_transaction
v$streams_message_tracking

RAC Related Views

v$cluster_interconnects
v$configured_interconnects
v$dynamic_remaster_stats
v$dlm_misc
v$dlm_latch
v$dlm_convert_local
v$dlm_convert_remote
v$ges_enqueue
v$ges_blocking_enqueue
v$dlm_all_locks
v$dlm_locks
v$dlm_ress
v$global_blocked_locks

ASM Related Views

v$asm_template
v$asm_alias
v$asm_file
v$asm_client
v$asm_diskgroup
v$asm_diskgroup_stat
v$asm_disk
v$asm_disk_stat
$asm_disk_iostat
v$asm_operation
v$asm_attribute

Wait Events Related Views

v$session
v$waitclassmetric
v$waitclassmetric_history
v$waitstat
v$wait_chains

Concurrency and SQL Tuning Related Views

v$lock
v$sql
v$sqlarea
v$sesstat
v$mystat
v$sess_io
v$sysstat
v$statname
v$osstat
v$active_session_history
v$active_sess_pool_mth 
v$session_wait
v$session_wait_class
v$system_wait_class
v$transaction
v$locked_object
v$latch
v$latch_children
v$latch_parent
v$latchname
v$latchholder
v$latch_misses
v$enqueue_lock
v$transaction_enqueue
v$sys_optimizer_env
v$ses_optimizer_env
v$sql_optimizer_env
v$sql_plan
v$sql_plan_statistics
v$sql_plan_statistics_all

Memory Related Views

v$sga
v$sgastat
v$sgainfo
v$sga_current_resize_ops
v$sga_resize_ops
v$sga_dynamic_components
v$sga_dynamic_free_memory
v$pgastat
v$sql_workarea_histogram
v$pga_target_advice_histogram                                              
v$pga_target_advice
v$memory_current_resize_ops
v$memory_resize_ops
v$memory_dynamic_components
v$library_cache_memory
v$shared_pool_advice
v$java_library_cache_memory
v$java_pool_advice
v$streams_pool_advice

Archive Related Views

v$archive_dest
v$archive_dest_status
v$archive_gap
v$archive_processes
v$archived_log

Buffer Related Views

v$bh
v$buffer_pool
v$buffer_pool_statistics

Controlfile Related Views 

v$controlfile
v$controlfile_record_section

Session Related Views

v$session
v$session_event
v$session_longops
v$session_wait
v$session_wait_history
v$sessmetric
v$sesstat

Tempfile Related Views

v$tempfile
v$tempseg_usage
v$tempseg_usage 
v$tempstat

Exadata Cell Related Views

V_$CELL
V_$CELL_CONFIG
V_$CELL_REQUEST_TOTALS
V_$CELL_STATE
V_$CELL_THREAD_HISTORY 


No comments:

Post a Comment