Oracle Dynamic Performance Views Version 12.2.0.1

Wesley13
• 阅读 1038

Oracle Dynamic Performance Views
Version 12.2.0.1

https://www.morganslibrary.org/reference/dyn_perf_view.html

General Information

Library Note

Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.

Page Notes

V$ view are views based on X$ arrays. The GV$ views are Global V$ views that have, as their first column, the instance identifier (INST_ID). You should always use GV$ rather than V$ where-ever possible. To examine their SQL definitions open the file $ORACLE_HOME/rdbms/admin/cdfixed.sql.

Dynamic Performance View Growth

Version

Number Views

6

23

7.1

72

8.1

185

9.2

259

10.1

340

10.2

372

11.1

484

11.2

525

12.1

606

12.2

746

Categories

Sections

Advanced Queuing (AQ)

Fixed Views

Parameters

Advisors

Flashback Database

Processes

Archive Logging

Flashback Recovery Area

RAC

ASH

Flashback Transaction

Redo Logs

ASM

GoldenGate

Resource Usage

Backup & Recovery

Hang Detection

Result Cache

Buffers

Health Management

Rollback/Undo Segments

Caches

I/O

Rules

Connection Pool

In-Memory Database

Security & Privileges

Container Database

Instance

Services

Control File

Keywords

Sessions

Cursors & SQL Statements

Latches & Locks

Shared Server

Data Guard & Standbys

Log Miner

Storage

Database Links

Materialized View Refresh

Streams

Data Pump

Memory Utilization

System Statistics

Diagnostics

Metrics

Temp Space

Direct Loader

Miscellaneous

Transportable Platform

Direct NFS

OLAP

Waits

Edition Based Redefinition

Optimizer

Workload Management

Exadata

Oracle File System (OFS)

Workload Replay

Feature Usage

Parallel Query

XStreams

Query to identify V$ views not duplicated as GV$ views

set linesize 121

SELECT object_name
FROM dba_objects_ae
WHERE object_name LIKE 'V%$%'
AND object_type = 'VIEW'
MINUS
SELECT SUBSTR(object_name, 2)
FROM dba_objects_ae
WHERE object_name LIKE 'GV%$%'
AND object_type = 'VIEW'
ORDER BY 1;

 

Advanced Queuing

 

gv$aq

gv$aq_server_pool

gv$aq1

gv$aq_sharded_subscriber_stat Oracle Dynamic Performance Views Version 12.2.0.1

gv$aq_background_coordinator

gv$aq_subscriber_load

gv$aq_bmap_nondur_subscribers

gv$aq_uncached_subshards Oracle Dynamic Performance Views Version 12.2.0.1

gv$aq_cached_subshards Oracle Dynamic Performance Views Version 12.2.0.1

gv$buffered_publishers

gv$aq_cross_instance_jobs

gv$buffered_queues

gv$aq_inactive_subshards Oracle Dynamic Performance Views Version 12.2.0.1

gv$buffered_subscribers

gv$aq_job_coordinator

gv$persistent_publishers

gv$aq_message_cache

gv$persistent_qmn_cache

gv$aq_message_cache_advice Oracle Dynamic Performance Views Version 12.2.0.1

gv$persistent_queues

gv$aq_message_cache_staat Oracle Dynamic Performance Views Version 12.2.0.1

gv$persistent_subscribers

gv$aq_msgbm

gv$qmon_coordinator_stats

gv$aq_nondur_registrations

gv$qmon_server_stats

gv$aq_nondur_subscriber

gv$qmon_tasks

gv$aq_nondur_subscriber_lwm

gv$qmon_task_stats

gv$aq_notification_clients

gv$queue

gv$aq_remote_dequqeue_affinity Oracle Dynamic Performance Views Version 12.2.0.1

gv$queueing_mth

 

Advisors

 

gv$advisor_current_sqlplan

gv$sga_target_advice

gv$advisor_progress

gv$shared_pool_advice

gv$java_pool_advice

v$stats_advisor_actions Oracle Dynamic Performance Views Version 12.2.0.1

gv$memory_target_advice

v$stats_advisor_findings Oracle Dynamic Performance Views Version 12.2.0.1

gv$mttr_target_advice

v$stats_advisor_rationales Oracle Dynamic Performance Views Version 12.2.0.1

gv$pga_target_advice

v$stats_advisor_recs Oracle Dynamic Performance Views Version 12.2.0.1

gv$pga_target_advice_histogram

v$stats_advisor_rules Oracle Dynamic Performance Views Version 12.2.0.1

gv$px_buffer_advice

 

 

Archive Logging

 

gv$archive

gv$archive_processes

gv$archived_log

gv$proxy_archivedlog

gv$archive_dest

v$proxy_archivelog_details

gv$archive_dest_status

v$proxy_archivelog_summary

gv$archive_gap

 

 

ASH

 

gv$active_session_history

gv$max_active_sess_target_mth

gv$ash_info

 

 

ASM

 

gv$asm_acfsrepl

gv$asm_dbclone_info Oracle Dynamic Performance Views Version 12.2.0.1

gv$asm_acfsrepltag

gv$asm_disk

gv$asm_acfssnapshots

gv$asm_diskgroup

gv$asm_acfstag

gv$asm_diskgroup_sparse Oracle Dynamic Performance Views Version 12.2.0.1

gv$asm_acfsvolumes

gv$asm_diskgroup_stat

gv$asm_acfs_encryption_info

gv$asm_disk_iostat

gv$asm_acfs_security_info

gv$asm_disk_sparse

gv$asm_acfs_sec_admin

