Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Documentation Accessibility

Related Documents

What's New in Oracle Database Reference?

Oracle Database 10g Release 1 (10.1) New Features

Part I Initialization Parameters

1 Initialization Parameters

Uses of Initialization Parameters

Types of Initialization Parameters

Derived Parameters

Operating System-Dependent Parameters

Variable Parameters

Basic Initialization Parameters

Parameter Files

Server Parameter Files

Initialization Parameter Files

Specifying Values in an Initialization Parameter File

Changing Parameter Values in a Parameter File

Parameters by Functional Category

Modifiable Parameters

Displaying Current Parameter Values

Parameters You Should Not Specify in the Parameter File

When Parameters Are Set Incorrectly

Reading the Parameter Descriptions

Initialization Parameter Descriptions

ACTIVE_INSTANCE_COUNT

AQ_TM_PROCESSES

ARCHIVE_LAG_TARGET

ASM_POWER_LIMIT

AUDIT_FILE_DEST

AUDIT_SYS_OPERATIONS

BACKGROUND_CORE_DUMP

BACKGROUND_DUMP_DEST

BACKUP_TAPE_IO_SLAVES

BITMAP_MERGE_AREA_SIZE

CLUSTER_DATABASE

CLUSTER_DATABASE_INSTANCES

CLUSTER_INTERCONNECTS

COMMIT_POINT_STRENGTH

CONTROL_FILE_RECORD_KEEP_TIME

CREATE_BITMAP_AREA_SIZE

CREATE_STORED_OUTLINES

CURSOR_SPACE_FOR_TIME

DB_nK_CACHE_SIZE

DB_BLOCK_BUFFERS

DB_BLOCK_CHECKING

DB_BLOCK_CHECKSUM

DB_CACHE_ADVICE

DB_CREATE_FILE_DEST

DB_CREATE_ONLINE_LOG_DEST_n

DB_FILE_MULTIBLOCK_READ_COUNT

DB_FILE_NAME_CONVERT

DB_FLASHBACK_RETENTION_TARGET

DB_KEEP_CACHE_SIZE

DB_RECOVERY_FILE_DEST

DB_RECOVERY_FILE_DEST_SIZE

DB_RECYCLE_CACHE_SIZE

DB_WRITER_PROCESSES

DDL_WAIT_FOR_LOCKS

DG_BROKER_CONFIG_FILEn

DG_BROKER_START

DISTRIBUTED_LOCK_TIMEOUT

ENQUEUE_RESOURCES

FAST_START_IO_TARGET

FAST_START_MTTR_TARGET

FAST_START_PARALLEL_ROLLBACK

FILEIO_NETWORK_ADAPTERS

FILESYSTEMIO_OPTIONS

GC_FILES_TO_LOCKS

GCS_SERVER_PROCESSES

GLOBAL_CONTEXT_POOL_SIZE

HI_SHARED_MEMORY_ADDRESS

HS_AUTOREGISTER

INSTANCE_GROUPS

INSTANCE_NUMBER

JAVA_MAX_SESSIONSPACE_SIZE

JAVA_SOFT_SESSIONSPACE_LIMIT

JOB_QUEUE_PROCESSES

LARGE_POOL_SIZE

LDAP_DIRECTORY_ACCESS

LICENSE_MAX_SESSIONS

LICENSE_MAX_USERS

LICENSE_SESSIONS_WARNING

LOCK_NAME_SPACE

LOG_ARCHIVE_CONFIG

LOG_ARCHIVE_DEST

LOG_ARCHIVE_DEST_n

LOG_ARCHIVE_DEST_STATE_n

LOG_ARCHIVE_DUPLEX_DEST

LOG_ARCHIVE_FORMAT

LOG_ARCHIVE_LOCAL_FIRST

LOG_ARCHIVE_MAX_PROCESSES

LOG_ARCHIVE_MIN_SUCCEED_DEST

LOG_ARCHIVE_TRACE

LOG_CHECKPOINT_INTERVAL

LOG_CHECKPOINT_TIMEOUT

LOG_CHECKPOINTS_TO_ALERT

LOG_FILE_NAME_CONVERT

LOGMNR_MAX_PERSISTENT_SESSIONS

MAX_COMMIT_PROPAGATION_DELAY

MAX_DISPATCHERS

MAX_DUMP_FILE_SIZE

MAX_ENABLED_ROLES

MAX_SHARED_SERVERS

NLS_DATE_FORMAT

NLS_DATE_LANGUAGE

NLS_DUAL_CURRENCY

NLS_ISO_CURRENCY

NLS_LENGTH_SEMANTICS

NLS_NCHAR_CONV_EXCP

NLS_NUMERIC_CHARACTERS

NLS_TIMESTAMP_FORMAT

NLS_TIMESTAMP_TZ_FORMAT

O7_DICTIONARY_ACCESSIBILITY

OBJECT_CACHE_MAX_SIZE_PERCENT

OBJECT_CACHE_OPTIMAL_SIZE

OLAP_PAGE_POOL_SIZE

OPEN_LINKS_PER_INSTANCE

OPTIMIZER_DYNAMIC_SAMPLING

OPTIMIZER_FEATURES_ENABLE

OPTIMIZER_INDEX_CACHING

OPTIMIZER_INDEX_COST_ADJ

OS_AUTHENT_PREFIX

PARALLEL_ADAPTIVE_MULTI_USER

PARALLEL_AUTOMATIC_TUNING

PARALLEL_EXECUTION_MESSAGE_SIZE

PARALLEL_INSTANCE_GROUP

PARALLEL_MAX_SERVERS

PARALLEL_MIN_PERCENT

PARALLEL_MIN_SERVERS

PARALLEL_THREADS_PER_CPU

PGA_AGGREGATE_TARGET

PLSQL_CODE_TYPE

