Wednesday, June 10, 2009

GV$ Views in Oracle9i

GV$ACCESS Synonym for GV_$ACCESS

GV$ACTIVE_INSTANCES Synonym for GV_$ACTIVE_INSTANCES

GV$ACTIVE_SESS_POOL_MTH Synonym for GV_$ACTIVE_SESS_POOL_MTH

GV$AQ Synonym for GV_$AQ

GV$AQ1 Synonym for GV_$AQ1

GV$ARCHIVE Synonym for GV_$ARCHIVE

GV$ARCHIVED_LOG Synonym for GV_$ARCHIVED_LOG

GV$ARCHIVE_DEST Synonym for GV_$ARCHIVE_DEST

GV$ARCHIVE_DEST_STATUS Synonym for GV_$ARCHIVE_DEST_STATUS

GV$ARCHIVE_GAP Synonym for GV_$ARCHIVE_GAP

GV$ARCHIVE_PROCESSES Synonym for GV_$ARCHIVE_PROCESSES

GV$AW_CALC Synonym for GV_$AW_CALC

GV$AW_OLAP Synonym for GV_$AW_OLAP

GV$AW_SESSION_INFO Synonym for GV_$AW_SESSION_INFO

GV$BACKUP Synonym for GV_$BACKUP

GV$BACKUP_ASYNC_IO Synonym for GV_$BACKUP_ASYNC_IO

GV$BACKUP_CORRUPTION Synonym for GV_$BACKUP_CORRUPTION

GV$BACKUP_DATAFILE Synonym for GV_$BACKUP_DATAFILE

GV$BACKUP_DEVICE Synonym for GV_$BACKUP_DEVICE

GV$BACKUP_PIECE Synonym for GV_$BACKUP_PIECE

GV$BACKUP_REDOLOG Synonym for GV_$BACKUP_REDOLOG

GV$BACKUP_SET Synonym for GV_$BACKUP_SET

GV$BACKUP_SPFILE Synonym for GV_$BACKUP_SPFILE

GV$BACKUP_SYNC_IO Synonym for GV_$BACKUP_SYNC_IO

GV$BGPROCESS Synonym for GV_$BGPROCESS

GV$BH Synonym for GV_$BH

GV$BSP Synonym for GV_$BSP

GV$BUFFER_POOL Synonym for GV_$BUFFER_POOL

GV$BUFFER_POOL_STATISTICS Synonym for GV_$BUFFER_POOL_STATISTICS

GV$CIRCUIT Synonym for GV_$CIRCUIT

GV$CLASS_CACHE_TRANSFER Synonym for GV_$CLASS_CACHE_TRANSFER

GV$CLASS_PING Synonym for GV_$CLASS_PING

GV$COMPATIBILITY Synonym for GV_$COMPATIBILITY

GV$COMPATSEG Synonym for GV_$COMPATSEG

GV$CONTEXT Synonym for GV_$CONTEXT

GV$CONTROLFILE Synonym for GV_$CONTROLFILE

GV$CONTROLFILE_RECORD_SECTION Synonym for GV_$CONTROLFILE_RECORD_SECTION

GV$COPY_CORRUPTION Synonym for GV_$COPY_CORRUPTION

GV$CR_BLOCK_SERVER Synonym for GV_$CR_BLOCK_SERVER

GV$DATABASE Synonym for GV_$DATABASE

GV$DATABASE_BLOCK_CORRUPTION Synonym for GV_$DATABASE_BLOCK_CORRUPTION

GV$DATABASE_INCARNATION Synonym for GV_$DATABASE_INCARNATION

GV$DATAFILE Synonym for GV_$DATAFILE

GV$DATAFILE_COPY Synonym for GV_$DATAFILE_COPY

GV$DATAFILE_HEADER Synonym for GV_$DATAFILE_HEADER

GV$DATAGUARD_STATUS Synonym for GV_$DATAGUARD_STATUS

GV$DBFILE Synonym for GV_$DBFILE

GV$DBLINK Synonym for GV_$DBLINK

GV$DB_CACHE_ADVICE Synonym for GV_$DB_CACHE_ADVICE

GV$DB_OBJECT_CACHE Synonym for GV_$DB_OBJECT_CACHE

GV$DB_PIPES Synonym for GV_$DB_PIPES

GV$DELETED_OBJECT Synonym for GV_$DELETED_OBJECT

GV$DISPATCHER Synonym for GV_$DISPATCHER

GV$DISPATCHER_RATE Synonym for GV_$DISPATCHER_RATE

