Oracle8 Server Reference
Release 8.0
A54645_01

Library

Product

Index


Next

Contents

Title and Copyright Information

Preface

Audience
Knowledge Assumed of the Reader
Installation and Migration Information
Information Database Administration
Application Design Information
How Oracle8 Server Reference Is Organized
Conventions Used in This Manual
Text of the Manual
Examples of Commands and Statements
Your Comments Are Welcome

Chapter 1 Initialization Parameters

Initialization Parameter File
Specifying Values in the Parameter File
Rules
Using Special Characters in Parameter Values
Using the Escape Character
Using Quotes
Changing Parameter Values
Dynamic Parameters
Displaying Current Parameter Values
Uses of Parameters
Types of Parameters
Derived Parameters
Global Cache Parameters with Prefix GC
Operating System-Dependent Parameters
Variable Parameters
Heterogeneous Services 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
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
CACHE_SIZE_THRESHOLD
CLEANUP_ROLLBACK_ENTRIES
CLOSE_CACHED_OPEN_CURSORS
COMMIT_POINT_STRENGTH
COMPATIBLE
COMPATIBLE_NO_RECOVERY
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_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_FILES
DB_FILE_DIRECT_IO_COUNT
DB_FILE_MULTIBLOCK_READ_COUNT
DB_FILE_NAME_CONVERT
DB_FILE_SIMULTANEOUS_WRITES
DB_NAME
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
PDML Restrictions
ENQUEUE_RESOURCES
EVENT
FIXED_DATE
FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY
GC_DEFER_TIME
GC_FILES_TO_LOCK
GC_LCK_PROCS
GC_RELEASABLE_LOCKS
GC_ROLLBACK_LOCKS
GLOBAL_NAMES
HASH_AREA_SIZE
HASH_MULTIBLOCK_IO_COUNT
IFILE
INSTANCE_GROUPS
INSTANCE_NUMBER
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
LOG_ARCHIVE_BUFFER_SIZE
LOG_ARCHIVE_BUFFERS
LOG_ARCHIVE_DEST
LOG_ARCHIVE_DUPLEX_DEST
LOG_ARCHIVE_FORMAT
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_CURRENCY
NLS_DATE_FORMAT
NLS_DATE_LANGUAGE
NLS_ISO_CURRENCY
NLS_LANGUAGE
NLS_NUMERIC_CHARACTERS
NLS_SORT
NLS_TERRITORY
OBJECT_CACHE_MAX_SIZE_PERCENT
OBJECT_CACHE_OPTIMAL_SIZE
OPEN_CURSORS
OPEN_LINKS
OPEN_LINKS_PER_INSTANCE
OPS_ADMIN_GROUP
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_DEFAULT_MAX_INSTANCES
PARALLEL_INSTANCE_GROUP
PARALLEL_MAX_SERVERS
PARALLEL_MIN_MESSAGE_POOL
PARALLEL_MIN_PERCENT
PARALLEL_MIN_SERVERS
PARALLEL_SERVER
PARALLEL_SERVER_IDLE_TIME
PARALLEL_TRANSACTION_RESOURCE_TIMEOUT
PARTITION_VIEW_ENABLED
PLSQL_V2_COMPATIBILITY
PRE_PAGE_SGA
PROCESSES
RECOVERY_PARALLELISM
REDUCE_ALARM
REMOTE_DEPENDENCIES_MODE
REMOTE_LOGIN_PASSWORDFILE
REMOTE_OS_AUTHENT
REMOTE_OS_ROLES
REPLICATION_DEPENDENCY_TRACKING
RESOURCE_LIMIT
ROLLBACK_SEGMENTS
ROW_CACHE_CURSORS
ROW_LOCKING
SEQUENCE_CACHE_ENTRIES
SEQUENCE_CACHE_HASH_BUCKET
SERIAL _REUSE
SESSION_CACHED_CURSORS
SESSION_MAX_OPEN_FILES
SESSIONS
SHADOW_CORE_DUMP
SHARED_POOL_RESERVED_MIN_ALLOC
SHARED_POOL_RESERVED_SIZE
SHARED_POOL_SIZE
SORT_AREA_RETAINED_SIZE
SORT_AREA_SIZE
SORT_DIRECT_WRITES
SORT_READ_FAC
SORT_SPACEMAP_SIZE
SORT_WRITE_BUFFER_SIZE
SORT_WRITE_BUFFERS
SPIN_COUNT
SQL_TRACE
SQL92_SECURITY
STAR_TRANSFORMATION_ENABLED
TAPE_ASYNCH_IO
TEMPORARY_TABLE_LOCKS
THREAD
TIMED_OS_STATISTICS
TIMED_STATISTICS
TRANSACTION_AUDITING
TRANSACTIONS
TRANSACTIONS_PER_ROLLBACK_SEGMENT
USE_ISM
USER_DUMP_DEST
UTL_FILE_DIR