PLSQL_COMPILER_FLAGS

PLSQL_NATIVE_LIBRARY_DIR

PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT

PLSQL_OPTIMIZE_LEVEL

PLSQL_V2_COMPATIBILITY

QUERY_REWRITE_ENABLED

QUERY_REWRITE_INTEGRITY

RDBMS_SERVER_DN

READ_ONLY_OPEN_DELAYED

RECOVERY_PARALLELISM

REMOTE_ARCHIVE_ENABLE

REMOTE_DEPENDENCIES_MODE

REMOTE_LISTENER

REMOTE_LOGIN_PASSWORDFILE

REMOTE_OS_AUTHENT

REMOTE_OS_ROLES

REPLICATION_DEPENDENCY_TRACKING

RESOURCE_MANAGER_PLAN

RESUMABLE_TIMEOUT

ROLLBACK_SEGMENTS

SESSION_CACHED_CURSORS

SESSION_MAX_OPEN_FILES

SHADOW_CORE_DUMP

SHARED_MEMORY_ADDRESS

SHARED_POOL_RESERVED_SIZE

SHARED_POOL_SIZE

SHARED_SERVER_SESSIONS

SKIP_UNUSABLE_INDEXES

SMTP_OUT_SERVER

SORT_AREA_RETAINED_SIZE

SQLTUNE_CATEGORY

STANDBY_ARCHIVE_DEST

STANDBY_FILE_MANAGEMENT

STAR_TRANSFORMATION_ENABLED

STATISTICS_LEVEL

STREAMS_POOL_SIZE

TIMED_OS_STATISTICS

TIMED_STATISTICS

TRACEFILE_IDENTIFIER

TRANSACTIONS_PER_ROLLBACK_SEGMENT

UNDO_MANAGEMENT

UNDO_TABLESPACE

USE_INDIRECT_DATA_BUFFERS

WORKAREA_SIZE_POLICY

Part II Static Data Dictionary Views

2 Static Data Dictionary Views: ALL_ALL_TABLES to DATABASE_PROPERTIES

About Static Data Dictionary Views

Oracle Replication Views

Oracle Workspace Manager Views

Recovery Catalog Views

Static Data Dictionary View Descriptions

ALL_APPLY_CONFLICT_COLUMNS

ALL_APPLY_DML_HANDLERS

ALL_APPLY_ENQUEUE

ALL_APPLY_ERROR

ALL_APPLY_EXECUTE

ALL_APPLY_KEY_COLUMNS

ALL_APPLY_PARAMETERS

ALL_APPLY_PROGRESS

ALL_APPLY_TABLE_COLUMNS

ALL_ASSOCIATIONS

ALL_AUDIT_POLICIES

ALL_AUDIT_POLICY_COLUMNS

ALL_BASE_TABLE_MVIEWS

ALL_CAPTURE_EXTRA_ATTRIBUTES

ALL_CAPTURE_PARAMETERS

ALL_CAPTURE_PREPARED_DATABASE

ALL_CAPTURE_PREPARED_SCHEMAS

ALL_CAPTURE_PREPARED_TABLES

ALL_CLUSTER_HASH_EXPRESSIONS

ALL_COL_COMMENTS

ALL_COL_PRIVS_MADE

ALL_COL_PRIVS_RECD

ALL_CONS_COLUMNS

ALL_CONS_OBJ_COLUMNS

ALL_CONSTRAINTS

ALL_DEF_AUDIT_OPTS

ALL_DEPENDENCIES

ALL_DIM_ATTRIBUTES

ALL_DIM_CHILD_OF

ALL_DIM_HIERARCHIES

ALL_DIM_JOIN_KEY

ALL_DIM_LEVEL_KEY

ALL_DIRECTORIES

ALL_EVALUATION_CONTEXT_TABLES

ALL_EVALUATION_CONTEXT_VARS

ALL_EVALUATION_CONTEXTS

ALL_EXTERNAL_LOCATIONS

ALL_EXTERNAL_TABLES

ALL_IND_COLUMNS

ALL_IND_EXPRESSIONS

ALL_IND_PARTITIONS

ALL_IND_STATISTICS

ALL_IND_SUBPARTITIONS

ALL_INDEXTYPE_ARRAYTYPES

ALL_INDEXTYPE_COMMENTS

ALL_INDEXTYPE_OPERATORS

ALL_INTERNAL_TRIGGERS

ALL_JAVA_ARGUMENTS

ALL_JAVA_CLASSES

ALL_JAVA_DERIVATIONS

ALL_JAVA_FIELDS

ALL_JAVA_IMPLEMENTS

ALL_JAVA_INNERS

ALL_JAVA_LAYOUTS

ALL_JAVA_METHODS

ALL_JAVA_NCOMPS

ALL_JAVA_RESOLVERS

ALL_JAVA_THROWS

ALL_JOIN_IND_COLUMNS

ALL_LOB_PARTITIONS

ALL_LOB_SUBPARTITIONS

ALL_LOB_TEMPLATES

ALL_LOG_GROUP_COLUMNS

ALL_METHOD_PARAMS

ALL_METHOD_RESULTS

ALL_MVIEW_AGGREGATES

ALL_MVIEW_ANALYSIS

ALL_MVIEW_COMMENTS

ALL_MVIEW_DETAIL_RELATIONS

ALL_MVIEW_JOINS

ALL_MVIEW_REFRESH_TIMES

ALL_NESTED_TABLE_COLS

ALL_NESTED_TABLES

ALL_OBJ_COLATTRS

ALL_OBJECT_TABLES

ALL_OPANCILLARY

ALL_OPARGUMENTS

ALL_OPERATOR_COMMENTS

ALL_OUTLINE_HINTS

ALL_PART_COL_STATISTICS

ALL_PART_HISTOGRAMS

ALL_PART_INDEXES

ALL_PART_KEY_COLUMNS

ALL_PART_TABLES

ALL_PARTIAL_DROP_TABS

ALL_PENDING_CONV_TABLES

ALL_PLSQL_OBJECT_SETTINGS

ALL_POLICY_CONTEXTS

ALL_POLICY_GROUPS

ALL_PROPAGATION

ALL_PUBLISHED_COLUMNS

ALL_QUEUE_TABLES

ALL_REFRESH_CHILDREN

ALL_REFRESH_DEPENDENCIES

ALL_REGISTERED_MVIEWS

ALL_REGISTRY_BANNERS

ALL_REWRITE_EQUIVALENCES

ALL_RULE_SET_RULES

ALL_SCHEDULER_JOB_ARGS

ALL_SCHEDULER_JOB_CLASSES

ALL_SCHEDULER_JOB_LOG

ALL_SCHEDULER_JOB_RUN_DETAILS

ALL_SCHEDULER_JOBS

ALL_SCHEDULER_PROGRAM_ARGS

ALL_SCHEDULER_PROGRAMS

ALL_SCHEDULER_RUNNING_JOBS

ALL_SCHEDULER_SCHEDULES

ALL_SCHEDULER_WINDOW_DETAILS

ALL_SCHEDULER_WINDOW_GROUPS

ALL_SCHEDULER_WINDOW_LOG

ALL_SCHEDULER_WINDOWS

ALL_SCHEDULER_WINGROUP_MEMBERS

ALL_SEC_RELEVANT_COLS

ALL_SOURCE_TABLES

ALL_SQLJ_TYPE_ATTRS

ALL_SQLJ_TYPE_METHODS

ALL_STORED_SETTINGS

ALL_STREAMS_GLOBAL_RULES

ALL_STREAMS_MESSAGE_CONSUMERS

ALL_STREAMS_MESSAGE_RULES

ALL_STREAMS_NEWLY_SUPPORTED

ALL_STREAMS_RULES

ALL_STREAMS_SCHEMA_RULES

ALL_STREAMS_TABLE_RULES

ALL_STREAMS_TRANSFORM_FUNCTION

ALL_STREAMS_UNSUPPORTED

ALL_SUBPART_COL_STATISTICS

ALL_SUBPART_HISTOGRAMS

ALL_SUBPART_KEY_COLUMNS

ALL_SUBPARTITION_TEMPLATES

ALL_SUBSCRIBED_COLUMNS

ALL_SUBSCRIBED_TABLES

ALL_SUBSCRIPTIONS

ALL_TAB_COL_STATISTICS

ALL_TAB_COLUMNS

ALL_TAB_COMMENTS

ALL_TAB_HISTOGRAMS

ALL_TAB_MODIFICATIONS

ALL_TAB_PARTITIONS

ALL_TAB_PRIVS_MADE

ALL_TAB_PRIVS_RECD

ALL_TAB_STATISTICS

ALL_TAB_SUBPARTITIONS

ALL_TRIGGER_COLS

ALL_TYPE_METHODS

ALL_TYPE_VERSIONS

ALL_UNUSED_COL_TABS

ALL_UPDATABLE_COLUMNS

ALL_WARNING_SETTINGS

ALL_XML_SCHEMAS

ALL_XML_TAB_COLS

ALL_XML_VIEW_COLS

DATABASE_PROPERTIES

3 Static Data Dictionary Views: DBA_2PC_NEIGHBORS to USER_XML_VIEWS

DBA_2PC_NEIGHBORS

DBA_2PC_PENDING

DBA_ADVISOR_ACTIONS

DBA_ADVISOR_COMMANDS

DBA_ADVISOR_DEFINITIONS

DBA_ADVISOR_FINDINGS

DBA_ADVISOR_JOURNAL

DBA_ADVISOR_LOG

DBA_ADVISOR_OBJECT_TYPES

DBA_ADVISOR_OBJECTS

DBA_ADVISOR_PARAMETERS

DBA_ADVISOR_RATIONALE

DBA_ADVISOR_RECOMMENDATIONS

DBA_ADVISOR_SQLA_REC_SUM

DBA_ADVISOR_SQLA_WK_MAP

DBA_ADVISOR_SQLA_WK_STMTS

DBA_ADVISOR_SQLW_JOURNAL

DBA_ADVISOR_SQLW_PARAMETERS

DBA_ADVISOR_SQLW_STMTS

DBA_ADVISOR_SQLW_SUM

DBA_ADVISOR_SQLW_TABLES

DBA_ADVISOR_SQLW_TEMPLATES

DBA_ADVISOR_TASKS

DBA_ADVISOR_TEMPLATES

DBA_ADVISOR_USAGE

DBA_ALERT_HISTORY

DBA_APPLICATION_ROLES

DBA_APPLY_CONFLICT_COLUMNS

DBA_APPLY_DML_HANDLERS

DBA_APPLY_ENQUEUE

DBA_APPLY_ERROR

DBA_APPLY_EXECUTE

DBA_APPLY_INSTANTIATED_GLOBAL

DBA_APPLY_INSTANTIATED_OBJECTS

DBA_APPLY_INSTANTIATED_SCHEMAS

DBA_APPLY_KEY_COLUMNS

DBA_APPLY_PARAMETERS

DBA_APPLY_PROGRESS

DBA_APPLY_TABLE_COLUMNS

DBA_AQ_AGENT_PRIVS

DBA_ASSOCIATIONS

DBA_ATTRIBUTE_TRANSFORMATIONS

DBA_AUDIT_EXISTS

DBA_AUDIT_OBJECT

DBA_AUDIT_POLICIES

DBA_AUDIT_POLICY_COLUMNS

DBA_AUDIT_SESSION

DBA_AUDIT_STATEMENT

DBA_AUDIT_TRAIL

DBA_BASE_TABLE_MVIEWS

