Dynamic Tables


Oracle provides dynamically populated performance tables, owned by SYS, that permit the DBA to view current information about a wide variety of conditions in the database. These tables are generally accessed via their public synonyms. In all cases except V$OBJECT_USAGE, where the two names are identical, the table name is the same as the synonym name , except for the insertion of an underscore character before the dollar sign. An example would be the public synonym of V$SQLXS for the table SYS.V_$SQLXS. Table 3-2 is a complete list of these synonyms, and Table 3-3 expands that list to show the columns in each of the underlying Views.

Table 3-2. Complete List of "V$" Synonyms

V$_LOCK

V$ACCESS

V$ACTIVE_INSTANCES

V$ACTIVE_SESS_POOL_MTH

V$AQ

V$AQ1

V$ARCHIVE

V$ARCHIVED_LOG

V$ARCHIVE_DEST

V$ARCHIVE_DEST_STATUS

V$ARCHIVE_GAP

V$ARCHIVE_PROCESSES

V$AW_CALC

V$AW_OLAP

V$AW_SESSION_INFO

V$BACKUP

V$BACKUP_ASYNC_IO

V$BACKUP_CORRUPTION

V$BACKUP_DATAFILE

V$BACKUP_DEVICE

V$BACKUP_PIECE

V$BACKUP_REDOLOG

V$BACKUP_SET

V$BACKUP_SPFILE

V$BACKUP_SYNC_IO

V$BGPROCESS

V$BH

V$BSP

V$BUFFER_POOL

V$BUFFER_POOL_STATISTICS

V$CIRCUIT

V$CLASS_CACHE_TRANSFER

V$CLASS_PING

V$COMPATIBILITY

V$COMPATSEG

V$CONTEXT

V$CONTROLFILE

V$CONTROLFILE_RECORD_SECTION

V$COPY_CORRUPTION

V$CR_BLOCK_SERVER

V$DATABASE

V$DATABASE_BLOCK_CORRUPTION

V$DATABASE_INCARNATION

V$DATAFILE

V$DATAFILE_COPY

V$DATAFILE_HEADER

V$DATAGUARD_STATUS

V$DBFILE

V$DBLINK

V$DB_CACHE_ADVICE

V$DB_OBJECT_CACHE

V$DB_PIPES

V$DELETED_OBJECT

V$DISPATCHER

V$DISPATCHER_RATE

V$DLM_ALL_LOCKS

V$DLM_CONVERT_LOCAL

V$DLM_CONVERT_REMOTE

V$DLM_LATCH

V$DLM_LOCKS

V$DLM_MISC

V$DLM_RESS

V$DLM_TRAFFIC_CONTROLLER

V$ENABLEDPRIVS

V$ENQUEUE_LOCK

V$ENQUEUE_STAT

V$EVENT_NAME

V$EXECUTION

V$FAST_START_SERVERS

V$FAST_START_TRANSACTIONS

V$FILESTAT

V$FILESTATXS

V$FILE_CACHE_TRANSFER

V$FILE_PING

V$FIXED_TABLE

V$FIXED_VIEW_DEFINITION

V$GCSHVMASTER_INFO

V$GCSPFMASTER_INFO

V$GC_ELEMENT

V$GC_ELEMENTS_WITH_COLLISIONS

V$GES_BLOCKING_ENQUEUE

V$GES_ENQUEUE

V$GLOBALCONTEXT

V$GLOBAL_BLOCKED_LOCKS

V$GLOBAL_TRANSACTION

V$HS_AGENT

V$HS_PARAMETER

V$HS_SESSION

V$HVMASTER_INFO

V$INDEXED_FIXED_COLUMN

V$INSTANCE

V$INSTANCE_RECOVERY

V$LATCH

V$LATCHHOLDER

V$LATCHNAME

V$LATCH_CHILDREN

V$LATCH_MISSES

V$LATCH_PARENT

V$LIBRARYCACHE

V$LIBRARY_CACHE_MEMORY

V$LICENSE

V$LOADISTAT

V$LOADPSTAT

V$LOCK

V$LOCKED_OBJECT

V$LOCKS_WITH_COLLISIONS

V$LOCK_ACTIVITY

V$LOCK_ELEMENT

V$LOG

V$LOGFILE

V$LOGHIST

V$LOGMNR_CALLBACK

V$LOGMNR_CONTENTS

V$LOGMNR_DICTIONARY

V$LOGMNR_LOGFILE

V$LOGMNR_LOGS

V$LOGMNR_PARAMETERS

V$LOGMNR_PROCESS

V$LOGMNR_REGION

V$LOGMNR_SESSION

V$LOGMNR_STATS

V$LOGMNR_TRANSACTION

V$LOGSTDBY

V$LOGSTDBY_STATS

V$LOG_HISTORY

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$MAX_ACTIVE_SESS_TARGET_MTH

V$MLS_PARAMETERS

V$MTS

V$MTTR_TARGET_ADVICE

V$MVREFRESH

V$MYSTAT

V$NLS_PARAMETERS

V$NLS_VALID_VALUES

V$OBJECT_DEPENDENCY

V$OBJECT_USAGE

V$OBSOLETE_PARAMETER

V$OFFLINE_RANGE

V$OPEN_CURSOR

V$OPTION

V$PARALLEL_DEGREE_LIMIT_MTH

V$PARAMETER

V$PARAMETER2

V$PGASTAT

V$PGA_TARGET_ADVICE

V$PGA_TARGET_ADVICE_HISTOGRAM

V$PQ_SESSTAT

V$PQ_SLAVE

V$PQ_SYSSTAT

V$PQ_TQSTAT

V$PROCESS

V$PROXY_ARCHIVEDLOG

V$PROXY_DATAFILE

V$PWFILE_USERS

V$PX_PROCESS

V$PX_PROCESS_SYSSTAT

V$PX_SESSION

V$PX_SESSTAT

V$QUEUE

V$QUEUEING_MTH

V$RECOVERY_FILE_STATUS

V$RECOVERY_LOG

V$RECOVERY_PROGRESS

V$RECOVERY_STATUS

V$RECOVER_FILE

V$REPLPROP

V$REPLQUEUE

V$REQDIST

V$RESERVED_WORDS

V$RESOURCE

V$RESOURCE_LIMIT

V$RESUMABLE

V$RMAN_CONFIGURATION

V$ROLLNAME

V$ROLLSTAT

V$ROWCACHE

V$ROWCACHE_PARENT

V$ROWCACHE_SUBORDINATE

V$RSRC_CONSUMER_GROUP

V$RSRC_CONSUMER_GROUP_CPU_MTH

V$RSRC_PLAN

V$RSRC_PLAN_CPU_MTH

V$SEGMENT_STATISTICS

V$SEGSTAT

V$SEGSTAT_NAME

V$SESSION

V$SESSION_CONNECT_INFO

V$SESSION_CURSOR_CACHE

V$SESSION_EVENT

V$SESSION_LONGOPS

V$SESSION_OBJECT_CACHE

V$SESSION_WAIT

V$SESSTAT

V$SESS_IO

V$SGA

V$SGASTAT

V$SGA_CURRENT_RESIZE_OPS

V$SGA_DYNAMIC_COMPONENTS

V$SGA_DYNAMIC_FREE_MEMORY

V$SGA_RESIZE_OPS

V$SHARED_POOL_ADVICE

V$SHARED_POOL_RESERVED

V$SHARED_SERVER

V$SHARED_SERVER_MONITOR

V$SORT_SEGMENT

V$SORT_USAGE

V$SPPARAMETER

V$SQL

V$SQLAREA

V$SQLTEXT

V$SQLTEXT_WITH_NEWLINES

V$SQLXS

V$SQL_BIND_DATA

V$SQL_BIND_METADATA

V$SQL_CURSOR

V$SQL_PLAN

V$SQL_PLAN_STATISTICS

V$SQL_PLAN_STATISTICS_ALL

V$SQL_REDIRECTION

V$SQL_SHARED_CURSOR

V$SQL_SHARED_MEMORY

V$SQL_WORKAREA

V$SQL_WORKAREA_ACTIVE

V$SQL_WORKAREA_HISTOGRAM

V$STANDBY_LOG

V$STATISTICS_LEVEL

V$STATNAME

V$STREAMS_APPLY_COORDINATOR

V$STREAMS_APPLY_READER

V$STREAMS_APPLY_SERVER

V$STREAMS_CAPTURE

V$SUBCACHE

V$SYSSTAT

V$SYSTEM_CURSOR_CACHE

V$SYSTEM_EVENT

V$SYSTEM_PARAMETER

V$SYSTEM_PARAMETER2

V$TABLESPACE

V$TEMPFILE

V$TEMPORARY_LOBS

V$TEMPSEG_USAGE

V$TEMPSTAT

V$TEMPSTATXS

V$TEMP_CACHE_TRANSFER

V$TEMP_EXTENT_MAP

V$TEMP_EXTENT_POOL

V$TEMP_PING

V$TEMP_SPACE_HEADER

V$THREAD

V$TIMER

V$TIMEZONE_NAMES

V$TRANSACTION

V$TRANSACTION_ENQUEUE

V$TYPE_SIZE

V$UNDOSTAT

V$VERSION

V$VPD_POLICY

V$WAITSTAT

Table 3-3. List of Underlying Tables in Dynamic Views

View

Columns

V$OBJECT_USAGE

INDEX_NAME

 

TABLE_NAME

 

MONITORING

 

USED

 

START_MONITORING

 

END_MONITORING

V_$ACCESS

SID

 

OWNER

 

OBJECT

 

TYPE

V_$ACTIVE_INSTANCES

INST_NUMBER

 

INST_NAME

V_$ACTIVE_SESS_POOL_MTH

NAME

V_$AQ

QID

 

WAITING

 

READY

 

EXPIRED

 

TOTAL_WAIT

 

AVERAGE_WAIT

V_$AQ1

QID

 

WAITING

 

READY

 

EXPIRED

 

TOTAL_CONSUMERS

 

TOTAL_WAIT

 

AVERAGE_WAIT

V_$ARCHIVE

GROUP #

 

THREAD#

 

SEQUENCE#

 

ISCURRENT

 

CURRENT

 

FIRST_CHANGE#

V_$ARCHIVED_LOG

RECID

 

STAMP

 

NAME

 

DEST_ID

 

THREAD#

 

SEQUENCE#

 

RESETLOGS_CHANGE#

 

RESETLOGS_TIME

 

FIRST_CHANGE#

 

FIRST_TIME

 

NEXT_CHANGE#

 

NEXT_TIME

 

BLOCKS

 

BLOCK_SIZE

 

CREATOR

 

REGISTRAR

 

STANDBY_DEST

 

ARCHIVED

 

APPLIED

 

DELETED

 

STATUS

 

COMPLETION_TIME

 

DICTIONARY_BEGIN

 

DICTIONARY_END

 

END_OF_REDO

 

BACKUP_COUNT

 

ARCHIVAL_THREAD#

 

ACTIVATION#

V_$ARCHIVE_DEST

DEST_ID

 

DEST_NAME

 

STATUS

 

BINDING

 

NAME_SPACE

 

TARGET

 

ARCHIVER

 

SCHEDULE

 

DESTINATION

 

LOG_SEQUENCE

 

REOPEN_SECS

 

DELAY_MINS

 

NET_TIMEOUT

 

PROCESS

 

REGISTER

 

FAIL_DATE

 

FAIL_SEQUENCE

 

FAIL_BLOCK

 

FAILURE_COUNT

 

MAX_FAILURE

 

ERROR

 

ALTERNATE

 

DEPENDENCY

 

REMOTE_TEMPLATE

 

QUOTA_SIZE

 

QUOTA_USED

 

MOUNTID

 

TRANSMIT_MODE

 

ASYNC_BLOCKS

 

AFFIRM

 

TYPE

V_$ARCHIVE_DEST_STATUS

DEST_ID

 

DEST_NAME

 

STATUS

 

TYPE

 

DATABASE_MODE

 

RECOVERY_MODE

 

PROTECTION_MODE

 

DESTINATION

 

STANDBY_LOGFILE_COUNT

 

STANDBY_LOGFILE_ACTIVE

 

ARCHIVED_THREAD#

 

ARCHIVED_SEQ#

 

APPLIED_THREAD#

 

APPLIED_SEQ#

 

ERROR

 

SRL

V_$ARCHIVE_GAP

THREAD#

 

LOW_SEQUENCE#

 

HIGH_SEQUENCE#

V_$ARCHIVE_PROCESSES

PROCESS

 

STATUS

 

LOG_SEQUENCE

 

STATE

V_$AW_CALC

AGGREGATE_CACHE_HITS

 

AGGREGATE_CACHE_MISSES

 

SESSION_CACHE_HITS

 

SESSION_CACHE_MISSES

 

POOL_HITS

 

POOL_MISSES

 

POOL_NEW_PAGES

 

POOL_RECLAIMED_PAGES

 

CACHE_WRITES

 

POOL_SIZE

V_$AW_OLAP

SESSION_ID

 

AW_NUMBER

 

ATTACH_MODE

 

GENERATION

 

TEMP_SPACE_PAGES

 

TEMP_SPACE_READS

 

LOB_READS

 

POOL_CHANGED_PAGES

 

POOL_UNCHANGED_PAGES

V_$AW_SESSION_INFO

CLIENT_TYPE

 

SESSION_STATE

 

SESSION_HANDLE

 

USERID

 

CURR_DML_COMMAND

 

PREV_DML_COMMAND

 

TOTAL_TRANSACTION

 

TOTAL_TRANSACTION_TIME

 

AVERAGE_TRANSACTION_TIME

 

TRANSACTION_CPU_TIME

 

TOTAL_TRANSACTION_CPU_TIME

 

AVERAGE_TRANSACTION_CPU_TIME

V_$BACKUP

FILE#

 

STATUS

 

CHANGE#

 

TIME

V_$BACKUP_ASYNC_IO

SID

 

SERIAL

 

USE_COUNT

 

DEVICE_TYPE

 

TYPE

 

STATUS

 

FILENAME

 

SET_COUNT

 

SET_STAMP

 

BUFFER_SIZE

 

BUFFER_COUNT

 

TOTAL_BYTES

 

OPEN_TIME

 

CLOSE_TIME

 

ELAPSED_TIME

 

MAXOPENFILES

 

BYTES

 

EFFECTIVE_BYTES_PER_SECOND

 

IO_COUNT

 

READY

 

SHORT_WAITS

 

SHORT_WAIT_TIME_TOTAL

 

SHORT_WAIT_TIME_MAX

 

LONG_WAITS

 

LONG_WAIT_TIME_TOTAL

 

LONG_WAIT_TIME_MAX

V_$BACKUP_CORRUPTION

RECID

 

STAMP

 

SET_STAMP

 

SET_COUNT

 

PIECE#

 

FILE#

 

BLOCK#

 

BLOCKS

 

CORRUPTION_CHANGE#

 

MARKED_CORRUPT

 

CORRUPTION_TYPE

V_$BACKUP_DATAFILE

RECID

 

STAMP

 

SET_STAMP

 

SET_COUNT

 

FILE#

 

CREATION_CHANGE#

 

CREATION_TIME

 

RESETLOGS_CHANGE#

 

RESETLOGS_TIME

 

INCREMENTAL_LEVEL

 

INCREMENTAL_CHANGE#

 

CHECKPOINT_CHANGE#

 

CHECKPOINT_TIME

 

ABSOLUTE_FUZZY_CHANGE#

 

MARKED_CORRUPT

 

MEDIA_CORRUPT

 

LOGICALLY_CORRUPT

 

DATAFILE_BLOCKS

 

BLOCKS

 

BLOCK_SIZE

 

OLDEST_OFFLINE_RANGE

 

COMPLETION_TIME

 

CONTROLFILE_TYPE

V_$BACKUP_DEVICE

DEVICE_TYPE

 

DEVICE_NAME

V_$BACKUP_PIECE

RECID

 

STAMP

 

SET_STAMP

 

SET_COUNT

 

PIECE#

 

COPY#

 

DEVICE_TYPE

 

HANDLE

 

COMMENTS

 

MEDIA

 

MEDIA_POOL

 

CONCUR

 

TAG

 

STATUS

 

START_TIME

 

COMPLETION_TIME

 

ELAPSED_SECONDS

 

DELETED

V_$BACKUP_REDOLOG

RECID

 

STAMP

 

SET_STAMP

 

SET_COUNT

 

THREAD#

 

SEQUENCE#

 

RESETLOGS_CHANGE#

 

RESETLOGS_TIME

 

FIRST_CHANGE#

 

FIRST_TIME

 

NEXT_CHANGE#

 

NEXT_TIME

 

BLOCKS

 

BLOCK_SIZE

V_$BACKUP_SET

RECID

 

STAMP

 

SET_STAMP

 

SET_COUNT

 

BACKUP_TYPE

 

CONTROLFILE_INCLUDED

 

INCREMENTAL_LEVEL

 

PIECES

 

START_TIME

 

COMPLETION_TIME

 

ELAPSED_SECONDS

 

BLOCK_SIZE

 

INPUT_FILE_SCAN_ONLY

 

KEEP

 

KEEP_UNTIL

 

KEEP_OPTIONS

V_$BACKUP_SPFILE

RECID

 

STAMP

 

SET_STAMP

 

SET_COUNT

 

MODIFICATION_TIME

 

BYTES

 

COMPLETION_TIME

V_$BACKUP_SYNC_IO

SID

 

SERIAL

 

USE_COUNT

 

DEVICE_TYPE

 

TYPE

 

STATUS

 

FILENAME

 

SET_COUNT

 

SET_STAMP

 

BUFFER_SIZE

 

BUFFER_COUNT

 

TOTAL_BYTES

 

OPEN_TIME

 

CLOSE_TIME

 

ELAPSED_TIME

 

MAXOPENFILES

 

BYTES

 

EFFECTIVE_BYTES_PER_SECOND

 

IO_COUNT

 

IO_TIME_TOTAL

 

IO_TIME_MAX

 

DISCRETE_BYTES_PER_SECOND

V_$BGPROCESS

PADDR

 

NAME

 

DESCRIPTION

 

ERROR

V_$BH

FILE#

 

BLOCK#

 

CLASS#

 

STATUS

 

XNC

 

FORCED_READS

 

FORCED_WRITES

 

LOCK_ELEMENT_ADDR

 

LOCK_ELEMENT_NAME

 

LOCK_ELEMENT_CLASS

 

DIRTY

 

TEMP

 

PING

 

STALE

 

DIRECT

 

NEW

 

OBJD

 

TS#

V_$BSP

CR_REQUESTS

 

CURRENT_REQUESTS

 

DATA_REQUESTS

 

UNDO_REQUESTS

 

TX_REQUESTS

 

CURRENT_RESULTS

 

PRIVATE_RESULTS

 

ZERO_RESULTS

 

DISK_READ_RESULTS

 

FAIL_RESULTS

 

FAIRNESS_DOWN_CONVERTS

 

FAIRNESS_CLEARS

 

FREE_LOCK_ELEMENTS

 

FLUSHES

 

FLUSHES_QUEUED

 

FLUSH_QUEUE_FULL

 

FLUSH_MAX_TIME

 

LIGHT_WORKS

 

ERRORS

V_$BUFFER_POOL

BUFFERS

 

TARGET_SIZE

 

TARGET_BUFFERS

 

PREV_SIZE

 

PREV_BUFFERS

 

LO_BNUM

 

HI_BNUM

 

LO_SETID

 

HI_SETID

 

SET_COUNT

 

ID

 

NAME

 

BLOCK_SIZE

 

RESIZE_STATE

 

CURRENT_SIZE

V_$BUFFER_POOL_STATISTICS

ID

 

NAME

 

BLOCK_SIZE

 

SET_MSIZE

 

CNUM_REPL

 

CNUM_WRITE

 

CNUM_SET

 

BUF_GOT

 

SUM_WRITE

 

SUM_SCAN

 

FREE_BUFFER_WAIT

 

WRITE_COMPLETE_WAIT

 

BUFFER_BUSY_WAIT

 

FREE_BUFFER_INSPECTED

 

DIRTY_BUFFERS_INSPECTED

 

DB_BLOCK_CHANGE

 

DB_BLOCK_GETS

 

CONSISTENT_GETS

 

PHYSICAL_READS

 

PHYSICAL_WRITES

V_$CIRCUIT

CIRCUIT

 

DISPATCHER

 

SERVER

 

WAITER

 

SADDR

 

STATUS

 

QUEUE

 

MESSAGE0

 

MESSAGE1

 

MESSAGE2

 

MESSAGE3

 

MESSAGES

 

BYTES

 

BREAKS

 

PRESENTATION

 

PCIRCUIT

V_$CLASS_CACHE_TRANSFER

CLASS

 

X_2_NULL

 

X_2_NULL_FORCED_WRITE

 

X_2_NULL_FORCED_STALE

 

X_2_S

 

X_2_S_FORCED_WRITE

 

S_2_NULL

 

S_2_NULL_FORCED_STALE

 

NULL_2_X

 

S_2_X

 

NULL_2_S

V_$CLASS_PING

CLASS

 

X_2_NULL

 

X_2_NULL_FORCED_WRITE

 

X_2_NULL_FORCED_STALE

 

X_2_S

 

X_2_S_FORCED_WRITE

 

X_2_SSX

 

X_2_SSX_FORCED_WRITE

 

S_2_NULL

 

S_2_NULL_FORCED_STALE

 

SS_2_NULL

 

SS_2_RLS

 

OP_2_SS

 

NULL_2_X

 

S_2_X

 

SSX_2_X

 

NULL_2_S

 

NULL_2_SS

V_$COMPATIBILITY

TYPE_ID

 

RELEASE

 

DESCRIPTION

V_$COMPATSEG

TYPE_ID

 

RELEASE

 

UPDATED

V_$CONTEXT

NAMESPACE

 

ATTRIBUTE

 

VALUE

V_$CONTROLFILE

STATUS

 

NAME

V_$CONTROLFILE_RECORD_SECTION

TYPE

 

RECORD_SIZE

 

RECORDS_TOTAL

 

RECORDS_USED

 

FIRST_INDEX

 

LAST_INDEX

 

LAST_RECID

V_$COPY_CORRUPTION

RECID

 

STAMP

 

COPY_RECID

 

COPY_STAMP

 

FILE#

 

BLOCK#

 

BLOCKS

 

CORRUPTION_CHANGE#

 

MARKED_CORRUPT

 

CORRUPTION_TYPE

V_$CR_BLOCK_SERVER

CR_REQUESTS

 

CURRENT_REQUESTS

 

DATA_REQUESTS

 

UNDO_REQUESTS

 

TX_REQUESTS

 

CURRENT_RESULTS

 

PRIVATE_RESULTS

 

ZERO_RESULTS

 

DISK_READ_RESULTS

 

FAIL_RESULTS

 

FAIRNESS_DOWN_CONVERTS

 

FAIRNESS_CLEARS

 

FREE_GC_ELEMENTS

 

FLUSHES

 

FLUSHES_QUEUED

 

FLUSH_QUEUE_FULL

 

FLUSH_MAX_TIME

 

LIGHT_WORKS

 

ERRORS

V_$DATABASE

DBID

 

NAME

 

CREATED

 

RESETLOGS_CHANGE#

 

RESETLOGS_TIME

 

PRIOR_RESETLOGS_CHANGE#

 

PRIOR_RESETLOGS_TIME

 

LOG_MODE

 

CHECKPOINT_CHANGE#

 

ARCHIVE_CHANGE#

 

CONTROLFILE_TYPE

 

CONTROLFILE_CREATED

 

CONTROLFILE_SEQUENCE#

 

CONTROLFILE_CHANGE#

 

CONTROLFILE_TIME

 

OPEN_RESETLOGS

 

VERSION_TIME

 

OPEN_MODE

 

PROTECTION_MODE

 

PROTECTION_LEVEL

 

REMOTE_ARCHIVE

 

ACTIVATION#

 

DATABASE_ROLE

 

ARCHIVELOG_CHANGE#

 

SWITCHOVER_STATUS

 

DATAGUARD_BROKER

 

GUARD_STATUS

 

SUPPLEMENTAL_LOG_DATA_MIN

 

SUPPLEMENTAL_LOG_DATA_PK

 

SUPPLEMENTAL_LOG_DATA_UI

 

FORCE_LOGGING

V_$DATABASE_BLOCK_CORRUPTION

FILE#

 

BLOCK#

 

BLOCKS

 

CORRUPTION_CHANGE#

 

CORRUPTION_TYPE

V_$DATABASE_INCARNATION

RESETLOGS_CHANGE#

 

RESETLOGS_TIME

 

PRIOR_RESETLOGS_CHANGE#

 

PRIOR_RESETLOGS_TIME

V_$DATAFILE

FILE#

 

CREATION_CHANGE#

 

CREATION_TIME

 

TS#

 

RFILE#

 

STATUS

 

ENABLED

 

CHECKPOINT_CHANGE#

 

CHECKPOINT_TIME

 

UNRECOVERABLE_CHANGE#

 

UNRECOVERABLE_TIME

 

LAST_CHANGE#

 

LAST_TIME

 

OFFLINE_CHANGE#

 

ONLINE_CHANGE#

 

ONLINE_TIME

 

BYTES

 

BLOCKS

 

CREATE_BYTES

 

BLOCK_SIZE

 

NAME

 

PLUGGED_IN

 

BLOCK1_OFFSET

 

AUX_NAME

V_$DATAFILE_COPY

TAG

 

FILE#

 

RFILE#

 

CREATION_CHANGE#

 

CREATION_TIME

 

RESETLOGS_CHANGE#

 

RESETLOGS_TIME

 

INCREMENTAL_LEVEL

 

CHECKPOINT_CHANGE#

 

CHECKPOINT_TIME

 

ABSOLUTE_FUZZY_CHANGE#

 

RECOVERY_FUZZY_CHANGE#

 

RECOVERY_FUZZY_TIME

 

ONLINE_FUZZY

 

BACKUP_FUZZY

 

MARKED_CORRUPT

 

MEDIA_CORRUPT

 

LOGICALLY_CORRUPT

 

BLOCKS

 

BLOCK_SIZE

 

OLDEST_OFFLINE_RANGE

 

DELETED

 

STATUS

 

COMPLETION_TIME

 

CONTROLFILE_TYPE

 

KEEP

 

KEEP_UNTIL

 

KEEP_OPTIONS

 

SCANNED

 

RECID

 

STAMP

 

NAME

V_$DATAFILE_HEADER

FILE#

 

STATUS

 

ERROR

 

FORMAT

 

RECOVER

 

FUZZY

 

CREATION_CHANGE#

 

CREATION_TIME

 

TABLESPACE_NAME

 

TS#

 

RFILE#

 

RESETLOGS_CHANGE#

 

RESETLOGS_TIME

 

CHECKPOINT_CHANGE#

 

CHECKPOINT_TIME

 

CHECKPOINT_COUNT

 

BYTES

 

BLOCKS

 

NAME

V_$DATAGUARD_STATUS

FACILITY

 

SEVERITY

 

DEST_ID

 

MESSAGE_NUM

 

ERROR_CODE

 

CALLOUT

 

TIMESTAMP

 

MESSAGE

V_$DBFILE

FILE#

 

NAME

V_$DBLINK

DB_LINK

 

OWNER_ID

 

LOGGED_ON

 

HETEROGENEOUS

 

PROTOCOL

 

OPEN_CURSORS

 

IN_TRANSACTION

 

UPDATE_SENT

 

COMMIT_POINT_STRENGTH

V_$DB_CACHE_ADVICE

ID

 

NAME

 

BLOCK_SIZE

 

ADVICE_STATUS

 

SIZE_FOR_ESTIMATE

 

SIZE_FACTOR

 

BUFFERS_FOR_ESTIMATE

 

ESTD_PHYSICAL_READ_FACTOR

 

ESTD_PHYSICAL_READS

V_$DB_OBJECT_CACHE

OWNER

 

NAME

 

DB_LINK

 

NAMESPACE

 

TYPE

 

SHARABLE_MEM

 

LOADS

 

EXECUTIONS

 

LOCKS

 

PINS

 

KEPT

 

CHILD_LATCH

V_$DB_PIPES

OWNERID

 

NAME

 

TYPE

 

PIPE_SIZE

V_$DELETED_OBJECT

RECID

 

STAMP

 

TYPE

 

OBJECT_RECID

 

OBJECT_STAMP

 

OBJECT_DATA

V_$DISPATCHER

NAME

 

NETWORK

 

PADDR

 

STATUS

 

ACCEPT

 

MESSAGES

 

BYTES

 

BREAKS

 

OWNED

 

CREATED

 

IDLE

 

BUSY

 

LISTENER

 

CONF_INDX

V_$DISPATCHER_RATE

AVG_EVENT_RATE

 

AVG_EVENTS_PER_LOOP

 

AVG_MSG_RATE

 

AVG_SVR_BUF_RATE

 

AVG_SVR_BYTE_RATE

 

AVG_SVR_BYTE_PER_BUF

 

AVG_CLT_BUF_RATE

 

AVG_CLT_BYTE_RATE

 

AVG_CLT_BYTE_PER_BUF

 

AVG_BUF_RATE

 

AVG_BYTE_RATE

 

AVG_BYTE_PER_BUF

 

AVG_IN_CONNECT_RATE

 

AVG_OUT_CONNECT_RATE

 

AVG_RECONNECT_RATE

 

TTL_LOOPS

 

TTL_MSG

 

TTL_SVR_BUF

 

TTL_CLT_BUF

 

TTL_BUF

 

TTL_IN_CONNECT

 

TTL_OUT_CONNECT

 

TTL_RECONNECT

 

SCALE_LOOPS

 

SCALE_MSG

 

SCALE_SVR_BUF

 

SCALE_CLT_BUF

 

SCALE_BUF

 

SCALE_IN_CONNECT

 

SCALE_OUT_CONNECT

 

SCALE_RECONNECT

 

NAME

 

PADDR

 

CUR_LOOP_RATE

 

CUR_EVENT_RATE

 

CUR_EVENTS_PER_LOOP

 

CUR_MSG_RATE

 

CUR_SVR_BUF_RATE

 

CUR_SVR_BYTE_RATE

 

CUR_SVR_BYTE_PER_BUF

 

CUR_CLT_BUF_RATE

 

CUR_CLT_BYTE_RATE

 

CUR_CLT_BYTE_PER_BUF

 

CUR_BUF_RATE

 

CUR_BYTE_RATE

 

CUR_BYTE_PER_BUF

 

CUR_IN_CONNECT_RATE

 

CUR_OUT_CONNECT_RATE

 

CUR_RECONNECT_RATE

 

MAX_LOOP_RATE

 

MAX_EVENT_RATE

 

MAX_EVENTS_PER_LOOP

 

MAX_MSG_RATE

 

MAX_SVR_BUF_RATE

 

MAX_SVR_BYTE_RATE

 

MAX_SVR_BYTE_PER_BUF

 

MAX_CLT_BUF_RATE

 

MAX_CLT_BYTE_RATE

 

MAX_CLT_BYTE_PER_BUF

 

MAX_BUF_RATE

 

MAX_BYTE_RATE

 

MAX_BYTE_PER_BUF

 

MAX_IN_CONNECT_RATE

 

MAX_OUT_CONNECT_RATE

 

MAX_RECONNECT_RATE

 

AVG_LOOP_RATE

V_$DLM_ALL_LOCKS

LOCKP

 

GRANT_LEVEL

 

REQUEST_LEVEL

 

RESOURCE_NAME1

 

RESOURCE_NAME2

 

PID

 

TRANSACTION_ID0

 

TRANSACTION_ID1

 

GROUP_ID

 

OPEN_OPT_DEADLOCK

 

OPEN_OPT_PERSISTENT

 

OPEN_OPT_PROCESS_OWNED

 

OPEN_OPT_NO_XID

 

CONVERT_OPT_GETVALUE

 

CONVERT_OPT_PUTVALUE

 

CONVERT_OPT_NOVALUE

 

CONVERT_OPT_DUBVALUE

 

CONVERT_OPT_NOQUEUE

 

CONVERT_OPT_EXPRESS

 

CONVERT_OPT_NODEADLOCKWAIT

 

CONVERT_OPT_NODEADLOCKBLOCK

 

WHICH_QUEUE

 

LOCKSTATE

 

AST_EVENT0

 

OWNER_NODE

 

BLOCKED

 

BLOCKER

V_$DLM_CONVERT_LOCAL

INST_ID

 

CONVERT_TYPE

 

AVERAGE_CONVERT_TIME

 

CONVERT_COUNT

V_$DLM_CONVERT_REMOTE

INST_ID

 

CONVERT_TYPE

 

AVERAGE_CONVERT_TIME

 

CONVERT_COUNT

V_$DLM_LATCH

IMMEDIATE_GETS

 

IMMEDIATE_MISSES

 

WAITERS_WOKEN

 

WAITS_HOLDING_LATCH

 

SPIN_GETS

 

SLEEP1

 

SLEEP2

 

SLEEP3

 

SLEEP4

 

SLEEP5

 

SLEEP6

 

SLEEP7

 

SLEEP8

 

SLEEP9

 

SLEEP10

 

SLEEP11

 

WAIT_TIME

 

ADDR

 

LATCH#

 

LEVEL#

 

NAME

 

GETS

 

MISSES

 

SLEEPS

V_$DLM_LOCKS

LOCKP

 

GRANT_LEVEL

 

REQUEST_LEVEL

 

RESOURCE_NAME1

 

RESOURCE_NAME2

 

PID

 

TRANSACTION_ID0

 

TRANSACTION_ID1

 

GROUP_ID

 

OPEN_OPT_DEADLOCK

 

OPEN_OPT_PERSISTENT

 

OPEN_OPT_PROCESS_OWNED

 

OPEN_OPT_NO_XID

 

CONVERT_OPT_GETVALUE

 

CONVERT_OPT_PUTVALUE

 

CONVERT_OPT_NOVALUE

 

CONVERT_OPT_DUBVALUE

 

CONVERT_OPT_NOQUEUE

 

CONVERT_OPT_EXPRESS

 

CONVERT_OPT_NODEADLOCKWAIT

 

CONVERT_OPT_NODEADLOCKBLOCK

 

WHICH_QUEUE

 

LOCKSTATE

 

AST_EVENT0

 

OWNER_NODE

 

BLOCKED

 

BLOCKER

V_$DLM_MISC

STATISTIC#

 

NAME

 

VALUE

V_$DLM_RESS

RESP

 

RESOURCE_NAME

 

ON_CONVERT_Q

 

ON_GRANT_Q

 

PERSISTENT_RES

 

MASTER_NODE

 

NEXT_CVT_LEVEL

 

VALUE_BLK_STATE

 

VALUE_BLK

V_$DLM_TRAFFIC_CONTROLLER

LOCAL_NID

 

REMOTE_NID

 

REMOTE_RID

 

REMOTE_INC

 

TCKT_AVAIL

 

TCKT_LIMIT

 

TCKT_RCVD

 

TCKT_WAIT

 

SND_SEQ_NO

 

RCV_SEQ_NO

 

SND_Q_LEN

 

SND_Q_MAX

 

SND_Q_TOT

 

SND_Q_TM_BASE

 

SND_Q_TM_WRAP

 

STATUS

 

SND_PROXY

V_$ENABLEDPRIVS

PRIV_NUMBER

V_$ENQUEUE_LOCK

ADDR

 

KADDR

 

SID

 

TYPE

 

ID1

 

ID2

 

LMODE

 

REQUEST

 

CTIME

 

BLOCK

V_$ENQUEUE_STAT

INST_ID

 

EQ_TYPE

 

TOTAL_REQ#

 

TOTAL_WAIT#

 

SUCC_REQ#

 

FAILED_REQ#

 

CUM_WAIT_TIME

V_$EVENT_NAME

EVENT#

 

NAME

 

PARAMETER1

 

PARAMETER2

 

PARAMETER3

V_$EXECUTION

PID

 

DEPTH

 

FUNCTION

 

TYPE

 

NVALS

 

VAL1

 

VAL2

 

SEQH

 

SEQL

V_$FAST_START_SERVERS

STATE

 

UNDOBLOCKSDONE

 

PID

V_$FAST_START_TRANSACTIONS

USN

 

SLT

 

SEQ

 

STATE

 

UNDOBLOCKSDONE

 

UNDOBLOCKSTOTAL

 

PID

 

CPUTIME

 

PARENTUSN

 

PARENTSLT

 

PARENTSEQ

V_$FILESTAT

FILE#

 

PHYRDS

 

PHYWRTS

 

PHYBLKRD

 

PHYBLKWRT

 

SINGLEBLKRDS

 

READTIM

 

WRITETIM

 

SINGLEBLKRDTIM

 

AVGIOTIM

 

LSTIOTIM

 

MINIOTIM

 

MAXIORTM

 

MAXIOWTM

V_$FILESTATXS

TSNAME

 

FILENAME

 

PHYRDS

 

PHYWRTS

 

READTIM

 

WRITETIM

 

PHYBLKRD

 

PHYBLKWRT

 

WAIT_COUNT

 

TIME

V_$FILE_CACHE_TRANSFER

FILE_NUMBER

 

X_2_NULL

 

X_2_NULL_FORCED_WRITE

 

X_2_NULL_FORCED_STALE

 

X_2_S

 

X_2_S_FORCED_WRITE

 

S_2_NULL

 

S_2_NULL_FORCED_STALE

 

RBR

 

RBR_FORCED_WRITE

 

RBR_FORCED_STALE

 

NULL_2_X

 

S_2_X

 

NULL_2_S

 

CR_TRANSFERS

 

CUR_TRANSFERS

V_$FILE_PING

FILE_NUMBER

 

FREQUENCY

 

X_2_NULL

 

X_2_NULL_FORCED_WRITE

 

X_2_NULL_FORCED_STALE

 

X_2_S

 

X_2_S_FORCED_WRITE

 

X_2_SSX

 

X_2_SSX_FORCED_WRITE

 

S_2_NULL

 

S_2_NULL_FORCED_STALE

 

SS_2_NULL

 

SS_2_RLS

 

WRB

 

WRB_FORCED_WRITE

 

RBR

 

RBR_FORCED_WRITE

 

RBR_FORCED_STALE

 

CBR

 

CBR_FORCED_WRITE

 

NULL_2_X

 

S_2_X

 

SSX_2_X

 

NULL_2_S

 

NULL_2_SS

 

OP_2_SS

V_$FIXED_TABLE

NAME

 

OBJECT_ID

 

TYPE

 

TABLE_NUM

V_$FIXED_VIEW_DEFINITION

VIEW_NAME

 

VIEW_DEFINITION

V_$GCSHVMASTER_INFO

HV_ID

 

CURRENT_MASTER

 

PREVIOUS_MASTER

 

REMASTER_CNT

V_$GCSPFMASTER_INFO

FILE_ID

 

CURRENT_MASTER

 

PREVIOUS_MASTER

 

REMASTER_CNT

V_$GC_ELEMENT

GC_ELEMENT_ADDR

 

INDX

 

CLASS

 

GC_ELEMENT_NAME

 

MODE_HELD

 

BLOCK_COUNT

 

RELEASING

 

ACQUIRING

 

WRITING

 

RECOVERING

 

LOCAL

 

FLAGS

V_$GC_ELEMENTS_WITH_COLLISIONS

GC_ELEMENT_ADDR

V_$GES_BLOCKING_ENQUEUE

HANDLE

 

GRANT_LEVEL

 

REQUEST_LEVEL

 

RESOURCE_NAME1

 

RESOURCE_NAME2

 

PID

 

TRANSACTION_ID0

 

TRANSACTION_ID1

 

GROUP_ID

 

OPEN_OPT_DEADLOCK

 

OPEN_OPT_PERSISTENT

 

OPEN_OPT_PROCESS_OWNED

 

OPEN_OPT_NO_XID

 

CONVERT_OPT_GETVALUE

 

CONVERT_OPT_PUTVALUE

 

CONVERT_OPT_NOVALUE

 

CONVERT_OPT_DUBVALUE

 

CONVERT_OPT_NOQUEUE

 

CONVERT_OPT_EXPRESS

 

CONVERT_OPT_NODEADLOCKWAIT

 

CONVERT_OPT_NODEADLOCKBLOCK

 

WHICH_QUEUE

 

STATE

 

AST_EVENT0

 

OWNER_NODE

 

BLOCKED

 

BLOCKER

V_$GES_ENQUEUE

HANDLE

 

GRANT_LEVEL

 

REQUEST_LEVEL

 

RESOURCE_NAME1

 

RESOURCE_NAME2

 

PID

 

TRANSACTION_ID0

 

TRANSACTION_ID1

 

GROUP_ID

 

OPEN_OPT_DEADLOCK

 

OPEN_OPT_PERSISTENT

 

OPEN_OPT_PROCESS_OWNED

 

OPEN_OPT_NO_XID

 

CONVERT_OPT_GETVALUE

 

CONVERT_OPT_PUTVALUE

 

CONVERT_OPT_NOVALUE

 

CONVERT_OPT_DUBVALUE

 

CONVERT_OPT_NOQUEUE

 

CONVERT_OPT_EXPRESS

 

CONVERT_OPT_NODEADLOCKWAIT

 

CONVERT_OPT_NODEADLOCKBLOCK

 

WHICH_QUEUE

 

STATE

 

AST_EVENT0

 

OWNER_NODE

 

BLOCKED

 

BLOCKER

V_$GLOBALCONTEXT

NAMESPACE

 

ATTRIBUTE

 

VALUE

 

USERNAME

 

CLIENT_IDENTIFIER

V_$GLOBAL_BLOCKED_LOCKS

ADDR

 

KADDR

 

SID

 

TYPE

 

ID1

 

ID2

 

LMODE

 

REQUEST

 

CTIME

V_$GLOBAL_TRANSACTION

FORMATID

 

GLOBALID

 

BRANCHID

 

BRANCHES

 

REFCOUNT

 

PREPARECOUNT

 

STATE

 

FLAGS

 

COUPLING

V_$HS_AGENT

AGENT_ID

 

MACHINE

 

PROCESS

 

PROGRAM

 

OSUSER

 

STARTTIME

 

AGENT_TYPE

 

FDS_CLASS_ID

 

FDS_INST_ID

V_$HS_PARAMETER

HS_SESSION_ID

 

PARAMETER

 

VALUE

 

SOURCE

 

ENV

V_$HS_SESSION

HS_SESSION_ID

 

AGENT_ID

 

SID

 

DB_LINK

 

DB_LINK_OWNER

 

STARTTIME

V_$HVMASTER_INFO

HV_ID

 

CURRENT_MASTER

 

PREVIOUS_MASTER

 

REMASTER_CNT

V_$INDEXED_FIXED_COLUMN

TABLE_NAME

 

INDEX_NUMBER

 

COLUMN_NAME

 

COLUMN_POSITION

V_$INSTANCE

INSTANCE_NUMBER

 

INSTANCE_NAME

 

HOST_NAME

 

VERSION

 

STARTUP_TIME

 

STATUS

 

PARALLEL

 

THREAD#

 

ARCHIVER

 

LOG_SWITCH_WAIT

 

LOGINS

 

SHUTDOWN_PENDING

 

DATABASE_STATUS

 

INSTANCE_ROLE

 

ACTIVE_STATE

V_$INSTANCE_RECOVERY

RECOVERY_ESTIMATED_IOS

 

ACTUAL_REDO_BLKS

 

TARGET_REDO_BLKS

 

LOG_FILE_SIZE_REDO_BLKS

 

LOG_CHKPT_TIMEOUT_REDO_BLKS

 

LOG_CHKPT_INTERVAL_REDO_BLKS

 

FAST_START_IO_TARGET_REDO_BLKS

 

TARGET_MTTR

 

ESTIMATED_MTTR

 

CKPT_BLOCK_WRITES

V_$LATCH

ADDR

 

LATCH#

 

LEVEL#

 

NAME

 

GETS

 

MISSES

 

SLEEPS

 

IMMEDIATE_GETS

 

IMMEDIATE_MISSES

 

WAITERS_WOKEN

 

WAITS_HOLDING_LATCH

 

SPIN_GETS

 

SLEEP1

 

SLEEP2

 

SLEEP3

 

SLEEP4

 

SLEEP5

 

SLEEP6

 

SLEEP7

 

SLEEP8

 

SLEEP9

 

SLEEP10

 

SLEEP11

 

WAIT_TIME

V_$LATCHHOLDER

PID

 

SID

 

LADDR

 

NAME

V_$LATCHNAME

LATCH#

 

NAME

V_$LATCH_CHILDREN

ADDR

 

LATCH#

 

CHILD#

 

LEVEL#

 

NAME

 

GETS

 

MISSES

 

SLEEPS

 

IMMEDIATE_GETS

 

IMMEDIATE_MISSES

 

WAITERS_WOKEN

 

WAITS_HOLDING_LATCH

 

SPIN_GETS

 

SLEEP1

 

SLEEP2

 

SLEEP3

 

SLEEP4

 

SLEEP5

 

SLEEP6

 

SLEEP7

 

SLEEP8

 

SLEEP9

 

SLEEP10

 

SLEEP11

 

WAIT_TIME

V_$LATCH_MISSES

PARENT_NAME

 

WHERE

 

NWFAIL_COUNT

 

SLEEP_COUNT

 

WTR_SLP_COUNT

 

LONGHOLD_COUNT

 

LOCATION

V_$LATCH_PARENT

ADDR

 

LATCH#

 

LEVEL#

 

NAME

 

GETS

 

MISSES

 

SLEEPS

 

IMMEDIATE_GETS

 

IMMEDIATE_MISSES

 

WAITERS_WOKEN

 

WAITS_HOLDING_LATCH

 

SPIN_GETS

 

SLEEP1

 

SLEEP2

 

SLEEP3

 

SLEEP4

 

SLEEP5

 

SLEEP6

 

SLEEP7

 

SLEEP8

 

SLEEP9

 

SLEEP10

 

SLEEP11

 

WAIT_TIME

V_$LIBRARYCACHE

NAMESPACE

 

GETS

 

GETHITS

 

GETHITRATIO

 

PINS

 

PINHITS

 

PINHITRATIO

 

RELOADS

 

INVALIDATIONS

 

DLM_LOCK_REQUESTS

 

DLM_PIN_REQUESTS

 

DLM_PIN_RELEASES

 

DLM_INVALIDATION_REQUESTS

 

DLM_INVALIDATIONS

V_$LIBRARY_CACHE_MEMORY

LC_NAMESPACE

 

LC_INUSE_MEMORY_OBJECTS

 

LC_INUSE_MEMORY_SIZE

 

LC_FREEABLE_MEMORY_OBJECTS

 

LC_FREEABLE_MEMORY_SIZE

V_$LICENSE

SESSIONS_MAX

 

SESSIONS_WARNING

 

SESSIONS_CURRENT

 

SESSIONS_HIGHWATER

 

USERS_MAX

V_$LOADISTAT

OWNER

 

TABNAME

 

INDEXNAME

 

SUBNAME

 

MESSAGE

V_$LOADPSTAT

OWNER

 

TABNAME

 

PARTNAME

 

LOADED

V_$LOCK

ADDR

 

KADDR

 

SID

 

TYPE

 

ID1

 

ID2

 

LMODE

 

REQUEST

 

CTIME

 

BLOCK

V_$LOCKED_OBJECT

ORACLE_USERNAME

 

OS_USER_NAME

 

PROCESS

 

LOCKED_MODE

 

XIDUSN

 

XIDSLOT

 

XIDSQN

 

OBJECT_ID

 

SESSION_ID

V_$LOCKS_WITH_COLLISIONS

LOCK_ELEMENT_ADDR

V_$LOCK_ACTIVITY

TO_VAL

 

ACTION_VAL

 

COUNTER

 

FROM_VAL

V_$LOCK_ELEMENT

LOCK_ELEMENT_ADDR

 

INDX

 

CLASS

 

LOCK_ELEMENT_NAME

 

MODE_HELD

 

BLOCK_COUNT

 

RELEASING

 

ACQUIRING

 

INVALID

 

FLAGS

V_$LOG

GROUP#

 

THREAD#

 

SEQUENCE#

 

BYTES

 

MEMBERS

 

ARCHIVED

 

STATUS

 

FIRST_CHANGE#

 

FIRST_TIME

V_$LOGFILE

GROUP#

 

STATUS

 

TYPE

 

MEMBER

V_$LOGHIST

THREAD#

 

SEQUENCE#

 

FIRST_CHANGE#

 

FIRST_TIME

 

SWITCH_CHANGE#

V_$LOGMNR_CALLBACK

STATE

 

TYPE

 

CAPABILITY

V_$LOGMNR_CONTENTS

SCN

 

CSCN

 

TIMESTAMP

 

COMMIT_TIMESTAMP

 

THREAD#

 

LOG_ID

 

XIDUSN

 

XIDSLT

 

XIDSQN

 

PXIDUSN

 

PXIDSLT

 

PXIDSQN

 

RBASQN

 

RBABLK

 

RBABYTE

 

UBAFIL

 

UBABLK

 

UBAREC

 

UBASQN

 

ABS_FILE#

 

REL_FILE#

 

DATA_BLK#

 

DATA_OBJ#

 

DATA_OBJD#

 

SEG_OWNER

 

SEG_NAME

 

SEG_TYPE

 

SEG_TYPE_NAME

 

TABLE_SPACE

 

ROW_ID

 

SESSION#

 

SERIAL#

 

USERNAME

 

SESSION_INFO

 

TX_NAME

 

ROLLBACK

 

OPERATION

 

OPERATION_CODE

 

SQL_REDO

 

SQL_UNDO

 

RS_ID

 

SEQUENCE#

 

SSN

 

CSF

 

INFO

 

STATUS

 

REDO_VALUE

 

UNDO_VALUE

 

SQL_COLUMN_TYPE

 

SQL_COLUMN_NAME

 

REDO_LENGTH

 

REDO_OFFSET

 

UNDO_LENGTH

 

UNDO_OFFSET

V_$LOGMNR_DICTIONARY

TIMESTAMP

 

DB_ID

 

DB_NAME

 

FILENAME

 

DICTIONARY_SCN

 

RESET_SCN

 

RESET_SCN_TIME

 

ENABLED_THREAD_MAP

 

INFO

 

STATUS

V_$LOGMNR_LOGFILE

LOG_ID

 

FILENAME

 

LOW_TIME

 

NEXT_TIME

 

DB_ID

 

DB_NAME

 

RESET_SCNWRP

 

RESET_SCNBAS

 

RESET_SCN_TIME

 

THREAD_ID

 

THREAD_SQN

 

LOW_SCNWRP

 

LOW_SCNBAS

 

NEXT_SCNWRP

 

NEXT_SCNBAS

 

FILE_STATE

V_$LOGMNR_LOGS

LOG_ID

 

FILENAME

 

LOW_TIME

 

HIGH_TIME

 

DB_ID

 

DB_NAME

 

RESET_SCN

 

RESET_SCN_TIME

 

THREAD_ID

 

THREAD_SQN

 

LOW_SCN

 

NEXT_SCN

 

DICTIONARY_BEGIN

 

DICTIONARY_END

 

INFO

 

STATUS

V_$LOGMNR_PARAMETERS

END_SCN

 

INFO

 

STATUS

 

START_DATE

 

END_DATE

 

START_SCN

V_$LOGMNR_PROCESS

PID

 

SPID

 

ROLE

 

USERNAME

 

SERIAL#

 

LATCHWAIT

 

LATCHSPIN

V_$LOGMNR_REGION

MEMSTATE

 

STATE

 

OWNING_PROCESS

V_$LOGMNR_SESSION

SESSION_ID

 

SESSION_NAME

 

SESSION_STATE

 

START_SCNWRP

 

START_SCNBAS

 

END_SCNWRP

 

END_SCNBAS

 

SPILL_SCNWRP

 

SPILL_SCNBAS

 

REQUIRED_SLAVE_NUM

 

EAGER_THRESHOLD

 

STOPMINING_THRESHOLD

 

MEMORY_SIZE

 

CLIENT_ID

 

DB_ID

 

RESET_SCNWRP

 

RESET_SCNBAS

 

CALLBACK_COUNT

 

SLAVE_COUNT

V_$LOGMNR_STATS

SESSION_ID

 

NAME

 

VALUE

V_$LOGMNR_TRANSACTION

XIDUSN

 

XIDSLT

 

XIDSQN

 

COMMIT_SCNWRP

 

COMMIT_SCNBAS

 

NUM_CHANGE_RECORD

 

FLAGS

 

CHUNK_INDEX

 

TOTAL_CHUNKS

V_$LOGSTDBY

SERIAL#

 

LOGSTDBY_ID

 

PID

 

TYPE

 

STATUS_CODE

 

STATUS

 

HIGH_SCN

V_$LOGSTDBY_STATS

NAME

 

VALUE

V_$LOG_HISTORY

RECID

 

STAMP

 

THREAD#

 

SEQUENCE#

 

FIRST_CHANGE#

 

FIRST_TIME

 

NEXT_CHANGE#

V_$MANAGED_STANDBY

PROCESS

 

PID

 

STATUS

 

CLIENT_PROCESS

 

CLIENT_PID

 

CLIENT_DBID

 

GROUP#

 

THREAD#

 

SEQUENCE#

 

BLOCK#

 

BLOCKS

 

DELAY_MINS

 

KNOWN_AGENTS

 

ACTIVE_AGENTS

V_$MAP_COMP_LIST

ELEM_IDX

 

NUM_COMP

 

COMP1_NAME

 

COMP1_VAL

 

COMP2_NAME

 

COMP2_VAL

 

COMP3_NAME

 

COMP3_VAL

 

COMP4_NAME

 

COMP4_VAL

 

COMP5_NAME

 

COMP5_VAL

V_$MAP_ELEMENT

ELEM_NAME

 

ELEM_IDX

 

ELEM_CFGID

 

ELEM_TYPE

 

ELEM_SIZE

 

ELEM_NSUBELEM

 

ELEM_DESCR

 

STRIPE_SIZE

 

LIB_IDX

V_$MAP_EXT_ELEMENT

ELEM_IDX

 

NUM_ATTRB

 

ATTRB1_NAME

 

ATTRB1_VAL

 

ATTRB2_NAME

 

ATTRB2_VAL

 

ATTRB3_NAME

 

ATTRB3_VAL

 

ATTRB4_NAME

 

ATTRB4_VAL

 

ATTRB5_NAME

 

ATTRB5_VAL

V_$MAP_FILE

FILE_MAP_IDX

 

FILE_CFGID

 

FILE_STATUS

 

FILE_NAME

 

FILE_TYPE

 

FILE_STRUCTURE

 

FILE_SIZE

 

FILE_NEXTS

 

LIB_IDX

V_$MAP_FILE_EXTENT

FILE_MAP_IDX

 

EXT_NUM

 

EXT_ELEM_OFF

 

EXT_SIZE

 

EXT_FILE_OFF

 

EXT_TYPE

 

ELEM_IDX

V_$MAP_FILE_IO_STACK

FILE_MAP_IDX

 

DEPTH

 

ELEM_IDX

 

CU_SIZE

 

STRIDE

 

NUM_CU

 

ELEM_OFFSET

 

FILE_OFFSET

 

DATA_TYPE

 

PARITY_POS

 

PARITY_PERIOD

 

ID

 

PARENT_ID

V_$MAP_LIBRARY

LIB_IDX

 

LIB_NAME

 

VENDOR_NAME

 

PROTOCOL_NUM

 

VERSION_NUM

 

PATH_NAME

 

MAP_FILE

 

FILE_CFGID

 

MAP_ELEM

 

ELEM_CFGID

 

MAP_SYNC

V_$MAP_SUBELEMENT

CHILD_IDX

 

PARENT_IDX

 

SUB_NUM

 

SUB_SIZE

 

ELEM_OFFSET

 

SUB_FLAGS

V_$MAX_ACTIVE_SESS_TARGET_MTH

NAME

V_$MLS_PARAMETERS

NUM

 

NAME

 

TYPE

 

VALUE

 

ISDEFAULT

 

ISSES_MODIFIABLE

 

ISSYS_MODIFIABLE

 

ISMODIFIED

 

ISADJUSTED

 

DESCRIPTION

 

UPDATE_COMMENT

V_$MTS

MAXIMUM_CONNECTIONS

 

MAXIMUM_SESSIONS

 

SERVERS_STARTED

 

SERVERS_TERMINATED

 

SERVERS_HIGHWATER

V_$MTTR_TARGET_ADVICE

MTTR_TARGET_FOR_ESTIMATE

 

ADVICE_STATUS

 

DIRTY_LIMIT

 

ESTD_CACHE_WRITES

 

ESTD_CACHE_WRITE_FACTOR

 

ESTD_TOTAL_WRITES

 

ESTD_TOTAL_WRITE_FACTOR

 

ESTD_TOTAL_IOS

 

ESTD_TOTAL_IO_FACTOR

V_$MVREFRESH

SID

 

SERIAL#

 

CURRMVOWNER

 

CURRMVNAME

V_$MYSTAT

SID

 

STATISTIC#

 

VALUE

V_$NLS_PARAMETERS

PARAMETER

 

VALUE

V_$NLS_VALID_VALUES

PARAMETER

 

VALUE

V_$OBJECT_DEPENDENCY

FROM_ADDRESS

 

FROM_HASH

 

TO_OWNER

 

TO_NAME

 

TO_ADDRESS

 

TO_HASH

 

TO_TYPE

V_$OBSOLETE_PARAMETER

NAME

 

ISSPECIFIED

V_$OFFLINE_RANGE

RECID

 

STAMP

 

FILE#

 

OFFLINE_CHANGE#

 

ONLINE_CHANGE#

 

ONLINE_TIME

V_$OPEN_CURSOR

SADDR

 

SID

 

USER_NAME

 

ADDRESS

 

HASH_VALUE

 

SQL_TEXT

V_$OPTION

PARAMETER

 

VALUE

V_$PARALLEL_DEGREE_LIMIT_MTH

NAME

V_$PARAMETER

NUM

 

NAME

 

TYPE

 

VALUE

 

ISDEFAULT

 

ISSES_MODIFIABLE

 

ISSYS_MODIFIABLE

 

ISMODIFIED

 

ISADJUSTED

 

DESCRIPTION

 

UPDATE_COMMENT

V_$PARAMETER2

NUM

 

NAME

 

TYPE

 

VALUE

 

ISDEFAULT

 

ISSES_MODIFIABLE

 

ISSYS_MODIFIABLE

 

ISMODIFIED

 

ISADJUSTED

 

DESCRIPTION

 

ORDINAL

 

UPDATE_COMMENT

V_$PGASTAT

NAME

 

VALUE

 

UNIT

V_$PGA_TARGET_ADVICE

PGA_TARGET_FOR_ESTIMATE

 

PGA_TARGET_FACTOR

 

ADVICE_STATUS

 

BYTES_PROCESSED

 

ESTD_EXTRA_BYTES_RW

 

ESTD_PGA_CACHE_HIT_PERCENTAGE

 

ESTD_OVERALLOC_COUNT

V_$PGA_TARGET_ADVICE_HISTOGRAM

PGA_TARGET_FOR_ESTIMATE

 

PGA_TARGET_FACTOR

 

ADVICE_STATUS

 

LOW_OPTIMAL_SIZE

 

HIGH_OPTIMAL_SIZE

 

ESTD_OPTIMAL_EXECUTIONS

 

ESTD_ONEPASS_EXECUTIONS

 

ESTD_MULTIPASSES_EXECUTIONS

 

ESTD_TOTAL_EXECUTIONS

 

IGNORED_WORKAREAS_COUNT

V_$PQ_SESSTAT

STATISTIC

 

LAST_QUERY

 

SESSION_TOTAL

V_$PQ_SLAVE

SLAVE_NAME

 

STATUS

 

SESSIONS

 

IDLE_TIME_CUR

 

BUSY_TIME_CUR

 

CPU_SECS_CUR

 

MSGS_SENT_CUR

 

MSGS_RCVD_CUR

 

IDLE_TIME_TOTAL

 

BUSY_TIME_TOTAL

 

CPU_SECS_TOTAL

 

MSGS_SENT_TOTAL

 

MSGS_RCVD_TOTAL

V_$PQ_SYSSTAT

STATISTIC

 

VALUE

V_$PQ_TQSTAT

DFO_NUMBER

 

TQ_ID

 

SERVER_TYPE

 

NUM_ROWS

 

BYTES

 

OPEN_TIME

 

AVG_LATENCY

 

WAITS

 

TIMEOUTS

 

PROCESS

 

INSTANCE

V_$PROCESS

ADDR

 

PID

 

SPID

 

USERNAME

 

SERIAL#

 

TERMINAL

 

PROGRAM

 

TRACEID

 

BACKGROUND

 

LATCHWAIT

 

LATCHSPIN

 

PGA_USED_MEM

 

PGA_ALLOC_MEM

 

PGA_FREEABLE_MEM

 

PGA_MAX_MEM

V_$PROXY_ARCHIVEDLOG

RECID

 

STAMP

 

DEVICE_TYPE

 

HANDLE

 

COMMENTS

 

MEDIA

 

MEDIA_POOL

 

STATUS

 

DELETED

 

THREAD#

 

SEQUENCE#

 

RESETLOGS_CHANGE#

 

RESETLOGS_TIME

 

FIRST_CHANGE#

 

FIRST_TIME

 

NEXT_CHANGE#

 

NEXT_TIME

 

BLOCKS

 

BLOCK_SIZE

 

START_TIME

 

COMPLETION_TIME

 

ELAPSED_SECONDS

V_$PROXY_DATAFILE

RECID

 

STAMP

 

DEVICE_TYPE

 

HANDLE

 

COMMENTS

 

MEDIA

 

MEDIA_POOL

 

TAG

 

STATUS

 

DELETED

 

FILE#

 

CREATION_CHANGE#

 

CREATION_TIME

 

RESETLOGS_CHANGE#

 

RESETLOGS_TIME

 

CHECKPOINT_CHANGE#

 

CHECKPOINT_TIME

 

ABSOLUTE_FUZZY_CHANGE#

 

RECOVERY_FUZZY_CHANGE#

 

RECOVERY_FUZZY_TIME

 

INCREMENTAL_LEVEL

 

ONLINE_FUZZY

 

BACKUP_FUZZY

 

BLOCKS

 

BLOCK_SIZE

 

OLDEST_OFFLINE_RANGE

 

START_TIME

 

COMPLETION_TIME

 

ELAPSED_SECONDS

 

CONTROLFILE_TYPE

 

KEEP

 

KEEP_UNTIL

 

KEEP_OPTIONS

V_$PWFILE_USERS

USERNAME

 

SYSDBA

 

SYSOPER

V_$PX_PROCESS

SERVER_NAME

 

STATUS

 

PID

 

SPID

 

SID

 

SERIAL#

V_$PX_PROCESS_SYSSTAT

STATISTIC

 

VALUE

V_$PX_SESSION

SADDR

 

SID

 

SERIAL#

 

QCSID

 

QCSERIAL#

 

QCINST_ID

 

SERVER_GROUP

 

SERVER_SET

 

SERVER#

 

DEGREE

 

REQ_DEGREE

V_$PX_SESSTAT

SADDR

 

SID

 

SERIAL#

 

QCSID

 

QCSERIAL#

 

QCINST_ID

 

SERVER_GROUP

 

SERVER_SET

 

SERVER#

 

DEGREE

 

REQ_DEGREE

 

STATISTIC#

 

VALUE

V_$QUEUE

PADDR

 

TYPE

 

QUEUED

 

WAIT

 

TOTALQ

V_$QUEUEING_MTH

NAME

V_$RECOVERY_FILE_STATUS

FILENUM

 

FILENAME

 

STATUS

V_$RECOVERY_LOG

THREAD#

 

SEQUENCE#

 

TIME

 

ARCHIVE_NAME

V_$RECOVERY_PROGRESS

TYPE

 

ITEM

 

SOFAR

 

TOTAL

V_$RECOVERY_STATUS

RECOVERY_CHECKPOINT

 

THREAD

 

SEQUENCE_NEEDED

 

SCN_NEEDED

 

TIME_NEEDED

 

PREVIOUS_LOG_NAME

 

PREVIOUS_LOG_STATUS

 

REASON

V_$RECOVER_FILE

FILE#

 

ONLINE

 

ONLINE_STATUS

 

ERROR

 

CHANGE#

 

TIME

V_$REPLPROP

SID

 

SERIAL#

 

NAME

 

DBLINK

 

STATE

 

XID

 

SEQUENCE

V_$REPLQUEUE

TXNS_ENQUEUED

 

CALLS_ENQUEUED

 

TXNS_PURGED

 

LAST_ENQUEUE_TIME

 

LAST_PURGE_TIME

V_$REQDIST

BUCKET

 

COUNT

V_$RESERVED_WORDS

KEYWORD

 

LENGTH

V_$RESOURCE

ADDR

 

TYPE

 

ID1

 

ID2

V_$RESOURCE_LIMIT

RESOURCE_NAME

 

CURRENT_UTILIZATION

 

MAX_UTILIZATION

 

INITIAL_ALLOCATION

 

LIMIT_VALUE

V_$RESUMABLE

ADDR

 

SID

 

ENABLED

 

STATUS

 

TIMEOUT

 

SUSPEND_TIME

 

RESUME_TIME

 

NAME

 

ERROR_NUMBER

 

ERROR_PARAMETER1

 

ERROR_PARAMETER2

 

ERROR_PARAMETER3

 

ERROR_PARAMETER4

 

ERROR_PARAMETER5

 

ERROR_MSG

V_$RMAN_CONFIGURATION

CONF#

 

NAME

 

VALUE

V_$ROLLNAME

USN

 

NAME

V_$ROLLSTAT

USN

 

LATCH

 

EXTENTS

 

RSSIZE

 

WRITES

 

XACTS

 

GETS

 

WAITS

 

OPTSIZE

 

HWMSIZE

 

SHRINKS

 

WRAPS

 

EXTENDS

 

AVESHRINK

 

AVEACTIVE

 

STATUS

 

CUREXT

 

CURBLK

V_$ROWCACHE

CACHE#

 

TYPE

 

SUBORDINATE#

 

PARAMETER

 

COUNT

 

USAGE

 

FIXED

 

GETS

 

GETMISSES

 

SCANS

 

SCANMISSES

 

SCANCOMPLETES

 

MODIFICATIONS

 

FLUSHES

 

DLM_REQUESTS

 

DLM_CONFLICTS

 

DLM_RELEASES

V_$ROWCACHE_PARENT

INDX

 

HASH

 

ADDRESS

 

CACHE#

 

CACHE_NAME

 

EXISTENT

 

LOCK_MODE

 

LOCK_REQUEST

 

TXN

 

SADDR

 

INST_LOCK_REQUEST

 

INST_LOCK_RELEASE

 

INST_LOCK_TYPE

 

INST_LOCK_ID1

 

INST_LOCK_ID2

 

KEY

V_$ROWCACHE_SUBORDINATE

INDX

 

HASH

 

ADDRESS

 

CACHE#

 

SUBCACHE#

 

SUBCACHE_NAME

 

EXISTENT

 

PARENT

 

KEY

V_$RSRC_CONSUMER_GROUP

NAME

 

ACTIVE_SESSIONS

 

EXECUTION_WAITERS

 

REQUESTS

 

CPU_WAIT_TIME

 

CPU_WAITS

 

CONSUMED_CPU_TIME

 

YIELDS

 

QUEUE_LENGTH

 

CURRENT_UNDO_CONSUMPTION

V_$RSRC_CONSUMER_GROUP_CPU_MTH

NAME

V_$RSRC_PLAN

NAME

V_$RSRC_PLAN_CPU_MTH

NAME

V_$SEGMENT_STATISTICS

OWNER

 

OBJECT_NAME

 

SUBOBJECT_NAME

 

TABLESPACE_NAME

 

TS#

 

OBJ#

 

DATAOBJ#

 

OBJECT_TYPE

 

STATISTIC_NAME

 

STATISTIC#

 

VALUE

V_$SEGSTAT

TS#

 

OBJ#

 

DATAOBJ#

 

STATISTIC_NAME

 

STATISTIC#

 

VALUE

V_$SEGSTAT_NAME

STATISTIC#

 

NAME

 

SAMPLED

V_$SESSION

SADDR

 

SID

 

SERIAL#

 

AUDSID

 

PADDR

 

USER#

 

USERNAME

 

COMMAND

 

OWNERID

 

TADDR

 

LOCKWAIT

 

STATUS

 

SERVER

 

SCHEMA#

 

SCHEMANAME

 

OSUSER

 

PROCESS

 

MACHINE

 

TERMINAL

 

PROGRAM

 

TYPE

 

SQL_ADDRESS

 

SQL_HASH_VALUE

 

PREV_SQL_ADDR

 

PREV_HASH_VALUE

 

MODULE

 

MODULE_HASH

 

ACTION

 

ACTION_HASH

 

CLIENT_INFO

 

FIXED_TABLE_SEQUENCE

 

ROW_WAIT_OBJ#

 

ROW_WAIT_FILE#

 

ROW_WAIT_BLOCK#

 

ROW_WAIT_ROW#

 

LOGON_TIME

 

LAST_CALL_ET

 

PDML_ENABLED

 

FAILOVER_TYPE

 

FAILOVER_METHOD

 

FAILED_OVER

 

RESOURCE_CONSUMER_GROUP

 

PDML_STATUS

 

PDDL_STATUS

 

PQ_STATUS

 

CURRENT_QUEUE_DURATION

 

CLIENT_IDENTIFIER

V_$SESSION_CONNECT_INFO

SID

 

AUTHENTICATION_TYPE

 

OSUSER

 

NETWORK_SERVICE_BANNER

V_$SESSION_CURSOR_CACHE

MAXIMUM

 

COUNT

 

OPENED_ONCE

 

OPEN

 

OPENS

 

HITS

 

HIT_RATIO

V_$SESSION_EVENT

SID

 

EVENT

 

TOTAL_WAITS

 

TOTAL_TIMEOUTS

 

TIME_WAITED

 

AVERAGE_WAIT

 

MAX_WAIT

 

TIME_WAITED_MICRO

V_$SESSION_LONGOPS

SID

 

SERIAL#

 

OPNAME

 

TARGET

 

TARGET_DESC

 

SOFAR

 

TOTALWORK

 

UNITS

 

START_TIME

 

LAST_UPDATE_TIME

 

TIME_REMAINING

 

ELAPSED_SECONDS

 

CONTEXT

 

MESSAGE

 

USERNAME

 

SQL_ADDRESS

 

SQL_HASH_VALUE

 

QCSID

V_$SESSION_OBJECT_CACHE

PINS

 

HITS

 

TRUE_HITS

 

HIT_RATIO

 

TRUE_HIT_RATIO

 

OBJECT_REFRESHES

 

CACHE_REFRESHES

 

OBJECT_FLUSHES

 

CACHE_FLUSHES

 

CACHE_SHRINKS

 

CACHED_OBJECTS

 

PINNED_OBJECTS

 

CACHE_SIZE

 

OPTIMAL_SIZE

 

MAXIMUM_SIZE

V_$SESSION_WAIT

SID

 

SEQ#

 

EVENT

 

P1TEXT

 

P1

 

P1RAW

 

P2TEXT

 

P2

 

P2RAW

 

P3TEXT

 

P3

 

P3RAW

 

WAIT_TIME

 

SECONDS_IN_WAIT

 

STATE

V_$SESSTAT

SID

 

STATISTIC#

 

VALUE

V_$SESS_IO

SID

 

BLOCK_GETS

 

CONSISTENT_GETS

 

PHYSICAL_READS

 

BLOCK_CHANGES

 

CONSISTENT_CHANGES

V_$SGA

NAME

 

VALUE

V_$SGASTAT

POOL

 

NAME

 

BYTES

V_$SGA_CURRENT_RESIZE_OPS

COMPONENT

 

OPER_TYPE

 

OPER_MODE

 

PARAMETER

 

INITIAL_SIZE

 

TARGET_SIZE

 

CURRENT_SIZE

 

START_TIME

 

LAST_UPDATE_TIME

V_$SGA_DYNAMIC_COMPONENTS

COMPONENT

 

CURRENT_SIZE

 

MIN_SIZE

 

MAX_SIZE

 

OPER_COUNT

 

LAST_OPER_TYPE

 

LAST_OPER_MODE

 

LAST_OPER_TIME

 

GRANULE_SIZE

V_$SGA_DYNAMIC_FREE_MEMORY

CURRENT_SIZE

V_$SGA_RESIZE_OPS

COMPONENT

 

OPER_TYPE

 

OPER_MODE

 

PARAMETER

 

INITIAL_SIZE

 

TARGET_SIZE

 

FINAL_SIZE

 

STATUS

 

START_TIME

 

END_TIME

V_$SHARED_POOL_ADVICE

SHARED_POOL_SIZE_FOR_ESTIMATE

 

SHARED_POOL_SIZE_FACTOR

 

ESTD_LC_SIZE

 

ESTD_LC_MEMORY_OBJECTS

 

ESTD_LC_TIME_SAVED

 

ESTD_LC_TIME_SAVED_FACTOR

 

ESTD_LC_MEMORY_OBJECT_HITS

V_$SHARED_POOL_RESERVED

FREE_SPACE

 

AVG_FREE_SIZE

 

FREE_COUNT

 

MAX_FREE_SIZE

 

USED_SPACE

 

AVG_USED_SIZE

 

USED_COUNT

 

MAX_USED_SIZE

 

REQUESTS

 

REQUEST_MISSES

 

LAST_MISS_SIZE

 

MAX_MISS_SIZE

 

REQUEST_FAILURES

 

LAST_FAILURE_SIZE

 

ABORTED_REQUEST_THRESHOLD

 

ABORTED_REQUESTS

 

LAST_ABORTED_SIZE

V_$SHARED_SERVER

NAME

 

PADDR

 

