Oracle8i Reference
Release 8.1.5

A67790-01

Library

Product

Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Initialization Parameters

Initialization Parameter File
Specifying Values in the Parameter File
Rules
Using Special Characters in Parameter Values
Changing Parameter Values
Displaying Current Parameter Values
Uses of Parameters
Types of Parameters
Parameters You Should Not Specify in the Parameter File
When Parameters Are Set Incorrectly
Reading the Parameter Descriptions
PARAMETER_NAME
Parameter Descriptions
O7_DICTIONARY_ACCESSIBILITY
ALLOW_PARTIAL_SN_RESULTS
ALWAYS_ANTI_JOIN
ALWAYS_SEMI_JOIN
AQ_TM_PROCESSES
ARCH_IO_SLAVES
AUDIT_FILE_DEST
AUDIT_TRAIL
B_TREE_BITMAP_PLANS
BACKGROUND_CORE_DUMP
BACKGROUND_DUMP_DEST
BACKUP_DISK_IO_SLAVES
BACKUP_TAPE_IO_SLAVES
BITMAP_MERGE_AREA_SIZE
BLANK_TRIMMING
BUFFER_POOL_KEEP
BUFFER_POOL_RECYCLE
CACHE_SIZE_THRESHOLD
CCF_IO_SIZE
CLEANUP_ROLLBACK_ENTRIES
CLOSE_CACHED_OPEN_CURSORS
COMMIT_POINT_STRENGTH
COMPATIBLE
COMPATIBLE_NO_RECOVERY
COMPLEX_VIEW_MERGING
CONTROL_FILE_RECORD_KEEP_TIME
CONTROL_FILES
CORE_DUMP_DEST
CPU_COUNT
CREATE_BITMAP_AREA_SIZE
CURSOR_SPACE_FOR_TIME
DB_BLOCK_BUFFERS
DB_BLOCK_CHECKPOINT_BATCH
DB_BLOCK_CHECKING
DB_BLOCK_CHECKSUM
DB_BLOCK_LRU_EXTENDED_STATISTICS
DB_BLOCK_LRU_LATCHES
DB_BLOCK_LRU_STATISTICS
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_FILE_SIMULTANEOUS_WRITES
DB_FILES
DB_NAME
DB_WRITER_PROCESSES
DBLINK_ENCRYPT_LOGIN
DBWR_IO_SLAVES
DELAYED_LOGGING_BLOCK_CLEANOUTS
DISCRETE_TRANSACTIONS_ENABLED
DISK_ASYNCH_IO
DISTRIBUTED_LOCK_TIMEOUT
DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME
DISTRIBUTED_TRANSACTIONS
DML_LOCKS
ENQUEUE_RESOURCES
ENT_DOMAIN_NAME
EVENT
FAST_FULL_SCAN_ENABLED
FAST_START_IO_TARGET
FAST_START_PARALLEL_ROLLBACK
FIXED_DATE
FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY
GC_DEFER_TIME
GC_FILES_TO_LOCKS
GC_LATCHES
GC_LCK_PROCS
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_POOL_SIZE
JOB_QUEUE_INTERVAL
JOB_QUEUE_PROCESSES
LARGE_POOL_MIN_ALLOC
LARGE_POOL_SIZE
LGWR_IO_SLAVES
LICENSE_MAX_SESSIONS
LICENSE_MAX_USERS
LICENSE_SESSIONS_WARNING
LM_LOCKS
LM_PROCS
LM_RESS
LOCAL_LISTENER
LOCK_NAME_SPACE
LOCK_SGA
LOCK_SGA_AREAS
LOG_ARCHIVE_BUFFER_SIZE
LOG_ARCHIVE_BUFFERS
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_BLOCK_CHECKSUM
LOG_BUFFER
LOG_CHECKPOINT_INTERVAL
LOG_CHECKPOINT_TIMEOUT
LOG_CHECKPOINTS_TO_ALERT
LOG_FILE_NAME_CONVERT
LOG_FILES
LOG_SIMULTANEOUS_COPIES
LOG_SMALL_ENTRY_MAX_SIZE
MAX_COMMIT_PROPAGATION_DELAY
MAX_DUMP_FILE_SIZE
MAX_ENABLED_ROLES
MAX_ROLLBACK_SEGMENTS
MAX_TRANSACTION_BRANCHES
MTS_DISPATCHERS
MTS_LISTENER_ADDRESS
MTS_MAX_DISPATCHERS
MTS_MAX_SERVERS
MTS_MULTIPLE_LISTENERS
MTS_RATE_LOG_SIZE
MTS_RATE_SCALE
MTS_SERVERS
MTS_SERVICE
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
OBJECT_CACHE_MAX_SIZE_PERCENT
OBJECT_CACHE_OPTIMAL_SIZE
OGMS_HOME
OPEN_CURSORS
OPEN_LINKS
OPEN_LINKS_PER_INSTANCE
OPS_ADMIN_GROUP
OPTIMIZER_FEATURES_ENABLE
OPTIMIZER_INDEX_CACHING
OPTIMIZER_INDEX_COST_ADJ
OPTIMIZER_MAX_PERMUTATIONS
OPTIMIZER_MODE
OPTIMIZER_PERCENT_PARALLEL
OPTIMIZER_SEARCH_LIMIT
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_DEFAULT_MAX_INSTANCES
PARALLEL_EXECUTION_MESSAGE_SIZE
PARALLEL_INSTANCE_GROUP
PARALLEL_MAX_SERVERS
PARALLEL_MIN_MESSAGE_POOL
PARALLEL_MIN_PERCENT
PARALLEL_MIN_SERVERS
PARALLEL_SERVER
PARALLEL_SERVER_IDLE_TIME
PARALLEL_SERVER_INSTANCES
PARALLEL_THREADS_PER_CPU
PARALLEL_TRANSACTION_RESOURCE_TIMEOUT
PARTITION_VIEW_ENABLED
PLSQL_V2_COMPATIBILITY
PRE_PAGE_SGA
PROCESSES
PUSH_JOIN_PREDICATE
QUERY_REWRITE_ENABLED
QUERY_REWRITE_INTEGRITY
RDBMS_SERVER_DN
READ_ONLY_OPEN_DELAYED
RECOVERY_PARALLELISM
REDUCE_ALARM
REMOTE_DEPENDENCIES_MODE
REMOTE_LOGIN_PASSWORDFILE
REMOTE_OS_AUTHENT
REMOTE_OS_ROLES
REPLICATION_DEPENDENCY_TRACKING
RESOURCE_LIMIT
RESOURCE_MANAGER_PLAN
ROLLBACK_SEGMENTS
ROW_CACHE_CURSORS
ROW_LOCKING
SEQUENCE_CACHE_ENTRIES
SEQUENCE_CACHE_HASH_BUCKETS
SERIAL _REUSE
SERVICE_NAMES
SESSION_CACHED_CURSORS
SESSION_MAX_OPEN_FILES
SESSIONS
SHADOW_CORE_DUMP
SHARED_MEMORY_ADDRESS
SHARED_POOL_RESERVED_MIN_ALLOC
SHARED_POOL_RESERVED_SIZE
SHARED_POOL_SIZE
SORT_AREA_RETAINED_SIZE
SORT_AREA_SIZE
SORT_DIRECT_WRITES
SORT_MULTIBLOCK_READ_COUNT
SORT_READ_FAC
SORT_SPACEMAP_SIZE
SORT_WRITE_BUFFER_SIZE
SORT_WRITE_BUFFERS
SPIN_COUNT
SQL92_SECURITY
SQL_TRACE
STANDBY_ARCHIVE_DEST
STAR_TRANSFORMATION_ENABLED
TAPE_ASYNCH_IO
TEMPORARY_TABLE_LOCKS
THREAD
TIMED_OS_STATISTICS
TIMED_STATISTICS
TRANSACTION_AUDITING
TRANSACTIONS
TRANSACTIONS_PER_ROLLBACK_SEGMENT
USE_INDIRECT_DATA_BUFFERS
USE_ISM
USER_DUMP_DEST
UTL_FILE_DIR