DBA_CAPTURE_EXTRA_ATTRIBUTES

DBA_CAPTURE_PARAMETERS

DBA_CAPTURE_PREPARED_DATABASE

DBA_CAPTURE_PREPARED_SCHEMAS

DBA_CAPTURE_PREPARED_TABLES

DBA_CLU_COLUMNS

DBA_CLUSTER_HASH_EXPRESSIONS

DBA_COL_COMMENTS

DBA_COMMON_AUDIT_TRAIL

DBA_CONS_OBJ_COLUMNS

DBA_CONSTRAINTS

DBA_DATAPUMP_JOBS

DBA_DATAPUMP_SESSIONS

DBA_DEPENDENCIES

DBA_DIM_ATTRIBUTES

DBA_DIM_CHILD_OF

DBA_DIM_HIERARCHIES

DBA_DIM_JOIN_KEY

DBA_DIM_LEVEL_KEY

DBA_DIRECTORIES

DBA_DMT_FREE_SPACE

DBA_DMT_USED_EXTENTS

DBA_ENABLED_AGGREGATIONS

DBA_ENABLED_TRACES

DBA_EVALUATION_CONTEXT_TABLES

DBA_EVALUATION_CONTEXT_VARS

DBA_EVALUATION_CONTEXTS

DBA_EXP_OBJECTS

DBA_EXP_VERSION

DBA_EXTERNAL_LOCATIONS

DBA_EXTERNAL_TABLES

DBA_FEATURE_USAGE_STATISTICS

DBA_FGA_AUDIT_TRAIL

DBA_FREE_SPACE_COALESCED

DBA_HIGH_WATER_MARK_STATISTICS

DBA_HIST_ACTIVE_SESS_HISTORY

DBA_HIST_BASELINE

DBA_HIST_BG_EVENT_SUMMARY

DBA_HIST_BUFFER_POOL_STAT

DBA_HIST_CR_BLOCK_SERVER

DBA_HIST_CURRENT_BLOCK_SERVER

DBA_HIST_DATABASE_INSTANCE

DBA_HIST_DATAFILE

DBA_HIST_DB_CACHE_ADVICE

DBA_HIST_DLM_MISC

DBA_HIST_ENQUEUE_STAT

DBA_HIST_EVENT_NAME

DBA_HIST_FILEMETRIC_HISTORY

DBA_HIST_FILESTATXS

DBA_HIST_INSTANCE_RECOVERY

DBA_HIST_JAVA_POOL_ADVICE

DBA_HIST_LATCH_CHILDREN

DBA_HIST_LATCH_MISSES_SUMMARY

DBA_HIST_LATCH_NAME

DBA_HIST_LATCH_PARENT

DBA_HIST_LIBRARYCACHE

DBA_HIST_METRIC_NAME

DBA_HIST_MTTR_TARGET_ADVICE

DBA_HIST_OPTIMIZER_ENV

DBA_HIST_OSSTAT

DBA_HIST_OSSTAT_NAME

DBA_HIST_PARAMETER

DBA_HIST_PARAMETER_NAME

DBA_HIST_PGA_TARGET_ADVICE

DBA_HIST_PGASTAT

DBA_HIST_RESOURCE_LIMIT

DBA_HIST_ROLLSTAT

DBA_HIST_ROWCACHE_SUMMARY

DBA_HIST_SEG_STAT

DBA_HIST_SEG_STAT_OBJ

DBA_HIST_SERVICE_NAME

DBA_HIST_SERVICE_STAT

DBA_HIST_SERVICE_WAIT_CLASS

DBA_HIST_SESSMETRIC_HISTORY

DBA_HIST_SGASTAT

DBA_HIST_SHARED_POOL_ADVICE

DBA_HIST_SNAP_ERROR

DBA_HIST_SNAPSHOT

DBA_HIST_SQL_PLAN

DBA_HIST_SQL_SUMMARY

DBA_HIST_SQL_WORKAREA_HSTGRM

DBA_HIST_SQLBIND

DBA_HIST_SQLSTAT

DBA_HIST_SQLTEXT

DBA_HIST_STAT_NAME

DBA_HIST_SYS_TIME_MODEL

DBA_HIST_SYSMETRIC_HISTORY

DBA_HIST_SYSMETRIC_SUMMARY

DBA_HIST_SYSSTAT

DBA_HIST_SYSTEM_EVENT

DBA_HIST_TABLESPACE_STAT

DBA_HIST_TBSPC_SPACE_USAGE

DBA_HIST_TEMPFILE

DBA_HIST_TEMPSTATXS

DBA_HIST_THREAD

DBA_HIST_UNDOSTAT

DBA_HIST_WAITCLASSMET_HISTORY

DBA_HIST_WAITSTAT

DBA_HIST_WR_CONTROL

DBA_IND_COLUMNS

DBA_IND_EXPRESSIONS

DBA_IND_PARTITIONS

DBA_IND_STATISTICS

DBA_IND_SUBPARTITIONS

DBA_INDEXTYPE_ARRAYTYPES

DBA_INDEXTYPE_COMMENTS

DBA_INDEXTYPE_OPERATORS

DBA_INTERNAL_TRIGGERS

DBA_JAVA_ARGUMENTS

DBA_JAVA_CLASSES

DBA_JAVA_DERIVATIONS

DBA_JAVA_FIELDS

DBA_JAVA_IMPLEMENTS

DBA_JAVA_INNERS

DBA_JAVA_LAYOUTS

DBA_JAVA_METHODS

DBA_JAVA_NCOMPS

DBA_JAVA_POLICY

DBA_JAVA_RESOLVERS

DBA_JAVA_THROWS

DBA_JOBS_RUNNING

DBA_JOIN_IND_COLUMNS

DBA_LMT_FREE_SPACE

DBA_LMT_USED_EXTENTS