STATUS

 

MESSAGES

 

BYTES

 

BREAKS

 

CIRCUIT

 

IDLE

 

BUSY

 

REQUESTS

V_$SHARED_SERVER_MONITOR

MAXIMUM_CONNECTIONS

 

MAXIMUM_SESSIONS

 

SERVERS_STARTED

 

SERVERS_TERMINATED

 

SERVERS_HIGHWATER

V_$SORT_SEGMENT

TABLESPACE_NAME

 

SEGMENT_FILE

 

SEGMENT_BLOCK

 

EXTENT_SIZE

 

CURRENT_USERS

 

TOTAL_EXTENTS

 

TOTAL_BLOCKS

 

USED_EXTENTS

 

USED_BLOCKS

 

FREE_EXTENTS

 

FREE_BLOCKS

 

ADDED_EXTENTS

 

EXTENT_HITS

 

FREED_EXTENTS

 

FREE_REQUESTS

 

MAX_SIZE

 

MAX_BLOCKS

 

MAX_USED_SIZE

 

MAX_USED_BLOCKS

 

MAX_SORT_SIZE

 

MAX_SORT_BLOCKS

 

RELATIVE_FNO

V_$TEMPSEG_USAGE

USERNAME

V_$SORT_USAGE

USERNAME

V_$TEMPSEG_USAGE

USER

V_$SORT_USAGE

USER

V_$TEMPSEG_USAGE

SESSION_ADDR

V_$SORT_USAGE

SESSION_ADDR

V_$TEMPSEG_USAGE

SESSION_NUM

V_$SORT_USAGE

SESSION_NUM

V_$TEMPSEG_USAGE

SQLADDR

V_$SORT_USAGE

SQLADDR

V_$TEMPSEG_USAGE

SQLHASH

V_$SORT_USAGE

SQLHASH

V_$TEMPSEG_USAGE

TABLESPACE

V_$SORT_USAGE

TABLESPACE

V_$TEMPSEG_USAGE

CONTENTS

V_$SORT_USAGE

CONTENTS

V_$TEMPSEG_USAGE

SEGTYPE

V_$SORT_USAGE

SEGTYPE

V_$TEMPSEG_USAGE

SEGFILE#

V_$SORT_USAGE

SEGFILE#

V_$TEMPSEG_USAGE

SEGBLK#

V_$SORT_USAGE

SEGBLK#

V_$TEMPSEG_USAGE

EXTENTS

V_$SORT_USAGE

EXTENTS

V_$TEMPSEG_USAGE

BLOCKS

V_$SORT_USAGE

BLOCKS

V_$TEMPSEG_USAGE

SEGRFNO#

V_$SORT_USAGE

SEGRFNO#

V_$SPPARAMETER

SID

 

NAME

 

VALUE

 

ISSPECIFIED

 

ORDINAL

 

UPDATE_COMMENT

V_$SQL

IS_OBSOLETE

 

CHILD_LATCH

 

SQL_TEXT

 

SHARABLE_MEM

 

PERSISTENT_MEM

 

RUNTIME_MEM

 

SORTS

 

LOADED_VERSIONS

 

OPEN_VERSIONS

 

USERS_OPENING

 

FETCHES

 

EXECUTIONS

 

USERS_EXECUTING

 

LOADS

 

FIRST_LOAD_TIME

 

INVALIDATIONS

 

PARSE_CALLS

 

DISK_READS

 

BUFFER_GETS

 

ROWS_PROCESSED

 

COMMAND_TYPE

 

OPTIMIZER_MODE

 

OPTIMIZER_COST

 

PARSING_USER_ID

 

PARSING_SCHEMA_ID

 

KEPT_VERSIONS

 

ADDRESS

 

TYPE_CHK_HEAP

 

HASH_VALUE

 

PLAN_HASH_VALUE

 

CHILD_NUMBER

 

MODULE

 

MODULE_HASH

 

ACTION

 

ACTION_HASH

 

SERIALIZABLE_ABORTS

 

OUTLINE_CATEGORY

 

CPU_TIME

 

ELAPSED_TIME

 

OUTLINE_SID

 

CHILD_ADDRESS

 

SQLTYPE

 

REMOTE

 

OBJECT_STATUS

 

LITERAL_HASH_VALUE

 

LAST_LOAD_TIME

V_$SQLAREA

SQL_TEXT

 

SHARABLE_MEM

 

PERSISTENT_MEM

 

RUNTIME_MEM

 

SORTS

 

VERSION_COUNT

 

LOADED_VERSIONS

 

OPEN_VERSIONS

 

USERS_OPENING

 

FETCHES

 

EXECUTIONS

 

USERS_EXECUTING

 

LOADS

 

FIRST_LOAD_TIME

 

INVALIDATIONS

 

PARSE_CALLS

 

DISK_READS

 

BUFFER_GETS

 

ROWS_PROCESSED

 

COMMAND_TYPE

 

OPTIMIZER_MODE

 

PARSING_USER_ID

 

PARSING_SCHEMA_ID

 

KEPT_VERSIONS

 

ADDRESS

 

HASH_VALUE

 

MODULE

 

MODULE_HASH

 

ACTION

 

ACTION_HASH

 

SERIALIZABLE_ABORTS

 

CPU_TIME

 

ELAPSED_TIME

 

IS_OBSOLETE

 

CHILD_LATCH

V_$SQLTEXT

ADDRESS

 

HASH_VALUE

 

COMMAND_TYPE

 

PIECE

 

SQL_TEXT

V_$SQLTEXT_WITH_NEWLINES

ADDRESS

 

HASH_VALUE

 

COMMAND_TYPE

 

PIECE

 

SQL_TEXT

V_$SQLXS

SQL_TEXT

 

SHARABLE_MEM

 

SORTS

 

MODULE

 

LOADED_VERSIONS

 

EXECUTIONS

 

LOADS

 

INVALIDATIONS

 

PARSE_CALLS

 

DISK_READS

 

BUFFER_GETS

 

ROWS_PROCESSED

 

ADDRESS

 

HASH_VALUE

 

VERSION_COUNT

V_$SQL_BIND_DATA

CURSOR_NUM

 

POSITION

 

DATATYPE

 

SHARED_MAX_LEN

 

PRIVATE_MAX_LEN

 

ARRAY_SIZE

 

PRECISION

 

SCALE

 

SHARED_FLAG

 

SHARED_FLAG2

 

BUF_ADDRESS

 

BUF_LENGTH

 

VAL_LENGTH

 

BUF_FLAG

 

INDICATOR

 

VALUE

V_$SQL_BIND_METADATA

ADDRESS

 

POSITION

 

DATATYPE

 

MAX_LENGTH

 

ARRAY_LEN

 

BIND_NAME

V_$SQL_CURSOR

CURNO

 

FLAG

 

STATUS

 

PARENT_HANDLE

 

PARENT_LOCK

 

CHILD_LOCK

 

CHILD_PIN

 

PERS_HEAP_MEM

 

WORK_HEAP_MEM

 

BIND_VARS

 

DEFINE_VARS

 

BIND_MEM_LOC

 

INST_FLAG

 

INST_FLAG2

V_$SQL_PLAN

ADDRESS

 

HASH_VALUE

 

CHILD_NUMBER

 

OPERATION

 

OPTIONS

 

OBJECT_NODE

 

OBJECT#

 

OBJECT_OWNER

 

OBJECT_NAME

 

OPTIMIZER

 

ID

 

PARENT_ID

 

DEPTH

 

POSITION

 

SEARCH_COLUMNS

 

COST

 

CARDINALITY

 

BYTES

 

OTHER_TAG

 

PARTITION_START

 

PARTITION_STOP

 

PARTITION_ID

 

OTHER

 

DISTRIBUTION

 

CPU_COST

 

IO_COST

 

TEMP_SPACE

 

ACCESS_PREDICATES

 

FILTER_PREDICATES

V_$SQL_PLAN_STATISTICS

ADDRESS

 

HASH_VALUE

 

CHILD_NUMBER

 

OPERATION_ID

 

EXECUTIONS

 

LAST_STARTS

 

STARTS

 

LAST_OUTPUT_ROWS

 

OUTPUT_ROWS

 

LAST_CR_BUFFER_GETS

 

CR_BUFFER_GETS

 

LAST_CU_BUFFER_GETS

 

CU_BUFFER_GETS

 

LAST_DISK_READS

 

DISK_READS

 

LAST_DISK_WRITES

 

DISK_WRITES

 

LAST_ELAPSED_TIME

 

ELAPSED_TIME

V_$SQL_PLAN_STATISTICS_ALL

PARENT_ID

 

DEPTH

 

POSITION

 

SEARCH_COLUMNS

 

COST

 

CARDINALITY

 

BYTES

 

OTHER_TAG

 

PARTITION_START

 

PARTITION_STOP

 

PARTITION_ID

 

OTHER

 

DISTRIBUTION

 

CPU_COST

 

IO_COST

 

TEMP_SPACE

 

ACCESS_PREDICATES

 

FILTER_PREDICATES

 

EXECUTIONS

 

LAST_STARTS

 

STARTS

 

LAST_OUTPUT_ROWS

 

OUTPUT_ROWS

 

LAST_CR_BUFFER_GETS

 

CR_BUFFER_GETS

 

LAST_CU_BUFFER_GETS

 

CU_BUFFER_GETS

 

LAST_DISK_READS

 

DISK_READS

 

LAST_DISK_WRITES

 

DISK_WRITES

 

LAST_ELAPSED_TIME

 

ELAPSED_TIME

 

POLICY

 

ESTIMATED_OPTIMAL_SIZE

 

ESTIMATED_ONEPASS_SIZE

 

LAST_MEMORY_USED

 

LAST_EXECUTION

 

LAST_DEGREE

 

TOTAL_EXECUTIONS

 

OPTIMAL_EXECUTIONS

 

ONEPASS_EXECUTIONS

 

MULTIPASSES_EXECUTIONS

 

ACTIVE_TIME

 

MAX_TEMPSEG_SIZE

 

LAST_TEMPSEG_SIZE

 

ADDRESS

 

HASH_VALUE

 

CHILD_NUMBER

 

OPERATION

 

OPTIONS

 

OBJECT_NODE

 

OBJECT#

 

OBJECT_OWNER

 

OBJECT_NAME

 

OPTIMIZER

 

ID

V_$SQL_REDIRECTION

ADDRESS

 

PARENT_HANDLE

 

HASH_VALUE

 

CHILD_NUMBER

 

PARSING_USER_ID

 

PARSING_SCHEMA_ID

 

COMMAND_TYPE

 

REASON

 

ERROR_CODE

 

POSITION

 

SQL_TEXT_PIECE

 

ERROR_MESSAGE

V_$SQL_SHARED_CURSOR

ADDRESS

 

KGLHDPAR

 

UNBOUND_CURSOR

 

SQL_TYPE_MISMATCH

 

OPTIMIZER_MISMATCH

 

OUTLINE_MISMATCH

 

STATS_ROW_MISMATCH

 

LITERAL_MISMATCH

 

SEC_DEPTH_MISMATCH

 

EXPLAIN_PLAN_CURSOR

 

BUFFERED_DML_MISMATCH

 

PDML_ENV_MISMATCH

 

INST_DRTLD_MISMATCH

 

SLAVE_QC_MISMATCH

 

TYPECHECK_MISMATCH

 

AUTH_CHECK_MISMATCH

 

BIND_MISMATCH

 

DESCRIBE_MISMATCH

 

LANGUAGE_MISMATCH

 

TRANSLATION_MISMATCH

 

ROW_LEVEL_SEC_MISMATCH

 

INSUFF_PRIVS

 

INSUFF_PRIVS_REM

 

REMOTE_TRANS_MISMATCH

 

LOGMINER_SESSION_MISMATCH

 

INCOMP_LTRL_MISMATCH

 

OVERLAP_TIME_MISMATCH

 

SQL_REDIRECT_MISMATCH

 

MV_QUERY_GEN_MISMATCH

 

USER_BIND_PEEK_MISMATCH

 

TYPCHK_DEP_MISMATCH

 

NO_TRIGGER_MISMATCH

 

FLASHBACK_CURSOR

V_$SQL_SHARED_MEMORY

SQL_TEXT

 

HASH_VALUE

 

HEAP_DESC

 

STRUCTURE

 

FUNCTION

 

CHUNK_COM

 

CHUNK_PTR

 

CHUNK_SIZE

 

ALLOC_CLASS

 

CHUNK_TYPE

 

SUBHEAP_DESC

