Fixed Views Definitions in Oracle Database 10.2
- gv$_lock
- gv$_lock1
- gv$_resumable2
- gv$_sequences
- gv$access
- gv$active_instances
- gv$active_services
- gv$active_sess_pool_mth
- gv$active_session_history
- gv$advisor_progress
- gv$alert_types
- gv$aq1
- gv$archive
- gv$archive_dest
- gv$archive_dest_status
- gv$archive_gap
- gv$archive_processes
- gv$archived_log
- gv$asm_alias
- gv$asm_client
- gv$asm_disk
- gv$asm_disk_stat
- gv$asm_diskgroup
- gv$asm_diskgroup_stat
- gv$asm_file
- gv$asm_operation
- gv$asm_template
- gv$aw_aggregate_op
- gv$aw_allocate_op
- gv$aw_calc
- gv$aw_longops
- gv$aw_olap
- gv$aw_session_info
- gv$backup
- gv$backup_async_io
- gv$backup_corruption
- gv$backup_datafile
- gv$backup_device
- gv$backup_piece
- gv$backup_redolog
- gv$backup_set
- gv$backup_spfile
- gv$backup_sync_io
- gv$bgprocess
- gv$bh
- gv$blocking_quiesce
- gv$bsp
- gv$buffer_pool
- gv$buffer_pool_statistics
- gv$buffered_publishers
- gv$buffered_queues
- gv$buffered_subscribers
- gv$circuit
- gv$class_cache_transfer
- gv$class_ping
- gv$client_stats
- gv$cluster_interconnects
- gv$configured_interconnects
- gv$context
- gv$controlfile
- gv$controlfile_record_section
- gv$copy_corruption
- gv$cr_block_server
- gv$current_block_server
- gv$database
- gv$database_block_corruption
- gv$database_incarnation
- gv$datafile
- gv$datafile_copy
- gv$datafile_header
- gv$dataguard_config
- gv$dataguard_status
- gv$datapump_job
- gv$datapump_session
- gv$db_cache_advice
- gv$db_object_cache
- gv$db_pipes
- gv$db_transportable_platform
- gv$dbfile
- gv$dblink
- gv$deleted_object
- gv$dispatcher
- gv$dispatcher_config
- gv$dispatcher_rate
- gv$dlm_all_locks
- gv$dlm_convert_local
- gv$dlm_convert_remote
- gv$dlm_latch
- gv$dlm_locks
- gv$dlm_misc
- gv$dlm_ress
- gv$dlm_traffic_controller
- gv$enabledprivs
- gv$enqueue_lock
- gv$enqueue_stat
- gv$enqueue_statistics
- gv$event_histogram
- gv$event_name
- gv$eventmetric
- gv$execution
- gv$fast_start_servers
- gv$fast_start_transactions
- gv$file_cache_transfer
- gv$file_histogram
- gv$file_ping
- gv$filemetric
- gv$filemetric_history
- gv$filespace_usage
- gv$filestat
- gv$fixed_table
- gv$fixed_view_definition
- gv$flashback_database_log
- gv$flashback_database_logfile
- gv$flashback_database_stat
- gv$gc_element
- gv$gc_elements_with_collisions
- gv$gcshvmaster_info
- gv$gcspfmaster_info
- gv$ges_blocking_enqueue
- gv$ges_enqueue
- gv$global_blocked_locks
- gv$global_transaction
- gv$globalcontext
- gv$hs_agent
- gv$hs_parameter
- gv$hs_session
- gv$hvmaster_info
- gv$indexed_fixed_column
- gv$instance
- gv$instance_cache_transfer
- gv$instance_log_group
- gv$instance_recovery
- gv$java_library_cache_memory
- gv$java_pool_advice
- gv$javapool
- gv$latch
- gv$latch_children
- gv$latch_misses
- gv$latch_parent
- gv$latchholder
- gv$latchname
- gv$library_cache_memory
- gv$librarycache
- gv$license
- gv$loadistat
- gv$loadpstat
- gv$lock
- gv$lock_activity
- gv$lock_element
- gv$lock_type
- gv$locked_object
- gv$locks_with_collisions
- gv$log
- gv$log_history
- gv$logfile
- gv$loghist
- gv$logmnr_callback
- gv$logmnr_contents
- gv$logmnr_dictionary
- gv$logmnr_dictionary_load
- gv$logmnr_latch
- gv$logmnr_logfile
- gv$logmnr_logs
- gv$logmnr_parameters
- gv$logmnr_process
- gv$logmnr_region
- gv$logmnr_session
- gv$logmnr_stats
- gv$logmnr_transaction
- gv$logstdby
- gv$logstdby_process
- gv$logstdby_progress
- gv$logstdby_state
- gv$logstdby_stats
- gv$logstdby_transaction
- gv$managed_standby
- gv$map_comp_list
- gv$map_element
- gv$map_ext_element
- gv$map_file
- gv$map_file_extent
- gv$map_file_io_stack
- gv$map_library
- gv$map_subelement
- gv$max_active_sess_target_mth
- gv$metric
- gv$metric_history
- gv$metricgroup
- gv$metricname
- gv$mttr_target_advice
- gv$mutex_sleep
- gv$mutex_sleep_history
- gv$mvrefresh
- gv$mystat
- gv$nls_parameters
- gv$nls_valid_values
- gv$object_dependency
- gv$obsolete_parameter
- gv$offline_range
- gv$open_cursor
- gv$option
- gv$osstat
- gv$parallel_degree_limit_mth
- gv$parameter
- gv$parameter2
- gv$parameter_valid_values
- gv$pga_target_advice
- gv$pga_target_advice_histogram
- gv$pgastat
- gv$pq_sesstat
- gv$pq_slave
- gv$pq_sysstat
- gv$pq_tqstat
- gv$process
- gv$process_memory
- gv$process_memory_detail
- gv$process_memory_detail_prog
- gv$propagation_receiver
- gv$propagation_sender
- gv$proxy_archivedlog
- gv$proxy_datafile
- gv$pwfile_users
- gv$px_buffer_advice
- gv$px_process
- gv$px_process_sysstat
- gv$px_session
- gv$px_sesstat
- gv$queue
- gv$queueing_mth
- gv$recover_file
- gv$recovery_file_status
- gv$recovery_log
- gv$recovery_progress
- gv$recovery_status
- gv$replprop
- gv$replqueue
- gv$reqdist
- gv$reserved_words
- gv$resource
- gv$resource_limit
- gv$restore_point
- gv$resumable
- gv$rfs_thread
- gv$rman_configuration
- gv$rman_encryption_algorithms
- gv$rman_output
- gv$rman_status_current
- gv$rollstat
- gv$rowcache
- gv$rowcache_parent
- gv$rowcache_subordinate
- gv$rsrc_cons_group_history
- gv$rsrc_consumer_group
- gv$rsrc_consumer_group_cpu_mth
- gv$rsrc_plan
- gv$rsrc_plan_cpu_mth
- gv$rsrc_plan_history
- gv$rsrc_session_info
- gv$rule
- gv$rule_set
- gv$rule_set_aggregate_stats
- gv$scheduler_running_jobs
- gv$segment_statistics
- gv$segstat
- gv$segstat_name
- gv$serv_mod_act_stats
- gv$service_event
- gv$service_stats
- gv$service_wait_class
- gv$servicemetric
- gv$servicemetric_history
- gv$services
- gv$ses_optimizer_env
- gv$sess_io
- gv$sess_time_model
- gv$session
- gv$session_connect_info
- gv$session_cursor_cache
- gv$session_event
- gv$session_longops
- gv$session_object_cache
- gv$session_wait
- gv$session_wait_class
- gv$session_wait_history
- gv$sessmetric
- gv$sesstat
- gv$sga
- gv$sga_current_resize_ops
- gv$sga_dynamic_components
- gv$sga_dynamic_free_memory
- gv$sga_resize_ops
- gv$sga_target_advice
- gv$sgainfo
- gv$sgastat
- gv$shared_pool_advice
- gv$shared_pool_reserved
- gv$shared_server
- gv$shared_server_monitor
- gv$sort_segment
- gv$sort_usage
- gv$spparameter
- gv$sql
- gv$sql_bind_data
- gv$sql_bind_metadata
- gv$sql_cursor
- gv$sql_join_filter
- gv$sql_optimizer_env
- gv$sql_plan
- gv$sql_plan_statistics
- gv$sql_plan_statistics_all
- gv$sql_redirection
- gv$sql_shared_cursor
- gv$sql_shared_memory
- gv$sql_workarea
- gv$sql_workarea_active
- gv$sql_workarea_histogram
- gv$sqlarea
- gv$sqlarea_plan_hash
- gv$sqlstats
- gv$sqltext
- gv$sqltext_with_newlines
- gv$standby_apply_snapshot
- gv$standby_log
- gv$statistics_level
- gv$statname
- gv$streams_apply_coordinator
- gv$streams_apply_reader
- gv$streams_apply_server
- gv$streams_capture
- gv$streams_pool_advice
- gv$streams_transaction
- gv$subcache
- gv$sys_optimizer_env
- gv$sys_time_model
- gv$sysaux_occupants
- gv$sysmetric
- gv$sysmetric_history
- gv$sysmetric_summary
- gv$sysstat
- gv$system_cursor_cache
- gv$system_event
- gv$system_parameter
- gv$system_parameter2
- gv$system_wait_class
- gv$tablespace
- gv$temp_cache_transfer
- gv$temp_extent_map
- gv$temp_extent_pool
- gv$temp_histogram
- gv$temp_ping
- gv$temp_space_header
- gv$tempfile
- gv$temporary_lobs
- gv$tempstat
- gv$thread
- gv$threshold_types
- gv$timer
- gv$timezone_file
- gv$timezone_names
- gv$transaction
- gv$transaction_enqueue
- gv$transportable_platform
- gv$tsm_sessions
- gv$type_size
- gv$undostat
- gv$version
- gv$vpd_policy
- gv$waitclassmetric
- gv$waitclassmetric_history
- gv$waitstat
- gv$wallet
- gv$xml_audit_trail
- v$backup_archivelog_details
- v$backup_archivelog_summary
- v$backup_controlfile_details
- v$backup_controlfile_summary
- v$backup_copy_details
- v$backup_copy_summary
- v$backup_datafile_details
- v$backup_datafile_summary
- v$backup_piece_details
- v$backup_set_details
- v$backup_set_summary
- v$backup_spfile_details
- v$backup_spfile_summary
- v$block_change_tracking
- v$dataguard_stats
- v$flash_recovery_area_usage
- v$proxy_archivelog_details
- v$proxy_archivelog_summary
- v$proxy_copy_details
- v$proxy_copy_summary
- v$recovery_file_dest
- v$rman_backup_job_details
- v$rman_backup_subjob_details
- v$rman_status
- v$unusable_backupfile_details