Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Initialization Parameters

Initialization Parameter File

Specifying Values in the Parameter File

Reading the Parameter Descriptions

Parameter Descriptions

ACTIVE_INSTANCE_COUNT

ALWAYS_ANTI_JOIN

ALWAYS_SEMI_JOIN

AQ_TM_PROCESSES

AUDIT_FILE_DEST

AUDIT_TRAIL

BACKGROUND_CORE_DUMP

BACKGROUND_DUMP_DEST

BACKUP_TAPE_IO_SLAVES

BITMAP_MERGE_AREA_SIZE

BLANK_TRIMMING

BUFFER_POOL_KEEP

BUFFER_POOL_RECYCLE

COMMIT_POINT_STRENGTH

COMPATIBLE

CONTROL_FILE_RECORD_KEEP_TIME

CONTROL_FILES

CORE_DUMP_DEST

CPU_COUNT

CREATE_BITMAP_AREA_SIZE

CURSOR_SHARING

CURSOR_SPACE_FOR_TIME

DB_BLOCK_BUFFERS

DB_BLOCK_CHECKING

DB_BLOCK_CHECKSUM

DB_BLOCK_LRU_LATCHES

DB_BLOCK_MAX_DIRTY_TARGET

DB_BLOCK_SIZE

DB_DOMAIN

DB_FILE_DIRECT_IO_COUNT

DB_FILE_MULTIBLOCK_READ_COUNT

DB_FILE_NAME_CONVERT

DB_FILES

DB_NAME

DB_WRITER_PROCESSES

DBLINK_ENCRYPT_LOGIN

DBWR_IO_SLAVES

DISK_ASYNCH_IO

DISTRIBUTED_TRANSACTIONS

DML_LOCKS

ENQUEUE_RESOURCES

EVENT

FAST_START_IO_TARGET

FAST_START_PARALLEL_ROLLBACK

FIXED_DATE

GC_DEFER_TIME

GC_FILES_TO_LOCKS

GC_RELEASABLE_LOCKS

GC_ROLLBACK_LOCKS

GLOBAL_NAMES

HASH_AREA_SIZE

HASH_JOIN_ENABLED

HASH_MULTIBLOCK_IO_COUNT

HI_SHARED_MEMORY_ADDRESS

HS_AUTOREGISTER

IFILE

INSTANCE_GROUPS

INSTANCE_NAME

INSTANCE_NUMBER

JAVA_MAX_SESSIONSPACE_SIZE

JAVA_POOL_SIZE

JAVA_SOFT_SESSIONSPACE_LIMIT

JOB_QUEUE_INTERVAL

JOB_QUEUE_PROCESSES

LARGE_POOL_SIZE

LICENSE_MAX_SESSIONS

LICENSE_MAX_USERS

LICENSE_SESSIONS_WARNING

LM_LOCKS

LM_RESS

LOCAL_LISTENER

LOCK_NAME_SPACE

LOCK_SGA

LOG_ARCHIVE_DEST

LOG_ARCHIVE_DEST_n

LOG_ARCHIVE_DEST_STATE_n

LOG_ARCHIVE_DUPLEX_DEST

LOG_ARCHIVE_FORMAT

LOG_ARCHIVE_MAX_PROCESSES

LOG_ARCHIVE_MIN_SUCCEED_DEST

LOG_ARCHIVE_START

LOG_ARCHIVE_TRACE

LOG_BUFFER

LOG_CHECKPOINT_INTERVAL

LOG_CHECKPOINT_TIMEOUT

LOG_CHECKPOINTS_TO_ALERT

LOG_FILE_NAME_CONVERT

MAX_COMMIT_PROPAGATION_DELAY

MAX_DUMP_FILE_SIZE

MAX_ENABLED_ROLES

MAX_ROLLBACK_SEGMENTS

MTS_CIRCUITS

MTS_DISPATCHERS

MTS_MAX_DISPATCHERS

MTS_MAX_SERVERS

