Contents

Title and Copyright Information

Send Us Your Comments

Preface

Related Documentation

Documentation Accessibility

What's New in Oracle9i Database Reference?

Oracle9i Release 2 (9.2) New Features in Oracle9i Database Reference

Oracle9i Release 1 (9.0.1) New Features in Oracle9i Database Reference

1 Initialization Parameters

Uses of Initialization Parameters

Types of Initialization Parameters

Parameter Files

Server Parameter Files

Initialization Parameter Files

Changing Parameter Values

Dynamic Parameters

Displaying Current Parameter Values

Parameters You Should Not Specify in the Parameter File

When Parameters Are Set Incorrectly

Reading the Parameter Descriptions

Parameter Descriptions

ACTIVE_INSTANCE_COUNT

AQ_TM_PROCESSES

ARCHIVE_LAG_TARGET

AUDIT_FILE_DEST

AUDIT_SYS_OPERATIONS

AUDIT_TRAIL

BACKGROUND_CORE_DUMP

BACKGROUND_DUMP_DEST

BACKUP_TAPE_IO_SLAVES

BITMAP_MERGE_AREA_SIZE

BLANK_TRIMMING

BUFFER_POOL_KEEP

BUFFER_POOL_RECYCLE

CLUSTER_DATABASE

CLUSTER_DATABASE_INSTANCES

CLUSTER_INTERCONNECTS

COMMIT_POINT_STRENGTH

CONTROL_FILE_RECORD_KEEP_TIME

CONTROL_FILES

CORE_DUMP_DEST

CREATE_BITMAP_AREA_SIZE

CURSOR_SHARING

CURSOR_SPACE_FOR_TIME

DB_nK_CACHE_SIZE

DB_BLOCK_BUFFERS

DB_BLOCK_CHECKING

DB_BLOCK_CHECKSUM

DB_BLOCK_SIZE

DB_CACHE_ADVICE

DB_CACHE_SIZE

DB_CREATE_FILE_DEST

DB_CREATE_ONLINE_LOG_DEST_n

DB_FILE_MULTIBLOCK_READ_COUNT

DB_FILE_NAME_CONVERT

DB_KEEP_CACHE_SIZE

DB_RECYCLE_CACHE_SIZE

DB_WRITER_PROCESSES

DBLINK_ENCRYPT_LOGIN

DBWR_IO_SLAVES

DG_BROKER_CONFIG_FILEn

DG_BROKER_START

DISK_ASYNCH_IO

DISPATCHERS

DISTRIBUTED_LOCK_TIMEOUT

ENQUEUE_RESOURCES

FAST_START_IO_TARGET

FAST_START_MTTR_TARGET

FAST_START_PARALLEL_ROLLBACK

FILE_MAPPING

FILESYSTEMIO_OPTIONS

GC_FILES_TO_LOCKS

GLOBAL_CONTEXT_POOL_SIZE

GLOBAL_NAMES

HASH_AREA_SIZE

HASH_JOIN_ENABLED

HI_SHARED_MEMORY_ADDRESS

HS_AUTOREGISTER

INSTANCE_GROUPS

INSTANCE_NAME

INSTANCE_NUMBER

JAVA_MAX_SESSIONSPACE_SIZE

JAVA_POOL_SIZE

JAVA_SOFT_SESSIONSPACE_LIMIT

JOB_QUEUE_PROCESSES

LARGE_POOL_SIZE

LICENSE_MAX_SESSIONS

LICENSE_MAX_USERS

LICENSE_SESSIONS_WARNING

LOCAL_LISTENER

LOCK_NAME_SPACE

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_CHECKPOINT_INTERVAL

LOG_CHECKPOINT_TIMEOUT

LOG_CHECKPOINTS_TO_ALERT

LOG_FILE_NAME_CONVERT

LOG_PARALLELISM

LOGMNR_MAX_PERSISTENT_SESSIONS

MAX_COMMIT_PROPAGATION_DELAY

MAX_DISPATCHERS

MAX_DUMP_FILE_SIZE

MAX_ENABLED_ROLES

MAX_ROLLBACK_SEGMENTS

MAX_SHARED_SERVERS

NLS_CALENDAR

NLS_CURRENCY

NLS_DATE_FORMAT

NLS_DATE_LANGUAGE

NLS_DUAL_CURRENCY

NLS_ISO_CURRENCY

NLS_LANGUAGE

NLS_LENGTH_SEMANTICS

NLS_NCHAR_CONV_EXCP

NLS_NUMERIC_CHARACTERS

NLS_TERRITORY

NLS_TIMESTAMP_FORMAT

NLS_TIMESTAMP_TZ_FORMAT

O7_DICTIONARY_ACCESSIBILITY

OBJECT_CACHE_MAX_SIZE_PERCENT

OBJECT_CACHE_OPTIMAL_SIZE

OLAP_PAGE_POOL_SIZE

OPEN_CURSORS

OPEN_LINKS_PER_INSTANCE

OPTIMIZER_DYNAMIC_SAMPLING

OPTIMIZER_FEATURES_ENABLE

OPTIMIZER_INDEX_CACHING

OPTIMIZER_INDEX_COST_ADJ

OPTIMIZER_MAX_PERMUTATIONS

OPTIMIZER_MODE

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

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

PARTITION_VIEW_ENABLED

PGA_AGGREGATE_TARGET

PLSQL_COMPILER_FLAGS

PLSQL_NATIVE_C_COMPILER

PLSQL_NATIVE_LIBRARY_DIR

PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT

PLSQL_NATIVE_LINKER

PLSQL_NATIVE_MAKE_FILE_NAME

PLSQL_NATIVE_MAKE_UTILITY

PLSQL_V2_COMPATIBILITY

PRE_PAGE_SGA

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_LIMIT

RESOURCE_MANAGER_PLAN

ROLLBACK_SEGMENTS

ROW_LOCKING

SERIAL _REUSE

SERVICE_NAMES

SESSION_CACHED_CURSORS

SESSION_MAX_OPEN_FILES

SGA_MAX_SIZE

SHADOW_CORE_DUMP

SHARED_MEMORY_ADDRESS

SHARED_POOL_RESERVED_SIZE

SHARED_POOL_SIZE

SHARED_SERVER_SESSIONS

SHARED_SERVERS

SORT_AREA_RETAINED_SIZE

SORT_AREA_SIZE

SQL92_SECURITY

STANDBY_ARCHIVE_DEST

STANDBY_FILE_MANAGEMENT

STAR_TRANSFORMATION_ENABLED

STATISTICS_LEVEL

TAPE_ASYNCH_IO

TIMED_OS_STATISTICS

TIMED_STATISTICS

TRACE_ENABLED

TRACEFILE_IDENTIFIER

TRANSACTION_AUDITING

TRANSACTIONS

TRANSACTIONS_PER_ROLLBACK_SEGMENT

UNDO_MANAGEMENT

UNDO_RETENTION

UNDO_SUPPRESS_ERRORS

UNDO_TABLESPACE

USE_INDIRECT_DATA_BUFFERS

USER_DUMP_DEST

UTL_FILE_DIR

WORKAREA_SIZE_POLICY

2 Static Data Dictionary Views

ALL_ALL_TABLES

ALL_APPLY_CONFLICT_COLUMNS

ALL_APPLY_DML_HANDLERS

ALL_APPLY_ERROR

ALL_APPLY_KEY_COLUMNS

ALL_APPLY_PARAMETERS

ALL_APPLY_PROGRESS

ALL_ARGUMENTS

ALL_ASSOCIATIONS

ALL_AUDIT_POLICIES

ALL_BASE_TABLE_MVIEWS

ALL_CAPTURE

ALL_CAPTURE_PARAMETERS

ALL_CAPTURE_PREPARED_DATABASE

ALL_CAPTURE_PREPARED_SCHEMAS

ALL_CAPTURE_PREPARED_TABLES

ALL_CATALOG

ALL_CLUSTER_HASH_EXPRESSIONS

ALL_CLUSTERS

ALL_COL_COMMENTS

ALL_COL_PRIVS

ALL_COL_PRIVS_MADE

ALL_COL_PRIVS_RECD

ALL_COLL_TYPES

ALL_CONS_COLUMNS

ALL_CONS_OBJ_COLUMNS

ALL_CONSTRAINTS

ALL_CONTEXT

