Oracle8
i
Reference
Release 2 (8.1.6)
Part Number A76961-01
Library
Product
Index
Updated information for Release 8.1.7 can be found in the
Oracle8i Documentation Addendum.
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