2 Static Data Dictionary Views

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_JOBS
ALL_LABELS
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_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_QUEUES
ALL_REFRESH
ALL_REFRESH_CHILDREN
ALL_REFRESH_DEPENDENCIES
ALL_REFS
ALL_REGISTERED_SNAPSHOTS
ALL_REPCATLOG
ALL_REPCOLUMN
ALL_REPCOLUMN_GROUP
ALL_REPCONFLICT
ALL_REPDDL
ALL_REPGENERATED
ALL_REPGENOBJECTS
ALL_REPGROUP
ALL_REPGROUPED_COLUMN
ALL_REPKEY_COLUMNS
ALL_REPOBJECT
ALL_REPPARAMETER_COLUMN
ALL_REPPRIORITY
ALL_REPPRIORITY_GROUP
ALL_REPPROP
ALL_REPRESOLUTION
ALL_REPRESOL_STATS_CONTROL
ALL_REPRESOLUTION_METHOD
ALL_REPRESOLUTION_STATISTICS
ALL_REPSITES
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_SUMMARIES
ALL_SYNONYMS
ALL_TAB_COL_STATISTICS
ALL_TAB_COLUMNS
ALL_TAB_COMMENTS
ALL_TAB_HISTOGRAMS
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_CONSTRAINTS
DBA_CONS_COLUMNS
DBA_CONTEXT
DBA_DATA_FILES
DBA_DB_LINKS
DBA_DDL_LOCKS
DBA_DEPENDENCIES
DBA_DIMENSIONS
DBA_DIM_ATTRIBUTES
DBA_DIM_CHILD_OF
DBA_DIM_JOIN_KEY
DBA_DIM_HIERARCHIES
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_INDEXES
DBA_IND_COLUMNS
DBA_IND_EXPRESSIONS
DBA_IND_PARTITIONS
DBA_IND_SUBPARTITIONS
DBA_INDEXTYPES
DBA_INDEXTYPE_OPERATORS
DBA_JOBS
DBA_JOBS_RUNNING
DBA_LIBRARIES
DBA_LOBS
DBA_LOB_PARTITIONS
DBA_LOB_SUBPARTITIONS
DBA_LOCKS
DBA_LOCK_INTERNAL
DBA_METHOD_PARAMS
DBA_METHOD_RESULTS
DBA_MVIEW_AGGREGATES
DBA_MVIEW_ANALYSIS
DBA_MVIEW_DETAIL_RELATIONS
DBA_MVIEW_JOINS
DBA_MVIEW_KEYS
DBA_NESTED_TABLES
DBA_OBJECT_SIZE
DBA_OBJECT_TABLES
DBA_OBJECTS
DBA_OBJ_AUDIT_OPTS
DBA_OPANCILLARY
DBA_OPARGUMENTS
DBA_OPBINDINGS
DBA_OPERATORS
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_REPCATLOG
DBA_REPCAT_REFRESH_TEMPLATES
DBA_REPCAT_TEMPLATE_OBJECTS
DBA_REPCAT_TEMPLATE_PARMS
DBA_REPCAT_TEMPLATE_SITES
DBA_REPCAT_USER_AUTHORIZATIONS
DBA_REPCAT_USER_PARM_VALUES
DBA_REPCOLUMN
DBA_REPCOLUMN_GROUP
DBA_REPCONFLICT
DBA_REPDDL
DBA_REPGENERATED
DBA_REPGENOBJECTS
DBA_REPGROUP
DBA_REPGROUPED_COLUMN
DBA_REPKEY_COLUMNS
DBA_REPOBJECT
DBA_REPPARAMETER_COLUMN
DBA_REPPRIORITY
DBA_REPPRIORITY_GROUP
DBA_REPPROP
DBA_REPRESOLUTION
DBA_REPRESOLUTION_METHOD
DBA_REPRESOL_STATS_CONTROL
DBA_REPSITES
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_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
DEFCALL
DEFCALLDEST
DEFDEFAULTDEST
DEFERRCOUNT
DEFERROR
DEFLOB
DEFPROPAGATOR
DEFSCHEDULE
DEFTRAN
DEFTRANDEST
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
ORPHAN_KEY_TABLE
PARSED_PIECES
PARSED_SIZE
PLAN_TABLE
PLUGGABLE_SET_CHECK
PRODUCT_COMPONENT_VERSION
PROXY_USERS
PSTUBTBL
PUBLICSYN
PUBLIC_DEPENDENCY
QUEUE_PRIVILEGES
RC
REPAIR_TABLE
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_CLUSTERS
USER_CLUSTER_HASH_EXPRESSIONS
USER_CLU_COLUMNS
USER_COL_COMMENTS
USER_COL_PRIVS
USER_COL_PRIVS_MADE
USER_COL_PRIVS_RECD
USER_COLL_TYPES
USER_CONSTRAINTS
USER_CONS_COLUMNS
USER_DB_LINKS
USER_DEPENDENCIES
USER_DIMENSIONS
USER_DIM_ATTRIBUTES
USER_DIM_CHILD_OF
USER_DIM_JOIN_KEY
USER_DIM_HIERARCHIES
USER_DIM_LEVELS
USER_DIM_LEVEL_KEY
USER_ERRORS
USER_EXTENTS
USER_FREE_SPACE
USER_INDEXES
USER_IND_COLUMNS
USER_IND_EXPRESSIONS
USER_IND_PARTITIONS
USER_IND_SUBPARTITIONS
USER_INDEXTYPES
USER_INDEXTYPE_OPERATORS
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_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_REPCATLOG
USER_REPCOLUMN
USER_REPCOLUMN_GROUP
USER_REPCONFLICT
USER_REPDDL
USER_REPGENERATED
USER_REPGENOBJECTS
USER_REPGROUP
USER_REPGROUPED_COLUMN
USER_REPKEY_COLUMNS
USER_REPOBJECT
USER_REPPARAMETER_COLUMN
USER_REPPRIORITY
USER_REPPRIORITY_GROUP
USER_REPPROP
USER_REPRESOLUTION
USER_REPRESOL_STATS_CONTROL
USER_REPRESOLUTION_METHOD
USER_REPRESOLUTION_STATISTICS
USER_REPSITES
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_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