ALL_DB_LINKS

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_DIM_LEVELS

ALL_DIMENSIONS

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_SUBPARTITIONS

ALL_INDEXES

ALL_INDEXTYPE_COMMENTS

ALL_INDEXTYPE_OPERATORS

ALL_INDEXTYPES

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_LIBRARIES

ALL_LOB_PARTITIONS

ALL_LOB_SUBPARTITIONS

ALL_LOB_TEMPLATES

ALL_LOG_GROUP_COLUMNS

ALL_LOG_GROUPS

ALL_METHOD_PARAMS

ALL_METHOD_RESULTS

ALL_MVIEW_AGGREGATES

ALL_MVIEW_ANALYSIS

ALL_MVIEW_DETAIL_RELATIONS

ALL_MVIEW_JOINS

ALL_MVIEW_KEYS

ALL_MVIEW_LOGS

ALL_MVIEW_REFRESH_TIMES

ALL_NESTED_TABLES

ALL_OBJ_COLATTRS

ALL_OBJECT_TABLES

ALL_OBJECTS

ALL_OPANCILLARY

ALL_OPARGUMENTS

ALL_OPBINDINGS

ALL_OPERATOR_COMMENTS

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_PENDING_CONV_TABLES

ALL_POLICIES

ALL_POLICY_CONTEXTS

ALL_POLICY_GROUPS

ALL_PROCEDURES

ALL_PROPAGATION

ALL_PUBLISHED_COLUMNS

ALL_QUEUE_TABLES

ALL_REFRESH

ALL_REFRESH_CHILDREN

ALL_REFRESH_DEPENDENCIES

ALL_REGISTERED_MVIEWS

ALL_REGISTRY_BANNERS

ALL_RULE_SET_RULES

ALL_RULE_SETS

ALL_SEQUENCES

ALL_SOURCE_TABLES

ALL_SQLJ_TYPE_ATTRS

ALL_SQLJ_TYPE_METHODS

ALL_SQLJ_TYPES

ALL_STORED_SETTINGS

ALL_STREAMS_GLOBAL_RULES

ALL_STREAMS_SCHEMA_RULES

ALL_STREAMS_TABLE_RULES

ALL_SUBPART_COL_STATISTICS

ALL_SUBPART_HISTOGRAMS

ALL_SUBPART_KEY_COLUMNS

ALL_SUBPARTITION_TEMPLATES

ALL_SUBSCRIBED_COLUMNS

ALL_SUBSCRIBED_TABLES

ALL_SUBSCRIPTIONS

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_TRIGGER_COLS

ALL_TRIGGERS

ALL_TYPE_ATTRS

ALL_TYPE_METHODS

ALL_TYPE_VERSIONS

ALL_UNUSED_COL_TABS

ALL_UPDATABLE_COLUMNS

ALL_VARRAYS

ALL_XML_SCHEMAS

ALL_XML_TAB_COLS

ALL_XML_TABLES

ALL_XML_VIEW_COLS

ALL_XML_VIEWS

AUDIT_ACTIONS

CAT

CHAINED_ROWS

CHANGE_SOURCES

CHANGE_SETS

CHANGE_TABLES

CLU

CODE_PIECES

COL

COLS

COLUMN_PRIVILEGES

DATABASE_PROPERTIES

DBA_2PC_NEIGHBORS

DBA_2PC_PENDING

DBA_ALL_TABLES

DBA_APPLICATION_ROLES

DBA_APPLY_CONFLICT_COLUMNS

DBA_APPLY_DML_HANDLERS

DBA_APPLY_ERROR

DBA_APPLY_INSTANTIATED_OBJECTS

DBA_APPLY_KEY_COLUMNS

DBA_APPLY_PARAMETERS

DBA_APPLY_PROGRESS

DBA_AQ_AGENT_PRIVS

DBA_AQ_AGENTS

DBA_ASSOCIATIONS

DBA_ATTRIBUTE_TRANSFORMATIONS

DBA_AUDIT_EXISTS

DBA_AUDIT_OBJECT

DBA_AUDIT_POLICIES

DBA_AUDIT_SESSION

DBA_AUDIT_STATEMENT

DBA_AUDIT_TRAIL

DBA_BASE_TABLE_MVIEWS

DBA_BLOCKERS

DBA_CAPTURE

DBA_CAPTURE_PARAMETERS

DBA_CAPTURE_PREPARED_DATABASE

DBA_CAPTURE_PREPARED_SCHEMAS

DBA_CAPTURE_PREPARED_TABLES

DBA_CATALOG

DBA_CLU_COLUMNS

DBA_CLUSTER_HASH_EXPRESSIONS

DBA_CLUSTERS

DBA_COL_COMMENTS

DBA_COL_PRIVS

DBA_COLL_TYPES

DBA_CONS_COLUMNS

DBA_CONS_OBJ_COLUMNS

DBA_CONSTRAINTS

DBA_CONTEXT

DBA_DATA_FILES

DBA_DB_LINKS

DBA_DDL_LOCKS

DBA_DEPENDENCIES

DBA_DIM_ATTRIBUTES

DBA_DIM_CHILD_OF

DBA_DIM_HIERARCHIES

DBA_DIM_JOIN_KEY

DBA_DIM_LEVEL_KEY

DBA_DIM_LEVELS

DBA_DIMENSIONS

DBA_DIRECTORIES

DBA_DML_LOCKS

DBA_DMT_FREE_SPACE

DBA_DMT_USED_EXTENTS

DBA_EVALUATION_CONTEXT_TABLES

DBA_EVALUATION_CONTEXT_VARS

DBA_EVALUATION_CONTEXTS

DBA_EXP_FILES

DBA_EXP_OBJECTS

DBA_EXP_VERSION

DBA_EXTENTS

DBA_EXTERNAL_LOCATIONS

DBA_EXTERNAL_TABLES

DBA_FGA_AUDIT_TRAIL

DBA_FREE_SPACE

DBA_FREE_SPACE_COALESCED

DBA_IND_COLUMNS

DBA_IND_EXPRESSIONS

DBA_IND_PARTITIONS

DBA_IND_SUBPARTITIONS

DBA_INDEXES

DBA_INDEXTYPE_COMMENTS

DBA_INDEXTYPE_OPERATORS

DBA_INDEXTYPES

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_KGLLOCK

DBA_LIBRARIES

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_LOG_GROUPS

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_DETAIL_RELATIONS

DBA_MVIEW_JOINS

DBA_MVIEW_KEYS

DBA_MVIEW_LOG_FILTER_COLS

DBA_MVIEW_LOGS

DBA_MVIEW_REFRESH_TIMES

DBA_NESTED_TABLES

DBA_OBJ_AUDIT_OPTS

DBA_OBJ_COLATTRS

DBA_OBJECT_SIZE

DBA_OBJECT_TABLES

DBA_OBJECTS

DBA_OPANCILLARY

DBA_OPARGUMENTS

DBA_OPBINDINGS

DBA_OPERATOR_COMMENTS

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_CONV_TABLES

DBA_PENDING_TRANSACTIONS

DBA_POLICIES

DBA_POLICY_CONTEXTS

DBA_POLICY_GROUPS

DBA_PRIV_AUDIT_OPTS

DBA_PROCEDURES

DBA_PROFILES

DBA_PROPAGATION

DBA_PROXIES

DBA_PUBLISHED_COLUMNS

DBA_QUEUE_SCHEDULES

DBA_QUEUE_TABLES

DBA_REFRESH

DBA_REFRESH_CHILDREN

DBA_REGISTERED_MVIEW_GROUPS

DBA_REGISTERED_MVIEWS

DBA_REGISTRY

DBA_REGISTRY_HIERARCHY

DBA_REPAIR_TABLE

DBA_RESUMABLE

DBA_ROLE_PRIVS

DBA_ROLLBACK_SEGS

DBA_RSRC_CONSUMER_GROUP_PRIVS

DBA_RSRC_CONSUMER_GROUPS

DBA_RSRC_MANAGER_SYSTEM_PRIVS

DBA_RSRC_PLAN_DIRECTIVES

DBA_RSRC_PLANS

DBA_RULE_SET_RULES

DBA_RULE_SETS

DBA_SEGMENTS

DBA_SEQUENCES

DBA_SOURCE_TABLES

DBA_SQLJ_TYPE_ATTRS