DBA_LOB_PARTITIONS

DBA_LOB_SUBPARTITIONS

DBA_LOB_TEMPLATES

DBA_LOCK_INTERNAL

DBA_LOG_GROUP_COLUMNS

DBA_LOGMNR_PURGED_LOG

DBA_LOGMNR_SESSION

DBA_LOGSTDBY_EVENTS

DBA_LOGSTDBY_LOG

DBA_LOGSTDBY_NOT_UNIQUE

DBA_LOGSTDBY_PARAMETERS

DBA_LOGSTDBY_PROGRESS

DBA_LOGSTDBY_SKIP

DBA_LOGSTDBY_SKIP_TRANSACTION

DBA_LOGSTDBY_UNSUPPORTED

DBA_METHOD_PARAMS

DBA_METHOD_RESULTS

DBA_MVIEW_AGGREGATES

DBA_MVIEW_ANALYSIS

DBA_MVIEW_COMMENTS

DBA_MVIEW_DETAIL_RELATIONS

DBA_MVIEW_JOINS

DBA_MVIEW_LOG_FILTER_COLS

DBA_MVIEW_REFRESH_TIMES

DBA_NESTED_TABLE_COLS

DBA_NESTED_TABLES

DBA_OBJ_AUDIT_OPTS

DBA_OBJ_COLATTRS

DBA_OBJECT_SIZE

DBA_OBJECT_TABLES

DBA_OPANCILLARY

DBA_OPARGUMENTS

DBA_OPERATOR_COMMENTS

DBA_ORPHAN_KEY_TABLE

DBA_OUTLINE_HINTS

DBA_OUTSTANDING_ALERTS

DBA_PART_COL_STATISTICS

DBA_PART_HISTOGRAMS

DBA_PART_INDEXES

DBA_PART_KEY_COLUMNS

DBA_PART_TABLES

DBA_PARTIAL_DROP_TABS

DBA_PENDING_CONV_TABLES

DBA_PENDING_TRANSACTIONS

DBA_PLSQL_OBJECT_SETTINGS

DBA_POLICY_CONTEXTS

DBA_POLICY_GROUPS

DBA_PRIV_AUDIT_OPTS

DBA_PROPAGATION

DBA_PUBLISHED_COLUMNS

DBA_QUEUE_SCHEDULES

DBA_QUEUE_TABLES

DBA_REDEFINITION_ERRORS

DBA_REDEFINITION_OBJECTS

DBA_REFRESH_CHILDREN

DBA_REGISTERED_ARCHIVED_LOG

DBA_REGISTERED_MVIEW_GROUPS

DBA_REGISTERED_MVIEWS

DBA_REGISTRY_HIERARCHY

DBA_REPAIR_TABLE

DBA_REWRITE_EQUIVALENCES

DBA_ROLLBACK_SEGS

DBA_RSRC_CONSUMER_GROUP_PRIVS

DBA_RSRC_CONSUMER_GROUPS

DBA_RSRC_GROUP_MAPPINGS

DBA_RSRC_MANAGER_SYSTEM_PRIVS

DBA_RSRC_MAPPING_PRIORITY

DBA_RSRC_PLAN_DIRECTIVES

DBA_RULE_SET_RULES

DBA_SCHEDULER_JOB_ARGS

DBA_SCHEDULER_JOB_CLASSES

DBA_SCHEDULER_JOB_LOG

DBA_SCHEDULER_JOB_RUN_DETAILS

DBA_SCHEDULER_JOBS

DBA_SCHEDULER_PROGRAM_ARGS

DBA_SCHEDULER_PROGRAMS

DBA_SCHEDULER_RUNNING_JOBS

DBA_SCHEDULER_SCHEDULES

DBA_SCHEDULER_WINDOW_DETAILS

DBA_SCHEDULER_WINDOW_GROUPS

DBA_SCHEDULER_WINDOW_LOG

DBA_SCHEDULER_WINDOWS

DBA_SCHEDULER_WINGROUP_MEMBERS

DBA_SEC_RELEVANT_COLS

DBA_SERVER_REGISTRY

DBA_SOURCE_TABLES

DBA_SQL_PROFILES

DBA_SQLJ_TYPE_ATTRS

DBA_SQLJ_TYPE_METHODS

DBA_SQLSET_BINDS

DBA_SQLSET_REFERENCES

DBA_SQLSET_STATEMENTS

DBA_SQLTUNE_BINDS

DBA_SQLTUNE_PLANS

DBA_SQLTUNE_RATIONALE_PLAN

DBA_SQLTUNE_STATISTICS

DBA_STMT_AUDIT_OPTS

DBA_STORED_SETTINGS

DBA_STREAMS_ADMINISTRATOR

DBA_STREAMS_GLOBAL_RULES

DBA_STREAMS_MESSAGE_CONSUMERS

DBA_STREAMS_MESSAGE_RULES

DBA_STREAMS_NEWLY_SUPPORTED

DBA_STREAMS_RULES

DBA_STREAMS_SCHEMA_RULES

DBA_STREAMS_TABLE_RULES

DBA_STREAMS_TRANSFORM_FUNCTION

DBA_STREAMS_UNSUPPORTED

DBA_SUBPART_COL_STATISTICS

DBA_SUBPART_HISTOGRAMS

DBA_SUBPART_KEY_COLUMNS

DBA_SUBPARTITION_TEMPLATES

DBA_SUBSCRIBED_COLUMNS

DBA_SUBSCRIBED_TABLES

DBA_SUBSCRIPTIONS

DBA_TAB_COL_STATISTICS

DBA_TAB_COLUMNS

DBA_TAB_COMMENTS

DBA_TAB_HISTOGRAMS

DBA_TAB_MODIFICATIONS

DBA_TAB_PARTITIONS

DBA_TAB_STATISTICS

