|
Welcome
Seminars
Consultancy
Calendar
Presentations
Diagnostics
Internals
References
Acknowledgements
|
Oracle 11.1 Dynamic Performance Views
In Oracle 10.2 there were 393 dynamic performance views; in Oracle 11.1 there are 481 dynamic performance views
The following table shows the 89 dynamic performance views that were added in Oracle 11.1:
|
| Name |
| V$ASM_ATTRIBUTE |
| V$ASM_DISK_IOSTAT |
| V$CALLTAG |
| V$CLIENT_RESULT_CACHE_STATS |
| V$CORRUPT_XID_LIST |
| V$CPOOL_CC_INFO |
| V$CPOOL_CC_STATS |
| V$CPOOL_STATS |
| V$DETACHED_SESSION |
| V$DIAG_INFO |
| V$DNFS_CHANNELS |
| V$DNFS_FILES |
| V$DNFS_SERVERS |
| V$DNFS_STATS |
| V$DYNAMIC_REMASTER_STATS |
| V$ENCRYPTED_TABLESPACES |
| V$ENCRYPTION_WALLET |
| V$FLASHBACK_TXN_GRAPH |
| V$FLASHBACK_TXN_MODS |
| V$FOREIGN_ARCHIVED_LOG |
| V$FS_FAILOVER_HISTOGRAM |
| V$FS_FAILOVER_STATS |
| 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$IOFUNCMETRIC |
| V$IOFUNCMETRIC_HISTORY |
| V$IOSTAT_CONSUMER_GROUP |
| V$IOSTAT_FILE |
| V$IOSTAT_FUNCTION |
| V$IOSTAT_NETWORK |
| V$IO_CALIBRATION_STATUS |
| V$IR_FAILURE |
| V$IR_FAILURE_SET |
| V$IR_MANUAL_CHECKLIST |
| V$IR_REPAIR |
| V$LOBSTAT |
| V$LOGMNR_DBA_OBJECTS |
| V$LOGMNR_EXTENTS |
| V$LOGMNR_OBJECT_SEGMENTS |
| V$LOGMNR_SYS_DBA_SEGS |
| V$LOGMNR_SYS_OBJECTS |
| 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_PRIVILEGE |
| V$PERSISTENT_PUBLISHERS |
| V$PERSISTENT_QUEUES |
| V$PERSISTENT_SUBSCRIBERS |
| V$PROCESS_GROUP |
| V$PX_INSTANCE_GROUP |
| 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$RSRCMGRMETRIC |
| V$RSRCMGRMETRIC_HISTORY |
| V$SECUREFILE_TIMER |
| V$SESSION_FIX_CONTROL |
| V$SQLFN_ARG_METADATA |
| V$SQLFN_METADATA |
| 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$SSCR_SESSIONS |
| V$STREAMS_MESSAGE_TRACKING |
| V$SUBSCR_REGISTRATION_STATS |
| V$SYSTEM_FIX_CONTROL |
| V$SYSTEM_PARAMETER4 |
| V$WAIT_CHAINS |
| V$WORKLOAD_REPLAY_THREAD |
|
The following table shows the only dynamic performance view that was removed in Oracle 11.1:
|