MTS_SERVERS

MTS_SESSIONS

NLS_CALENDAR

NLS_COMP

NLS_CURRENCY

NLS_DATE_FORMAT

NLS_DATE_LANGUAGE

NLS_DUAL_CURRENCY

NLS_ISO_CURRENCY

NLS_LANGUAGE

NLS_NUMERIC_CHARACTERS

NLS_SORT

NLS_TERRITORY

O7_DICTIONARY_ACCESSIBILITY

OBJECT_CACHE_MAX_SIZE_PERCENT

OBJECT_CACHE_OPTIMAL_SIZE

OPEN_CURSORS

OPEN_LINKS

OPEN_LINKS_PER_INSTANCE

OPTIMIZER_FEATURES_ENABLE

OPTIMIZER_INDEX_CACHING

OPTIMIZER_INDEX_COST_ADJ

OPTIMIZER_MAX_PERMUTATIONS

OPTIMIZER_MODE

OPTIMIZER_PERCENT_PARALLEL

ORACLE_TRACE_COLLECTION_NAME

ORACLE_TRACE_COLLECTION_PATH

ORACLE_TRACE_COLLECTION_SIZE

ORACLE_TRACE_ENABLE

ORACLE_TRACE_FACILITY_NAME

ORACLE_TRACE_FACILITY_PATH

OS_AUTHENT_PREFIX

OS_ROLES

PARALLEL_ADAPTIVE_MULTI_USER

PARALLEL_AUTOMATIC_TUNING

PARALLEL_BROADCAST_ENABLED

PARALLEL_EXECUTION_MESSAGE_SIZE

PARALLEL_INSTANCE_GROUP

PARALLEL_MAX_SERVERS

PARALLEL_MIN_PERCENT

PARALLEL_MIN_SERVERS

PARALLEL_SERVER

PARALLEL_SERVER_INSTANCES

PARALLEL_THREADS_PER_CPU

PARTITION_VIEW_ENABLED

PLSQL_V2_COMPATIBILITY

PRE_PAGE_SGA

PROCESSES

QUERY_REWRITE_ENABLED

QUERY_REWRITE_INTEGRITY

RDBMS_SERVER_DN

READ_ONLY_OPEN_DELAYED

RECOVERY_PARALLELISM

REMOTE_DEPENDENCIES_MODE

REMOTE_LOGIN_PASSWORDFILE

REMOTE_OS_AUTHENT

REMOTE_OS_ROLES

REPLICATION_DEPENDENCY_TRACKING

RESOURCE_LIMIT

RESOURCE_MANAGER_PLAN

ROLLBACK_SEGMENTS

ROW_LOCKING

SERIAL _REUSE

SERVICE_NAMES

SESSION_CACHED_CURSORS

SESSION_MAX_OPEN_FILES

SESSIONS

SHADOW_CORE_DUMP

SHARED_MEMORY_ADDRESS

SHARED_POOL_RESERVED_SIZE

SHARED_POOL_SIZE

SORT_AREA_RETAINED_SIZE

SORT_AREA_SIZE

SORT_MULTIBLOCK_READ_COUNT

SQL92_SECURITY

SQL_TRACE

STANDBY_ARCHIVE_DEST

STAR_TRANSFORMATION_ENABLED

TAPE_ASYNCH_IO

THREAD

TIMED_OS_STATISTICS

TIMED_STATISTICS

TRANSACTION_AUDITING

TRANSACTIONS

TRANSACTIONS_PER_ROLLBACK_SEGMENT

USE_INDIRECT_DATA_BUFFERS

USER_DUMP_DEST

UTL_FILE_DIR

2 Static Data Dictionary Views

ALL_ALL_TABLES

ALL_ARGUMENTS

ALL_ASSOCIATIONS

ALL_CATALOG

ALL_CLUSTERS

ALL_CLUSTER_HASH_EXPRESSIONS

ALL_COL_COMMENTS

