D
Changes to Dynamic Performance Views
Version 8 supports new dynamic performance views (V$ views), and some dynamic performance views have been changed or have become obsolete in version 8. This appendix lists the new, changed, and obsolete dynamic performance views in version 8.
This appendix covers the following topics:
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$CONTEXT |
GV$DLM_ALL_LOCKS |
GV$DLM_RESS |
GV$FAST_START_SERVERS |
GV$FAST_START_TRANSACTIONS |
GV$GLOBAL_BLOCKED_LOCKS |
GV$HS_AGENT |
GV$HS_SESSION |
GV$INSTANCE_RECOVERY |
GV$LOGMNR_CONTENTS |
GV$LOGMNR_DICTIONARY |
GV$LOGMNR_LOGS |
GV$LOGMNR_PARAMETERS |
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$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$CONTEXT |
V$DLM_ALL_LOCKS |
V$DLM_RESS |
V$FAST_START_SERVERS |
V$FAST_START_TRANSACTIONS |
V$GLOBAL_BLOCKED_LOCKS |
V$HS_AGENT |
V$HS_SESSION |
V$INSTANCE_RECOVERY |
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$TEMP_EXTENT_MAP |
V$TEMP_EXTENT_POOL |
V$TEMP_PING |
V$TEMP_SPACE_HEADER |
V$TEMPFILE |
V$TEMPORARY_LOBS |
V$TEMPSTAT |
|
Dynamic Performance Views Renamed in Version 8
The dynamic performance views in this section have been renamed in version 8. If an application requires one or more of the views listed below, modify the application accordingly.
Dynamic Performance Views Renamed in Release 8.1
The following dynamic performance views were renamed in release 8.1:
Note:
No dynamic performance views were renamed in release 8.0.
|
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$AQ |
GV$BACKUP_PIECE |
GV$BH |
GV$CIRCUIT |
GV$DATABASE |
GV$DATAFILE |
GV$DISPATCHER |
GV$DLM_LATCH |
GV$DLM_LOCKS |
GV$INSTANCE |
GV$INSTANCE_RECOVERY |
GV$LOGMNR_CONTENTS |
GV$SESSION |
GV$SESSION_LONGOPS |
GV$SQL |
V$ARCHIVE_DEST |
V$AQ |
V$BACKUP_PIECE |
V$BH |
V$CIRCUIT |
V$DATABASE |
V$DATAFILE |
V$DISPATCHER |
V$DLM_LATCH |
V$DLM_LOCKS |
V$INSTANCE |
V$INSTANCE_RECOVERY |
V$LOGMNR_CONTENTS |
V$SESSION |
V$SESSION_LONGOPS |
V$SQL |
Note:
The GV$TARGETRBA and V$TARGETRBA dynamic performance views were added in release 8.1.3. The names of these views are changed to GV$INSTANCE_RECOVERY and V$INSTANCE_RECOVERY, respectively, in release 8.1.5 and higher. As the preceding list shows, new columns were added to these dynamic performance views under the new names in release 8.1.5.
|
Dynamic Performance Views with Dropped Columns in Release 8.1
The columns listed in the following sections were dropped in release 8.1. If an application requires one or more of the columns listed below, modify the application accordingly.
Dynamic Performance Views with Dropped Columns in Release 8.1
The columns listed in Table D-2 were dropped in release 8.1.
Dynamic Performance Views Obsolete in Version 8
The dynamic performance views 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 |
Note:
No dynamic performance views became obsolete in release 8.0.
|
Date Columns in Dynamic Performance Views
In Oracle7, all date columns in dynamic performance views were VARCHAR2(20) strings in MM/DD/YY HH24:MI:SS format. In version 8, every new date column is a real DATE column that uses the DATE datatype. In contrast to the previous VARCHAR2(20) string, the DATE datatype provides the following benefits: