Oracle release 11.2 has introduced s staggering 219 new v$ views more
than any other sub-release of Oracle:
v$advisor_current_sqlplan
v$ash_info
v$asm_acfs_encryption_info
v$asm_acfs_security_info
v$asm_acfssnapshots
v$asm_acfsvolumes
v$asm_attribute
v$asm_disk_iostat
v$asm_filesystem
v$asm_user
v$asm_usergroup
v$asm_usergroup_member
v$asm_volume
v$asm_volume_stat
v$calltag
v$cell
v$cell_config
v$cell_request_totals
v$cell_state
v$cell_thread_history
v$corrupt_xid_list
v$cpool_cc_info
v$cpool_cc_stats
v$cpool_conn_info
v$cpool_stats
v$database_key_info
v$detached_session
v$diag_adr_control
v$diag_adr_invalidation
v$diag_alert_ext
v$diag_ams_xaction
v$diag_critical_error
v$diag_dde_user_action
v$diag_dde_user_action_def
v$diag_dde_usr_act_param
v$diag_dde_usr_act_param_def
v$diag_dde_usr_inc_act_map
v$diag_dde_usr_inc_type
v$diag_dfw_config_capture
v$diag_dfw_config_item
v$diag_diagv_incident
v$diag_dir_ext
v$diag_em_diag_job
v$diag_em_target_info
v$diag_em_user_activity
v$diag_hm_fdg_set
v$diag_hm_finding
v$diag_hm_info
v$diag_hm_message
v$diag_hm_recommendation
v$diag_hm_run
v$diag_inc_meter_config
v$diag_inc_meter_impt_def
v$diag_inc_meter_info
v$diag_inc_meter_pk_impts
v$diag_inc_meter_summary
v$diag_incckey
v$diag_incident
v$diag_incident_file
v$diag_info
v$diag_ips_configuration
v$diag_ips_file_copy_log
v$diag_ips_file_metadata
v$diag_ips_package
v$diag_ips_package_file
v$diag_ips_package_history
v$diag_ips_package_incident
v$diag_ips_pkg_unpack_hist
v$diag_ips_progress_log
v$diag_ips_remote_package
v$diag_pickleerr
v$diag_problem
v$diag_relmd_ext
v$diag_sweeperr
v$diag_v_actinc
v$diag_v_actprob
v$diag_v_inc_meter_info_prob
v$diag_v_inccount
v$diag_v_incfcount
v$diag_v_ipsprbcnt
v$diag_v_ipsprbcnt1
v$diag_v_nfcinc
v$diag_v_swperrcount
v$diag_vem_user_actlog
v$diag_vem_user_actlog1
v$diag_vhm_run
v$diag_view
v$diag_viewcol
v$diag_vinc_meter_info
v$diag_vincident
v$diag_vincident_file
v$diag_vips_file_copy_log
v$diag_vips_file_metadata
v$diag_vips_package_file
v$diag_vips_package_history
v$diag_vips_package_main_int
v$diag_vips_package_size
v$diag_vips_pkg_file
v$diag_vips_pkg_inc_cand
v$diag_vips_pkg_inc_dtl
v$diag_vips_pkg_inc_dtl1
v$diag_vips_pkg_main_problem
v$diag_vnot_exist_incident
v$diag_vproblem
v$diag_vproblem_bucket
v$diag_vproblem_bucket_count
v$diag_vproblem_bucket1
v$diag_vproblem_int
v$diag_vproblem_lastinc
v$diag_vproblem1
v$diag_vproblem2
v$diag_vshowcatview
v$diag_vshowincb
v$diag_vshowincb_i
v$diag_vtest_exists
v$dnfs_channels
v$dnfs_files
v$dnfs_servers
v$dnfs_stats
v$dynamic_remaster_stats
v$emon
v$encrypted_tablespaces
v$file_optimized_histogram
v$flashback_txn_graph
v$flashback_txn_mods
v$foreign_archived_log
v$fs_failover_histogram
v$fs_failover_stats
v$goldengate_capture
v$goldengate_message_tracking
v$goldengate_transaction
v$hang_info
v$hang_session_info
v$hm_check
v$hm_check_param
v$hm_finding
v$hm_info
v$hm_recommendation
v$hm_run
v$incmeter_config
v$incmeter_info
v$incmeter_summary
v$io_calibration_status
v$iofuncmetric
v$iofuncmetric_history
v$iostat_consumer_group
v$iostat_file
v$iostat_function
v$iostat_function_detail
v$iostat_network
v$ir_failure
v$ir_failure_set
v$ir_manual_checklist
v$ir_repair
v$libcache_locks
v$listener_network
v$lobstat
v$memory_current_resize_ops
v$memory_dynamic_components
v$memory_resize_ops
v$memory_target_advice
v$nfs_clients
v$nfs_locks
v$nfs_open_files
v$object_dml_frequencies
v$object_privilege
v$persistent_publishers
v$persistent_qmn_cache
v$persistent_queues
v$persistent_subscribers
v$policy_history
v$process_group
v$px_instance_group
v$qmon_coordinator_stats
v$qmon_server_stats
v$qmon_task_stats
v$qmon_tasks
v$recovery_area_usage
v$redo_dest_resp_histogram
v$result_cache_dependency
v$result_cache_memory
v$result_cache_objects
v$result_cache_statistics
v$rman_compression_algorithm
v$rman_encryption_algorithms
v$rsrcmgrmetric
v$rsrcmgrmetric_history
v$securefile_timer
v$segspace_usage
v$session_blockers
v$sql_cs_histogram
v$sql_cs_selectivity
v$sql_cs_statistics
v$sql_feature
v$sql_feature_dependency
v$sql_feature_hierarchy
v$sql_hint
v$sql_monitor
v$sql_plan_monitor
v$sqlcommand
v$sqlfn_arg_metadata
v$sqlfn_metadata
v$sqlpa_metric
v$sqlstats_plan_hash
v$sscr_sessions
v$standby_event_histogram
v$streams_message_tracking
v$streams_pool_statistics
v$subscr_registration_stats
v$toplevelcall
v$wait_chains
v$wlm_pc_stats
v$wlm_pcmetric
v$wlm_pcmetric_history
v$workload_replay_thread
v$xstream_capture
v$xstream_message_tracking
v$xstream_outbound_serverv$xstream_transaction
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