ALL_COL_PRIVS

ALL_COL_PRIVS_MADE

ALL_COL_PRIVS_RECD

ALL_COLL_TYPES

ALL_CONS_COLUMNS

ALL_CONSTRAINTS

ALL_CONTEXT

ALL_DB_LINKS

ALL_DEF_AUDIT_OPTS

ALL_DEPENDENCIES

ALL_DIMENSIONS

ALL_DIM_ATTRIBUTES

ALL_DIM_CHILD_OF

ALL_DIM_HIERARCHIES

ALL_DIM_JOIN_KEY

ALL_DIM_LEVELS

ALL_DIM_LEVEL_KEY

ALL_DIRECTORIES

ALL_ERRORS

ALL_IND_COLUMNS

ALL_IND_EXPRESSIONS

ALL_IND_PARTITIONS

ALL_IND_SUBPARTITIONS

ALL_INDEXES

ALL_INDEXTYPES

ALL_INDEXTYPE_OPERATORS

ALL_INTERNAL_TRIGGERS

ALL_JOBS

ALL_LIBRARIES

ALL_LOBS

ALL_LOB_PARTITIONS

ALL_LOB_SUBPARTITIONS

ALL_METHOD_PARAMS

ALL_METHOD_RESULTS

ALL_MVIEW_AGGREGATES

ALL_MVIEW_ANALYSIS

ALL_MVIEW_DETAIL_RELATIONS

ALL_MVIEW_JOINS

ALL_MVIEW_KEYS

ALL_MVIEWS

ALL_NESTED_TABLES

ALL_OBJECT_TABLES

ALL_OBJECTS

ALL_OPANCILLARY

ALL_OPARGUMENTS

ALL_OPBINDINGS

ALL_OPERATORS

ALL_OUTLINE_HINTS

ALL_OUTLINES

ALL_PART_COL_STATISTICS

ALL_PART_HISTOGRAMS

ALL_PART_INDEXES

ALL_PART_KEY_COLUMNS

ALL_PART_LOBS

ALL_PART_TABLES

ALL_PARTIAL_DROP_TABS

ALL_POLICIES

ALL_QUEUE_TABLES

ALL_QUEUES

ALL_REFRESH

ALL_REFRESH_CHILDREN

ALL_REFRESH_DEPENDENCIES

ALL_REFS

ALL_REGISTERED_SNAPSHOTS

ALL_SEQUENCES

ALL_SNAPSHOT_LOGS

ALL_SNAPSHOT_REFRESH_TIMES

ALL_SNAPSHOTS

ALL_SOURCE

ALL_SUBPART_COL_STATISTICS

ALL_SUBPART_HISTOGRAMS

ALL_SUBPART_KEY_COLUMNS

ALL_SUMDELTA

ALL_SYNONYMS

ALL_TAB_COL_STATISTICS

ALL_TAB_COLUMNS

ALL_TAB_COMMENTS

ALL_TAB_HISTOGRAMS

ALL_TAB_MODIFICATIONS

ALL_TAB_PARTITIONS

ALL_TAB_PRIVS

ALL_TAB_PRIVS_MADE

ALL_TAB_PRIVS_RECD

ALL_TAB_SUBPARTITIONS

ALL_TABLES

ALL_TRIGGERS

ALL_TRIGGER_COLS

ALL_TYPE_ATTRS

ALL_TYPE_METHODS

ALL_TYPES

ALL_UNUSED_COL_TABS

ALL_UPDATABLE_COLUMNS

ALL_USERS

ALL_USTATS

ALL_VARRAYS

ALL_VIEWS

AUDIT_ACTIONS

CATALOG

CAT

CHAINED_ROWS

CLU

CODE_PIECES

CODE_SIZE

COL

COLS

COLUMN_PRIVILEGES

DBA_2PC_NEIGHBORS

DBA_2PC_PENDING

DBA_ALL_TABLES

DBA_ANALYZE_OBJECTS