gv$asm_disk_sparse_stat

gv$asm_acfs_sec_cmdrule

gv$asm_disk_stat

gv$asm_acfs_sec_realm

gv$asm_estimate

gv$asm_acfs_sec_realm_filter

gv$asm_file

gv$asm_acfs_sec_realm_group

gv$asm_filegroup Oracle Dynamic Performance Views Version 12.2.0.1

gv$asm_acfs_sec_realm_user

gv$asm_filegroup_file Oracle Dynamic Performance Views Version 12.2.0.1

gv$asm_acfs_sec_rule

gv$asm_filegroup_property Oracle Dynamic Performance Views Version 12.2.0.1

gv$asm_acfs_sec_ruleset

gv$asm_filesystem

gv$asm_acfs_sec_ruleset_rule

gv$asm_operation

gv$asm_alias

gv$asm_quotagroup Oracle Dynamic Performance Views Version 12.2.0.1

gv$asm_attribute

gv$asm_template

gv$asm_audit_cleanup_jobs

gv$asm_user

gv$asm_audit_clean_events

gv$asm_usergroup

gv$asm_audit_config_params

gv$asm_usergroup_member

gv$asm_audit_last_arch_ts

gv$asm_volume

gv$asm_client

gv$asm_volume_stat

 

Backup and Recovery (RMAN)

 

gv$backup

gv$db_transportable_platform

v$backup_archivelog_details

gv$deleted_object

v$backup_archivelog_summary

gv$fast_start_servers

gv$backup_async_io

gv$fast_start_transactions

v$backup_controlfile_details

gv$database_block_corruption

v$backup_controlfile_summary

gv$instance_recovery

v$backup_copy_details

v$proxy_copy_details

v$backup_copy_summary

v$proxy_copy_summary

gv$backup_corruption

gv$proxy_datafile

gv$backup_datafile

v$recovery_area_usage

v$backup_datafile_details

v$recovery_file_dest

v$backup_datafile_summary

gv$recovery_file_status

gv$backup_device

gv$recovery_log

v$backup_files

gv$recovery_progress

gv$backup_nonlogged

gv$recovery_slave Oracle Dynamic Performance Views Version 12.2.0.1

gv$backup_piece

gv$recovery_status

v$backup_piece_details

gv$recover_file

gv$backup_redolog

v$restore_range

gv$backup_set

v$rman_backup_job_details

v$backup_set_details

v$rman_backup_subjob_details

v$backup_set_summary

v$rman_backup_type

gv$backup_spfile

gv$rman_compression_algorithm

v$backup_spfile_details

gv$rman_configuration

v$backup_spfile_summary

v$rman_encryption_algorithms

gv$backup_sync_io

gv$rman_output

v$block_change_tracking

gv$tsm_sessions

gv$copy_corruption

v$rman_status

gv$copy_nonlogged

v$sbt_restore_range

gv$database_incarnation

gv$shadow_datafile Oracle Dynamic Performance Views Version 12.2.0.1

gv$datafile_copy

v$unusable_backupfile_details

 

Buffers

 

gv$bh

gv$buffer_pool_statistics

gv$buffer_pool

 

 

Caches

bsp = block server background process

gv$bsp

gv$library_cache_memory

gv$cache

gv$map_comp_list

v$cache_lock

gv$map_element

v$cache_transfer

gv$map_ext_element

gv$class_cache_transfer

gv$map_file

gv$class_ping

gv$map_file_extent

gv$cr_block_server

gv$map_file_io_stack

gv$current_block_server

gv$map_library

gv$db_cache_advice

gv$map_subelement

gv$db_object_cache

gv$propagation_receiver

gv$gcshvmaster_info

gv$propagation_sender

gv$gcspfmaster_info

gv$rowcache

gv$hvmaster_info

gv$rowcache_parent

gv$instance_cache_transfer

gv$rowcache_subordinate

gv$java_library_cache_memory

gv$subcache

gv$javapool

gv$temp_ping

gv$librarycache

 

 

Connection Pool

 

gv$cpool_cc_info

gv$cpool_conn_info

gv$cpool_cc_stats

gv$cpool_stats

 

Container Database

 

gv$clonedfile

gv$con_system_wait_class

gv$containers

gv$con_sys_time_model

gv$con_event_histogram_micro Oracle Dynamic Performance Views Version 12.2.0.1

v$diag_pdb_problem Oracle Dynamic Performance Views Version 12.2.0.1

gv$con_sysmetric Oracle Dynamic Performance Views Version 12.2.0.1

v$diag_pdb_space_mgmt Oracle Dynamic Performance Views Version 12.2.0.1

gv$con_sysmetric_history Oracle Dynamic Performance Views Version 12.2.0.1

gv$pdbs

gv$con_sysmetric_summary Oracle Dynamic Performance Views Version 12.2.0.1

gv$pdb_incarnation

gv$con_sysstat

gv$proxy_pdb_targets Oracle Dynamic Performance Views Version 12.2.0.1

gv$con_system_event

gv$zonemap_usage_stats Oracle Dynamic Performance Views Version 12.2.0.1

 

Control Files

 

gv$controlfile

gv$controlfile_record_section

 

Cursors and SQL Statements

 

gv$object_dependency

gv$sql_monitor_sesstat

gv$open_cursor

gv$sql_monitor_statname

gv$sql

gv$sql_plan

gv$sqlarea

gv$sql_plan_monitor

gv$sqlarea_plan_hash

gv$sql_plan_statistics

gv$sqlstats

gv$sql_plan_statistics_all

