Oracle8i Migration
Release 8.1.5

A67774-01

Library

Product

Contents

Index

Prev Next

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:

Table D-1 Dynamic Performance Views Renamed in Release 8.1
Release 8.1.3 and 8.1.4 Name  Release 8.1.5 and Higher Name 

GV$RECOVERY_SERVERS  

GV$FAST_START_SERVERS  

GV$RECOVERY_TRANSACTIONS  

GV$FAST_START_TRANSACTIONS  

GV$TARGETRBA  

GV$INSTANCE_RECOVERY  

V$RECOVERY_SERVERS  

V$FAST_START_SERVERS  

V$RECOVERY_TRANSACTIONS  

V$FAST_START_TRANSACTIONS  

V$TARGETRBA  

V$INSTANCE_RECOVERY  


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.

Table D-2 Dynamic Performance Views with Dropped Columns in Release 8.1
Dynamic Performance View  Dropped Columns 

V$ARCHIVE_DEST  

ARCMODE  

V$DLM_LATCH  

IMM_GETS

LATCH_TYPE

TTL_GETS  

V$DLM_LOCKS  

RESOURCE_NAME  

V$SESSION_LONGOPS

 

APPLICATION_DATA_1

APPLICATION_DATA_2

APPLICATION_DATA_3

COMPNAM

CURRENT_TIME

MSG

OBJID

OPID

STEPID

STEPSOFAR

STEPTOTAL

UPDATE_COUNT  

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:




Prev

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index