GV$DLM_ALL_LOCKS Synonym for GV_$DLM_ALL_LOCKS

GV$DLM_CONVERT_LOCAL Synonym for GV_$DLM_CONVERT_LOCAL

GV$DLM_CONVERT_REMOTE Synonym for GV_$DLM_CONVERT_REMOTE

GV$DLM_LATCH Synonym for GV_$DLM_LATCH

GV$DLM_LOCKS Synonym for GV_$DLM_LOCKS

GV$DLM_MISC Synonym for GV_$DLM_MISC

GV$DLM_RESS Synonym for GV_$DLM_RESS

GV$DLM_TRAFFIC_CONTROLLER Synonym for GV_$DLM_TRAFFIC_CONTROLLER

GV$ENABLEDPRIVS Synonym for GV_$ENABLEDPRIVS

GV$ENQUEUE_LOCK Synonym for GV_$ENQUEUE_LOCK

GV$ENQUEUE_STAT Synonym for GV_$ENQUEUE_STAT

GV$EVENT_NAME Synonym for GV_$EVENT_NAME

GV$EXECUTION Synonym for GV_$EXECUTION

GV$FAST_START_SERVERS Synonym for GV_$FAST_START_SERVERS

GV$FAST_START_TRANSACTIONS Synonym for GV_$FAST_START_TRANSACTIONS

GV$FILESTAT Synonym for GV_$FILESTAT

GV$FILE_CACHE_TRANSFER Synonym for GV_$FILE_CACHE_TRANSFER

GV$FILE_PING Synonym for GV_$FILE_PING

GV$FIXED_TABLE Synonym for GV_$FIXED_TABLE

GV$FIXED_VIEW_DEFINITION Synonym for GV_$FIXED_VIEW_DEFINITION

GV$GCSHVMASTER_INFO Synonym for GV_$GCSHVMASTER_INFO

GV$GCSPFMASTER_INFO Synonym for GV_$GCSPFMASTER_INFO

GV$GC_ELEMENT Synonym for GV_$GC_ELEMENT

GV$GC_ELEMENTS_WITH_COLLISIONS Synonym for GV_$GC_ELEMENTS_W_COLLISIONS

GV$GES_BLOCKING_ENQUEUE Synonym for GV_$GES_BLOCKING_ENQUEUE

GV$GES_ENQUEUE Synonym for GV_$GES_ENQUEUE

GV$GLOBALCONTEXT Synonym for GV_$GLOBALCONTEXT

GV$GLOBAL_BLOCKED_LOCKS Synonym for GV_$GLOBAL_BLOCKED_LOCKS

GV$GLOBAL_TRANSACTION Synonym for GV_$GLOBAL_TRANSACTION

GV$HS_AGENT Synonym for GV_$HS_AGENT

GV$HS_PARAMETER Synonym for GV_$HS_PARAMETER

GV$HS_SESSION Synonym for GV_$HS_SESSION

GV$HVMASTER_INFO Synonym for GV_$HVMASTER_INFO

GV$INDEXED_FIXED_COLUMN Synonym for GV_$INDEXED_FIXED_COLUMN

GV$INSTANCE Synonym for GV_$INSTANCE

GV$INSTANCE_RECOVERY Synonym for GV_$INSTANCE_RECOVERY

GV$LATCH Synonym for GV_$LATCH

GV$LATCHHOLDER Synonym for GV_$LATCHHOLDER

GV$LATCHNAME Synonym for GV_$LATCHNAME

GV$LATCH_CHILDREN Synonym for GV_$LATCH_CHILDREN

GV$LATCH_MISSES Synonym for GV_$LATCH_MISSES

GV$LATCH_PARENT Synonym for GV_$LATCH_PARENT

GV$LIBRARYCACHE Synonym for GV_$LIBRARYCACHE

GV$LIBRARY_CACHE_MEMORY Synonym for GV_$LIBRARY_CACHE_MEMORY

GV$LICENSE Synonym for GV_$LICENSE

GV$LOADISTAT Synonym for GV_$LOADISTAT

GV$LOADPSTAT Synonym for GV_$LOADPSTAT

GV$LOCK Synonym for GV_$LOCK

GV$LOCKED_OBJECT Synonym for GV_$LOCKED_OBJECT

GV$LOCKS_WITH_COLLISIONS Synonym for GV_$LOCKS_WITH_COLLISIONS

GV$LOCK_ACTIVITY Synonym for GV_$LOCK_ACTIVITY

GV$LOCK_ELEMENT Synonym for GV_$LOCK_ELEMENT

GV$LOG Synonym for GV_$LOG

GV$LOGFILE Synonym for GV_$LOGFILE

GV$LOGHIST Synonym for GV_$LOGHIST

GV$LOGMNR_CALLBACK Synonym for GV_$LOGMNR_CALLBACK

GV$LOGMNR_CONTENTS Synonym for GV_$LOGMNR_CONTENTS

GV$LOGMNR_DICTIONARY Synonym for GV_$LOGMNR_DICTIONARY

GV$LOGMNR_LOGFILE Synonym for GV_$LOGMNR_LOGFILE

GV$LOGMNR_LOGS Synonym for GV_$LOGMNR_LOGS

GV$LOGMNR_PARAMETERS Synonym for GV_$LOGMNR_PARAMETERS

GV$LOGMNR_PROCESS Synonym for GV_$LOGMNR_PROCESS

GV$LOGMNR_REGION Synonym for GV_$LOGMNR_REGION

GV$LOGMNR_SESSION Synonym for GV_$LOGMNR_SESSION

GV$LOGMNR_STATS Synonym for GV_$LOGMNR_STATS

GV$LOGMNR_TRANSACTION Synonym for GV_$LOGMNR_TRANSACTION

GV$LOGSTDBY Synonym for GV_$LOGSTDBY

GV$LOGSTDBY_STATS Synonym for GV_$LOGSTDBY_STATS

GV$LOG_HISTORY Synonym for GV_$LOG_HISTORY

GV$MANAGED_STANDBY Synonym for GV_$MANAGED_STANDBY

GV$MAP_COMP_LIST Synonym for GV_$MAP_COMP_LIST

GV$MAP_ELEMENT Synonym for GV_$MAP_ELEMENT

GV$MAP_EXT_ELEMENT Synonym for GV_$MAP_EXT_ELEMENT

GV$MAP_FILE Synonym for GV_$MAP_FILE

GV$MAP_FILE_EXTENT Synonym for GV_$MAP_FILE_EXTENT

GV$MAP_FILE_IO_STACK Synonym for GV_$MAP_FILE_IO_STACK

GV$MAP_LIBRARY Synonym for GV_$MAP_LIBRARY

GV$MAP_SUBELEMENT Synonym for GV_$MAP_SUBELEMENT

GV$MAX_ACTIVE_SESS_TARGET_MTH Synonym for GV_$MAX_ACTIVE_SESS_TARGET_MTH

GV$MLS_PARAMETERS Synonym for GV_$MLS_PARAMETERS

GV$MTS Synonym for GV_$MTS

GV$MTTR_TARGET_ADVICE Synonym for GV_$MTTR_TARGET_ADVICE

GV$MVREFRESH Synonym for GV_$MVREFRESH

GV$MYSTAT Synonym for GV_$MYSTAT

GV$NLS_PARAMETERS Synonym for GV_$NLS_PARAMETERS

GV$NLS_VALID_VALUES Synonym for GV_$NLS_VALID_VALUES

GV$OBJECT_DEPENDENCY Synonym for GV_$OBJECT_DEPENDENCY

GV$OBSOLETE_PARAMETER Synonym for GV_$OBSOLETE_PARAMETER

GV$OFFLINE_RANGE Synonym for GV_$OFFLINE_RANGE

GV$OPEN_CURSOR Synonym for GV_$OPEN_CURSOR

GV$OPTION Synonym for GV_$OPTION

GV$PARALLEL_DEGREE_LIMIT_MTH Synonym for GV_$PARALLEL_DEGREE_LIMIT_MTH

GV$PARAMETER Synonym for GV_$PARAMETER

GV$PARAMETER2 Synonym for GV_$PARAMETER2

GV$PGASTAT Synonym for GV_$PGASTAT

GV$PGA_TARGET_ADVICE Synonym for GV_$PGA_TARGET_ADVICE

GV$PGA_TARGET_ADVICE_HISTOGRAM Synonym for GV_$PGATARGET_ADVICE_HISTOGRAM

GV$PQ_SESSTAT Synonym for GV_$PQ_SESSTAT

GV$PQ_SLAVE Synonym for GV_$PQ_SLAVE

GV$PQ_SYSSTAT Synonym for GV_$PQ_SYSSTAT

GV$PQ_TQSTAT Synonym for GV_$PQ_TQSTAT

GV$PROCESS Synonym for GV_$PROCESS

GV$PROXY_ARCHIVEDLOG Synonym for GV_$PROXY_ARCHIVEDLOG

GV$PROXY_DATAFILE Synonym for GV_$PROXY_DATAFILE

GV$PWFILE_USERS Synonym for GV_$PWFILE_USERS

GV$PX_PROCESS Synonym for GV_$PX_PROCESS

GV$PX_PROCESS_SYSSTAT Synonym for GV_$PX_PROCESS_SYSSTAT

GV$PX_SESSION Synonym for GV_$PX_SESSION

GV$PX_SESSTAT Synonym for GV_$PX_SESSTAT

GV$QUEUE Synonym for GV_$QUEUE

GV$QUEUEING_MTH Synonym for GV_$QUEUEING_MTH

GV$RECOVERY_FILE_STATUS Synonym for GV_$RECOVERY_FILE_STATUS

GV$RECOVERY_LOG Synonym for GV_$RECOVERY_LOG

GV$RECOVERY_PROGRESS Synonym for GV_$RECOVERY_PROGRESS

GV$RECOVERY_STATUS Synonym for GV_$RECOVERY_STATUS

GV$RECOVER_FILE Synonym for GV_$RECOVER_FILE

GV$REPLPROP Synonym for GV_$REPLPROP

GV$REPLQUEUE Synonym for GV_$REPLQUEUE

GV$REQDIST Synonym for GV_$REQDIST

GV$RESERVED_WORDS Synonym for GV_$RESERVED_WORDS

GV$RESOURCE Synonym for GV_$RESOURCE

GV$RESOURCE_LIMIT Synonym for GV_$RESOURCE_LIMIT

GV$RESUMABLE Synonym for GV_$RESUMABLE

GV$RMAN_CONFIGURATION Synonym for GV_$RMAN_CONFIGURATION

GV$ROLLSTAT Synonym for GV_$ROLLSTAT

GV$ROWCACHE Synonym for GV_$ROWCACHE

GV$ROWCACHE_PARENT Synonym for GV_$ROWCACHE_PARENT

GV$ROWCACHE_SUBORDINATE Synonym for GV_$ROWCACHE_SUBORDINATE

GV$RSRC_CONSUMER_GROUP Synonym for GV_$RSRC_CONSUMER_GROUP

GV$RSRC_CONSUMER_GROUP_CPU_MTH Synonym for GV_$RSRC_CONSUME_GROUP_CPU_MTH

GV$RSRC_PLAN Synonym for GV_$RSRC_PLAN

GV$RSRC_PLAN_CPU_MTH Synonym for GV_$RSRC_PLAN_CPU_MTH

GV$SEGMENT_STATISTICS Synonym for GV_$SEGMENT_STATISTICS

GV$SEGSTAT Synonym for GV_$SEGSTAT

GV$SEGSTAT_NAME Synonym for GV_$SEGSTAT_NAME

GV$SESSION Synonym for GV_$SESSION

GV$SESSION_CONNECT_INFO Synonym for GV_$SESSION_CONNECT_INFO

GV$SESSION_CURSOR_CACHE Synonym for GV_$SESSION_CURSOR_CACHE

GV$SESSION_EVENT Synonym for GV_$SESSION_EVENT

GV$SESSION_LONGOPS Synonym for GV_$SESSION_LONGOPS

GV$SESSION_OBJECT_CACHE Synonym for GV_$SESSION_OBJECT_CACHE

GV$SESSION_WAIT Synonym for GV_$SESSION_WAIT

GV$SESSTAT Synonym for GV_$SESSTAT

GV$SESS_IO Synonym for GV_$SESS_IO

GV$SGA Synonym for GV_$SGA

GV$SGASTAT Synonym for GV_$SGASTAT

GV$SGA_CURRENT_RESIZE_OPS Synonym for GV_$SGA_CURRENT_RESIZE_OPS

GV$SGA_DYNAMIC_COMPONENTS Synonym for GV_$SGA_DYNAMIC_COMPONENTS

GV$SGA_DYNAMIC_FREE_MEMORY Synonym for GV_$SGA_DYNAMIC_FREE_MEMORY

GV$SGA_RESIZE_OPS Synonym for GV_$SGA_RESIZE_OPS

GV$SHARED_POOL_ADVICE Synonym for GV_$SHARED_POOL_ADVICE

GV$SHARED_POOL_RESERVED Synonym for GV_$SHARED_POOL_RESERVED

GV$SHARED_SERVER Synonym for GV_$SHARED_SERVER

GV$SHARED_SERVER_MONITOR Synonym for GV_$SHARED_SERVER_MONITOR

GV$SORT_SEGMENT Synonym for GV_$SORT_SEGMENT