gv$sqlstats_plan_hash

gv$sql_redirection

gv$sqltext

gv$sql_diag_repository

gv$sqltext_with_newlines

gv$sql_diag_repository_reason

gv$sql_bind_capture

gv$sql_shared_cursor

gv$sql_bind_data

gv$sql_shared_memory

gv$sql_bind_metadata

gv$sql_workarea

gv$sql_cursor

gv$sql_workarea_active

gv$sql_join_filter

gv$sql_workarea_histogram

gv$sql_monitor

 

 

Data Guard & Standby Databases

 

gv$dataguard_config

gv$logstdby

gv$dataguard_process Oracle Dynamic Performance Views Version 12.2.0.1

gv$logstdby_process

gv$dataguard_stats

gv$logstdby_progress

v$dataguard_status

gv$logstdby_state

gv$dg_broker_config

gv$logstdby_stats

gv$foreign_archived_log

gv$logstdby_transaction

gv$fs_failover_histogram

gv$managed_standby

gv$fs_failover_observers Oracle Dynamic Performance Views Version 12.2.0.1

gv$rfs_thread

gv$fs_failover_stats

gv$standby_log

gv$fs_observer_histogram

v$standby_event_histogram

 

Database Links & Heterogeneous Services

 

gv$dblink

gv$hs_parameter

gv$hs_agent

gv$hs_session

 

Data Pump

 

gv$datapump_job

gv$datapump_session

 

Diagnostics

 

v$diag_adr_control

v$diag_sess_sql_trace_records Oracle Dynamic Performance Views Version 12.2.0.1

v$diag_adr_control_aux Oracle Dynamic Performance Views Version 12.2.0.1

gv$diag_sql_trace_records Oracle Dynamic Performance Views Version 12.2.0.1

v$diag_adr_invalidation

v$diag_sweeperr

v$diag_alert_ext (source is x$dbgalertext)

gv$diag_trace_file Oracle Dynamic Performance Views Version 12.2.0.1

v$diag_ams_xaction

gv$diag_trace_file_contents Oracle Dynamic Performance Views Version 12.2.0.1

gv$diag_app_trace_file Oracle Dynamic Performance Views Version 12.2.0.1

v$diag_vem_user_actlog

v$diag_critical_error

v$diag_vem_user_actlog1

v$diag_dde_user_action

v$diag_vhm_run

v$diag_dde_user_action_def

v$diag_view

v$diag_dde_usr_act_param

v$diag_viewcol

v$diag_dde_usr_act_param_def

v$diag_vincident

v$diag_dde_usr_inc_act_map

v$diag_vincident_file

v$diag_dde_usr_inc_type

v$diag_vinc_meter_info

v$diag_dfs_purge Oracle Dynamic Performance Views Version 12.2.0.1

v$diag_vips_file_copy_log

v$diag_dfw_config_capture

v$diag_vips_file_metadata

v$diag_dfw_config_item

v$diag_vips_package_file

v$diag_dfw_patch_capture

v$diag_vips_package_history

v$diag_dfw_patch_item

v$diag_vips_package_main_int

v$diag_dfw_purge Oracle Dynamic Performance Views Version 12.2.0.1

v$diag_vips_package_size

v$diag_dfw_purge_item Oracle Dynamic Performance Views Version 12.2.0.1

v$diag_vips_pkg_file

v$diag_diagvincident

v$diag_vips_pkg_inc_cand

v$diag_dir_ext

v$diag_vips_pkg_inc_dtl

v$diag_em_diag_job

v$diag_vips_pkg_inc_dtl1

v$diag_em_target_info

v$diag_vips_pkg_main_problem

v$diag_em_user_activity

v$diag_vnot_exist_incident

v$diag_incckey

v$diag_vpdb_problem Oracle Dynamic Performance Views Version 12.2.0.1

v$diag_incident

v$diag_vproblem

v$diag_incident_file

v$diag_vproblem1

v$diag_inc_meter_config

v$diag_vproblem2

v$diag_inc_meter_impt_def

v$diag_vproblem_bucket

v$diag_inc_meter_info

v$diag_vproblem_bucket1

v$diag_inc_meter_pk_impts

v$diag_vproblem_bucket_count

v$diag_inc_meter_summary

v$diag_vproblem_int

gv$diag_info

v$diag_vproblem_lastinc

v$diag_ips_configuration

v$diag_vshowcatview

v$diag_ips_file_copy_log

v$diag_vshowincb

v$diag_ips_file_metadata

v$diag_vshowincb_i

v$diag_ips_package

v$diag_vtest_exists

v$diag_ips_package_file

v$diag_v_actinc

v$diag_ips_package_history

v$diag_v_actprob

v$diag_ips_package_incident

v$diag_v_inccount

v$diag_ips_pkg_unpack_hist

v$diag_v_incfcount

v$diag_ips_progress_log

v$diag_v_inc_meter_info_prob

v$diag_ips_remote_package

v$diag_v_ipsprbcnt

v$diag_log_ext

v$diag_v_ipsprbcnt1

gv$diag_opt_trace_records Oracle Dynamic Performance Views Version 12.2.0.1

v$diag_v_nfcinc

v$diag_pdb_problem Oracle Dynamic Performance Views Version 12.2.0.1

v$diag_v_swperrcount

v$diag_pdb_space_mgmt Oracle Dynamic Performance Views Version 12.2.0.1

gv$incmeter_config

v$diag_pickleerr

gv$incmeter_info

v$diag_problem

gv$incmeter_summary

v$diag_relmd_ext