V_$SQL_WORKAREA

ADDRESS

 

HASH_VALUE

 

CHILD_NUMBER

 

WORKAREA_ADDRESS

 

OPERATION_TYPE

 

OPERATION_ID

 

POLICY

 

ESTIMATED_OPTIMAL_SIZE

 

ESTIMATED_ONEPASS_SIZE

 

LAST_MEMORY_USED

 

LAST_EXECUTION

 

LAST_DEGREE

 

TOTAL_EXECUTIONS

 

OPTIMAL_EXECUTIONS

 

ONEPASS_EXECUTIONS

 

MULTIPASSES_EXECUTIONS

 

ACTIVE_TIME

 

MAX_TEMPSEG_SIZE

 

LAST_TEMPSEG_SIZE

V_$SQL_WORKAREA_ACTIVE

WORKAREA_ADDRESS

 

OPERATION_TYPE

 

OPERATION_ID

 

POLICY

 

SID

 

QCINST_ID

 

QCSID

 

ACTIVE_TIME

 

WORK_AREA_SIZE

 

EXPECTED_SIZE

 

ACTUAL_MEM_USED

 

MAX_MEM_USED

 

NUMBER_PASSES

 

TEMPSEG_SIZE

 

TABLESPACE

 

SEGRFNO#

 

SEGBLK#

V_$SQL_WORKAREA_HISTOGRAM

LOW_OPTIMAL_SIZE

 

HIGH_OPTIMAL_SIZE

 

OPTIMAL_EXECUTIONS

 

ONEPASS_EXECUTIONS

 

MULTIPASSES_EXECUTIONS

 

TOTAL_EXECUTIONS

V_$STANDBY_LOG

GROUP#

 

THREAD#

 

SEQUENCE#

 

BYTES

 

USED

 

ARCHIVED

 

STATUS

 

FIRST_CHANGE#

 

FIRST_TIME

 

LAST_CHANGE#

 

LAST_TIME

V_$STATISTICS_LEVEL

STATISTICS_NAME

 

DESCRIPTION

 

SESSION_STATUS

 

SYSTEM_STATUS

 

ACTIVATION_LEVEL

 

STATISTICS_VIEW_NAME

 

SESSION_SETTABLE

V_$STATNAME

STATISTIC#

 

NAME

 

CLASS

V_$STREAMS_APPLY_COORDINATOR

SID

 

SERIAL#

 

STATE

 

APPLY#

 

APPLY_NAME

 

TOTAL_APPLIED

 

TOTAL_WAIT_DEPS

 

TOTAL_WAIT_COMMITS

 

TOTAL_ADMIN

 

TOTAL_ASSIGNED

 

TOTAL_RECEIVED

 

TOTAL_ERRORS

 

LWM_TIME

 

LWM_MESSAGE_NUMBER

 

LWM_MESSAGE_CREATE_TIME

 

HWM_TIME

 

HWM_MESSAGE_NUMBER

 

HWM_MESSAGE_CREATE_TIME

 

STARTUP_TIME

 

ELAPSED_SCHEDULE_TIME

V_$STREAMS_APPLY_READER

SID

 

SERIAL#

 

APPLY#

 

APPLY_NAME

 

STATE

 

TOTAL_MESSAGES_DEQUEUED

 

DEQUEUE_TIME

 

DEQUEUED_MESSAGE_NUMBER

 

DEQUEUED_MESSAGE_CREATE_TIME

 

SGA_USED

 

ELAPSED_DEQUEUE_TIME

 

ELAPSED_SCHEDULE_TIME

V_$STREAMS_APPLY_SERVER

SID

 

SERIAL#

 

APPLY#

 

APPLY_NAME

 

SERVER_ID

 

STATE

 

XIDUSN

 

XIDSLT

 

XIDSQN

 

COMMITSCN

 

DEP_XIDUSN

 

DEP_XIDSLT

 

DEP_XIDSQN

 

DEP_COMMITSCN

 

MESSAGE_SEQUENCE

 

TOTAL_ASSIGNED

 

TOTAL_ADMIN

 

TOTAL_MESSAGES_APPLIED

 

APPLY_TIME

 

APPLIED_MESSAGE_NUMBER

 

APPLIED_MESSAGE_CREATE_TIME

 

ELAPSED_DEQUEUE_TIME

 

ELAPSED_APPLY_TIME

V_$STREAMS_CAPTURE

SID

 

SERIAL#

 

CAPTURE#

 

CAPTURE_NAME

 

STARTUP_TIME

 

STATE

 

TOTAL_MESSAGES_CAPTURED

 

CAPTURE_TIME

 

CAPTURE_MESSAGE_NUMBER

 

CAPTURE_MESSAGE_CREATE_TIME

 

TOTAL_MESSAGES_ENQUEUED

 

ENQUEUE_TIME

 

ENQUEUE_MESSAGE_NUMBER

 

ENQUEUE_MESSAGE_CREATE_TIME

 

ELAPSED_CAPTURE_TIME

 

ELAPSED_RULE_TIME

 

ELAPSED_ENQUEUE_TIME

 

ELAPSED_LCR_TIME

V_$SUBCACHE

OWNER_NAME

 

NAME

 

TYPE

 

HEAP_NUM

 

CACHE_ID

 

CACHE_CNT

 

HEAP_SZ

 

HEAP_ALOC

 

HEAP_USED

V_$SYSSTAT

STATISTIC#

 

NAME

 

CLASS

 

VALUE

V_$SYSTEM_CURSOR_CACHE

OPENS

 

HITS

 

HIT_RATIO

V_$SYSTEM_EVENT

EVENT

 

TOTAL_WAITS

 

TOTAL_TIMEOUTS

 

TIME_WAITED

 

AVERAGE_WAIT

 

TIME_WAITED_MICRO

V_$SYSTEM_PARAMETER

NUM

 

NAME

 

TYPE

 

VALUE

 

ISDEFAULT

 

ISSES_MODIFIABLE

 

ISSYS_MODIFIABLE

 

ISMODIFIED

 

ISADJUSTED

 

DESCRIPTION

 

UPDATE_COMMENT

V_$SYSTEM_PARAMETER2

NUM

 

NAME

 

TYPE

 

VALUE

 

ISDEFAULT

 

ISSES_MODIFIABLE

 

ISSYS_MODIFIABLE

 

ISMODIFIED

 

ISADJUSTED

 

DESCRIPTION

 

ORDINAL

 

UPDATE_COMMENT

V_$TABLESPACE

TS#

 

NAME

 

INCLUDED_IN_DATABASE_BACKUP

V_$TEMPFILE

FILE#

 

CREATION_CHANGE#

 

CREATION_TIME

 

TS#

 

RFILE#

 

STATUS

 

ENABLED

 

BYTES

 

BLOCKS

 

CREATE_BYTES

 

BLOCK_SIZE

 

NAME

V_$TEMPORARY_LOBS

SID

 

CACHE_LOBS

 

NOCACHE_LOBS

V_$TEMPSTAT

FILE#

 

PHYRDS

 

PHYWRTS

 

PHYBLKRD

 

PHYBLKWRT

 

SINGLEBLKRDS

 

READTIM

 

WRITETIM

 

SINGLEBLKRDTIM

 

AVGIOTIM

 

LSTIOTIM

 

MINIOTIM

 

MAXIORTM

 

MAXIOWTM

V_$TEMPSTATXS

TSNAME

 

FILENAME

 

PHYRDS

 

PHYWRTS

 

READTIM

 

WRITETIM

 

PHYBLKRD

 

PHYBLKWRT

 

WAIT_COUNT

 

TIME

V_$TEMP_CACHE_TRANSFER

X_2_NULL_FORCED_STALE

 

X_2_S

 

X_2_S_FORCED_WRITE

 

S_2_NULL

 

S_2_NULL_FORCED_STALE

 

RBR

 

RBR_FORCED_WRITE

 

NULL_2_X

 

S_2_X

 

NULL_2_S

 

FILE_NUMBER

 

X_2_NULL

 

X_2_NULL_FORCED_WRITE

V_$TEMP_EXTENT_MAP

TABLESPACE_NAME

 

FILE_ID

 

BLOCK_ID

 

BYTES

 

BLOCKS

 

OWNER

 

RELATIVE_FNO

V_$TEMP_EXTENT_POOL

TABLESPACE_NAME

 

FILE_ID

 

EXTENTS_CACHED

 

EXTENTS_USED

 

BLOCKS_CACHED

 

BLOCKS_USED

 

BYTES_CACHED

 

BYTES_USED

 

RELATIVE_FNO

V_$TEMP_PING

FILE_NUMBER

 

FREQUENCY

 

X_2_NULL

 

X_2_NULL_FORCED_WRITE

 

X_2_NULL_FORCED_STALE

 

X_2_S

 

X_2_S_FORCED_WRITE

 

X_2_SSX

 

X_2_SSX_FORCED_WRITE

 

S_2_NULL

 

S_2_NULL_FORCED_STALE

 

SS_2_NULL

 

SS_2_RLS

 

WRB

 

WRB_FORCED_WRITE

 

RBR

 

RBR_FORCED_WRITE

 

RBR_FORCED_STALE

 

CBR

 

CBR_FORCED_WRITE

 

NULL_2_X

 

S_2_X

 

SSX_2_X

 

NULL_2_S

 

NULL_2_SS

 

OP_2_SS

V_$TEMP_SPACE_HEADER

TABLESPACE_NAME

 

FILE_ID

 

BYTES_USED

 

BLOCKS_USED

 

BYTES_FREE

 

BLOCKS_FREE

 

RELATIVE_FNO

V_$THREAD

THREAD#

 

STATUS

 

ENABLED

 

GROUPS

 

INSTANCE

 

OPEN_TIME

 

CURRENT_GROUP#

 

SEQUENCE#

 

CHECKPOINT_CHANGE#

 

CHECKPOINT_TIME

 

ENABLE_CHANGE#

 

ENABLE_TIME

 

DISABLE_CHANGE#

 

DISABLE_TIME

V_$TIMER

HSECS

V_$TIMEZONE_NAMES

TZNAME

 

TZABBREV

V_$TRANSACTION

ADDR

 

XIDUSN

 

XIDSLOT

 

XIDSQN

 

UBAFIL

 

UBABLK

 

UBASQN

 

UBAREC

 

STATUS

 

START_TIME

 

START_SCNB

 

START_SCNW

 

START_UEXT

 

START_UBAFIL

 

START_UBABLK

 

START_UBASQN

 

START_UBAREC

 

SES_ADDR

 

FLAG

 

SPACE

 

RECURSIVE

 

NOUNDO

 

PTX

 

NAME

 

PRV_XIDUSN

 

PRV_XIDSLT

 

PRV_XIDSQN

 

PTX_XIDUSN

 

PTX_XIDSLT

 

PTX_XIDSQN

 

DSCN-B

 

DSCN-W

 

USED_UBLK

 

USED_UREC

 

LOG_IO

 

PHY_IO

 

CR_GET

 

CR_CHANGE

V_$TRANSACTION_ENQUEUE

ADDR

 

KADDR

 

SID

 

TYPE

 

ID1

 

ID2

 

LMODE

 

REQUEST

 

CTIME

 

BLOCK

V_$TYPE_SIZE

COMPONENT

 

TYPE

 

DESCRIPTION

 

TYPE_SIZE

V_$UNDOSTAT

BEGIN_TIME

 

END_TIME

 

UNDOTSN

 

UNDOBLKS

 

TXNCOUNT

 

MAXQUERYLEN

 

MAXCONCURRENCY

 

UNXPSTEALCNT

 

UNXPBLKRELCNT

 

UNXPBLKREUCNT

 

EXPSTEALCNT

 

EXPBLKRELCNT

 

EXPBLKREUCNT

 

SSOLDERRCNT

 

NOSPACEERRCNT

V_$VERSION

BANNER

V_$VPD_POLICY

ADDRESS

 

PARADDR

 

SQL_HASH

 

CHILD_NUMBER

 

OBJECT_OWNER

 

OBJECT_NAME

 

POLICY_GROUP

 

POLICY

 

POLICY_FUNCTION_OWNER

 

PREDICATE

V_$WAITSTAT

CLASS

 

COUNT

 

TIME

V_$_LOCK

LADDR

 

KADDR

 

SADDR

 

RADDR

 

LMODE

 

REQUEST

 

CTIME

 

BLOCK



Oracle DBA SQL Quick Reference
Oracle DBA SQL Quick Reference
ISBN: 131403036
EAN: N/A
Year: 2003
Pages: 49

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net