GV$SORT_USAGE Synonym for GV_$SORT_USAGE

GV$SPPARAMETER Synonym for GV_$SPPARAMETER

GV$SQL Synonym for GV_$SQL

GV$SQLAREA Synonym for GV_$SQLAREA

GV$SQLTEXT Synonym for GV_$SQLTEXT

GV$SQLTEXT_WITH_NEWLINES Synonym for GV_$SQLTEXT_WITH_NEWLINES

GV$SQL_BIND_DATA Synonym for GV_$SQL_BIND_DATA

GV$SQL_BIND_METADATA Synonym for GV_$SQL_BIND_METADATA

GV$SQL_CURSOR Synonym for GV_$SQL_CURSOR

GV$SQL_PLAN Synonym for GV_$SQL_PLAN

GV$SQL_PLAN_STATISTICS Synonym for GV_$SQL_PLAN_STATISTICS

GV$SQL_PLAN_STATISTICS_ALL Synonym for GV_$SQL_PLAN_STATISTICS_ALL

GV$SQL_REDIRECTION Synonym for GV_$SQL_REDIRECTION

GV$SQL_SHARED_CURSOR Synonym for GV_$SQL_SHARED_CURSOR

GV$SQL_SHARED_MEMORY Synonym for GV_$SQL_SHARED_MEMORY

GV$SQL_WORKAREA Synonym for GV_$SQL_WORKAREA

GV$SQL_WORKAREA_ACTIVE Synonym for GV_$SQL_WORKAREA_ACTIVE

GV$SQL_WORKAREA_HISTOGRAM Synonym for GV_$SQL_WORKAREA_HISTOGRAM

GV$STANDBY_LOG Synonym for GV_$STANDBY_LOG

GV$STATISTICS_LEVEL Synonym for GV_$STATISTICS_LEVEL

GV$STATNAME Synonym for GV_$STATNAME

GV$STREAMS_APPLY_COORDINATOR Synonym for GV_$STREAMS_APPLY_COORDINATOR

GV$STREAMS_APPLY_READER Synonym for GV_$STREAMS_APPLY_READER

GV$STREAMS_APPLY_SERVER Synonym for GV_$STREAMS_APPLY_SERVER

GV$STREAMS_CAPTURE Synonym for GV_$STREAMS_CAPTURE

GV$SUBCACHE Synonym for GV_$SUBCACHE

GV$SYSSTAT Synonym for GV_$SYSSTAT

GV$SYSTEM_CURSOR_CACHE Synonym for GV_$SYSTEM_CURSOR_CACHE

GV$SYSTEM_EVENT Synonym for GV_$SYSTEM_EVENT

GV$SYSTEM_PARAMETER Synonym for GV_$SYSTEM_PARAMETER

GV$SYSTEM_PARAMETER2 Synonym for GV_$SYSTEM_PARAMETER2

GV$TABLESPACE Synonym for GV_$TABLESPACE

GV$TEMPFILE Synonym for GV_$TEMPFILE

GV$TEMPORARY_LOBS Synonym for GV_$TEMPORARY_LOBS

GV$TEMPSEG_USAGE Synonym for GV_$SORT_USAGE

GV$TEMPSTAT Synonym for GV_$TEMPSTAT

GV$TEMP_CACHE_TRANSFER Synonym for GV_$TEMP_CACHE_TRANSFER

GV$TEMP_EXTENT_MAP Synonym for GV_$TEMP_EXTENT_MAP

GV$TEMP_EXTENT_POOL Synonym for GV_$TEMP_EXTENT_POOL

GV$TEMP_PING Synonym for GV_$TEMP_PING

GV$TEMP_SPACE_HEADER Synonym for GV_$TEMP_SPACE_HEADER

GV$THREAD Synonym for GV_$THREAD

GV$TIMER Synonym for GV_$TIMER

GV$TIMEZONE_NAMES Synonym for GV_$TIMEZONE_NAMES

GV$TRANSACTION Synonym for GV_$TRANSACTION

GV$TRANSACTION_ENQUEUE Synonym for GV_$TRANSACTION_ENQUEUE

GV$TYPE_SIZE Synonym for GV_$TYPE_SIZE

GV$UNDOSTAT Synonym for GV_$UNDOSTAT

GV$VERSION Synonym for GV_$VERSION

GV$VPD_POLICY Synonym for GV_$VPD_POLICY

GV$WAITSTAT Synonym for GV_$WAITSTAT

GV$_LOCK Synonym for GV_$_LOCK

No comments:

Post a Comment