DBA_ASSOCIATIONS

DBA_AUDIT_EXISTS

DBA_AUDIT_OBJECT

DBA_AUDIT_SESSION

DBA_AUDIT_STATEMENT

DBA_AUDIT_TRAIL

DBA_BLOCKERS

DBA_CATALOG

DBA_CLU_COLUMNS

DBA_CLUSTERS

DBA_CLUSTER_HASH_EXPRESSIONS

DBA_COL_COMMENTS

DBA_COL_PRIVS

DBA_COLL_TYPES

DBA_CONS_COLUMNS

DBA_CONSTRAINTS

DBA_CONTEXT

DBA_DATA_FILES

DBA_DB_LINKS

DBA_DDL_LOCKS

DBA_DEPENDENCIES

DBA_DIMENSIONS

DBA_DIM_ATTRIBUTES

DBA_DIM_CHILD_OF

DBA_DIM_HIERARCHIES

DBA_DIM_JOIN_KEY

DBA_DIM_LEVELS

DBA_DIM_LEVEL_KEY

DBA_DIRECTORIES

DBA_DML_LOCKS

DBA_ERRORS

DBA_EXP_FILES

DBA_EXP_OBJECTS

DBA_EXP_VERSION

DBA_EXTENTS

DBA_FREE_SPACE

DBA_FREE_SPACE_COALESCED

DBA_IND_COLUMNS

DBA_IND_EXPRESSIONS

DBA_IND_PARTITIONS

DBA_IND_SUBPARTITIONS

DBA_INDEXES

DBA_INDEXTYPES

DBA_INDEXTYPE_OPERATORS

DBA_INTERNAL_TRIGGERS

DBA_JOBS

DBA_JOBS_RUNNING

DBA_KGLLOCK

DBA_LIBRARIES

DBA_LOBS

DBA_LOB_PARTITIONS

DBA_LOB_SUBPARTITIONS

DBA_LOCK_INTERNAL

DBA_LOCKS

DBA_METHOD_PARAMS

DBA_METHOD_RESULTS

DBA_MVIEW_AGGREGATES

DBA_MVIEW_ANALYSIS

DBA_MVIEW_DETAIL_RELATIONS

DBA_MVIEW_JOINS

DBA_MVIEW_KEYS

DBA_MVIEWS

DBA_NESTED_TABLES

DBA_OBJECT_SIZE

DBA_OBJECT_TABLES

DBA_OBJECTS

DBA_OBJ_AUDIT_OPTS

DBA_OPANCILLARY

DBA_OPARGUMENTS

DBA_OPBINDINGS

DBA_OPERATORS

DBA_ORPHAN_KEY_TABLE

DBA_OUTLINE_HINTS

DBA_OUTLINES

DBA_PART_COL_STATISTICS

DBA_PART_HISTOGRAMS

DBA_PART_INDEXES

DBA_PART_KEY_COLUMNS

DBA_PART_LOBS

DBA_PART_TABLES

DBA_PARTIAL_DROP_TABS

DBA_PENDING_TRANSACTIONS

DBA_POLICIES

DBA_PRIV_AUDIT_OPTS

DBA_PROFILES

DBA_QUEUE_SCHEDULES

DBA_QUEUE_TABLES

DBA_QUEUES

DBA_RCHILD

DBA_REFRESH

DBA_REFRESH_CHILDREN

DBA_REFS

DBA_REGISTERED_SNAPSHOT_GROUPS

DBA_REGISTERED_SNAPSHOTS

DBA_REPAIR_TABLE

DBA_RGROUP

DBA_ROLES

DBA_ROLE_PRIVS

DBA_ROLLBACK_SEGS

DBA_RSRC_CONSUMER_GROUP_PRIVS

DBA_RSRC_CONSUMER_GROUPS

DBA_RSRC_MANAGER_SYSTEM_PRIVS

DBA_RSRC_PLANS

DBA_RSRC_PLAN_DIRECTIVES

