Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.2 Dynamic Performance Views

In Oracle 10.1 there were 337 dynamic performance views; in Oracle 10.2 there are 393 dynamic performance views

The following table shows the 56 dynamic performance views that were added in Oracle 10.2:

Name
V$ASM_DISKGROUP_STAT
V$ASM_DISK_STAT
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$BLOCKING_QUIESCE
V$CLUSTER_INTERCONNECTS
V$CONFIGURED_INTERCONNECTS
V$DATAGUARD_STATS
V$DB_TRANSPORTABLE_PLATFORM
V$FLASH_RECOVERY_AREA_USAGE
V$LOGMNR_DICTIONARY_LOAD
V$LOGSTDBY_PROCESS
V$LOGSTDBY_PROGRESS
V$LOGSTDBY_STATE
V$LOGSTDBY_TRANSACTION
V$MUTEX_SLEEP
V$MUTEX_SLEEP_HISTORY
V$PARAMETER_VALID_VALUES
V$PROCESS_MEMORY
V$PROCESS_MEMORY_DETAIL
V$PROCESS_MEMORY_DETAIL_PROG
V$PROXY_ARCHIVELOG_DETAILS
V$PROXY_ARCHIVELOG_SUMMARY
V$PROXY_COPY_DETAILS
V$PROXY_COPY_SUMMARY
V$RESTORE_POINT
V$RFS_THREAD
V$RMAN_BACKUP_JOB_DETAILS
V$RMAN_BACKUP_SUBJOB_DETAILS
V$RMAN_BACKUP_TYPE
V$RMAN_ENCRYPTION_ALGORITHMS
V$RSRC_CONS_GROUP_HISTORY
V$RSRC_PLAN_HISTORY
V$RSRC_SESSION_INFO
V$SGA_TARGET_ADVICE
V$SQLAREA_PLAN_HASH
V$SQLSTATS
V$SQL_JOIN_FILTER
V$STANDBY_APPLY_SNAPSHOT
V$STREAMS_POOL_ADVICE
V$STREAMS_TRANSACTION
V$TSM_SESSIONS
V$UNUSABLE_BACKUPFILE_DETAILS
V$WALLET
V$XML_AUDIT_TRAIL

No dynamic performance views were removed from Oracle 10.2: