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