DBA_RULESETS

DBA_SEGMENTS

DBA_SEQUENCES

DBA_SNAPSHOT_LOGS

DBA_SNAPSHOT_LOG_FILTER_COLS

DBA_SNAPSHOT_REFRESH_TIMES

DBA_SNAPSHOTS

DBA_SOURCE

DBA_STMT_AUDIT_OPTS

DBA_SUBPART_COL_STATISTICS

DBA_SUBPART_HISTOGRAMS

DBA_SUBPART_KEY_COLUMNS

DBA_SYNONYMS

DBA_SYS_PRIVS

DBA_TAB_COL_STATISTICS

DBA_TAB_COLUMNS

DBA_TAB_COMMENTS

DBA_TAB_HISTOGRAMS

DBA_TAB_MODIFICATIONS

DBA_TAB_PARTITIONS

DBA_TAB_PRIVS

DBA_TAB_SUBPARTITIONS

DBA_TABLES

DBA_TABLESPACES

DBA_TEMP_FILES

DBA_TRIGGERS

DBA_TRIGGER_COLS

DBA_TS_QUOTAS

DBA_TYPE_ATTRS

DBA_TYPE_METHODS

DBA_TYPES

DBA_UNUSED_COL_TABS

DBA_UPDATABLE_COLUMNS

DBA_USERS

DBA_USTATS

DBA_VARRAYS

DBA_VIEWS

DBA_WAITERS

DBMS_ALERT_INFO

DBMS_LOCK_ALLOCATED

DEPTREE

DICT

DICTIONARY

DICT_COLUMNS

ERROR_SIZE

EXCEPTIONS

FILE_LOCK

FILE_PING

FILEXT$

GLOBAL_NAME

HS_ALL_CAPS

HS_ALL_DD

HS_ALL_INITS

HS_BASE_CAPS

HS_BASE_DD

HS_CLASS_CAPS

HS_CLASS_DD

HS_CLASS_INIT

HS_EXTERNAL_OBJECT_PRIVILEGES

HS_EXTERNAL_OBJECTS

HS_EXTERNAL_USER_PRIVILEGES

HS_FDS_CLASS

HS_FDS_INST

HS_INST_CAPS

HS_INST_DD

HS_INST_INIT

IDEPTREE

IND

INDEX_HISTOGRAM

INDEX_STATS

NLS_DATABASE_PARAMETERS

NLS_INSTANCE_PARAMETERS

NLS_SESSION_PARAMETERS

OBJ

PARSED_PIECES

PARSED_SIZE

PLAN_TABLE

PLUGGABLE_SET_CHECK

PRODUCT_COMPONENT_VERSION

PROXY_USERS

PSTUBTBL

PUBLICSYN

PUBLIC_DEPENDENCY

QUEUE_PRIVILEGES

RC

RESOURCE_COST

RESOURCE_MAP

ROLE_ROLE_PRIVS

ROLE_SYS_PRIVS

ROLE_TAB_PRIVS

SEQ

SESSION_CONTEXT

SESSION_PRIVS

SESSION_ROLES

SOURCE_SIZE

STMT_AUDIT_OPTION_MAP

SYN

SYNONYMS

SYSCATALOG

SYSFILES

SYSSEGOBJ

SYSTEM_PRIVILEGE_MAP

SYS_OBJECTS

TAB

TABLE_PRIVILEGES

TABLE_PRIVILEGE_MAP

TABS

TABQUOTAS

TRUSTED_SERVERS

TS_PITR_CHECK

TS_PITR_OBJECTS_TO_BE_DROPPED

UNI_PLUGGABLE_SET_CHECK

USER_ALL_TABLES

USER_ARGUMENTS

USER_ASSOCIATIONS

USER_AUDIT_OBJECT

USER_AUDIT_SESSION

USER_AUDIT_STATEMENT

USER_AUDIT_TRAIL

USER_CATALOG

USER_CLU_COLUMNS

USER_CLUSTERS