DBA_SQLJ_TYPE_METHODS

DBA_SQLJ_TYPES

DBA_STMT_AUDIT_OPTS

DBA_STORED_SETTINGS

DBA_STREAMS_GLOBAL_RULES

DBA_STREAMS_SCHEMA_RULES

DBA_STREAMS_TABLE_RULES

DBA_SUBPART_COL_STATISTICS

DBA_SUBPART_HISTOGRAMS

DBA_SUBPART_KEY_COLUMNS

DBA_SUBPARTITION_TEMPLATES

DBA_SUBSCRIBED_COLUMNS

DBA_SUBSCRIBED_TABLES

DBA_SUBSCRIPTIONS

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_TABLESPACES

DBA_TEMP_FILES

DBA_TRANSFORMATIONS

DBA_TRIGGER_COLS

DBA_TRIGGERS

DBA_TS_QUOTAS

DBA_TYPE_ATTRS

DBA_TYPE_METHODS

DBA_TYPE_VERSIONS

DBA_UNDO_EXTENTS

DBA_UNUSED_COL_TABS

DBA_UPDATABLE_COLUMNS

DBA_VARRAYS

DBA_WAITERS

DBA_XML_SCHEMAS

DBA_XML_TAB_COLS

DBA_XML_TABLES

DBA_XML_VIEW_COLS

DBA_XML_VIEWS

DBMS_ALERT_INFO

DBMS_LOCK_ALLOCATED

DICT

DICT_COLUMNS

GLOBAL_NAME

HS_ALL_CAPS

HS_ALL_INITS

HS_BASE_CAPS

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_INIT

IND

INDEX_HISTOGRAM

INDEX_STATS

NLS_DATABASE_PARAMETERS

NLS_INSTANCE_PARAMETERS

NLS_SESSION_PARAMETERS

OBJ

PARSED_PIECES

PARSED_SIZE

PLUGGABLE_SET_CHECK

PRODUCT_COMPONENT_VERSION

PROXY_USERS

PUBLIC_DEPENDENCY

QUEUE_PRIVILEGES

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

SYSTEM_PRIVILEGE_MAP

SYS_OBJECTS

TAB

TABLE_PRIVILEGE_MAP

TABLE_PRIVILEGES

TABS

TRUSTED_SERVERS

TS_PITR_CHECK

TS_PITR_OBJECTS_TO_BE_DROPPED

UNI_PLUGGABLE_SET_CHECK

USER_ALL_TABLES

USER_AQ_AGENT_PRIVS

USER_ARGUMENTS

USER_ASSOCIATIONS

USER_ATTRIBUTE_TRANSFORMATIONS

USER_AUDIT_OBJECT

USER_AUDIT_POLICIES

USER_AUDIT_SESSION

USER_AUDIT_STATEMENT

USER_AUDIT_TRAIL

USER_BASE_TABLE_MVIEWS

USER_CATALOG

USER_CLU_COLUMNS

USER_CLUSTER_HASH_EXPRESSIONS

USER_CLUSTERS

USER_COL_COMMENTS

USER_COL_PRIVS

USER_COL_PRIVS_MADE

USER_COL_PRIVS_RECD

USER_COLL_TYPES

USER_CONS_COLUMNS

USER_CONS_OBJ_COLUMNS

USER_CONSTRAINTS

USER_DB_LINKS

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_ERRORS

USER_EVALUATION_CONTEXT_TABLES

USER_EVALUATION_CONTEXT_VARS

USER_EVALUATION_CONTEXTS

USER_EXTENTS

USER_EXTERNAL_LOCATIONS

USER_EXTERNAL_TABLES

USER_FREE_SPACE

USER_IND_COLUMNS

USER_IND_EXPRESSIONS

USER_IND_PARTITIONS

USER_IND_SUBPARTITIONS

USER_INDEXES

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_LIBRARIES

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_DETAIL_RELATIONS

USER_MVIEW_JOINS

USER_MVIEW_KEYS

USER_MVIEW_LOGS

USER_MVIEW_REFRESH_TIMES

USER_MVIEWS

USER_NESTED_TABLES

USER_OBJ_AUDIT_OPTS

USER_OBJ_COLATTRS