Chapter 2 Static Data Dictionary Views

Data Dictionary Views
ALL_ALL_TABLES
ALL_ARGUMENTS
ALL_CATALOG
ALL_CLUSTERS
ALL_COL_COMMENTS
ALL_COL_PRIVS
ALL_COL_PRIVS_MADE
ALL_COL_PRIVS_RECD
ALL_COLL_TYPES
ALL_CONS_COLUMNS
ALL_CONSTRAINTS
ALL_DB_LINKS
ALL_DEF_AUDIT_OPTS
ALL_DEPENDENCIES
ALL_DIRECTORIES
ALL_ERRORS
ALL_IND_COLUMNS
ALL_IND_PARTITIONS
ALL_INDEXES
ALL_LABELS
ALL_LIBRARIES
ALL_LOBS
ALL_METHOD_PARAMS
ALL_METHOD_RESULTS
ALL_NESTED_TABLES
ALL_OBJECT_TABLES
ALL_OBJECTS
ALL_PART_COL_STATISTICS
ALL_PART_HISTOGRAMS
ALL_PART_INDEXES
ALL_PART_KEY_COLUMNS
ALL_PART_TABLES
ALL_REFRESH
ALL_REFRESH_CHILDREN
ALL_REFS
ALL_REGISTERED_SNAPSHOTS
ALL_REPCATLOG
ALL_REPCOLUMN
ALL_REPCOLUMN_GROUP
ALL_REPCONFLICT
ALL_REPDDL
ALL_REPGENERATED
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_SNAPSHOTS
ALL_SOURCE
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_TABLES
ALL_TRIGGERS
ALL_TRIGGER_COLS
ALL_TYPE_ATTRS
ALL_TYPE_METHODS
ALL_TYPES
ALL_UPDATABLE_COLUMNS
ALL_USERS
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_AUDIT_EXISTS
DBA_AUDIT_OBJECT
DBA_AUDIT_SESSION
DBA_AUDIT_STATEMENT
DBA_AUDIT_TRAIL
DBA_BLOCKERS
DBA_CATALOG
DBA_CLU_COLUMNS
DBA_CLUSTERS
DBA_COL_COMMENTS
DBA_COL_PRIVS
DBA_COLL_TYPES
DBA_CONSTRAINTS
DBA_CONS_COLUMNS
DBA_DATA_FILES
DBA_DB_LINKS
DBA_DDL_LOCKS
DBA_DEPENDENCIES
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_PARTITIONS
DBA_JOBS
DBA_JOBS_RUNNING
DBA_LIBRARIES
DBA_LOBS
DBA_LOCKS
DBA_METHOD_PARAMS
DBA_METHOD_RESULTS
DBA_NESTED_TABLES
DBA_OBJECT_SIZE
DBA_OBJECT_TABLES
DBA_OBJECTS
DBA_OBJ_AUDIT_OPTS
DBA_PART_COL_STATISTICS
DBA_PART_HISTOGRAMS
DBA_PART_INDEXES
DBA_PART_KEY_COLUMNS
DBA_PART_TABLES
DBA_PRIV_AUDIT_OPTS
DBA_PROFILES
DBA_QUEUE_TABLES
DBA_QUEUES
DBA_RCHILD
DBA_REFRESH
DBA_REFRESH_CHILDREN
DBA_REFRESH_TIMES
DBA_REFS
DBA_REGISTERED_SNAPSHOT_GROUPS
DBA_REGISTERED_SNAPSHOTS
DBA_REPCATLOG
DBA_REPCOLUMN
DBA_REPCOLUMN_GROUP
DBA_REPCONFLICT
DBA_REPDDL
DBA_REPGENERATED
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_SEGMENTS
DBA_SEQUENCES
DBA_SNAPSHOT_LOGS
DBA_SNAPSHOTS
DBA_SOURCE
DBA_STMT_AUDIT_OPTS
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_TABLES
DBA_TABLESPACES
DBA_TRIGGERS
DBA_TRIGGER_COLS
DBA_TS_QUOTAS
DBA_TYPE_ATTRS
DBA_TYPE_METHODS
DBA_TYPES
DBA_UPDATABLE_COLUMNS
DBA_USERS
DBA_VIEWS
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
LOADER_CONSTRAINT_INFO
LOADER_FILE_TS
LOADER_PART_INFO
LOADER_PARAM_INFO
LOADER_TAB_INFO
LOADER_TRIGGER_INFO
NLS_DATABASE_PARAMETERS
NLS_INSTANCE_PARAMETERS
NLS_SESSION_PARAMETERS
OBJ
PARSED_PIECES
PARSED_SIZE
PLAN_TABLE
PRODUCT_COMPONENT_VERSION
PSTUBTBL
PUBLICSYN
PUBLIC_DEPENDENCY
RESOURCE_COST
RESOURCE_MAP
ROLE_ROLE_PRIVS
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS
SEQ
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
USER_ALL_TABLES
USER_ARGUMENTS
USER_AUDIT_OBJECT
USER_AUDIT_SESSION
USER_AUDIT_STATEMENT
USER_AUDIT_TRAIL
USER_CATALOG
USER_CLUSTERS
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_ERRORS
USER_EXTENTS
USER_FREE_SPACE
USER_ INDEXES
USER_IND_COLUMNS
USER_IND_PARTITIONS
USER_JOBS
USER_LIBRARIES
USER_LOBS
USER_METHOD_PARAMS
USER_METHOD_RESULTS
USER_NESTED_TABLES
USER_OBJECT_TABLES
USER_OBJECTS
USER_OBJECT_SIZE
USER_OBJ_AUDIT_OPTS
USER_PART_COL_STATISTICS
USER_PART_HISTOGRAMS
USER_PART_KEY_COLUMNS
USER_PART_INDEXES
USER_PART_TABLES
USER_PASSWORD_LIMITS
USER_QUEUE_TABLES
USER_QUEUES
USER_REFRESH
USER_REFRESH_CHILDREN
USER_REFS
USER_REPCATLOG
USER_REPCOLUMN
USER_REPCOLUMN_GROUP
USER_REPCONFLICT
USER_REPDDL
USER_REPGENERATED
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_SEGMENTS
USER_SEQUENCES
USER_SNAPSHOTS
USER_SNAPSHOT_LOGS
USER_SOURCE
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_TABLES
USER_TABLESPACES
USER_TRIGGERS
USER_TRIGGER_COLS
USER_TS_QUOTAS
USER_TYPES
USER_TYPE_ATTRS
USER_TYPE_METHODS
USER_UPDATABLE_COLUMNS
USER_USERS
USER_VIEWS