USER_CLUSTER_HASH_EXPRESSIONS

USER_COL_COMMENTS

USER_COL_PRIVS

USER_COL_PRIVS_MADE

USER_COL_PRIVS_RECD

USER_COLL_TYPES

USER_CONS_COLUMNS

USER_CONSTRAINTS

USER_DB_LINKS

USER_DEPENDENCIES

USER_DIMENSIONS

USER_DIM_ATTRIBUTES

USER_DIM_CHILD_OF

USER_DIM_HIERARCHIES

USER_DIM_JOIN_KEY

USER_DIM_LEVELS

USER_DIM_LEVEL_KEY

USER_ERRORS

USER_EXTENTS

USER_FREE_SPACE

USER_IND_COLUMNS

USER_IND_EXPRESSIONS

USER_IND_PARTITIONS

USER_IND_SUBPARTITIONS

USER_INDEXES

USER_INDEXTYPES

USER_INDEXTYPE_OPERATORS

USER_INTERNAL_TRIGGERS

USER_JOBS

USER_LIBRARIES

USER_LOBS

USER_LOB_PARTITIONS

USER_LOB_SUBPARTITIONS

USER_METHOD_PARAMS

USER_METHOD_RESULTS

USER_MVIEW_AGGREGATES

USER_MVIEW_ANALYSIS

USER_MVIEW_DETAIL_RELATIONS

USER_MVIEW_JOINS

USER_MVIEW_KEYS

USER_MVIEWS

USER_NESTED_TABLES

USER_OBJECT_TABLES

USER_OBJECTS

USER_OBJECT_SIZE

USER_OBJ_AUDIT_OPTS

USER_OPANCILLARY

USER_OPARGUMENTS

USER_OPBINDINGS

USER_OPERATORS

USER_OUTLINE_HINTS

USER_OUTLINES

USER_PART_COL_STATISTICS

USER_PART_HISTOGRAMS

USER_PART_KEY_COLUMNS

USER_PART_INDEXES

USER_PART_LOBS

USER_PART_TABLES

USER_PARTIAL_DROP_TABS

USER_PASSWORD_LIMITS

USER_POLICIES

USER_QUEUE_SCHEDULES

USER_QUEUE_TABLES

USER_QUEUES

USER_REFRESH

USER_REFRESH_CHILDREN

USER_REFS

USER_REGISTERED_SNAPSHOTS

USER_RESOURCE_LIMITS

USER_ROLE_PRIVS

USER_RSRC_CONSUMER_GROUP_PRIVS

USER_RSRC_MANAGER_SYSTEM_PRIVS

USER_RULESETS

USER_SEGMENTS

USER_SEQUENCES

USER_SNAPSHOTS

USER_SNAPSHOT_LOGS

USER_SNAPSHOT_REFRESH_TIMES

USER_SOURCE

USER_SUBPART_COL_STATISTICS

USER_SUBPART_HISTOGRAMS

USER_SUBPART_KEY_COLUMNS

USER_SYNONYMS

USER_SYS_PRIVS

USER_TAB_COL_STATISTICS

USER_TAB_COLUMNS

USER_TAB_COMMENTS

USER_TAB_HISTOGRAMS

USER_TAB_MODIFICATIONS

USER_TAB_PARTITIONS

USER_TAB_PRIVS

USER_TAB_PRIVS_MADE

USER_TAB_PRIVS_RECD

USER_TAB_SUBPARTITIONS

USER_TABLES

USER_TABLESPACES

USER_TRIGGERS

USER_TRIGGER_COLS

USER_TS_QUOTAS

USER_TYPES

USER_TYPE_ATTRS

USER_TYPE_METHODS

USER_UNUSED_COL_TABS

USER_UPDATABLE_COLUMNS

USER_USERS

USER_USTATS

USER_VARRAYS

USER_VIEWS

3 Dynamic Performance (V$) Views

V$ACCESS

V$ACTIVE_INSTANCES