gv$plsql_debuggable_sessions Oracle Dynamic Performance Views Version 12.2.0.1

v$diag_sess_opt_trace_records Oracle Dynamic Performance Views Version 12.2.0.1

 

 

Direct Loader

 

gv$loadistat

gv$loadpstat

 

Direct NFS & NFS

 

gv$dnfs_channels

gv$nfs_clients

gv$dnfs_files

gv$nfs_locks

gv$dnfs_servers

gv$nfs_open_files

gv$dnfs_stats

 

 

Edition Based Redefinition

 

gv$editionable_types

 

 

Exadata

 

gv$cell

v$cell_ioreason

gv$cell_config

v$cell_ioreason_name

v$cell_config_info

v$cell_metric_desc

v$cell_db

gv$cell_ofl_thread_history

v$cell_db_history

v$cell_open_alerts

v$cell_disk

gv$cell_request_totals

v$cell_disk_history

gv$cell_state

v$cell_global

gv$cell_thread_history

v$cell_global_history

 

 

Features and Feature Usage

 

gv$sql_feature

gv$sql_feature_hierarchy

gv$sql_feature_dependency

 

 

Fixed Views

 

gv$fixed_table

gv$transportable_platform

gv$fixed_view_definition

gv$version

gv$indexed_fixed_column

 

`SELECT * FROM v$version;

BANNER                                                                       CON_ID


Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production      0
PL/SQL Release 12.2.0.1.0 - Production                                            0
CORE 12.2.0.1.0 Production                                                        0
TNS for Linux: Version 12.2.0.1.0 - Production                                    0
NLSRTL Version 12.2.0.1.0 - Production                                            0`

 

Flashback Database

 

gv$flashback_database_log

v$flashback_txn_mods

gv$flashback_database_logfile

v$recovery_area_usage

gv$flashback_database_stat

gv$restore_point

v$flashback_txn_graph

 

 

Flashback Recovery Area

 

v$flash_recovery_area_usage

v$recovery_area_usage

 

Flashback Transaction

 

v$flashback_txn_graph

v$flashback_txn_mods

 

GoldenGate

 

gv$gg_apply_coordinator

gv$goldengate_capture

gv$gg_apply_reader

gv$goldengate_message_tracking

gv$gg_apply_receiver

gv$goldengate_procedure_stats Oracle Dynamic Performance Views Version 12.2.0.1

gv$gg_apply_server

v$goldengate_table_stats

gv$goldengate_capabilities

v$goldengate_transaction

 

Hang Detection

 

v$hang_info

gv$hang_statistics

v$hang_session_info

 

 

Health Management

 

v$diag_hm_fdg_set

gv$hm_info

v$diag_hm_finding

gv$hm_recommendation

v$diag_hm_info

gv$hm_run

v$diag_hm_message

gv$ir_failure

v$diag_hm_recommendation

gv$ir_failure_set

v$diag_hm_run

gv$ir_manual_checklist

gv$hm_check

gv$ir_repair

gv$hm_check_param

gv$session_fix_control

gv$hm_finding

gv$system_fix_control

 

In-Memory Database

 

gv$imeu_header Oracle Dynamic Performance Views Version 12.2.0.1

gv$im_segments

gv$im_adoelements Oracle Dynamic Performance Views Version 12.2.0.1

gv$im_segments_detail

gv$im_adotaskdetails Oracle Dynamic Performance Views Version 12.2.0.1

gv$im_seg_ext_map

gv$im_adotasks Oracle Dynamic Performance Views Version 12.2.0.1

gv$im_smu_chunk

gv$im_column_level

gv$im_smu_head

gv$im_col_cu

gv$im_tbs_ext_map

gv$im_header

gv$im_user_segments

gv$im_imecol_cuU Oracle Dynamic Performance Views Version 12.2.0.1

gv$inmemory_area

gv$im_segdict Oracle Dynamic Performance Views Version 12.2.0.1

gvinmemory_faststart_area Oracle Dynamic Performance Views Version 12.2.0.1

gv$im_segdict_piecemap Oracle Dynamic Performance Views Version 12.2.0.1

gv$inmemory_xmem_area Oracle Dynamic Performance Views Version 12.2.0.1

gv$im_segdict_sortorder Oracle Dynamic Performance Views Version 12.2.0.1

gv$scheduler_inmem_mdinfo

gv$im_segdict_version Oracle Dynamic Performance Views Version 12.2.0.1

gv$scheduler_inmem_rtinfo

 

I/O

 

gv$file_histogram

 

gv$file_optimized_histogram

gv$iostat_function

gv$filemetric

gv$iostat_function_detail

gv$filemetric_history

gv$iostat_network

gv$filestat

gv$io_calibration_status

gv$iofuncmetric

gv$io_outlier

gv$iofuncmetric_history

gv$kernel_io_outlier

gv$iostat_consumer_group

gv$lgwrio_outlier

gv$iostat_file

gv$tempstat

`CREATE TABLE avg_read_write
(inst_id, avg_read_time, avg_write_time) AS
SELECT inst_id, AVG(average_read_time), AVG(average_write_time)
FROM gv$filemetric_history
WHERE 0=1
GROUP BY inst_id;

CREATE OR REPLACE PROCEDURE file_io_metrics AUTHID DEFINER IS
BEGIN
  INSERT INTO avg_read_write
  (inst_id, avg_read_time, avg_write_time)
  SELECT inst_id, AVG(average_read_time), AVG(average_write_time)
  FROM gv$filemetric_history
  WHERE average_read_time IS NOT NULL
  AND average_write_time IS NOT NULL
  GROUP BY inst_id
  ORDER BY 1;

  COMMIT;
END file_io_metrics;
/

exec file_io_metrics

-- sample output
INST_ID    AVG(AVERAGE_READ_TIME) AVG(AVERAGE_WRITE_TIME)


         5             .844172725              .027063522
         6             .542269401              .029147572
         7             .846074066              .186608746
         8            1.102195470              .071913735
         9             .519971963              .029391265
        10             .586967514              .071486951`

 