Chapter 3 Dynamic Performance (V$) Views

Dynamic Performance Views
V$ Views
GV$ Views
Restrictions on GV$ Views
Access to the Dynamic Performance Tables
View Descriptions
FILEXT$
V$ACCESS
V$ACTIVE_INSTANCES
V$ARCHIVE
V$ARCHIVE_DEST
V$ARCHIVED_LOG
V$BACKUP
V$BACKUP_CORRUPTION
V$BACKUP_DATAFILE
V$BACKUP_DEVICE
V$BACKUP_PIECE
V$BACKUP_REDOLOG
V$BACKUP_SET
V$BGPROCESS
V$BH
V$BUFFER_POOL
V$CACHE
V$CACHE_LOCK
V$CIRCUIT
V$CLASS_PING
V$COMPATIBILITY
V$COMPATSEG
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_CONVERT_LOCAL
V$DLM_CONVERT_REMOTE
V$DLM_LATCH
V$DLM_MISC
V$ENABLEDPRIVS
V$ENQUEUE_LOCK
V$EVENT_NAME
V$EXECUTION
V$EXECUTION_LOCATION
V$FALSE_PING
V$FILE_PING
V$FILESTAT
V$FIXED_TABLE
V$FIXED_VIEW_DEFINITION
V$GLOBAL_TRANSACTION
V$INDEXED_FIXED_COLUMN
V$INSTANCE
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$LOG_HISTORY
V$MLS_PARAMETERS
V$MTS
V$MYSTAT
V$NLS_PARAMETERS
V$NLS_VALID_VALUES
V$OBJECT_DEPENDENCY
V$OFFLINE_RANGE
V$OPEN_CURSOR
V$OPTION
V$PARAMETER
V$PING
V$PQ_SESSTAT
V$PQ_SLAVE
V$PQ_SYSSTAT
V$PQ_TQSTAT
V$PROCESS
V$PWFILE_USERS
V$QUEUE
V$RECOVER_FILE
V$RECOVERY_FILE_STATUS
V$RECOVERY_LOG
V$RECOVERY_STATUS
V$REQDIST
V$RESOURCE
V$RESOURCE_LIMIT
V$ROLLNAME
V$ROLLSTAT
V$ROWCACHE
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$THREAD
V$TIMER
V$TRANSACTION
V$TRANSACTION_ENQUEUE
V$TYPE_SIZE
V$VERSION
V$WAITSTAT

Chapter 4 National Language Support