V$AQ

V$ARCHIVE

V$ARCHIVE_DEST

V$ARCHIVED_LOG

V$ARCHIVE_PROCESSES

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_SYNC_IO

V$BGPROCESS

V$BH

V$BSP

V$BUFFER_POOL

V$BUFFER_POOL_STATISTICS

V$CACHE

V$CACHE_LOCK

V$CIRCUIT

V$CLASS_PING

V$COMPATIBILITY

V$COMPATSEG

V$CONTEXT

V$CONTROLFILE

V$CONTROLFILE_RECORD_SECTION

V$COPY_CORRUPTION

V$DATABASE

V$DATAFILE

V$DATAFILE_COPY

V$DATAFILE_HEADER

V$DBFILE

V$DBLINK

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

V$ENQUEUE_LOCK

V$EVENT_NAME

V$EXECUTION

V$FALSE_PING

V$FAST_START_SERVERS

V$FAST_START_TRANSACTIONS

V$FILE_PING

V$FILESTAT

V$FIXED_TABLE

V$FIXED_VIEW_DEFINITION

V$GLOBAL_BLOCKED_LOCKS

V$GLOBAL_TRANSACTION

V$HS_AGENT

V$HS_PARAMETER

V$HS_SESSION

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

V$LOADCSTAT

V$LOADTSTAT

V$LOCK

V$LOCK_ACTIVITY

V$LOCK_ELEMENT

V$LOCKED_OBJECT

V$LOCKS_WITH_COLLISIONS

V$LOG

V$LOGFILE

V$LOGHIST

V$LOGMNR_CONTENTS

V$LOGMNR_DICTIONARY

V$LOGMNR_LOGS

V$LOGMNR_PARAMETERS

V$LOG_HISTORY

V$MTS

V$MYSTAT

V$NLS_PARAMETERS

V$NLS_VALID_VALUES

V$OBJECT_DEPENDENCY

V$OBSOLETE_PARAMETER

V$OFFLINE_RANGE

V$OPEN_CURSOR

V$OPTION

V$PARALLEL_DEGREE_LIMIT_MTH

V$PARAMETER

V$PING

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

V$RECOVERY_FILE_STATUS

V$RECOVERY_LOG

V$RECOVERY_PROGRESS

V$RECOVERY_STATUS

V$REQDIST

V$RESERVED_WORDS

V$RESOURCE

V$RESOURCE_LIMIT

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

V$SHARED_SERVER

V$SORT_SEGMENT

V$SORT_USAGE

V$SQL

V$SQL_BIND_DATA

V$SQL_BIND_METADATA

V$SQL_CURSOR

V$SQL_SHARED_MEMORY

V$SQLAREA

V$SQLTEXT

V$SQLTEXT_WITH_NEWLINES

V$STATNAME

V$SUBCACHE

V$SYSSTAT

V$SYSTEM_CURSOR_CACHE

V$SYSTEM_EVENT

V$SYSTEM_PARAMETER

V$TABLESPACE

V$TEMPFILE

V$TEMPORARY_LOBS

V$TEMP_EXTENT_MAP

V$TEMP_EXTENT_POOL

V$TEMP_PING

V$TEMP_SPACE_HEADER

V$TEMPSTAT

V$THREAD

V$TIMER

V$TRANSACTION

V$TRANSACTION_ENQUEUE

V$TYPE_SIZE

V$VERSION

V$WAITSTAT

4 Database Limits

Datatype Limits

Physical Database Limits

Logical Database Limits

Process and Runtime Limits

5 SQL Scripts

Creating the Data Dictionary

Creating Additional Data Dictionary Structures

The "NO" Scripts

Migration Scripts

Java Scripts

A Oracle Wait Events

Displaying Wait Events

Wait Events and Parameters

Parameter Descriptions

Wait Event Descriptions

B Oracle Enqueue Names

C Statistics Descriptions

Displaying Statistics

Statistics Descriptions