Oracle 10.1 Dynamic Performance Views
In Oracle 9.2 there were 256 dynamic performance views; in Oracle 10.1 there are 337 dynamic performance views
The following table shows the 83 dynamic performance views that were added in Oracle 10.1:
|
| Name |
| V$ACTIVE_SERVICES |
| V$ACTIVE_SESSION_HISTORY |
| V$ADVISOR_PROGRESS |
| V$ALERT_TYPES |
| V$ASM_ALIAS |
| V$ASM_CLIENT |
| V$ASM_DISK |
| V$ASM_DISKGROUP |
| V$ASM_FILE |
| V$ASM_OPERATION |
| V$ASM_TEMPLATE |
| V$AW_AGGREGATE_OP |
| V$AW_ALLOCATE_OP |
| V$AW_LONGOPS |
| V$BLOCK_CHANGE_TRACKING |
| V$BUFFERED_PUBLISHERS |
| V$BUFFERED_QUEUES |
| V$BUFFERED_SUBSCRIBERS |
| V$CLIENT_STATS |
| V$CURRENT_BLOCK_SERVER |
| V$DATAGUARD_CONFIG |
| V$DATAPUMP_JOB |
| V$DATAPUMP_SESSION |
| V$DISPATCHER_CONFIG |
| V$ENQUEUE_STATISTICS |
| V$EVENTMETRIC |
| V$EVENT_HISTOGRAM |
| V$FILEMETRIC |
| V$FILEMETRIC_HISTORY |
| V$FILESPACE_USAGE |
| V$FILE_HISTOGRAM |
| V$FLASHBACK_DATABASE_LOG |
| V$FLASHBACK_DATABASE_LOGFILE |
| V$FLASHBACK_DATABASE_STAT |
| V$INSTANCE_CACHE_TRANSFER |
| V$INSTANCE_LOG_GROUP |
| V$JAVAPOOL |
| V$JAVA_LIBRARY_CACHE_MEMORY |
| V$JAVA_POOL_ADVICE |
| V$LOCK_TYPE |
| V$LOGMNR_LATCH |
| V$METRIC |
| V$METRICGROUP |
| V$METRICNAME |
| V$METRIC_HISTORY |
| V$OSSTAT |
| V$PROPAGATION_RECEIVER |
| V$PROPAGATION_SENDER |
| V$PX_BUFFER_ADVICE |
| V$RECOVERY_FILE_DEST |
| V$RMAN_OUTPUT |
| V$RMAN_STATUS |
| V$RULE |
| V$RULE_SET |
| V$RULE_SET_AGGREGATE_STATS |
| V$SCHEDULER_RUNNING_JOBS |
| V$SERVICEMETRIC |
| V$SERVICEMETRIC_HISTORY |
| V$SERVICES |
| V$SERVICE_EVENT |
| V$SERVICE_STATS |
| V$SERVICE_WAIT_CLASS |
| V$SERV_MOD_ACT_STATS |
| V$SESSION_WAIT_CLASS |
| V$SESSION_WAIT_HISTORY |
| V$SESSMETRIC |
| V$SESS_TIME_MODEL |
| V$SES_OPTIMIZER_ENV |
| V$SGAINFO |
| V$SQL_OPTIMIZER_ENV |
| V$SYSAUX_OCCUPANTS |
| V$SYSMETRIC |
| V$SYSMETRIC_HISTORY |
| V$SYSMETRIC_SUMMARY |
| V$SYSTEM_WAIT_CLASS |
| V$SYS_OPTIMIZER_ENV |
| V$SYS_TIME_MODEL |
| V$TEMP_HISTOGRAM |
| V$THRESHOLD_TYPES |
| V$TIMEZONE_FILE |
| V$TRANSPORTABLE_PLATFORM |
| V$WAITCLASSMETRIC |
| V$WAITCLASSMETRIC_HISTORY |
|
The following table shows the two dynamic performance views that were removed from Oracle 10.1:
|
| Name |
| V$COMPATIBILITY |
| V$COMPATSEG |
|
|