Instance

 

gv$active_instances

gv$instance_ping

gv$instance

 

 

Keywords

Reserved Words

Warning: This is an incomplete list of reserved words.

`desc gv$reserved_words

set linesize 121
set pagesize 0

SELECT keyword
FROM gv$reserved_words
ORDER BY 1;`

 

Latches & Locks

 

gv$dlm_all_locks

gv$latchholder

gv$dlm_convert_local

gv$latchname

gv$dlm_convert_remote

gv$latch_children

gv$dlm_latch

gv$latch_misses

gv$dlm_locks

gv$latch_parent

gv$dlm_misc

gv$libcache_locks

gv$dlm_ress

gv$lock

gv$dlm_traffic_controller

gv$locked_object

gv$enqueue_lock

gv$locks_with_collisions

gv$enqueue_stat

gv$lock_activity

gv$enqueue_statistics

gv$lock_element

gv$event_name

gv$lock_type

gv$file_ping

gv$mutex_sleep

gv$ges_blocking_enqueue

gv$mutex_sleep_history

gv$ges_deadlocks

gv$process

gv$ges_deadlock_sessions

gv$resource

gv$ges_enqueue

gv$resource_limit

gv$global_blocked_locks

gv$transaction_enqueue

gv$latch

gv_$_lock

 

Log Miner

 

gv$logmnr_contents

gv$logmnr_parameters

gv$logmnr_dictionary

gv$logmnr_process

gv$logmnr_dictionary_load

gv$logmnr_session

gv$logmnr_latch

gv$logmnr_stats

gv$logmnr_logfile

gv$logmnr_transaction

gv$logmnr_logs

 

 

Materialized View Refresh

 

gv$mvrefresh

 

 

Memory Utilization

 

gv$memory_current_resize_ops

gv$sgastat

gv$memory_dynamic_components

gv$sga_current_resize_ops

gv$memory_resize_ops

gv$sga_dynamic_components

gv$memory_target_advice

gv$sga_dynamic_free_memory

gv$pgastat

gv$sga_resize_ops

gv$process_memory

gv$sga_target_advice

gv$sga

gv$shared_pool_advice

gv$sgainfo

gv$shared_pool_reserved

 

Metrics

 

gv$alert_types

gv$metric_history

gv$eventmetric

gv$sqlpa_metric

gv$event_histogram

gv$sysmetric

gv$metric

gv$sysmetric_history

gv$metricgroup

gv$sysmetric_summary

gv$metricname

gv$threshold_types

 

Miscellaneous

 

gv$auto_bmr_statistics Oracle Dynamic Performance Views Version 12.2.0.1

gv$object_dml_frequencies

gv$bgprocess

v$object_usage (deprecated as of 12cR1 but still in 12cR2)

gv$blocking_quiesce

gv$online_redef Oracle Dynamic Performance Views Version 12.2.0.1

gv$bts_stat

gv$option

gv$bt_scan_cache

gv$patches

gv$bt_scan_obj_temps

gv$ping

gv$calltag

gv$policy_history

gv$code_clause Oracle Dynamic Performance Views Version 12.2.0.1

gv$quarantine Oracle Dynamic Performance Views Version 12.2.0.1

gv$context

gv$resumable

gv$corrupt_xid_list

gv$scheduler_running_jobs

gv$database

gv$securefile_timer

gv$db_pipes

gv$sqlcommand

gv$dead_cleanup

gv$sqlfn_arg_metadata

gv$detached_session

gv$sqlfn_metadata

v$disk_restore_range

gv$sql_cs_histogram

gv$emon

gv$sql_cs_selectivity

gv$emx_usage_stats

gv$sql_cs_statistics

gv$exp_stats Oracle Dynamic Performance Views Version 12.2.0.1

gv$sscr_sessions

gv$false_ping (deprecated as of 12cR1)

gv$subscr_registration_stats

gv$flashfilestat

gv$sysaux_occupants

gv$gcr_actions Oracle Dynamic Performance Views Version 12.2.0.1

gv$sys_report_requests

gv$gcr_log Oracle Dynamic Performance Views Version 12.2.0.1

gv$sys_report_stats

gv$gcr_metrics Oracle Dynamic Performance Views Version 12.2.0.1

gv$timer

gv$gcr_status Oracle Dynamic Performance Views Version 12.2.0.1

gv$timezone_file

gv$heat_map_segment

gv$timezone_names

gv$ios_client

gv$toplevelcall

v_$kccdi

gv$type_size

v_$kccfe

v$unified_audit_record_format

gv$key_vector

gv$unified_audit_trial

v_$kxftask

gv$xs_sessions

gv$license

gv$xs_session_ns_attributes

gv$listener_network

gv$xs_session_roles

gv$mapped_sql

v_x$kswsastab

gv$nonlogged_block

 

`SELECT *
FROM gv$type_size
ORDER BY 3;

SELECT clause_name, parameter_name
FROM gv$code_clause
ORDER BY 1,2;

CLAUSE_NAME                    PARAMETER_NAME


ADVISE
ARCHIVE LOG                    ALL
ARCHIVE LOG                    CHANGE
ARCHIVE LOG                    CURRENT
ARCHIVE LOG                    GROUP
ARCHIVE LOG                    LOGFILE
ARCHIVE LOG                    NEXT
ARCHIVE LOG                    SEQUENCE
CHECK DATAFILES
CHECKPOINT
CLOSE DATABASE LINK
COMMIT IN PROCEDURE
COPY LOGFILE
DISTRIBUTED RECOVERY
DUMP                           DATAFILE
DUMP                           FLASHBACK
DUMP                           LOGFILE
DUMP                           REDO
DUMP                           TEMPFILE
DUMP                           UNDO
END SESSION                    DISCONNECT SESSION
END SESSION                    KILL SESSION
FLUSH                          BUFFER CACHE
FLUSH                          FLASH_CACHE
FLUSH                          GLOBAL CONTEXT
FLUSH                          REDO
FLUSH                          SHARED_POOL 
GUARD
ILM                            ROW ACCESS TRACKING
ILM                            ROW MODIFICATION TRACKING
LOGICAL REPLICATION
PARALLEL DDL
PARALLEL DML
PARALLEL QUERY
QUIESCE                        QUIESCE RESTRICTED
QUIESCE                        UNQUIESCE
REFRESH                        LDAP_REGISTRATION
REGISTER
RESET
RESUMABLE
RESUME
SECURITY                       RESTRICTED SESSION
SECURITY                       SET ENCRYPTION KEY
SECURITY                       SET ENCRYPTION WALLET
SET                            APPLICATION ACTION
SET                            APPLICATION MODULE
SET                            CONSTRAINTS
SET                            CONTAINER
SET                            CURRENT_SCHEMA
SET                            EDITION
SET                            ERROR_ON_OVERLAP_TIME
SET                            EVENTS
SET                            EVENTS
SET                            FLAGGER
SET                            GLOBAL_TOPIC_ENABLED
SET                            ILM VISIBILITY
SET                            INSTANCE
SET                            ISOLATION_LEVEL
SET                            LDAP_REGISTRATION_ENABLED
SET                            LDAP_REG_SYNC_INTERVAL
SET                            LOG_READ_ONLY_VIOLATIONS
SET                            SINGLETASK DEBUG
SET                            SQL_TRANSLATION_PROFILE
SET                            STANDBY_MAX_DATA_DELAY
SET                            TIME_ZONE
SET                            USE_PRIVATE_OUTLINES
SET                            USE_STORED_OUTLINES
SET                            USE_STORED_OUTLINES
SET
SET
SHARD DDL
SHARD OPERATIONS
SHUTDOWN
SUSPEND
SWITCH LOGFILE
SYNC WITH PRIMARY
TX RECOVERY`

 

OLAP

 

gv$aw_aggregate_op

gv$aw_longops

gv$aw_allocate_op

gv$aw_olap

gv$aw_calc

gv$aw_session_info

 

Optimizer

 

gv$column_statistics Oracle Dynamic Performance Views Version 12.2.0.1

gv$sql_hint

gv$index_usage_info Oracle Dynamic Performance Views Version 12.2.0.1

gv$sql_optimizer_env

gv$optimizer_processing_rate

gv$sql_reoptimization_hints

gv$rt_addm_control

gv$sys_optimizer_env

gv$ses_optimizer_env

 

 

Oracle File System (OFS)

 

gv$ofsmount

gv$ofs_stats

 

Parallel Query

 

gv$execution

gv$px_instance_group

gv$parallel_degree_limit_mth

gv$px_process

gv$pq_sesstat

gv$px_process_sysstat

gv$pq_slave

gv$px_process_trace

gv$pq_sysstat

gv$px_session

gv$pq_tqstat

gv$px_sesstat

gv$px_buffer_advice

gv$qpx_inventory

 

Parameters

Session specific information for connected sessions.

This query shows the values that are non-default and deprecated. These will most likely trigger a warning message during startup.

gv$nls_parameters

gv$spparameter

gv$nls_valid_values

gv$system_parameter

gv$obsolete_parameter

gv$system_parameter2

gv$parameter

gv$system_reset_parameter Oracle Dynamic Performance Views Version 12.2.0.1

gv$parameter2

gv$system_reset_parameter2 Oracle Dynamic Performance Views Version 12.2.0.1

gv$parameter_valid_values

 

`desc gv$parameter

set linesize 121
set pagesize 25
col name format a35
col value format a70

SELECT name, value
FROM gv$parameter
WHERE isdefault = 'FALSE'
AND isdeprecated = 'TRUE'
ORDER BY 1;`

 

Processes

 

gv$cleanup_process Oracle Dynamic Performance Views Version 12.2.0.1

gv$process_memory_detail_prog

gv$process_group

gv$process_pool Oracle Dynamic Performance Views Version 12.2.0.1

gv$process_memory_detail

gv$process_priority_data Oracle Dynamic Performance Views Version 12.2.0.1

 

Real Application Clusters (RAC)

 

gv$active_instances

gv$gc_element

gv$cluster_interconnects

gv$gc_elements_with_collisions

gv$configured_interconnects

gv$instance_cache_transfer

gv$dynamic_remaster_stats

gv$temp_cache_transfer

gv$file_cache_transfer

 

 

Redo Logs

 

gv$instance_log_group

gv$log_history

gv$log

gv$redo_dest_resp_histogram

gv$logfile

v$rollname

gv$loghist

gv$thread

 

Resource Usage

Resource limits and resource utilization

gv$access

gv$rsrc_plan_cpu_mth

gv$iostat_consumer_group

