Oracle9i supports new dynamic performance views (V$
views), and some dynamic performance views have been changed or have become obsolete in Oracle9i. This appendix lists the new, changed, and obsolete dynamic performance views in version 8 and Oracle9i.
This appendix covers the following topics:
Changes to Dynamic Performance Views in Oracle9i
The following sections list the new, changed, and obsolete dynamic performance views in Oracle9i:
Dynamic Performance Views Added in Oracle9i
The dynamic performance views listed in this section are new in Oracle9i.
Dynamic Performance Views Added in Release 9.0.1
The following dynamic performance views were added in release 9.0.1:
GV$ACTIVE_SESS_POOL_MTH |
GV$ARCHIVE_DEST_STATUS |
GV$ARCHIVE_GAP |
GV$ENQUEUE_STAT |
GV$GCSHVMASTER_INFO |
GV$GCSPFMASTER_INFO |
GV$GLOBALCONTEXT |
GV$HVMASTER_INFO |
GV$LOGMNR_CALLBACK |
GV$LOGMNR_LOGFILE |
GV$LOGMNR_PROCESS |
GV$LOGMNR_REGION |
GV$LOGMNR_SESSION |
GV$LOGMNR_TRANSACTION |
GV$LOGSTDBY |
GV$LOGSTDBY_STATS |
GV$MANAGED_STANDBY |
GV$MVREFRESH |
GV$PGASTAT |
GV$QUEUEING_MTH |
GV$REPLPROP |
GV$REPLQUEUE |
GV$RESUMABLE |
GV$RMAN_CONFIGURATION |
GV$SPPARAMETER |
GV$SQL_PLAN |
GV$SQL_REDIRECTION |
GV$SQL_WORKAREA |
GV$SQL_WORKAREA_ACTIVE |
GV$STANDBY_LOG |
GV$TIMEZONE_NAMES |
GV$UNDOSTAT |
GV$VPD_POLICY |
V$ACTIVE_SESS_POOL_MTH |
V$ARCHIVE_DEST_STATUS |
V$ARCHIVE_GAP |
V$ENQUEUE_STAT |
V$FILESTATXS |
V$GCSHVMASTER_INFO |
V$GCSPFMASTER_INFO |
V$GLOBALCONTEXT |
V$HVMASTER_INFO |
V$LOGMNR_CALLBACK |
V$LOGMNR_LOGFILE |
V$LOGMNR_PROCESS |
V$LOGMNR_REGION |
V$LOGMNR_SESSION |
V$LOGMNR_TRANSACTION |
V$LOGSTDBY |
V$LOGSTDBY_STATS |
V$MANAGED_STANDBY |
V$MVREFRESH |
V$PGASTAT |
V$QUEUEING_MTH |
V$REPLPROP |
V$REPLQUEUE |
V$RESUMABLE |
V$RMAN_CONFIGURATION |
V$SPPARAMETER |
V$SQLXS |
V$SQL_PLAN |
V$SQL_REDIRECTION |
V$SQL_WORKAREA |
V$SQL_WORKAREA_ACTIVE |
V$STANDBY_LOG |
V$TEMPSTATXS |
V$TIMEZONE_NAMES |
V$UNDOSTAT |
V$VPD_POLICY |
|
Dynamic Performance Views Renamed in Oracle9i
The dynamic performance views listed in this section have been renamed in Oracle9i. If an application requires one or more of the views listed below, then modify the application accordingly.
Dynamic Performance Views Renamed in Release 9.0.1
The following dynamic performance views were renamed in release 9.0.1:
Table D-1 Dynamic Performance Views Renamed in Release 9.0.1
Note:
The old names are maintained for backward compatibility with version 8. Oracle Corporation recommends migrating to the new names.
|
Dynamic Performance Views with Dropped Columns in Oracle9i
The columns listed in the following sections were dropped in Oracle9i. If an application requires one or more of the columns listed below, then modify the application accordingly.
Dynamic Performance Views with Dropped Columns in Release 9.0.1
The columns listed in Table D-2 were dropped in release 9.0.1.
Table D-2 Dynamic Performance Views with Dropped Columns in Release 9.0.1
Dynamic Performance Views Obsolete in Oracle9i
The dynamic performance views listed in this section are obsolete in Oracle9i.
Dynamic Performance Views Obsolete in Release 9.0.1
The following dynamic performance views became obsolete in release 9.0.1 and are not available in release 9.0.1 and higher:
Changes to Dynamic Performance Views in Version 8
The following sections list the new, changed, and obsolete dynamic performance views in version 8:
Dynamic Performance Views Added in Version 8
The dynamic performance views listed in this section are new in version 8.
Dynamic Performance Views Added in Release 8.0
The following dynamic performance views were added in release 8.0:
GV$ACCESS |
GV$ACTIVE_INSTANCES |
GV$AQ |
GV$ARCHIVE |
GV$ARCHIVE_DEST |
GV$ARCHIVED_LOG |
GV$BACKUP |
GV$BACKUP_CORRUPTION |
GV$BACKUP_DATAFILE |
GV$BACKUP_DEVICE |
GV$BACKUP_PIECE |
GV$BACKUP_REDOLOG |
GV$BACKUP_SET |
GV$BGPROCESS |
GV$BH |
GV$BUFFER_POOL |
GV$CACHE |
GV$CIRCUIT |
GV$CLASS_PING |
GV$COMPATIBILITY |
GV$COMPATSEG |
GV$CONTROLFILE |
GV$CONTROLFILE_RECORD_SECTION |
GV$COPY_CORRUPTION |
GV$CURRENT_BUCKET |
GV$DATABASE |
GV$DATAFILE |
GV$DATAFILE_COPY |
GV$DATAFILE_HEADER |
GV$DB_OBJECT_CACHE |
GV$DB_PIPES |
GV$DBFILE |
GV$DBLINK |
GV$DELETED_OBJECT |
GV$DISPATCHER |
GV$DISPATCHER_RATE |
GV$DLM_CONVERT_LOCAL |
GV$DLM_CONVERT_REMOTE |
GV$DLM_LATCH |
GV$DLM_LOCKS |
GV$DLM_MISC |
GV$ENABLEDPRIVS |
GV$ENQUEUE_LOCK |
GV$EVENT_NAME |
GV$EXECUTION |
GV$FALSE_PING |
GV$FILE_PING |
GV$FILESTAT |
GV$FIXED_TABLE |
GV$FIXED_VIEW_DEFINITION |
GV$GLOBAL_TRANSACTION |
GV$INDEXED_FIXED_COLUMN |
GV$INSTANCE |
GV$LATCH |
GV$LATCH_CHILDREN |
GV$LATCH_MISSES |
GV$LATCH_PARENT |
GV$LATCHHOLDER |
GV$LATCHNAME |
GV$LIBRARYCACHE |
GV$LICENSE |
GV$LOADCSTAT |
GV$LOADPSTAT |
GV$LOADTSTAT |
GV$LOCK |
GV$LOCK_ACTIVITY |
GV$LOCK_ELEMENT |
GV$LOCKED_OBJECT |
GV$LOCKS_WITH_COLLISIONS |
GV$LOG |
GV$LOG_HISTORY |
GV$LOGFILE |
GV$LOGHIST |
GV$MLS_PARAMETERS |
GV$MTS |
GV$MYSTAT |
GV$NLS_PARAMETERS |
GV$NLS_VALID_VALUES |
GV$OBJECT_DEPENDENCY |
GV$OFFLINE_RANGE |
GV$OPEN_CURSOR |
GV$OPTION |
GV$PARAMETER |
GV$PING |
GV$PQ_SESSTAT |
GV$PQ_SLAVE |
GV$PQ_SYSSTAT |
GV$PQ_TQSTAT |
GV$PROCESS |
GV$PWFILE_USERS |
GV$QUEUE |
GV$RECENT_BUCKET |
GV$RECOVER_FILE |
GV$RECOVERY_FILE_STATUS |
GV$RECOVERY_LOG |
GV$RECOVERY_PROGRESS |
GV$RECOVERY_STATUS |
GV$REQDIST |
GV$RESOURCE |
GV$RESOURCE_LIMIT |
GV$ROLLSTAT |
GV$ROWCACHE |
GV$ROWCACHE_PARENT |
GV$ROWCACHE_SUBORDINATE |
GV$SESS_IO |
GV$SESSION |
GV$SESSION_CONNECT_INFO |
GV$SESSION_CURSOR_CACHE |
GV$SESSION_EVENT |
GV$SESSION_LONGOPS |
GV$SESSION_OBJECT_CACHE |
GV$SESSION_WAIT |
GV$SESSTAT |
GV$SGA |
GV$SGASTAT |
GV$SHARED_POOL_RESERVED |
GV$SHARED_SERVER |
GV$SORT_SEGMENT |
GV$SORT_USAGE |
GV$SQL |
GV$SQL_BIND_DATA |
GV$SQL_BIND_METADATA |
GV$SQL_CURSOR |
GV$SQL_SHARED_MEMORY |
GV$SQLAREA |
GV$SQLTEXT |
GV$SQLTEXT_WITH_NEWLINES |
GV$STATNAME |
GV$SUBCACHE |
GV$SYSSTAT |
GV$SYSTEM_CURSOR_CACHE |
GV$SYSTEM_EVENT |
GV$SYSTEM_PARAMETER |
GV$TABLESPACE |
GV$THREAD |
GV$TIMER |
GV$TRANSACTION |
GV$TRANSACTION_ENQUEUE |
GV$TYPE_SIZE |
GV$VERSION |
GV$WAITSTAT |
V$AQ |
V$ARCHIVE_DEST |
V$ARCHIVED_LOG |
V$BACKUP_CORRUPTION |
V$BACKUP_DATAFILE |
V$BACKUP_DEVICE |
V$BACKUP_PIECE |
V$BACKUP_REDOLOG |
V$BACKUP_SET |
V$BUFFER_POOL |
V$CLASS_PING |
V$CONTROLFILE_RECORD_SECTION |
V$COPY_CORRUPTION |
V$CURRENT_BUCKET |
V$DATAFILE_COPY |
V$DATAFILE_HEADER |
V$DELETED_OBJECT |
V$DISPATCHER_RATE |
V$DLM_CONVERT_LOCAL |
V$DLM_CONVERT_REMOTE |
V$DLM_LATCH |
V$DLM_LOCKS |
V$DLM_MISC |
V$ENQUEUE_LOCK |
V$FILE_PING |
V$GLOBAL_TRANSACTION |
V$LOADPSTAT |
V$OFFLINE_RANGE |
V$RECENT_BUCKET |
V$RECOVERY_PROGRESS |
V$RESOURCE_LIMIT |
V$ROWCACHE_PARENT |
V$ROWCACHE_SUBORDINATE |
V$SESSION_LONGOPS |
V$SESSION_OBJECT_CACHE |
V$SORT_USAGE |
V$SUBCACHE |
V$TABLESPACE |
V$TRANSACTION_ENQUEUE |
Dynamic Performance Views Added in Release 8.1
The following dynamic performance views were added in release 8.1:
GV$ARCHIVE_PROCESSES |
GV$BACKUP_ASYNC_IO |
GV$BACKUP_SYNC_IO |
GV$BSP |
GV$BUFFER_POOL_STATISTICS |
GV$CONTEXT |
GV$DB_CACHE_ADVICE |
GV$DLM_ALL_LOCKS |
GV$DLM_RESS |
GV$DLM_TRAFFIC_CONTROLLER |
GV$FAST_START_SERVERS |
GV$FAST_START_TRANSACTIONS |
GV$GLOBAL_BLOCKED_LOCKS |
GV$HS_AGENT |
GV$HS_PARAMETER |
GV$HS_SESSION |
GV$INSTANCE_RECOVERY |
GV$LOADISTAT |
GV$LOGMNR_CONTENTS |
GV$LOGMNR_DICTIONARY |
GV$LOGMNR_LOGS |
GV$LOGMNR_PARAMETERS |
GV$OBSOLETE_PARAMETER |
GV$PARALLEL_DEGREE_LIMIT_MTH |
GV$PROXY_ARCHIVEDLOG |
GV$PROXY_DATAFILE |
GV$PX_PROCESS |
GV$PX_PROCESS_SYSSTAT |
GV$PX_SESSION |
GV$PX_SESSTAT |
GV$RESERVED_WORDS |
GV$RSRC_CONSUMER_GROUP |
GV$RSRC_CONSUMER_GROUP_CPU_MTH |
GV$RSRC_PLAN |
GV$RSRC_PLAN_CPU_MTH |
GV$SQL_SHARED_CURSOR |
GV$TEMP_EXTENT_MAP |
GV$TEMP_EXTENT_POOL |
GV$TEMP_PING |
GV$TEMP_SPACE_HEADER |
GV$TEMPFILE |
GV$TEMPORARY_LOBS |
GV$TEMPSTAT |
V$ARCHIVE_PROCESSES |
V$BACKUP_ASYNC_IO |
V$BACKUP_SYNC_IO |
V$BSP |
V$BUFFER_POOL_STATISTICS |
V$CONTEXT |
V$DB_CACHE_ADVICE |
V$DLM_ALL_LOCKS |
V$DLM_RESS |
V$DLM_TRAFFIC_CONTROLLER |
V$FAST_START_SERVERS |
V$FAST_START_TRANSACTIONS |
V$GLOBAL_BLOCKED_LOCKS |
V$HS_AGENT |
V$HS_PARAMETER |
V$HS_SESSION |
V$INSTANCE_RECOVERY |
V$LOADISTAT |
V$LOGMNR_CONTENTS |
V$LOGMNR_DICTIONARY |
V$LOGMNR_LOGS |
V$LOGMNR_PARAMETERS |
V$OBSOLETE_PARAMETER |
V$PARALLEL_DEGREE_LIMIT_MTH |
V$PROXY_ARCHIVEDLOG |
V$PROXY_DATAFILE |
V$PX_PROCESS |
V$PX_PROCESS_SYSSTAT |
V$PX_SESSION |
V$PX_SESSTAT |
V$RESERVED_WORDS |
V$RSRC_CONSUMER_GROUP |
V$RSRC_CONSUMER_GROUP_CPU_MTH |
V$RSRC_PLAN |
V$RSRC_PLAN_CPU_MTH |
V$SQL_SHARED_CURSOR |
V$TEMP_EXTENT_MAP |
V$TEMP_EXTENT_POOL |
V$TEMP_PING |
V$TEMP_SPACE_HEADER |
V$TEMPFILE |
V$TEMPORARY_LOBS |
V$TEMPSTAT |
Dynamic Performance Views with Added Columns in Version 8
New columns were added to the dynamic performance views listed in the following sections.
Dynamic Performance Views with Added Columns in Release 8.0
New columns were added to the following dynamic performance views in release 8.0:
V$BH |
V$CACHE |
V$CACHE_LOCK |
V$DATABASE |
V$DATAFILE |
V$FALSE_PING |
V$FILESTAT |
V$INSTANCE |
V$LATCH_MISSES |
V$LOADCSTAT |
V$LOADTSTAT |
V$LOG_HISTORY |
V$PING |
V$SESSION |
V$SESSION_EVENT |
V$SGASTAT |
V$SORT_SEGMENT |
V$SQL |
V$THREAD |
V$TRANSACTION |
Dynamic Performance Views with Added Columns in Release 8.1
New columns were added to the following dynamic performance views in release 8.1:
GV$ARCHIVE_DEST |
GV$BACKUP_PIECE |
GV$BH |
GV$CIRCUIT |
GV$DATABASE |
GV$DATAFILE |
GV$DISPATCHER |
GV$DLM_LATCH |
GV$DLM_LOCKS |
GV$INSTANCE |
GV$LOGMNR_CONTENTS |
GV$MTS |
GV$PROXY_ARCHIVEDLOG |
GV$PROXY_DATAFILE |
GV$SESSION |
GV$SESSION_LONGOPS |
GV$SORT_USAGE |
GV$SQL |
V$ARCHIVE_DEST |
V$BACKUP_PIECE |
V$BH |
V$CIRCUIT |
V$DATABASE |
V$DATAFILE |
V$DISPATCHER |
V$DLM_LATCH |
V$DLM_LOCKS |
V$INSTANCE |
V$LOGMNR_CONTENTS |
V$MTS |
V$PROXY_ARCHIVEDLOG |
V$PROXY_DATAFILE |
V$SESSION |
V$SESSION_LONGOPS |
V$SQL |
|
Dynamic Performance Views with Dropped Columns in Version 8
The columns listed in the following sections were dropped in version 8. If an application requires one or more of the columns listed below, then modify the application accordingly.
Dynamic Performance Views with Dropped Columns in Release 8.1
The columns listed in Table D-3 were dropped in release 8.1.
Table D-3 Dynamic Performance Views with Dropped Columns in Release 8.1
Dynamic Performance Views with Renamed Columns in Version 8
The columns listed in the following sections were renamed in version 8. If an application requires one or more of the columns listed below, then modify the application accordingly.
Dynamic Performance Views with Renamed Columns in Release 8.1
The columns listed in Table D-4 were renamed in release 8.1.
Table D-4 Dynamic Performance Views with Renamed Columns in Release 8.1
Dynamic Performance Views Obsolete in Version 8
The dynamic performance views listed in this section are obsolete in version 8.
Dynamic Performance Views Obsolete in Release 8.1
The following dynamic performance views became obsolete in release 8.1 and are not available in release 8.1 and higher:
GV$CURRENT_BUCKET |
GV$RECENT_BUCKET |
V$CURRENT_BUCKET |
V$RECENT_BUCKET |