#
One key task of the Oracle database professional is to perform
daily monitoring to ensure that the database environment is healthy
for Oracle. The following key v$ dynamic views allow the DBA to
quickly drill down into the Oracle database engine to quickly
assess the database statusV$DATABASE
V$INSTANCE V$OPTION V$LICENSE V$CONTROLFILE V$TABLESPACE V$DATAFILE V$LOG V$LOGFILE V$ARCHIVED_LOG V$TEMPFILEThe follow v$ views are used by the new result cache:
V$RESULT_CACHE_STATISTICS V$RESULT_CACHE_MEMORY V$RESULT_CACHE_OBJECTS V$RESULT_CACHE_DEPENDENCY V$CLIENT_RESULT_CACHE_STATS The Oracle RAT suite includes database replay and the following
v$ view provides details on usage and status for this key new
feature with Oracle.For the new feature for the Incident Repair component of the
ADR, there are the following v$ views: V$IR_FAILURE V$IR_REPAIR V$IR_MANUAL_CHECKLIST V$IR_FAILURE_SET The health monitor (HM) is linked to the following v$ views
listed below:V$HM_CHECK
V$HM_CHECK_PARAM V$HM_RUN V$HM_FINDING V$HM_RECOMMENDATION V$HM_INFO Oracle provides a new feature to setup NFS based files within
Oracle. The following v$ views provide the details for NFS
configurationwithin Oracle. V$NFS_CLIENTS V$NFS_OPEN_FILES V$NFS_LOCKS V$IOSTAT_NETWORKBackup and Recoveryis the
most important function of the serious Oracle DBA and can mean the
difference between life and death in terms of corporate safety and
job security. The following v$ views provide details for Oracle
Backup and Recovery. 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_CONFIGURATIONOracle RAC and ASM provide highly available robust
architectures for performance, service and reliability as part of
the Oracle Maximum Availability Architecture
(MAA). The following v$ views provide details on these key HA
technologies. 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 V$STREAMS_APPLY_COORDINATOR V$STREAMS_APPLY_SERVER V$STREAMS_APPLY_READER V$STREAMS_CAPTURE V$STREAMS_TRANSACTION V$STREAMS_MESSAGE_TRACKING 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 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_ATTRIBUTEPerformance tuning is a complex task that daunts many Oracle DBAs.
It is as much an art as a science. While GUI tools such as Oracle
Enterprise Manager and Quest TOAD provide a nice slick graphical
interface, to dig into the internal nuts and bolts of database
performance, the serious Oracle performance analyst relies on
reports generated by v$ dynamic performance views from within the
Oracle data dictionary. The following v$ views provide insight
into database tuning for Oracle.V$SESSION
V$WAITCLASSMETRIC V$WAITCLASSMETRIC_HISTORY V$WAITSTAT V$WAIT_CHAINSV$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_ALLV$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_ADVICENext, a useful way to generate the complete listing for all
Oracle v$ dynamic performance views
within the Oracle database environment will be shown.#
With each new major release and version of Oracle, dozens if
not hundreds of new dynamic performance v$ views are added. For
instance, in Oracle 10gR2, there are 398 dynamic performance v$
views. In Oracle 11g R1 there are now 484 dynamic performance v$
views which means that between 10gR2 and 11g R1, there are 86 new
v$ views in 11gR1. So how does one find out what all of the dynamic performance
views are within Oracle? Well, one needs a query such as the
following to run against the v$fixed_table
to obtain the full listing.SELECT NAME, TYPE
FROM V$FIXED_TABLE WHERE NAME LIKE 'V$%'; / SQL> SELECT NAME, TYPE 2 FROM V$FIXED_TABLE 3 WHERE NAME LIKE 'V$%';NAME
TYPE ------------------------------ ----- V$WAITSTAT VIEW V$BH VIEW V$GC_ELEMENT VIEW V$CR_BLOCK_SERVER VIEW V$CURRENT_BLOCK_SERVER VIEW V$ENCRYPTED_TABLESPACES VIEW V$GC_ELEMENTS_WITH_COLLISIONS VIEW V$FILE_CACHE_TRANSFER VIEW V$TEMP_CACHE_TRANSFER VIEW V$CLASS_CACHE_TRANSFER VIEW V$INSTANCE_CACHE_TRANSFER VIEW V$LOCK_ELEMENT VIEW V$BSP VIEW V$LOCKS_WITH_COLLISIONS VIEW V$FILE_PING VIEW V$TEMP_PING VIEW V$CLASS_PING VIEW V$LOCK_ACTIVITY VIEW V$ROWCACHE VIEW V$ROWCACHE_PARENT VIEW V$ROWCACHE_SUBORDINATE VIEW V$PROCESS VIEW V$BGPROCESS VIEW V$PROCESS_MEMORY VIEW V$PROCESS_MEMORY_DETAIL VIEW V$PROCESS_MEMORY_DETAIL_PROG VIEW V$SESSION VIEW V$RSRC_SESSION_INFO VIEW V$BLOCKING_QUIESCE VIEW V$PX_SESSION VIEW NAME
TYPE ------------------------------ ----- V$PX_SESSTAT VIEW V$SESSION_CONNECT_INFO VIEW V$SESSION_WAIT_HISTORY VIEW V$WAIT_CHAINS VIEW V$SESSION_WAIT VIEW V$SESSION_WAIT_CLASS VIEW V$SYSTEM_WAIT_CLASS VIEW V$SESSION_EVENT VIEW V$EVENT_HISTOGRAM VIEW V$SYSTEM_EVENT VIEW V$EVENT_NAME VIEW V$LICENSE VIEW V$TRANSACTION VIEW V$LOCKED_OBJECT VIEW V$LATCH VIEW V$LATCH_CHILDREN VIEW V$LATCH_PARENT VIEW V$LATCHNAME VIEW V$LATCHHOLDER VIEW V$LATCH_MISSES VIEW V$RESOURCE
VIEW V$_LOCK1 VIEW V$_LOCK VIEW V$LOCK VIEW V$ENQUEUE_LOCK VIEW V$TRANSACTION_ENQUEUE VIEW V$TIMER VIEW V$SESSTAT VIEW V$MYSTAT VIEW V$SESS_IO VIEW V$SYSSTAT
VIEW V$STATNAME VIEW V$OSSTAT VIEW V$RESOURCE_LIMIT VIEW V$ACCESS VIEW V$OBJECT_DEPENDENCY VIEW V$DBFILE VIEW V$ARCHIVE VIEW V$FILESTAT VIEW V$FILE_HISTOGRAM VIEW V$TEMPSTAT
VIEW V$LOGFILE VIEW V$ROLLSTAT VIEW V$FAST_START_SERVERS VIEW V$FAST_START_TRANSACTIONS VIEW V$SGA VIEW V$SGASTAT VIEW V$SGAINFO VIEW V$SGA_CURRENT_RESIZE_OPS VIEW V$SGA_RESIZE_OPS VIEW NAME TYPE ------------------------------ ----- V$SGA_DYNAMIC_COMPONENTS VIEW V$SGA_DYNAMIC_FREE_MEMORY VIEW V$MEMORY_CURRENT_RESIZE_OPS VIEW V$MEMORY_RESIZE_OPS VIEW V$MEMORY_DYNAMIC_COMPONENTS VIEW V$PARAMETER VIEW V$SYSTEM_PARAMETER VIEW V$PARAMETER2 VIEW V$SYSTEM_PARAMETER2 VIEW V$SYSTEM_PARAMETER4 VIEW V$OBSOLETE_PARAMETER
VIEW V$SPPARAMETER VIEW V$PARAMETER_VALID_VALUES VIEW V$CLUSTER_INTERCONNECTS VIEW V$CONFIGURED_INTERCONNECTS VIEW V$ENABLEDPRIVS VIEW V$DISPATCHER VIEW V$DISPATCHER_CONFIG VIEW V$DISPATCHER_RATE VIEW V$SHARED_SERVER VIEW V$QUEUE
VIEW V$REQDIST VIEW V$CIRCUIT VIEW V$LOADPSTAT VIEW V$LOADISTAT VIEW V$LIBRARY_CACHE_MEMORY VIEW V$SHARED_POOL_ADVICE VIEW V$JAVA_LIBRARY_CACHE_MEMORY VIEW V$JAVA_POOL_ADVICE VIEW V$STREAMS_POOL_ADVICE VIEW V$LIBRARYCACHE
VIEW V$SQLAREA VIEW V$SQL VIEW V$SQLAREA_PLAN_HASH VIEW V$SQL_SHARED_MEMORY VIEW V$SQLTEXT VIEW V$SQLTEXT_WITH_NEWLINES VIEW V$OPEN_CURSOR VIEW V$SUBCACHE VIEW V$DB_OBJECT_CACHE VIEW V$DB_PIPES
VIEW V$VERSION VIEW V$CONTROLFILE VIEW V$DATABASE VIEW V$THREAD VIEW V$INSTANCE_LOG_GROUP VIEW V$LOG VIEW V$STANDBY_LOG VIEW V$DATAFILE VIEW V$TEMPFILE VIEW V$LOGHIST
VIEW V$SEGSTAT_NAME VIEW V$SEGSTAT VIEW V$SEGMENT_STATISTICS VIEW V$LOBSTAT VIEW V$BUFFER_POOL VIEW V$BUFFER_POOL_STATISTICS VIEW V$INSTANCE VIEW V$TYPE_SIZE VIEW V$NLS_PARAMETERS VIEW V$NLS_VALID_VALUES
VIEW V$OPTION VIEW V$RECOVER_FILE VIEW V$BACKUP VIEW V$LOG_HISTORY VIEW V$ARCHIVE_GAP VIEW V$RECOVERY_LOG VIEW V$FIXED_TABLE VIEW V$INDEXED_FIXED_COLUMN VIEW V$FIXED_VIEW_DEFINITION VIEW V$SESSION_CURSOR_CACHE
VIEW V$SYSTEM_CURSOR_CACHE VIEW V$SHARED_SERVER_MONITOR VIEW V$PWFILE_USERS VIEW V$DBLINK VIEW V$PQ_SLAVE VIEW V$PX_PROCESS VIEW V$PQ_SESSTAT VIEW V$PQ_SYSSTAT VIEW V$PX_PROCESS_SYSSTAT VIEW V$PX_BUFFER_ADVICE
VIEW V$EXECUTION VIEW V$RECOVERY_STATUS VIEW V$RECOVERY_FILE_STATUS VIEW V$SHARED_POOL_RESERVED VIEW V$SORT_SEGMENT VIEW V$SORT_USAGE VIEW V$TEMP_EXTENT_MAP VIEW V$TEMP_EXTENT_POOL VIEW V$TEMP_SPACE_HEADER VIEW V$_SEQUENCES
VIEW V$PQ_TQSTAT VIEW V$PX_INSTANCE_GROUP VIEW V$ACTIVE_INSTANCES VIEW V$SQL_CURSOR VIEW V$SQL_BIND_METADATA VIEW V$SQL_SHARED_CURSOR VIEW V$SQL_BIND_DATA VIEW V$TABLESPACE VIEW V$RMAN_CONFIGURATION VIEW NAME
TYPE ------------------------------ ----- V$OFFLINE_RANGE VIEW V$ARCHIVED_LOG VIEW V$FOREIGN_ARCHIVED_LOG VIEW V$ARCHIVE_PROCESSES VIEW V$MANAGED_STANDBY VIEW V$DATAGUARD_STATUS VIEW V$ARCHIVE_DEST VIEW V$ARCHIVE_DEST_STATUS VIEW V$DATAGUARD_CONFIG VIEW V$SESSION_LONGOPS VIEW V$ADVISOR_PROGRESS
VIEW V$DATAFILE_COPY VIEW V$COPY_CORRUPTION VIEW V$BACKUP_SET VIEW V$BACKUP_PIECE VIEW V$BACKUP_DATAFILE VIEW V$BACKUP_REDOLOG VIEW V$BACKUP_CORRUPTION VIEW V$DELETED_OBJECT VIEW V$CONTROLFILE_RECORD_SECTION VIEW V$DATAFILE_HEADER
VIEW V$SESSION_OBJECT_CACHE VIEW V$GLOBAL_TRANSACTION VIEW V$BACKUP_DEVICE VIEW V$DYNAMIC_REMASTER_STATS VIEW V$DLM_MISC VIEW V$DLM_LATCH VIEW V$DLM_CONVERT_LOCAL VIEW V$DLM_CONVERT_REMOTE VIEW V$RECOVERY_PROGRESS VIEWV$GES_ENQUEUE
VIEW V$GES_BLOCKING_ENQUEUE VIEW V$DLM_ALL_LOCKS VIEW V$DLM_LOCKS VIEW V$DLM_RESS VIEW V$GLOBAL_BLOCKED_LOCKS VIEW V$AQ1 VIEW V$CONTEXT VIEW V$RSRC_CONSUMER_GROUP_CPU_MTH VIEW V$RSRC_PLAN_CPU_MTH VIEW V$MAX_ACTIVE_SESS_TARGET_MTH
VIEW V$ACTIVE_SESS_POOL_MTH VIEW V$PARALLEL_DEGREE_LIMIT_MTH VIEW V$QUEUEING_MTH VIEW V$RSRC_CONSUMER_GROUP VIEW V$RSRC_PLAN VIEW V$RSRC_PLAN_HISTORY VIEW V$RSRC_CONS_GROUP_HISTORY VIEW V$RSRCMGRMETRIC VIEW V$RSRCMGRMETRIC_HISTORY VIEW NAME
TYPE ------------------------------ ----- V$HS_AGENT VIEW V$HS_SESSION VIEW V$INSTANCE_RECOVERY VIEW V$LOGMNR_CONTENTS VIEW V$LOGMNR_LOGS VIEW V$LOGMNR_DICTIONARY VIEW V$LOGMNR_PARAMETERS VIEW V$TEMPORARY_LOBS VIEW V$PROXY_DATAFILE VIEW V$PROXY_ARCHIVEDLOG VIEW V$BACKUP_SPFILE
VIEW V$BACKUP_SYNC_IO VIEW V$BACKUP_ASYNC_IO VIEW V$RESERVED_WORDS VIEW V$DLM_TRAFFIC_CONTROLLER VIEW V$HS_PARAMETER VIEW V$UNDOSTAT VIEW V$MEMORY_TARGET_ADVICE VIEW V$SGA_TARGET_ADVICE VIEW V$DB_CACHE_ADVICE VIEWV$MTTR_TARGET_ADVICE
VIEW V$LOGMNR_LOGFILE VIEW V$LOGMNR_PROCESS VIEW V$LOGMNR_TRANSACTION VIEW V$LOGMNR_REGION VIEW V$LOGMNR_CALLBACK VIEW V$LOGMNR_SESSION VIEW V$LOGMNR_LATCH VIEW V$LOGMNR_DICTIONARY_LOAD VIEW V$LOGMNR_SYS_OBJECTS VIEW V$LOGMNR_SYS_DBA_SEGS
VIEW V$LOGMNR_EXTENTS VIEW V$LOGMNR_DBA_OBJECTS VIEW V$LOGMNR_OBJECT_SEGMENTS VIEW V$SQL_WORKAREA VIEW V$SQL_WORKAREA_ACTIVE VIEW V$PGASTAT VIEW V$SQL_WORKAREA_HISTOGRAM VIEW V$PGA_TARGET_ADVICE_HISTOGRAM VIEW V$PGA_TARGET_ADVICE VIEWV$SYS_OPTIMIZER_ENV
VIEW V$SES_OPTIMIZER_ENV VIEW V$SQL_OPTIMIZER_ENV VIEW V$SQL_PLAN VIEW V$SQL_PLAN_STATISTICS VIEW V$SQL_PLAN_STATISTICS_ALL VIEW V$GLOBALCONTEXT VIEW V$RESUMABLE VIEW V$STREAMS_APPLY_COORDINATOR VIEW V$STREAMS_APPLY_SERVER VIEW NAME TYPE ------------------------------ ----- V$STREAMS_APPLY_READER VIEW V$STREAMS_CAPTURE VIEW V$STREAMS_TRANSACTION VIEW V$STREAMS_MESSAGE_TRACKING VIEW V$TIMEZONE_NAMES VIEW V$TIMEZONE_FILE VIEW V$ENQUEUE_STAT VIEW V$ENQUEUE_STATISTICS VIEW V$LOCK_TYPE VIEW V$REPLQUEUE VIEW V$REPLPROP
VIEW V$MVREFRESH VIEW V$LOGSTDBY VIEW V$LOGSTDBY_STATS VIEW V$LOGSTDBY_TRANSACTION VIEW V$LOGSTDBY_PROCESS VIEW V$LOGSTDBY_PROGRESS VIEW V$LOGSTDBY_STATE VIEW V$VPD_POLICY VIEW V$SQL_REDIRECTION VIEW V$HVMASTER_INFO
VIEW V$GCSHVMASTER_INFO VIEW V$GCSPFMASTER_INFO VIEW V$DATABASE_BLOCK_CORRUPTION VIEW V$LOGMNR_STATS VIEW V$ASM_TEMPLATE VIEW V$ASM_ALIAS VIEW V$ASM_FILE VIEW V$ASM_CLIENT VIEW V$ASM_DISKGROUP VIEWV$ASM_DISKGROUP_STAT
VIEW V$ASM_DISK VIEW V$ASM_DISK_STAT VIEW V$ASM_DISK_IOSTAT VIEW V$ASM_OPERATION VIEW V$ASM_ATTRIBUTE VIEW V$STATISTICS_LEVEL VIEW V$DATABASE_INCARNATION VIEW V$AW_OLAP VIEW V$AW_CALC VIEW V$AW_SESSION_INFO
VIEW V$MAP_FILE VIEW V$MAP_FILE_EXTENT VIEW V$MAP_ELEMENT VIEW V$MAP_EXT_ELEMENT VIEW V$MAP_COMP_LIST VIEW V$MAP_SUBELEMENT VIEW V$MAP_FILE_IO_STACK VIEW V$MAP_LIBRARY VIEW V$DATAPUMP_JOB VIEWNAME
TYPE ------------------------------ ----- V$DATAPUMP_SESSION VIEW V$RULE_SET VIEW V$RULE_SET_AGGREGATE_STATS VIEW V$JAVAPOOL VIEW V$SYSAUX_OCCUPANTS VIEW V$RECOVERY_FILE_DEST VIEW V$FLASH_RECOVERY_AREA_USAGE VIEW V$AW_AGGREGATE_OP VIEW V$AW_ALLOCATE_OP VIEW V$TRANSPORTABLE_PLATFORM VIEW V$BLOCK_CHANGE_TRACKING
VIEW V$RULE VIEW V$FLASHBACK_DATABASE_LOGFILE VIEW V$FLASHBACK_DATABASE_LOG VIEW V$FLASHBACK_DATABASE_STAT VIEW V$ACTIVE_SESSION_HISTORY VIEW V$WORKLOAD_REPLAY_THREAD VIEW V$RMAN_STATUS VIEW V$RMAN_OUTPUT VIEW V$ACTIVE_SERVICES VIEW V$SERVICE_WAIT_CLASS
VIEW V$SERVICE_EVENT VIEW V$SERVICES VIEW V$AW_LONGOPS VIEW V$METRICGROUP VIEW V$METRICNAME VIEW V$METRIC VIEW V$METRIC_HISTORY VIEW V$SYSMETRIC VIEW V$SYSMETRIC_HISTORY VIEW V$FILESPACE_USAGE
VIEW V$SCHEDULER_RUNNING_JOBS VIEW V$BUFFERED_QUEUES VIEW V$BUFFERED_SUBSCRIBERS VIEW V$BUFFERED_PUBLISHERS VIEW V$TSM_SESSIONS VIEW V$PROPAGATION_SENDER VIEW V$PROPAGATION_RECEIVER VIEW V$SUBSCR_REGISTRATION_STATS VIEW V$CLIENT_STATS VIEW V$SERV_MOD_ACT_STATS
VIEW V$SERVICE_STATS VIEW V$SYS_TIME_MODEL VIEW V$SESS_TIME_MODEL VIEW V$SYSMETRIC_SUMMARY VIEW V$SESSMETRIC VIEW V$FILEMETRIC VIEW V$FILEMETRIC_HISTORY VIEW V$IOFUNCMETRIC VIEW V$IOFUNCMETRIC_HISTORY VIEWNAME
TYPE ------------------------------ ----- V$EVENTMETRIC VIEW V$WAITCLASSMETRIC VIEW V$WAITCLASSMETRIC_HISTORY VIEW V$SERVICEMETRIC VIEW V$SERVICEMETRIC_HISTORY VIEW V$XML_AUDIT_TRAIL VIEW V$ALERT_TYPES VIEW V$THRESHOLD_TYPES VIEW V$RESTORE_POINT VIEW V$DB_TRANSPORTABLE_PLATFORM VIEW V$SQL_JOIN_FILTER
VIEW V$RMAN_BACKUP_SUBJOB_DETAILS VIEW V$RMAN_BACKUP_JOB_DETAILS VIEW V$BACKUP_SET_DETAILS VIEW V$BACKUP_PIECE_DETAILS VIEW V$BACKUP_COPY_DETAILS VIEW V$PROXY_COPY_DETAILS VIEW V$PROXY_ARCHIVELOG_DETAILS VIEW V$BACKUP_DATAFILE_DETAILS VIEW V$BACKUP_CONTROLFILE_DETAILS VIEW V$BACKUP_ARCHIVELOG_DETAILS
VIEW V$BACKUP_SPFILE_DETAILS VIEW V$BACKUP_DATAFILE_SUMMARY VIEW V$BACKUP_CONTROLFILE_SUMMARY VIEW V$BACKUP_ARCHIVELOG_SUMMARY VIEW V$BACKUP_SPFILE_SUMMARY VIEW V$BACKUP_SET_SUMMARY VIEW V$BACKUP_COPY_SUMMARY VIEW V$PROXY_COPY_SUMMARY VIEW V$PROXY_ARCHIVELOG_SUMMARY VIEWV$UNUSABLE_BACKUPFILE_DETAILS
VIEW V$SQLSTATS VIEW V$WALLET VIEW V$RFS_THREAD VIEW V$DATAGUARD_STATS VIEW V$STANDBY_APPLY_SNAPSHOT VIEW V$RMAN_BACKUP_TYPE VIEW V$MUTEX_SLEEP_HISTORY VIEW V$MUTEX_SLEEP VIEW V$RMAN_ENCRYPTION_ALGORITHMS VIEWV$OBJECT_PRIVILEGE
VIEW V$SYSTEM_FIX_CONTROL VIEW V$SESSION_FIX_CONTROL VIEW V$FS_FAILOVER_HISTOGRAM VIEW V$FS_FAILOVER_STATS VIEW V$NFS_CLIENTS VIEW V$NFS_OPEN_FILES VIEW V$NFS_LOCKS VIEW V$IOSTAT_NETWORK VIEW V$SQL_FEATURE VIEWNAME
TYPE ------------------------------ ----- V$SQL_FEATURE_HIERARCHY VIEW V$SQL_FEATURE_DEPENDENCY VIEW V$REDO_DEST_RESP_HISTOGRAM VIEW V$CORRUPT_XID_LIST VIEW V$FLASHBACK_TXN_MODS VIEW V$FLASHBACK_TXN_GRAPH VIEW V$SQL_HINT VIEW V$RESULT_CACHE_STATISTICS VIEW V$RESULT_CACHE_MEMORY VIEW V$RESULT_CACHE_OBJECTS VIEW V$RESULT_CACHE_DEPENDENCY
VIEW V$CLIENT_RESULT_CACHE_STATS VIEW V$IR_FAILURE VIEW V$IR_REPAIR VIEW V$IR_MANUAL_CHECKLIST VIEW V$IR_FAILURE_SET VIEW V$HM_CHECK VIEW V$HM_CHECK_PARAM VIEW V$HM_RUN VIEW V$HM_FINDING VIEWV$HM_RECOMMENDATION
VIEW V$HM_INFO VIEW V$IOSTAT_CONSUMER_GROUP VIEW V$IOSTAT_FUNCTION VIEW V$IOSTAT_FILE VIEW V$SQL_CS_HISTOGRAM VIEW V$SQL_CS_SELECTIVITY VIEW V$SQL_CS_STATISTICS VIEW V$CPOOL_CC_INFO VIEW V$CPOOL_CC_STATS VIEW V$PERSISTENT_QUEUES
VIEW V$PERSISTENT_SUBSCRIBERS VIEW V$PERSISTENT_PUBLISHERS VIEW V$SSCR_SESSIONS VIEW V$CALLTAG VIEW V$SQL_MONITOR VIEW V$SQL_PLAN_MONITOR VIEW V$DNFS_STATS VIEW V$DNFS_SERVERS VIEW V$DNFS_FILES VIEWV$ENCRYPTION_WALLET
VIEW V$CPOOL_STATS VIEW V$INCMETER_CONFIG VIEW V$INCMETER_SUMMARY VIEW V$INCMETER_INFO VIEW V$SQLFN_METADATA VIEW V$SQLFN_ARG_METADATA VIEW V$RMA_COMPRESSION_ALGORITHM VIEW V$DIAG_INFO VIEW V$IO_CALIBRATION_STATUS VIEW V$PROCESS_GROUP VIEW V$DETACHED_SESSION VIEW V$SECUREFILE_TIMER VIEW V$DNFS_CHANNELS VIEW484 rows selected.
Due to the large number of v$ views for, it would take a
massive set of encyclopedias to describe each and every v$ dynamic
performance view in great detail! Therefore, the most important
new v$ dynamic performance views for Oracle will be described
here as well as how to understand database internal operations by
using these v$ views.| | | [
| | [Exploring
Oracle Internals: Tips and Tricks for the Oracle DBA](http://www.rampant-books.com/book_0901_11g_insider_secrets.htm)[buy it](http://www.rampant-books.com/book_0901_11g_insider_secrets.htm)|
—
—
—
Burleson is the American Team
[
Oracle forum](http://dbaforums.org/oracle/index.php?showforum=2)
[Oracle
qualifications](http://www.dba-oracle.com/qualifications.htm)
| [
Oracle](http://www.dba-oracle.com/oracle_performance_consulting.htm)**[ Performance Tuning](http://www.dba-oracle.com/oracle_performance_consulting.htm)**
**[Remote DBA Services](http://www.remote-dba.net/)**—
Copyright © 1996 – 2016All rights reserved by
Burleson Oracle®
is the registered trademark of Oracle Corporation.