Dynamic Performance Views
V$ Views
GV$ Views
Access to the Dynamic Performance Tables
View Descriptions
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$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_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$MLS_PARAMETERS
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

Database Limits

5 SQL Scripts

Creating the Data Dictionary
Creating Additional Data Dictionary Structures
The"NO" Scripts
Migration Scripts

A Oracle Wait Events

Displaying Wait Events
Wait Events and Parameters
Parameter Descriptions
block#
blocks
break?
class
dba
driver id
file#
id1
id2
lenum
mode
name and type
namespace
requests
session#
waited
Wait Event Descriptions
BFILE check if exists
BFILE check if open
BFILE closure
BFILE get length
BFILE get name object
BFILE get path object
BFILE internal seek
BFILE open
BFILE read
DFS db file lock
DFS lock handle
PL/SQL lock timer
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
WMON goes to sleep
alter system set mts_dispatchers
batched allocate scn lock request
buffer busy waits
buffer deadlock
buffer for checkpoint
buffer latch
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
direct path read
direct path write
dispatcher shutdown
dispatcher timer
duplicate cluster key
enqueue
file identify
file open
free buffer waits
free global transaction table entry
free process state object
global cache freelist wait
global cache lock busy
global cache lock cleanup
global cache lock null to s
global cache lock null to x
global cache lock open null
global cache lock open s
global cache lock open x
global cache lock s to x
inactive session
inactive transaction branch
index block split
instance recovery
instance state change
io done
kcl bg acks
latch activity
latch free
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 file sync
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)
pipe get
pipe put
pmon rdomain attach
pmon timer
process startup
queue messages
rdbms ipc message
rdbms ipc message block
rdbms ipc reply
redo wait
row cache lock
scginq AST call
single-task message
smon timer
switch logfile command
timer in sksawat
transaction
unbound tx
undo segment extension
undo segment recovery
undo segment tx slot
virtual circuit status
write complete waits
writes stopped by instance recovery or database suspension