DBA_TAB_SUBPARTITIONS

DBA_TABLESPACE_GROUPS

DBA_TABLESPACES

DBA_TRANSFORMATIONS

DBA_TRIGGER_COLS

DBA_TYPE_METHODS

DBA_TYPE_VERSIONS

DBA_UNDO_EXTENTS

DBA_UNUSED_COL_TABS

DBA_UPDATABLE_COLUMNS

DBA_WARNING_SETTINGS

DBA_XML_SCHEMAS

DBA_XML_TAB_COLS

DBA_XML_VIEW_COLS

FLASHBACK_TRANSACTION_QUERY

DBMS_ALERT_INFO

DBMS_LOCK_ALLOCATED

HS_EXTERNAL_OBJECT_PRIVILEGES

HS_EXTERNAL_OBJECTS

HS_EXTERNAL_USER_PRIVILEGES

INDEX_HISTOGRAM

NLS_DATABASE_PARAMETERS

NLS_INSTANCE_PARAMETERS

NLS_SESSION_PARAMETERS

PLUGGABLE_SET_CHECK

PRODUCT_COMPONENT_VERSION

PUBLIC_DEPENDENCY

QUEUE_PRIVILEGES

ROLE_ROLE_PRIVS

SESSION_CONTEXT

STMT_AUDIT_OPTION_MAP

SYSTEM_PRIVILEGE_MAP

TABLE_PRIVILEGE_MAP

TRUSTED_SERVERS

TS_PITR_OBJECTS_TO_BE_DROPPED

UNI_PLUGGABLE_SET_CHECK

USER_ADVISOR_ACTIONS

USER_ADVISOR_FINDINGS

USER_ADVISOR_JOURNAL

USER_ADVISOR_LOG

USER_ADVISOR_OBJECTS

USER_ADVISOR_PARAMETERS

USER_ADVISOR_RATIONALE

USER_ADVISOR_RECOMMENDATIONS

USER_ADVISOR_SQLA_REC_SUM

USER_ADVISOR_SQLA_WK_MAP

USER_ADVISOR_SQLA_WK_STMTS

USER_ADVISOR_SQLW_JOURNAL

USER_ADVISOR_SQLW_PARAMETERS

USER_ADVISOR_SQLW_STMTS

USER_ADVISOR_SQLW_SUM

USER_ADVISOR_SQLW_TABLES

USER_ADVISOR_SQLW_TEMPLATES

USER_ADVISOR_TASKS

USER_ADVISOR_TEMPLATES

USER_ALL_TABLES

USER_AQ_AGENT_PRIVS

USER_ASSOCIATIONS

USER_ATTRIBUTE_TRANSFORMATIONS

USER_AUDIT_OBJECT

USER_AUDIT_POLICIES

USER_AUDIT_POLICY_COLUMNS

USER_AUDIT_SESSION

USER_AUDIT_STATEMENT

USER_AUDIT_TRAIL

USER_BASE_TABLE_MVIEWS

USER_CLU_COLUMNS

USER_CLUSTER_HASH_EXPRESSIONS

USER_COL_COMMENTS

USER_COL_PRIVS_MADE

USER_COL_PRIVS_RECD

USER_COLL_TYPES

USER_CONS_COLUMNS

USER_CONS_OBJ_COLUMNS

USER_CONSTRAINTS

USER_DATAPUMP_JOBS

USER_DEPENDENCIES

USER_DIM_ATTRIBUTES

USER_DIM_CHILD_OF

USER_DIM_HIERARCHIES

USER_DIM_JOIN_KEY

USER_DIM_LEVEL_KEY

USER_DIM_LEVELS

USER_DIMENSIONS

USER_EVALUATION_CONTEXT_TABLES

USER_EVALUATION_CONTEXT_VARS

USER_EVALUATION_CONTEXTS

USER_EXTERNAL_LOCATIONS

USER_EXTERNAL_TABLES

USER_FREE_SPACE

USER_IND_COLUMNS

USER_IND_EXPRESSIONS

USER_IND_PARTITIONS

USER_IND_STATISTICS

USER_IND_SUBPARTITIONS

USER_INDEXTYPE_ARRAYTYPES

USER_INDEXTYPE_COMMENTS

USER_INDEXTYPE_OPERATORS

USER_INDEXTYPES

USER_INTERNAL_TRIGGERS

USER_JAVA_ARGUMENTS

USER_JAVA_CLASSES

USER_JAVA_DERIVATIONS

USER_JAVA_FIELDS

USER_JAVA_IMPLEMENTS

USER_JAVA_INNERS

USER_JAVA_LAYOUTS

USER_JAVA_METHODS

USER_JAVA_NCOMPS

USER_JAVA_POLICY

USER_JAVA_RESOLVERS

USER_JAVA_THROWS

USER_JOIN_IND_COLUMNS

USER_LOB_PARTITIONS

USER_LOB_SUBPARTITIONS

USER_LOB_TEMPLATES

USER_LOG_GROUP_COLUMNS

USER_LOG_GROUPS

USER_METHOD_PARAMS

USER_METHOD_RESULTS

USER_MVIEW_AGGREGATES

USER_MVIEW_ANALYSIS

USER_MVIEW_COMMENTS

USER_MVIEW_DETAIL_RELATIONS

USER_MVIEW_JOINS

USER_MVIEW_KEYS

USER_MVIEW_LOGS

USER_MVIEW_REFRESH_TIMES

USER_NESTED_TABLE_COLS

USER_NESTED_TABLES

USER_OBJ_AUDIT_OPTS

USER_OBJ_COLATTRS

USER_OBJECT_SIZE

USER_OBJECT_TABLES

USER_OPANCILLARY

USER_OPARGUMENTS

USER_OPBINDINGS

USER_OPERATOR_COMMENTS

USER_OUTLINE_HINTS