USER_OBJECT_SIZE

USER_OBJECT_TABLES

USER_OBJECTS

USER_OPANCILLARY

USER_OPARGUMENTS

USER_OPBINDINGS

USER_OPERATOR_COMMENTS

USER_OPERATORS

USER_OUTLINE_HINTS

USER_OUTLINES

USER_PART_COL_STATISTICS

USER_PART_HISTOGRAMS

USER_PART_INDEXES

USER_PART_KEY_COLUMNS

USER_PART_LOBS

USER_PART_TABLES

USER_PARTIAL_DROP_TABS

USER_PASSWORD_LIMITS

USER_PENDING_CONV_TABLES

USER_POLICIES

USER_POLICY_CONTEXTS

USER_POLICY_GROUPS

USER_PROCEDURES

USER_PROXIES

USER_PUBLISHED_COLUMNS

USER_QUEUE_SCHEDULES

USER_QUEUE_TABLES

USER_QUEUES

USER_REFRESH

USER_REFRESH_CHILDREN

USER_REGISTERED_MVIEWS

USER_REGISTRY

USER_RESOURCE_LIMITS

USER_RESUMABLE

USER_ROLE_PRIVS

USER_RSRC_CONSUMER_GROUP_PRIVS

USER_RSRC_MANAGER_SYSTEM_PRIVS

USER_RULE_SET_RULES

USER_RULE_SETS

USER_SEGMENTS

USER_SEQUENCES

USER_SOURCE

USER_SOURCE_TABLES

USER_SQLJ_TYPE_ATTRS

USER_SQLJ_TYPE_METHODS

USER_SQLJ_TYPES

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_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_TRANSFORMATIONS

USER_TRIGGER_COLS

USER_TRIGGERS

USER_TS_QUOTAS

USER_TYPE_ATTRS

USER_TYPE_METHODS

USER_TYPE_VERSIONS

USER_UNUSED_COL_TABS

USER_UPDATABLE_COLUMNS

USER_USTATS

USER_VARRAYS

USER_XML_SCHEMAS

USER_XML_TAB_COLS

USER_XML_TABLES

USER_XML_VIEW_COLS

USER_XML_VIEWS

3 Dynamic Performance (V$) Views

About Dynamic Performance Views

V$ACTIVE_INSTANCES

V$ACTIVE_SESS_POOL_MTH

V$AQ

V$ARCHIVE_DEST

V$ARCHIVE_DEST_STATUS

V$ARCHIVE_GAP

V$ARCHIVE_PROCESSES

V$ARCHIVED_LOG

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

V$BUFFER_POOL_STATISTICS

V$CACHE_LOCK

V$CACHE_TRANSFER

V$CLASS_CACHE_TRANSFER

V$COMPATIBILITY

V$COMPATSEG

V$CONTROLFILE

V$CONTROLFILE_RECORD_SECTION

V$COPY_CORRUPTION

V$CR_BLOCK_SERVER

V$DATABASE_BLOCK_CORRUPTION

V$DATABASE_INCARNATION

V$DATAFILE_COPY

V$DATAFILE_HEADER

V$DATAGUARD_STATUS

V$DB_CACHE_ADVICE

V$DB_OBJECT_CACHE

V$DELETED_OBJECT

V$DISPATCHER

V$DISPATCHER_RATE

V$ENABLEDPRIVS

V$ENQUEUE_LOCK

V$ENQUEUE_STAT

V$EVENT_NAME

V$EXECUTION

V$FALSE_PING

V$FAST_START_SERVERS

V$FAST_START_TRANSACTIONS

V$FILE_CACHE_TRANSFER

V$FIXED_TABLE

V$FIXED_VIEW_DEFINITION

V$GC_ELEMENT

V$GC_ELEMENTS_WITH_COLLISIONS

V$GCSHVMASTER_INFO

V$GCSPFMASTER_INFO

V$GES_BLOCKING_ENQUEUE

V$GES_CONVERT_LOCAL

V$GES_CONVERT_REMOTE

V$GES_ENQUEUE

V$GES_LATCH

V$GES_RESOURCE

V$GES_STATISTICS

V$GLOBAL_BLOCKED_LOCKS

V$GLOBAL_TRANSACTION