B Enqueue and Lock Names

Oracle Enqueue and Lock Names

C Statistics Descriptions

Displaying Statistics
Statistics Descriptions
CPU used by this session
CPU used when call started
CR blocks created
Cached Commit SCN referenced
Commit SCN referenced
Current blocks converted for CR
DBWR buffers scanned
DBWR checkpoint buffers written
DBWR checkpoints
DBWR forced writes
DBWR free buffers found
DBWR lru scans
DBWR make free requests
DBWR revisited being-written buffer
DBWR skip hot writes
DBWR summed scan depth
DBWR undo block writes
DDL statements parallelized
DML statements parallelized.
PX local messages recv'd
PX local messages sent
PX remote messages recv'd
PX remote messages sent
SQL*Net roundtrips to/from client
SQL*Net roundtrips to/from dblink
Switch current to new buffer
Unnecessary process cleanup for SCN batching
background checkpoints completed
background checkpoints started
bytes received via SQL*Net from client
bytes received via SQL*Net from dblink
bytes sent via SQL*Net to client
bytes sent via SQL*Net to dblink
calls to get snapshot scn: kcmgss
change write time
cleanouts and rollbacks - consistent read gets
cleanouts only - consistent read gets
cluster key scan block gets
cluster key scans
commit cleanout failures: block lost
commit cleanout failures: buffer being written
commit cleanout failures: callback failure
commit cleanout failures: cannot pin
commit cleanout failures: hot backup in progress
commit cleanout failures: write disabled
commit cleanouts
commit cleanouts successfully completed
consistent changes
consistent gets
data blocks consistent reads - undo records applied
db block changes
db block gets
deferred (CURRENT) block cleanout applications
dirty buffers inspected
enqueue conversions
enqueue deadlocks
enqueue releases
enqueue requests
enqueue timeouts
enqueue waits
exchange deadlocks
execute count
free buffer inspected
free buffer requested
global cache defers
global cache freelist waits
global lock convert time
global lock converts (async)
global lock converts (non async)
global lock get time
global lock gets (async)
global lock gets (non async)
global lock releases
hot buffers moved to head of LRU
immediate (CR) block cleanout applications
immediate (CURRENT) block cleanout applications
kcmccs called get current scn
kcmccs read scn without going to DLM
kcmgss waited for batching
logons cumulative
logons current
native hash arithmetic execute
native hash arithmetic fail
next scns gotten without going to DLM
no work - consistent read gets
opened cursors cumulative
opened cursors current
opens of replaced files
opens requiring cache replacement
parse count (hard)
parse count (total)
parse time cpu
parse time elapsed
physical reads
physical reads direct
physical writes
physical writes direct
physical writes non-checkpoint
pinned buffers inspected
queries parallelized
recovery array read time
recovery array reads
recovery blocks read
recursive calls
recursive cpu usage
redo entries
redo log space requests
redo log space wait time
redo log switch interrupts
redo ordering marks
redo size
redo synch time
redo sync writes
redo wastage
redo write time
redo writer latching time
redo writes
remote instance undo block writes
remote instance undo header writes
rollback changes - undo records applied
rollbacks only - consistent read gets
serializable aborts
session connect time
session cursor cache count
session cursor cache hits
session logical reads
session pga memory
session pga memory max
session stored procedure space
session uga memory
session uga memory max
sorts (disk)
sorts (memory)
sorts (rows)
summed dirty queue length
table fetch by rowid
table fetch continued row
table scan blocks gotten
table scan rows gotten
table scans (cache partitions)
table scans (direct read)
table scans (long tables)
table scans (rowid ranges)
table scans (short tables)
total file opens
transaction rollbacks
transaction tables consistent read rollbacks
transaction tables consistent reads - undo records applied
user calls
user commits
user rollbacks

Index



Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Index