USER_PART_COL_STATISTICS

USER_PART_HISTOGRAMS

USER_PART_INDEXES

USER_PART_KEY_COLUMNS

USER_PART_TABLES

USER_PARTIAL_DROP_TABS

USER_PASSWORD_LIMITS

USER_PENDING_CONV_TABLES

USER_PLSQL_OBJECT_SETTINGS

USER_POLICY_CONTEXTS

USER_POLICY_GROUPS

USER_PROCEDURES

USER_PUBLISHED_COLUMNS

USER_QUEUE_SCHEDULES

USER_QUEUE_TABLES

USER_RECYCLEBIN

USER_REFRESH_CHILDREN

USER_REGISTERED_MVIEWS

USER_RESOURCE_LIMITS

USER_REWRITE_EQUIVALENCES

USER_ROLE_PRIVS

USER_RSRC_CONSUMER_GROUP_PRIVS

USER_RSRC_MANAGER_SYSTEM_PRIVS

USER_RULE_SET_RULES

USER_SCHEDULER_JOB_ARGS

USER_SCHEDULER_JOB_LOG

USER_SCHEDULER_JOB_RUN_DETAILS

USER_SCHEDULER_JOBS

USER_SCHEDULER_PROGRAM_ARGS

USER_SCHEDULER_PROGRAMS

USER_SCHEDULER_RUNNING_JOBS

USER_SCHEDULER_SCHEDULES

USER_SEC_RELEVANT_COLS

USER_SOURCE_TABLES

USER_SQLJ_TYPE_ATTRS

USER_SQLJ_TYPE_METHODS

USER_SQLJ_TYPES

USER_SQLSET_BINDS

USER_SQLSET_REFERENCES

USER_SQLSET_STATEMENTS

USER_SQLTUNE_BINDS

USER_SQLTUNE_PLANS

USER_SQLTUNE_RATIONALE_PLAN

USER_SQLTUNE_STATISTICS

USER_STORED_SETTINGS

USER_SUBPART_COL_STATISTICS

USER_SUBPART_HISTOGRAMS

USER_SUBPART_KEY_COLUMNS

USER_SUBPARTITION_TEMPLATES

USER_SUBSCRIBED_COLUMNS

USER_SUBSCRIBED_TABLES

USER_SUBSCRIPTIONS

USER_TAB_COL_STATISTICS

USER_TAB_COLUMNS

USER_TAB_COMMENTS

USER_TAB_HISTOGRAMS

USER_TAB_MODIFICATIONS

USER_TAB_PARTITIONS

USER_TAB_PRIVS_MADE

USER_TAB_PRIVS_RECD

USER_TAB_STATISTICS

USER_TAB_SUBPARTITIONS

USER_TABLESPACES

USER_TRANSFORMATIONS

USER_TRIGGER_COLS

USER_TUNE_MVIEW

USER_TYPE_ATTRS

USER_TYPE_METHODS

USER_TYPE_VERSIONS

USER_UNUSED_COL_TABS

USER_UPDATABLE_COLUMNS

USER_WARNING_SETTINGS

USER_XML_SCHEMAS

USER_XML_TAB_COLS

USER_XML_TABLES

USER_XML_VIEW_COLS

Part III Dynamic Performance Views

4 Dynamic Performance (V$) Views

About Dynamic Performance Views

Dynamic Performance View Descriptions

V$ACTIVE_INSTANCES

V$ACTIVE_SERVICES

V$ACTIVE_SESS_POOL_MTH

V$ACTIVE_SESSION_HISTORY

V$ARCHIVE_DEST_STATUS

V$ARCHIVE_PROCESSES

V$ASM_DISKGROUP

V$ASM_OPERATION

V$BACKUP_ASYNC_IO

V$BACKUP_CORRUPTION

V$BACKUP_DATAFILE

V$BACKUP_DEVICE

V$BACKUP_REDOLOG

V$BACKUP_SPFILE

V$BACKUP_SYNC_IO

V$BLOCK_CHANGE_TRACKING

V$BUFFER_POOL_STATISTICS

V$BUFFERED_PUBLISHERS

V$BUFFERED_QUEUES

V$BUFFERED_SUBSCRIBERS

V$CACHE_TRANSFER

V$CLASS_CACHE_TRANSFER

V$CONTROLFILE_RECORD_SECTION

V$COPY_CORRUPTION

V$CR_BLOCK_SERVER

V$CURRENT_BLOCK_SERVER

V$DATABASE_BLOCK_CORRUPTION

V$DATABASE_INCARNATION

V$DATAFILE_COPY

V$DATAFILE_HEADER

V$DATAGUARD_CONFIG

V$DATAGUARD_STATUS

V$DB_CACHE_ADVICE

V$DB_OBJECT_CACHE

V$DELETED_OBJECT

V$DISPATCHER_CONFIG

V$DISPATCHER_RATE

V$EVENT_HISTOGRAM

V$FAST_START_SERVERS

V$FAST_START_TRANSACTIONS

V$FILE_CACHE_TRANSFER

V$FILE_HISTOGRAM

V$FILEMETRIC_HISTORY

V$FIXED_VIEW_DEFINITION

V$FLASHBACK_DATABASE_LOG

V$FLASHBACK_DATABASE_STAT

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_STATISTICS

V$GLOBAL_BLOCKED_LOCKS

V$GLOBAL_TRANSACTION

V$HVMASTER_INFO

V$INDEXED_FIXED_COLUMN

V$INSTANCE_RECOVERY

V$JAVA_LIBRARY_CACHE_MEMORY

V$JAVA_POOL_ADVICE

V$LATCH_CHILDREN

V$LIBRARY_CACHE_MEMORY

V$LOCK_ACTIVITY

V$LOCKED_OBJECT

V$LOGMNR_CONTENTS

