4 Dynamic Performance (V$) Views< /h3>

About Dynamic Performance Views

V$ Views

GV$ Views

Dynamic Performance View Descriptions

V$ACCESS

V$ACTIVE_INSTANCES

V$ACTIVE_SERVICES

V$ACTIVE_SESS_POOL_MTH

V$ACTIVE_SESSION_H ISTORY

V$ALERT_TYPES

V$AQ

V$ARCHIVE

V$ARCHIVE_DEST

V$ARCHIVE_DEST_STATUS

V$ARCHIVE_GAP< /a>

V$ARCHIVE_PROCESSES

V$ARCHIVE D_LOG

V$ASM_ALIAS

V$ASM_CLIEN T

V$ASM_DISK

V$ASM_DISKGROUP< /a>

V$ASM_FILE

V$ASM_OPERATION

V$ASM_TEMPLATE

V$BACKUP

V$BACKUP_ASYNC_IO

V$BACKUP_CORRUPTIO N

V$BACKUP_DATAFILE

V$BACKUP_ DEVICE

V$BACKUP_FILES

V$BACKU P_PIECE

V$BACKUP_REDOLOG

V$BA CKUP_SET

V$BACKUP_SPFILE

V$BA CKUP_SYNC_IO

V$BGPROCESS

V$BH

V$BLOCK_CHANGE_TRACKING

V$BU FFER_POOL

V$BUFFER_POOL_STATISTICS

V$BUFFERED_PUBLISHERS

V$BUFFERED_QUEUES

V$BUFFERED_SUBSCRIBERS

V$CACHE

V$CACHE_LOCK

V$CACHE_TRANSFER

V$CIRCUIT

V$CLASS_CACHE_TRANSFER

V$CLIENT_STATS

V$CONTEXT

V$CONTROLFILE

V$CONTROLFILE_RECORD_SECTION

V$COPY_CORRUPTION

V$CR_BLOCK_SERVER
V$CURRENT_BLOCK_SERVER
V$DATABASE
V$DATABASE_BLOCK_CORRUPTION

V$DATAB ASE_INCARNATION

V$DATAFILE

V$ DATAFILE_COPY

V$DATAFILE_HEADER

V$DATAGUARD_CONFIG

V$DATAGUARD_STATUS

V$DB_CACHE_ADVICE

V$DB_OBJECT_CACHE

V$DB_PIPES

V$DBFILE

V$DBLINK

V$DELETED_OBJECT

V$DISPATCHER

V$DISPATCHER_CONFIG

V$DISPATCHER_RATE

V$ENABLEDPRIVS

V$ENQUEUE_LOCK

V$ENQUEUE_STAT

V$EVENT_HISTOGRAM

V$EVENT_NAME

V$EVENTMETRIC

V$EXECUTION

V$FALSE_PING

V$FAST_START_SERVERS

V$FAST_START_TRANSACTIONS

V$FILE_CACHE_TRANSFER

V$FILE_HISTOGRAM

V$FILEMETRIC

V$FILEMETRIC_HISTORY

V$FILESTAT

V$FIXED_TABLE

V$FIXED_VIEW_DEFINITION< /a>

V$FLASHBACK_DATABASE_LOG

V$FL ASHBACK_DATABASE_STAT

V$GC_ELEMENT

V$GC_ELEMENTS_WITH_COLLISIONS

V$GCSHVMASTER_INFO

V$GCSPFMASTER_INFO

V$GES_BLOCKING_ENQUEUE

V$GES_CONVERT_LOCAL

V$GES_CONVERT_REMOTE

V$GES_ENQUEUE

V$GES_LATCH< /dd>
V$GES_RESOURCE

V$GES_STATISTICS

V$GLOBAL_BLOCKED_LOCKS

V$GLOBA L_TRANSACTION

V$HS_AGENT

V$HS _PARAMETER

V$HS_SESSION

V$HVM ASTER_INFO

V$INDEXED_FIXED_COLUMN

V$INSTANCE

V$INSTANCE_RECOVERY

V$JAVA_LIBRARY_CACHE_MEMORY

V$JAVA_POOL_ADVICE

V$LATCH

V$LATCH_CHILDREN

V$LATCH_MISSES

V$LATCH_PARENT

V$LATCHHOLDER

V$LATCHNAME

V$LIBRARY_CACHE_MEMORY

V$LIBRARYCACHE

V$LICENSE

V$LOADISTAT

V$LOADPSTAT

V$LOCK

V$LOCK_ACTIVITY

V$LOCKED_OBJECT

V$LOG

V$LOG_HISTORY

V$LOGFILE

V$LOGHIST

V$LO GMNR_CONTENTS

V$LOGMNR_DICTIONARY

V$LOGMNR_LOGS

V$LOGMNR_PARAMETERS

V$LOGSTDBY

V$LOGSTDBY_STATS

V$MANAGED_STANDBY

V$MAP_COMP_LIST

V$MAP_ELEMENT

V$MAP_EXT_ELEMENT

V$MAP_FILE

V$MAP_FILE_EXTENT

V$MAP_FILE_IO_STACK

V$MAP_LIBRARY

V$MAP_SUBELEMENT

V$METRICNAME

V$MTTR_TARGET_ADVICE

V$MVREFRESH

V$MYSTAT

< a href="waitevents004.htm#sthref3817">global cache open s

global cache open x

global cache s to x

inactive ses sion

inactive transaction branch

index block split

instance recovery

instance state change

library cache load lock

library cache lock

library cache pin

lock manager wait for remote message

log buffer space

log file parallel write

log file sequential read

log file single write

log file switch (archiving needed)

log file switch (checkpoint incomple te)

log file switch (clearing log file)

log file switch completion

log file sync

log switch/archive

on-going SCN fetch to complete

pending global transaction(s)

pipe ge t

pipe put

PL/SQL lock timer< /a>

rdbms ipc message block

SQL*Net break/reset to client

SQL*Net break/reset to dblink

SQL*Net message from client

SQL*Net message from dblink

SQL*Net message to client

SQL*Net message to dblink

SQL*Net more data from client

SQL*Net more data from dblink

SQL*Net more da ta to client

SQL*Net more data to dblink

switch logfile command

timer in sksawat

transaction

unbound tx

undo segment extension

undo segment recovery

undo segment tx slot

virtual circuit status< /dd>

WMON goes to sleep

write complete waits

writes stopped by instance recovery or database suspension

D Oracle Enqueue Na mes

E Statistics Descriptions

Displaying Statistics

Statistics Descriptions

Contents

Title and Copyright Information

Send Us Your Comments

Pref ace

What's New in Oracle Database Reference?

Part I Initialization Parameters

1 Initialization Parameters

Part II Static Data Dictionary Views

2 Static Data Dictionary Views: ALL_ALL_TABLES to DATABASE_PROPERTIES

3 Stati c Data Dictionary Views: DBA_2PC_NEIGHBORS to USER_XML_VIEWS

Part III Dynamic Performance Views

5 Dynamic Performance (V$) Views: V$NLS_PARAMETERS to V$WAITSTAT

A Database Limits

B SQL Scripts

C Oracle Wait Events

D Oracle Enqueue Na mes

E Statistics Descriptions

Index