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:
- Establishes consistency, because all date columns are in the DATE datatype.
- Makes it easier to perform date arithmetic (including sorting) in SQL and PL/SQL.
- Enables you to set your date format using NLS_DATE_FORMAT.
- Lets you to see dates in the old format by setting NLS_DATE_FORMAT to MM/DD/YY HH24:MI:SS.
- Avoids two-digit year numbers, thereby avoiding problems at the year 2000 and beyond.
Note:
Although Oracle7 displays dates using the VARCHAR(20) datatype in dynamic performance views, Oracle7 still is fully year-2000 compliant. Oracle7 stores time to the nearest second in the redo log files and control files.
|