V$LOGMNR_DICTIONARY

V$LOGMNR_PARAMETERS

V$LOGSTDBY_STATS

V$MANAGED_STANDBY

V$MAP_COMP_LIST

V$MAP_EXT_ELEMENT

V$MAP_FILE_EXTENT

V$MAP_FILE_IO_STACK

V$MAP_SUBELEMENT

V$MTTR_TARGET_ADVICE

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

V$NLS_PARAMETERS

V$NLS_VALID_VALUES

V$OBJECT_DEPENDENCY

V$OBSOLETE_BACKUP_FILES

V$OBSOLETE_PARAMETER

V$OFFLINE_RANGE

V$PARALLEL_DEGREE_LIMIT_MTH

V$PGA_TARGET_ADVICE

V$PGA_TARGET_ADVICE_HISTOGRAM

V$PROPAGATION_RECEIVER

V$PROPAGATION_SENDER

V$PROXY_ARCHIVEDLOG

V$PROXY_DATAFILE

V$PX_PROCESS_SYSSTAT

V$RECOVERY_FILE_DEST

V$RECOVERY_FILE_STATUS

V$RECOVERY_PROGRESS

V$RECOVERY_STATUS

V$RESERVED_WORDS

V$RESOURCE_LIMIT

V$RMAN_CONFIGURATION

V$ROWCACHE_PARENT

V$ROWCACHE_SUBORDINATE

V$RSRC_CONSUMER_GROUP

V$RSRC_CONSUMER_GROUP_CPU_MTH

V$RSRC_PLAN_CPU_MTH

V$RULE_SET_AGGREGATE_STATS

V$SEGMENT_STATISTICS

V$SERV_MOD_ACT_STATS

V$SERVICE_EVENT

V$SERVICE_STATS

V$SERVICE_WAIT_CLASS

V$SERVICEMETRIC

V$SERVICEMETRIC_HISTORY

V$SES_OPTIMIZER_ENV

V$SESS_TIME_MODEL

V$SESSION_CONNECT_INFO

V$SESSION_CURSOR_CACHE

V$SESSION_EVENT

V$SESSION_LONGOPS

V$SESSION_OBJECT_CACHE

V$SESSION_WAIT_CLASS

V$SESSION_WAIT_HISTORY

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

V$SQL_BIND_DATA

V$SQL_BIND_METADATA

V$SQL_OPTIMIZER_ENV

V$SQL_PLAN_STATISTICS

V$SQL_PLAN_STATISTICS_ALL

V$SQL_REDIRECTION

V$SQL_SHARED_CURSOR

V$SQL_SHARED_MEMORY

V$SQL_WORKAREA_ACTIVE

V$SQL_WORKAREA_HISTOGRAM

V$SQLTEXT_WITH_NEWLINES

V$STATISTICS_LEVEL

V$STREAMS_APPLY_COORDINATOR

V$STREAMS_APPLY_READER

V$STREAMS_APPLY_SERVER

V$STREAMS_CAPTURE

V$SYS_OPTIMIZER_ENV

V$SYS_TIME_MODEL

V$SYSAUX_OCCUPANTS

V$SYSMETRIC_HISTORY

V$SYSMETRIC_SUMMARY

V$SYSTEM_CURSOR_CACHE

V$SYSTEM_PARAMETER

V$SYSTEM_PARAMETER2

V$SYSTEM_WAIT_CLASS

V$TEMP_CACHE_TRANSFER

V$TEMP_EXTENT_MAP

V$TEMP_EXTENT_POOL

V$TEMP_HISTOGRAM

V$TEMP_SPACE_HEADER

V$TEMPORARY_LOBS

V$TEMPSEG_USAGE

V$THRESHOLD_TYPES

V$TIMEZONE_NAMES

V$TRANSACTION_ENQUEUE

V$TRANSPORTABLE_PLATFORM

V$WAITCLASSMETRIC

V$WAITCLASSMETRIC_HISTORY

A Database Limits

Datatype Limits

Physical Database Limits

Logical Database Limits

Process and Runtime Limits

B SQL Scripts

Creating the Data Dictionary

Creating Additional Data Dictionary Structures

The "NO" Scripts

Upgrade and Downgrade Scripts

C Oracle Wait Events

Displaying Wait Events

Wait Events and Parameters

Parameter Descriptions

Wait Event Descriptions

alter system set dispatchers

batched allocate scn lock request

BFILE check if exists

BFILE check if open

BFILE get length

BFILE get name object

BFILE get path object

BFILE internal seek

buffer busy waits

buffer deadlock

buffer for checkpoint

buffer read retry

checkpoint completed

checkpoint range buffer not saved

control file parallel write

control file sequential read

control file single write

conversion file read

db file parallel read

db file parallel write

db file scattered read

db file sequential read

db file single write

DFS db file lock

DFS lock handle

direct path read

direct path write

dispatcher shutdown

dispatcher timer

duplicate cluster key

free buffer waits

free global transaction table entry

free process state object

global cache busy

global cache lock cleanup

global cache freelist wait

global cache null to s

global cache null to x

global cache open s

global cache open x

global cache s to x

inactive session

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 incomplete)

log file switch (clearing log file)

log file switch completion

log switch/archive

on-going SCN fetch to complete

pending global transaction(s)

PL/SQL lock timer

process startup

PX dequeue wait

PX server shutdown

PX signal server

rdbms ipc message

rdbms ipc message block

rdbms ipc reply

scginq AST call

single-task message

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 data to client

SQL*Net more data to dblink

switch logfile command

timer in sksawat

undo segment extension

undo segment recovery

undo segment tx slot

virtual circuit status

WMON goes to sleep

write complete waits

writes stopped by instance recovery or database suspension

D Oracle Enqueue Names

E Statistics Descriptions

Displaying Statistics

Statistics Descriptions

Index