gv$rsrc_plan_history

gv$rsrcmgrmetric

gv$rsrc_session_info

gv$rsrcmgrmetric_history

gv$rsrcpdbmetric Oracle Dynamic Performance Views Version 12.2.0.1

gv$rsrc_consumer_group

gv$rsrcpdbmetric_history Oracle Dynamic Performance Views Version 12.2.0.1

gv$rsrc_consumer_group_cpu_mth

gv$rsrc_pdb Oracle Dynamic Performance Views Version 12.2.0.1

gv$rsrc_cons_group_history

gv$rsrc_pdb_history Oracle Dynamic Performance Views Version 12.2.0.1

gv$rsrc_plan

 

`desc gv$resource_limit

SELECT * FROM gv$resource_limit;`

 

Result Cache

 

gv$client_result_cache_stats

gv$result_cache_objects

gv$result_cache_dependency

gv$result_cache_statistics

gv$result_cache_memory

 

 

Rollback Segments / Undo Segments

 

v$rollname

gv$undostat

gv$rollstat

 

 

Rules

 

gv$rule

gv$rule_set_aggregate_stats

gv$rule_set

 

 

Security, Privileges, Data Masking/Redaction

 

gv$client_secrets

v$object_privilege

gv$context

gv$passwordfile_info Oracle Dynamic Performance Views Version 12.2.0.1

gv$database_key_info

gv$pwfile_users

gv$enabledprivs

gv$ro_user_account

gv$encrypted_tablespaces

gv$tsdp_supported_feature

gv$encryption_keys

gv$unified_audit_trail

gv$encryption_wallet

gv$vpd_policy

gv$exadirect_acl Oracle Dynamic Performance Views Version 12.2.0.1

gv$wallet

gv$globalcontext

gv$xml_audit_trail

gv$ip_acl Oracle Dynamic Performance Views Version 12.2.0.1

 

 

`SQL> select * from gv$passwordfile_info;

 INST_ID FILE_NAME                                           FORMAT IS_AS  CON_ID


       1 /u01/app/oracle/product/12.2/db_1/dbs/orapworcl12c      12 FALSE       0`

 

Services

 

gv$active_services

gv$service_event

gv$servicemetric

gv$service_region_metric Oracle Dynamic Performance Views Version 12.2.0.1

gv$servicemetric_history

gv$service_stats

gv$service_wait_class

gv$services

 

Sessions

Session specific information for connected sessions

gv$active_session_history

gv$session_cursor_cache

gv$active_sess_pool_mth

gv$session_event

gv$client_stats

gv$session_fix_control

gv$mystat

gv$session_longops

gv$sess_io

gv$session_object_cache

gv$sess_time_model

gv$session_wait

gv$session

gv$session_wait_class

gv$session_blockers

gv$session_wait_history

gv$session_connect_info

gv$sessmetric

v$sessions_count

gv$sesstat

`desc gv$session

col username format a10
col schemaname format a10
col osuser format a25
col machine format a20
col service_name format a25
col program format a25
col terminal format a10

-- audsid: audit SID
SELECT sid, audsid, username, status, server, schemaname, osuser, type, service_name
FROM gv$session;

SELECT username, command, machine, terminal, program, state
FROM gv$session;`

 

Shared Servers (formerly MTS)

 

gv$circuit

gv$max_active_sess_target_mth

gv$dispatcher

gv$reqdist

gv$dispatcher_config

gv$shared_server

gv$dispatcher_rate

gv$shared_server_monitor

 

Storage

 

gv$datafile

gv$nfs_locks

gv$datafile_header

gv$nfs_open_files

gv$dbfile

gv$offline_range

gv$filespace_usage

gv$segspace_usage

gv$chunk_metric Oracle Dynamic Performance Views Version 12.2.0.1

gv$tablespace

gv$lobstat

gv$temporary_lobs

gv$nfs_clients

 

 

Streams

 

gv$streams_apply_coordinator

gv$streams_message_tracking

gv$streams_apply_reader

gv$streams_pool_advice

gv$streams_apply_server

gv$streams_pool_statistics

gv$streams_capture

gv$streams_transaction

 

System Statistics

 

gv$dml_stats Oracle Dynamic Performance Views Version 12.2.0.1

gv$statistics_level

gv$global_transaction

gv$statname

gv$osstat

gv$sysstat

gv$segment_statistics

gv$system_cursor_cache

gv$segstat

gv$system_event

gv$segstat_name

gv$sys_time_model

gv$serv_mod_act_stats

gv$transaction

gv$sort_usage

 

 

Temp Space

 

gv$sort_segment

gv$tempfile

gv$tempfile_info_instance Oracle Dynamic Performance Views Version 12.2.0.1

gv$tempseg_usage

gv$temp_extent_map

gv$tempstat

gv$temp_extent_pool

gv$tempundostat

gv$temp_space_header

 

 

Transportable Platforms

 

gv$transportable_platform

 

 

`SQL> SELECT *
  2  FROM gv$transportable_platform
  3* ORDER BY 2;

 INST_ID PLATFORM_ID PLATFORM_NAME                      ENDIAN_FORMAT   CON_ID


       1           1 Solaris[tm] OE (32-bit)            Big                  0
       1           2 Solaris[tm] OE (64-bit)            Big                  0
       1            3 HP-UX (64-bit)                    Big                  0
       1            4 HP-UX IA (64-bit)                 Big                  0
       1            5 HP Tru64 UNIX                     Little               0
       1            6 AIX-Based Systems (64-bit)        Big                  0
       1            7 Microsoft Windows IA (32-bit)     Little               0
       1            8 Microsoft Windows IA (64-bit)     Little               0
       1            9 IBM zSeries Based Linux           Big                  0
       1           10 Linux IA (32-bit)                 Little               0
       1           11 Linux IA (64-bit)                 Little               0
       1           12 Microsoft Windows x86 64-bit      Little               0
       1           13 Linux x86 64-bit                  Little               0
       1           15 HP Open VMS                       Little               0
       1           16 Apple Mac OS                      Big                  0
       1           17 Solaris Operating System (x86)    Little               0
       1           18 IBM Power Based Linux             Big                  0
       1           19 HP IA Open VMS                    Little               0
       1           20 Solaris Operating System (x86-64) Little               0
       1           21 Apple Mac OS (x86-64)             Little               0`

 

Waits

 

gv$channel_waits

gv$session_wait_history

gv$event_histogram_micro

gv$system_wait_class

gv$event_outliers Oracle Dynamic Performance Views Version 12.2.0.1

gv$waitclassmetric

gv$service_wait_class

gv$waitclassmetric_history

gv$session_blockers

gv$waitstat

gv$session_wait

v$wait_chains

gv$session_wait_class

 

 

Workload Management

 

gv$wlm_db_mode Oracle Dynamic Performance Views Version 12.2.0.1

gv$wlm_pcmetric_history

gv$wlm_pcmetric

gv$wlm_pc_stats

 

Workload Replay

 

gv$replay_context

gv$replay_context_systimestamp

gv$replay_context_lob

gv$wlm_pcmetric

gv$replay_context_sequence

gv$wlm_pcmetric_history

gv$replay_context_sysdate

gv$wlm_pc_stats

gv$replay_context_sysguid

gv$workload_replay_thread

 

XStreams

Heterogeneous Streams

gv$xstream_apply_coordinator

gv$xstream_message_tracking

v$xstream_apply_reader

gv$xstream_outbound_server

v$xstream_apply_receiver

v$xstream_table_stats

v$xstream_apply_server

gv$xstream_transaction

gv$xstream_capture

点赞
收藏
评论区
推荐文章
blmius blmius
3年前
MySQL:[Err] 1292 - Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘CREATE_TIME‘ at row 1
文章目录问题用navicat导入数据时,报错:原因这是因为当前的MySQL不支持datetime为0的情况。解决修改sql\mode:sql\mode:SQLMode定义了MySQL应支持的SQL语法、数据校验等,这样可以更容易地在不同的环境中使用MySQL。全局s
皕杰报表之UUID
​在我们用皕杰报表工具设计填报报表时,如何在新增行里自动增加id呢?能新增整数排序id吗?目前可以在新增行里自动增加id,但只能用uuid函数增加UUID编码,不能新增整数排序id。uuid函数说明:获取一个UUID,可以在填报表中用来创建数据ID语法:uuid()或uuid(sep)参数说明:sep布尔值,生成的uuid中是否包含分隔符'',缺省为
待兔 待兔
3个月前
手写Java HashMap源码
HashMap的使用教程HashMap的使用教程HashMap的使用教程HashMap的使用教程HashMap的使用教程22
Jacquelyn38 Jacquelyn38
3年前
2020年前端实用代码段,为你的工作保驾护航
有空的时候,自己总结了几个代码段,在开发中也经常使用,谢谢。1、使用解构获取json数据let jsonData  id: 1,status: "OK",data: 'a', 'b';let  id, status, data: number   jsonData;console.log(id, status, number )
Stella981 Stella981
3年前
Opencv中Mat矩阵相乘——点乘、dot、mul运算详解
Opencv中Mat矩阵相乘——点乘、dot、mul运算详解2016年09月02日00:00:36 \牧野(https://www.oschina.net/action/GoToLink?urlhttps%3A%2F%2Fme.csdn.net%2Fdcrmg) 阅读数:59593
Stella981 Stella981
3年前
AndroidStudio封装SDK的那些事
<divclass"markdown\_views"<!flowchart箭头图标勿删<svgxmlns"http://www.w3.org/2000/svg"style"display:none;"<pathstrokelinecap"round"d"M5,00,2.55,5z"id"raphael
Wesley13 Wesley13
3年前
00:Java简单了解
浅谈Java之概述Java是SUN(StanfordUniversityNetwork),斯坦福大学网络公司)1995年推出的一门高级编程语言。Java是一种面向Internet的编程语言。随着Java技术在web方面的不断成熟,已经成为Web应用程序的首选开发语言。Java是简单易学,完全面向对象,安全可靠,与平台无关的编程语言。
Stella981 Stella981
3年前
Android蓝牙连接汽车OBD设备
//设备连接public class BluetoothConnect implements Runnable {    private static final UUID CONNECT_UUID  UUID.fromString("0000110100001000800000805F9B34FB");
Wesley13 Wesley13
3年前
MySQL部分从库上面因为大量的临时表tmp_table造成慢查询
背景描述Time:20190124T00:08:14.70572408:00User@Host:@Id:Schema:sentrymetaLast_errno:0Killed:0Query_time:0.315758Lock_
Python进阶者 Python进阶者
9个月前
Excel中这日期老是出来00:00:00,怎么用Pandas把这个去除
大家好,我是皮皮。一、前言前几天在Python白银交流群【上海新年人】问了一个Pandas数据筛选的问题。问题如下:这日期老是出来00:00:00,怎么把这个去除。二、实现过程后来【论草莓如何成为冻干莓】给了一个思路和代码如下:pd.toexcel之前把这