V$HS_PARAMETER

V$HS_SESSION

V$HVMASTER_INFO

V$INDEXED_FIXED_COLUMN

V$INSTANCE_RECOVERY

V$LATCH_CHILDREN

V$LATCH_MISSES

V$LATCH_PARENT

V$LATCHHOLDER

V$LATCHNAME

V$LIBRARY_CACHE_MEMORY

V$LIBRARYCACHE

V$LOADISTAT

V$LOADPSTAT

V$LOCK_ACTIVITY

V$LOCKED_OBJECT

V$LOG_HISTORY

V$LOGMNR_CONTENTS

V$LOGMNR_DICTIONARY

V$LOGMNR_LOGS

V$LOGMNR_PARAMETERS

V$LOGSTDBY_STATS

V$MANAGED_STANDBY

V$MAP_COMP_LIST

V$MAP_ELEMENT

V$MAP_EXT_ELEMENT

V$MAP_FILE_EXTENT

V$MAP_FILE_IO_STACK

V$MAP_LIBRARY

V$MAP_SUBELEMENT

V$MTTR_TARGET_ADVICE

V$NLS_PARAMETERS

V$NLS_VALID_VALUES

V$OBJECT_DEPENDENCY

V$OBJECT_USAGE

V$OBSOLETE_PARAMETER

V$OFFLINE_RANGE

V$OPEN_CURSOR

V$PARALLEL_DEGREE_LIMIT_MTH

V$PARAMETER

V$PARAMETER2

V$PGA_TARGET_ADVICE

V$PGA_TARGET_ADVICE_HISTOGRAM

V$PQ_SESSTAT

V$PQ_SYSSTAT

V$PQ_TQSTAT

V$PROXY_ARCHIVEDLOG

V$PROXY_DATAFILE

V$PWFILE_USERS

V$PX_PROCESS

V$PX_PROCESS_SYSSTAT

V$PX_SESSION

V$PX_SESSTAT

V$QUEUEING_MTH

V$RECOVER_FILE

V$RECOVERY_FILE_STATUS

V$RECOVERY_LOG

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

V$RSRC_PLAN_CPU_MTH

V$SEGMENT_STATISTICS

V$SEGSTAT_NAME

V$SESSION_CONNECT_INFO

V$SESSION_CURSOR_CACHE

V$SESSION_EVENT

V$SESSION_LONGOPS

V$SESSION_OBJECT_CACHE

V$SESSION_WAIT

V$SGA_CURRENT_RESIZE_OPS

V$SGA_RESIZE_OPS

V$SGA_DYNAMIC_COMPONENTS

V$SGA_DYNAMIC_FREE_MEMORY

V$SHARED_POOL_ADVICE

V$SHARED_POOL_RESERVED

V$SHARED_SERVER

V$SHARED_SERVER_MONITOR

V$SORT_SEGMENT

V$SPPARAMETER

V$SQL_BIND_DATA

V$SQL_BIND_METADATA

V$SQL_CURSOR

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

V$STANDBY_LOG

V$STATISTICS_LEVEL

V$STREAMS_APPLY_COORDINATOR

V$STREAMS_APPLY_READER

V$STREAMS_APPLY_SERVER

V$STREAMS_CAPTURE

V$SYSTEM_CURSOR_CACHE

V$SYSTEM_EVENT

V$SYSTEM_PARAMETER

V$SYSTEM_PARAMETER2

V$TABLESPACE

V$TEMP_CACHE_TRANSFER

V$TEMP_EXTENT_MAP

V$TEMP_EXTENT_POOL

V$TEMP_SPACE_HEADER

V$TEMPORARY_LOBS

V$TEMPSEG_USAGE

V$TIMEZONE_NAMES

V$TRANSACTION

V$TRANSACTION_ENQUEUE

V$TYPE_SIZE

V$VPD_POLICY

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

Database Migration Scripts

Java Scripts

A 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

parallel execution create server

parallel execution dequeue wait

parallel execution qref latch

parallel execution server shutdown

parallel execution signal server

pending global transaction(s)

PL/SQL lock timer

pmon rdomain attach

process startup

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

B Oracle Enqueue Names

C Statistics Descriptions

Displaying Statistics

Statistics Descriptions

Index