What Does National Language Support Provide?
Oracle Server NLS Architecture
Background Information
Character Encoding Schemes
Restrictions on Character Sets Used to Express Names and Text
Single-Byte 7-Bit Encoding Schemes
Single-Byte 8-Bit Encoding Schemes
Varying-Width Multi-Byte Encoding Schemes
Fixed-Width Multi-Byte Encoding Schemes
UTF8 Encoding
Arabic/Hebrew Display Character Set Support
Choosing Character Sets for Database Character Set and
National Character Set
Uses for the Database Character Set
Uses for the National Character Set
Guidelines for Choosing Character Sets
Specifying Language-Dependent Behavior
Specifying Language-Dependent Behavior for a Session
NLS_LANG
Specifying NLS_LANG
Client/Server Architecture
Overriding Language and Territory Specifications
Specifying Language-Dependent Application Behavior
Language-Dependent Functions
Messages and Text
Number Format
Date Format, Currency Symbols, and First Day of the Week
Sorting Character Data
Binary Sorts
Linguistic Sorts
Linguistic Special Cases
Specifying Default Language-Dependent Behavior
NLS_LANGUAGE
NLS_TERRITORY
Runtime Loadable NLS Data
Data Loading
Utilities
NLS Parameters
NLS_CALENDAR
NLS_CURRENCY
NLS_DATE_FORMAT
Date Formats and Partition Bound Expressions
NLS_DATE_ LANGUAGE
NLS_ISO_CURRENCY
NLS_NUMERIC_CHARACTERS
NLS_SORT
Specifying Character Sets
Supported Character Sets
Character Set Conversion
The Concatenation Operator
Storing Data in Multi-Byte Character Sets
Loadable Character Sets
Date and Number Formats
Date Formats
Week and Day Number Conventions
Number Formats
Additional NLS Environment Variables
Client-Only Environment Variables
NLS_CREDIT
NLS_DEBIT
NLS_DISPLAY
NLS_LIST_SEPARATOR
NLS_MONETARY_CHARACTERS
NLS_NCHAR
Using NLS Parameters in SQL Functions
Default Specifications
Specifying Parameters
Unacceptable Parameters
CONVERT Function
NLSSORT Function
String Comparisons in a WHERE Clause
Other SQL Functions
Partitioned Tables and Indexes
Controlling an ORDER BY Clause
Obsolete NLS Data
Unicode (UTF-8) Support
NLS Data
Supported Languages
Supported Territories
Storage Character Sets
Arabic/Hebrew Display Character Sets
Linguistic Definitions
Calendar Systems

Chapter 5 Database Limits

Database Limits

Chapter 6 SQL Scripts

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

Appendix A Oracle Wait Events

Introduction
Oracle Wait Events
Parameter Descriptions
block#
blocks
break?
class
dba
driver id
file#
id1
id2
lenum
mode
name and type
namespace
requests
session#
waited
Wait Events
DFS db file lock
DFS lock handle
KOLF: Register LFI close
KOLF: Register LFI exists
KOLF: Register LFI isopen
KOLF: Register LFI length
KOLF: Register LFI lfimkm
KOLF: Register LFI lfimkpth
KOLF: Register LFI open
KOLF: Register LFI read
KOLF: Register LFI seek
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 ss
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 query create server
parallel query dequeue wait
parallel query qref latch
parallel query server shutdown
parallel query signal server
pending ast
pending global transaction(s)
pipe get
pipe put
pmon timer
process startup
queue messages
queue wait
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

Appendix B Enqueue and Lock Names

Introduction

Appendix C Statistics Descriptions

Statistics Descriptions
CPU used by this session
CR blocks created
Current blocks converted for CR
DBWR Flush object call found no dirty buffers
DBWR Flush object cross instance calls
DBWR buffers scanned
DBWR checkpoints
DBWR cross instance writes
DBWR free buffers found
DBWR lru scans
DBWR make free requests
DBWR summed scan depth
DBWR timeouts
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
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
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
cross instance CR read
db block changes
db block gets
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 cache hash latch 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 release time
global lock releases
kcmccs called get current scn
kcmccs read scn without going to DLM
kcmgss waited for batching
lock element waits
logons cumulative
logons current
next scns gotten without going to DLM
opened cursors cumulative
opened cursors current
opens of replaced files
opens requiring cache replacement
parse count (hard)
parse count (soft)
parse count (total)
parse time cpu
parse time elapsed
physical reads
physical writes
queries parallelized
recovery array read time
recovery array reads
recovery blocks read
recursive calls
recursive cpu usage
redo entries
redo entries linearized
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
remote instance undo requests
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
user calls
user commits
user rollbacks
write requests

Index



Next
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.

Library

Product

Index