Index

@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

@

• # symbol
• 7-bit ASCII
• 8-bit ASCII

  A

• abbreviations
  • AM/PM
  • BC/AD
• ACCESSIBLE_COLUMNS view
• acquiring rollback segments, distributed locks
• ALERT file
• ALL_CATALOG view [2]
• ALL_COL_PRIVS view
• ALL_COL_PRIVS_MADE view
• ALL_COL_PRIVS_RECD view
• ALL_COLUMN_COMMENTS view
• ALL_CONS_COLUMNS view
• ALL_CONSTRAINTS view
• ALL_DB_LINKS view
• ALL_DEF_AUDIT_OPTS view
• ALL_DEPENDENCIES view
• ALL_ERRORS view
• ALL_HISTOGRAMS view
• ALL_IND_COLUMNS view
• ALL_INDEXES view
• ALL_LABELS view
• ALL_MOUNTED_DBS view
• ALL_OBJECTS view
• ALL_REFRESH view
• ALL_REFRESH_CHILDREN view
• ALL_SEQUENCES view
• ALL_SNAPSHOTS view
• ALL_SOURCE view
• ALL_SYNONYMS view
• ALL_TAB_COLUMNS view
  • ACCESSIBLE_COLUMNS synonym
• ALL_TAB_COMMENTS view
• ALL_TAB_PRIVS view
• ALL_TAB_PRIVS_MADE view
• ALL_TAB_PRIVS_RECD view
• ALL_TABLES view
• ALL_TRIGGER_COLS view
• ALL_TRIGGERS view
• ALL_UPDATABLE_COLUMNS view
• ALL_USERS view
• ALL_VIEWS view
• ALLOCATE EXTENT option, instance number
• allocation
  • archival buffer
  • PCM locks
  • rollback segments
• ALTER DATABASE command
  • ADD LOGFILE
  • database name
  • ENABLE THREAD
  • THREAD
• ALTER SESSION command
  • SET HASH_AREA_SIZE option
  • SET HASH_JOIN_ENABLED option
  • SET HASH_MULTIBLOCK_IO_COUNT option
  • SET LOG_SIMULTANEOUS_COPIES option
  • SET NLS_* options
  • SET NLS_CURRENCY option [2]
  • SET NLS_DATE_FORMAT option
  • SET NLS_LANGUAGE option
  • SET NLS_NUMERIC_CHARACTERS option
  • SET NLS_TERRITORY option
  • SET OPTIMIZER_MODE option
  • SET OPTIMIZER_PERCENT_PARALLEL option
  • SET PARTITION_VIEW_ENABLED option
  • SET SQL_TRACE option
• ALTER SYSTEM command
  • SET HASH_MULTIBLOCK_IO_COUNT option
  • SET NLS_LANGUAGE option
• ALTER TABLE statement, allocating extents
• ALWAYS_ANTI_JOIN parameter
• AM/PM abbreviation, language of
• ANALYZE command [2] [3] [4] [5] [6] [7] [8] [9]
• applications
  • language behavior for
  • NLS support
• Arabic character set [2]
• ARCHIVE LOG command
  • destination file
  • START and STOP
• archived redo log
  • automatic versus manual
  • buffer [2]
  • storage device [2]
  • tuning [2]
• ARCHIVELOG mode, archiving destination [2]
  • automatic archiving
• ASCII character set, sorting order
• AUDIT_ACTIONS table
• AUDIT_TRAIL parameter
• authenticating remote clients
• authenticating users
• AUTO_MOUNTING parameter

  B

• background processes
  • enabling the checkpoint process (CKPT)
  • LCKn
  • SNP background process
  • specifying number
  • specifying trace files
  • tuning the log writer process (LGWR)
• BACKGROUND_DUMP_DEST parameter
  • ALERT file
• backslash (\) character
• BC/AD abbreviation, language of
• binary sorting
• BLANK_TRIMMING parameter
• block
  • deferred rollback
  • PCM lock [2]
  • redo log [2]
  • rollback segment
  • size
  • when written to disk
• buffer cache, database
• buffers, archival [2]
  • effect on performance
  • number of [2]

  C

• CACHE_SIZE_THRESHOLD parameter
• cache
  • database blocks
  • dictionary
  • row cache
  • sequence cache
  • statistics
• calendar systems
• calendars
• CAT synonym for USER_CATALOG
• CATALOG
• CATALOG.SQL scripts
• CATALOG.SQL, creating V$ views
• CATALOG6.SQL script
• CATAUDIT.SQL script
  • audit trail records created by
  • audit trails for connections and disconnections
  • auditing options created by
• CATAUDIT.SQL scripts
• CATBLOCK.SQL script
• CATDBSYN.SQL script
• CATEXP.SQL scripts
• CATEXP6.SQL script
• CATLDR.SQL scripts
• CATNOAUD.SQL script
• CATNOPRC.SQL script
• CATNOREP.SQL script
• CATNOSVM.SQL script
• CATPARR.SQL script
• CATPRC.SQL script
• CATPROC.SQL script
• CATREPAD.SQL script
• CATRPC.SQL script
• CATSNAP.SQL script
• CATSVRMG.SQL script
• CATTRUST.SQL script
• CHAINED_ROWS view
• CHAR datatype, multi-byte character sets and
• character encoding schemes
• character sets
  • 7-bit ASCII
  • 8-bit versus 7-bit
  • CONVERT function
  • converting [2]
  • encoding schemes
  • loadable character sets
  • multi-byte
  • sorting data
• characters, numeric group separators
• checkpoint process (CKPT)
• CHECKPOINT_PROCESS parameter
• checkpoints
  • checkpoint interval
  • CKPT process
  • statistics
• CKPT
• CLEANUP_ROLLBACK_ENTRIES parameter
• CLOSE_CACHED_OPEN_CURSORS parameter
• CLU synonym for USER_CLUSTERS
• code pages
• CODE_PIECES view
• CODE_SIZE view
• COL view
• COLS synonym for USER_TAB_COLUMNS
• COLUMN_PRIVILEGES view
• comments, in parameter files
• COMMIT_POINT_STRENGTH parameter
• COMPATIBLE parameter
• COMPATIBLE_NO_RECOVERY parameter
• concatenation operator
• concurrency
  • ROW_LOCKING parameter
  • sequences
  • SERIALIZABLE parameter
  • transactions and
  • transactions per rollback segment
  • user processes
• connecting
• consistency
  • multiversion read
  • rollback information
  • SERIALIZABLE parameter
• contention, block-level
• context areas, sort spacemap
• control files
  • names
  • specifying
• CONTROL_FILES parameter
• CONVERT function
• converting character sets
• cost-based optimizer [2]
• CPU_COUNT parameter
• CREATE DATABASE command
  • database name
  • MAXDATAFILES option
  • MAXLOGFILES option
  • setting the block size
  • setting the log mode
• CREATE INDEX command, performance
• CREATE TABLE statement, FREELIST GROUPS option
• creating
  • databases
    • setting block size
• currency
• currency symbol
  • default
  • local currency symbol
• currency
  • international currency symbol
  • monetary units characters
• CURSOR_SPACE_FOR_TIME parameter
• cursors
  • OPEN_CURSORS parameter
  • row cache
  • shared pool

  D

• data blocks
  • reading multiple
  • size of
• data dictionary
  • base tables
  • cache
  • datafiles [2]
  • DICTIONARY view
  • dynamic performance tables
  • location
  • rollback segments
  • row cache
  • scripts
  • sequence cache
  • SQL scripts
  • tables
  • views
    • DBA views
    • overview [2]
    • user views
• database administrator, data dictionary views
• database writer process (DBWR), batch writes [2]
  • checkpoint
• databases
  • database limits
  • default language
  • full database import
  • name
  • number of redo log files
  • resource limits
  • valid characters for database name
• data
  • conversion
  • CONVERT function
• datafiles
  • batch writes
  • mapping blocks to PCM locks
  • maximum number [2]
  • parameter
  • unspecified for PCM locks
• dates
  • ISO standard
  • language used for
  • NLS_DATE_LANGUAGE parameter
  • NLS_TERRITORY parameter
  • setting SYSDATE
  • TO_CHAR and TO_DATE functions
• day
  • format element
  • language of names
• DB_BLOCK_BUFFERS parameter
• DB_BLOCK_CHECKPOINT_BATCH parameter
• DB_BLOCK_CHECKSUM parameter
• DB_BLOCK_LRU_EXTENDED_STATISTICS parameter
• DB_BLOCK_LRU_LATCHES parameter
• DB_BLOCK_LRU_STATISTICS parameter
• DB_BLOCK_SIZE parameter [2]
• DB_DOMAIN parameter
• DB_FILE_MULTIBLOCK_READ_COUNT parameter
• DB_FILE_SIMULTANEOUS_WRITES parameter
• DB_FILE_STANDBY_NAME_CONVERT parameter
• DB_FILES parameter
• DB_MOUNT_MODE, Trusted ORACLE parameter
• DB_NAME parameter
• DBA_2PC_NEIGHBORS view
• DBA_2PC_PENDING view
• DBA_ANALYZE_OBJECTS view
• DBA_AUDIT_EXISTS view
• DBA_AUDIT_OBJECT view
• DBA_AUDIT_SESSION view
• DBA_AUDIT_STATEMENT view
• DBA_AUDIT_TRAIL view
• DBA_BLOCKERS view
• DBA_CATALOG view
• DBA_CLU_COLUMNS view
• DBA_CLUSTERS view
• DBA_COL_COMMENTS view
• DBA_COL_PRIVS view
• DBA_CONS_COLUMNS view
• DBA_CONSTRAINTS view
• DBA_DATA_FILES view [2]
• DBA_DB_LINKS view
• DBA_DDL_LOCKS view
• DBA_DEPENDENCIES view
• DBA_DML_LOCKS view
• DBA_ERRORS view
• DBA_EXP_FILES view
• DBA_EXP_OBJECTS view
• DBA_EXP_VERSION view
• DBA_EXTENTS view
• DBA_FREE_SPACE view
• DBA_FREE_SPACE_COALESCED view
• DBA_HISTOGRAMS view
• DBA_IND_COLUMNS view
• DBA_INDEXES view
• DBA_JOBS view
• DBA_JOBS_RUNNING view
• DBA_LOCKS view
• DBA_OBJ_AUDIT_OPTS view
• DBA_OBJECT_SIZE view
• DBA_OBJECTS view
• DBA_PRIV_AUDIT_OPTS view
• DBA_PROFILES view
• DBA_RCHILD view
• DBA_REFRESH view
• DBA_REFRESH_CHILDREN view
• DBA_RGROUP view
• DBA_ROLE_PRIVS view
• DBA_ROLES view
• DBA_ROLLBACK_SEGS view
• DBA_SEGMENTS view
• DBA_SEQUENCES view
• DBA_SNAPSHOT_LOGS view
• DBA_SNAPSHOTS view
• DBA_SOURCE view
• DBA_STMT_AUDIT_OPTS view
• DBA_SYNONYMS view
• DBA_SYS_PRIVS view
• DBA_TAB_COLUMNS view
• DBA_TAB_COMMENTS view
• DBA_TAB_PRIVS view
• DBA_TABLES view
• DBA_TABLESPACES view
• DBA_TRIGGER_COLS view
• DBA_TRIGGERS view
• DBA_TS_QUOTAS view
• DBA_UPDATABLE_COLUMNS view
• DBA_USERS view
• DBA_VIEWS view
• DBLINK_ENCRYPT_LOGIN parameter
• DBMS_ALERT_INFO view
• DBMS_LOCK_ALLOCATED table
• DBMSALRT.SQL script
• DBMSDESC.SQL script
• DBMSLOCK.SQL script
• DBMSMAIL.SQL script
• DBMSOTPT.SQL script
• DBMSPIPE.SQL script
• DBMSSNAP.SQL script
• DBMSSTDX.SQL script
• DBMSUTIL.SQL script
• DBWR
• debit symbol
• decimal character
  • default
  • NLS_NUMERIC_CHARACTERS parameter
  • when not a period (.)
• DEFCALL view
• deferred rollback segment
• DELAYED_LOGGING_BLOCK_CLEANOUTS parameter
• DEPTREE view
• derived parameters
• destination
  • archiving redo log files
  • BACKGROUND_DUMP_DEST parameter
  • overriding default
  • USER_DUMP_DEST
• devices, storage
• DICT synonym for DICTIONARY
• DICT_COLUMNS view
• DICTIONARY view
  • DICT synonym
• DISCRETE_TRANSACTIONS_ENABLED parameter
• disk drives
  • archiving destination
  • writing blocks
• dispatcher processes
  • configuration
  • maximum number
• distributed lock
  • exclusive
  • rollback segment [2] [3]
  • segment
  • space management
  • total number [2] [3]
• distributed queries
  • disabling
  • enabling
  • links for
• distributed transactions, limiting number of
• DISTRIBUTED_LOCK_TIMEOUT parameter
• DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME parameter
• DISTRIBUTED_TRANSACTIONS parameter
• DIUTIL.SQL script
• DML_LOCKS parameter
• DROPCAT6.SQL script
• dump files
• dynamic initialization parameters
• dynamic performance tables
  • CATALOG.SQL script
  • granting selective access
  • performance
  • public synonyms (V$)
  • views (V_$)

  E

• EBCDIC character set, sorting order
• embedded parameter files
• ENQUEUE_RESOURCES parameter
• enqueues
  • disabling
  • ENQUEUE_RESOURCES parameter
• environment variables
  • client environment
  • NLS parameters [2]
  • NLS_LANG
• ERROR_SIZE view
• errors, archiving
• EVENT parameter
• EXCEPTIONS table
• exclusive distributed lock, rollback data
• exclusive mode, specifying instance number
• extent, allocating to instance

  F

• FILE_LOCK view
• FILE_PING view
• filenames
  • case significance
  • name and number
• FILEXT$ view
• FIRST_ROWS [2]
• FIXED_DATE parameter
• format elements [2]
  • C
  • D [2]
  • day
  • G [2]
  • IW
  • IY
  • L [2]
  • month
  • RM [2]
  • RN
• free space list, locating space
• FREELIST GROUPS storage option
• FREELISTS storage option, maximum value

  G

• GC_DB_LOCKS parameter
  • unassigned locks
• GC_DEFAULT_LOCKS parameter
• GC_FILES_TO_LOCKS parameter
• GC_LCK_PROCS parameter
• GC_RELEASABLE_LOCKS parameter
• GC_ROLLBACK_LOCKS parameter
• GC_ROLLBACK_SEGMENTS parameter
• GC_SAVE_ROLLBACK_LOCKS parameter
• GC_SEGMENTS parameter
• GC_TABLESPACES parameter
• global cache control parameters [2] [3]
• global constant parameter, rollback segments [2]
• GLOBAL_NAME view
• GLOBAL_NAMES parameter
• group separator
  • default
  • NLS_NUMERIC_CHARACTERS parameter

  H

• HASH_AREA_SIZE parameter
• HASH_JOIN_ENABLED parameter
• HASH_MULTIBLOCK_IO_COUNT parameter
• Hebrew character set [2]
• hints
  • FIRST_ROWS
  • RULE [2]
• HISTOGRAMS view

  I

• I/O
  • reading multiple blocks
  • redo log files
  • reducing with buffer cache
• IDEPTREE view
• IFILE
• IFILE keyword
  • nested files
• importing, performance
• IND synonym for USER_INDEXES
• INDEX_HISTOGRAM view
• INDEX_STATS view
• indexes
  • FREELISTS option
  • maximum PGA memory
  • sort spacemap
• INIT.ORA, parameter files
• INIT_SQL_FILES parameter
  • data dictionary creation
• initialization parameters
  • altering
  • ALWAYS_ANTI_JOIN parameter
  • AUDIT_TRAIL parameter
  • AUTO_MOUNTING parameter
  • BACKGROUND_DUMP_DEST parameter
  • BLANK_TRIMMING parameter
  • CACHE_SIZE_THRESHOLD parameter
  • case significance in filenames
  • CHECKPOINT_PROCESS parameter
  • CLEANUP_ROLLBACK_ENTRIES parameter
  • CLOSE_CACHED_OPEN_CURSORS parameter
  • COMMIT_POINT_STRENGTH parameter
  • COMPATIBLE parameter
  • COMPATIBLE_NO_RECOVERY parameter
  • CONTROL_FILES parameter
  • controling archiving
  • CPU_COUNT parameter
  • CURSOR_SPACE_FOR_TIME parameter
  • database creation
  • DB_BLOCK_BUFFERS parameter
  • DB_BLOCK_CHECKPOINT_BATCH parameter
  • DB_BLOCK_CHECKSUM parameter
  • DB_BLOCK_LRU_EXTENDED_STATISTIC parameter
  • DB_BLOCK_LRU_LATCHES parameter
  • DB_BLOCK_LRU_STATISTICS parameter
  • DB_BLOCK_SIZE parameter
  • DB_DOMAIN parameter
  • DB_FILE_MULTIBLOCK_READ_COUNT parameter
  • DB_FILE_SIMULTANEOUS_WRITES parameter
  • DB_FILE_STANDBY_NAME_CONVERT parameter
  • DB_FILES parameter
  • DB_MOUNT_MODE parameter
  • DB_NAME parameter
  • DBLINK_ENCRYPT_LOGIN parameter
  • DELAYED_LOGGING_BLOCK_CLEANOUTS parameter
  • derived parameters
  • DISCRETE_TRANSACTIONS_ENABLED parameter
  • display current settings
  • DISTRIBUTED_LOCK_TIMEOUT parameter
  • DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME parameter
  • DISTRIBUTED_TRANSACTIONS parameter
  • DML_LOCKS parameter
  • dynamic
  • ENQUEUE_RESOURCES parameter
  • EVENT parameter
  • FIXED_DATE parameter
  • GC parameters
  • GC_DB_LOCKS parameter
  • GC_DEFAULT_LOCKS parameter
  • GC_FILES_TO_LOCKS parameter
  • GC_LCK_PROCS parameter
  • GC_RELEASABLE_LOCKS parameter
  • GC_ROLLBACK_LOCKS parameter
  • GC_ROLLBACK_SEGMENT parameter
  • GC_SAVE_ROLLACK_LOCKS parameter
  • GC_SEGMENTS parameter
  • GC_TABLESPACES parameter
  • global cache
  • global constant parameters
  • GLOBAL_NAMES parameter
  • HASH_AREA_SIZE parameter
  • HASH_JOIN_ENABLED parameter
  • HASH_MULTIBLOCK_IO_COUNT parameter
  • INIT_SQL_FILES
  • INIT_SQL_FILES parameter
  • INSTANCE_NUMBER parameter
  • JOB_QUEUE_INTERVAL parameter
  • JOB_QUEUE_PROCESSES parameter
  • LABEL_CACHE_SIZE parameter
  • language-dependent NLS
  • LICENSE_MAX_SESSIONS parameter
  • LICENSE_MAX_USERS parameter
  • LICENSE_SESSIONS_WARNING parameter
  • LOG_ARCHIVE_BUFFER_SIZE parameter
  • LOG_ARCHIVE_BUFFERS parameter
  • LOG_ARCHIVE_DEST parameter
  • LOG_ARCHIVE_FORMAT parameter
  • LOG_ARCHIVE_START parameter
  • LOG_BLOCK_CHECKSUM parameter
  • LOG_BUFFER parameter
  • LOG_CHECKPOINT_INTERVAL parameter
  • LOG_CHECKPOINT_TIMEOUT parameter
  • LOG_CHECKPOINTS_TO_ALERT parameter
  • LOG_ENTRY_PREBUILD_THRESHOLD
  • LOG_FILE_STANDBY_NAME_CONVERT parameter
  • LOG_FILES parameter
  • LOG_SIMULTANEOUS_COPIES parameter
  • LOG_SMALL_ENTRY_MAX_SIZE parameter
  • MAX_DEFAULT_PROPAGATION_DELAY parameter
  • MAX_DUMP_FILE_SIZE parameter
  • MAX_ENABLED_ROLES parameter
  • MAX_ROLLBACK_SEGMRNTS parameter
  • MAX_TRANSACTION_BRANCHES parameter
  • MLS_LABEL_FORMAT parameter
  • MTS_DISPATCHERS parameter
  • MTS_LISTENER_ADDRESS parameter
  • MTS_MAX_DISPATCHERS parameter
  • MTS_MAX_SERVERS parameter
  • MTS_MULTIPLE_LISTENERS parameter
  • MTS_SERVERS parameter
  • MTS_SERVICE parameter
  • NLS_CALENDAR parameter
  • NLS_CURRENCY parameter
  • NLS_DATE parameter
  • NLS_DATE_LANGUAGE parameter
  • NLS_DEBIT parameter
  • NLS_DISPLAY parameter
  • NLS_ISO_CURRENCY parameter
  • NLS_LANGUAGE parameter
  • NLS_LIST_SEPARATOR parameter
  • NLS_MONETARY_CHARACTERS parameter
  • NLS_NUMERIC_CHARACTERS parameter
  • NLS_SORT parameter
  • NLS_TERRITORY parameter
  • OPEN_CURSORS parameter
  • OPEN_LINKS parameter
  • OPEN_MOUNTS parameter
  • operating system dependent parameters
  • OPTIMIZER_MODE parameter
  • OPTIMIZER_PERCENT_PARALLEL parameter
  • ORACLE_TRACE_COLLECTION_NAME parameter
  • ORACLE_TRACE_COLLECTION_PATH parameter
  • ORACLE_TRACE_COLLECTION_SIZE parameter
  • ORACLE_TRACE_ENABLE parameter
  • ORACLE_TRACE_FACILITY_NAME parameter
  • ORACLE_TRACE_FACILITY_PATH parameter
  • OS_AUTHENT_PREFIX parameter
  • OS_ROLES parameter
  • overview
  • PARALLEL_DEFAULT_MAX_INSTANCES parameter
  • PARALLEL_DEFAULT_MAX_SCANS parameter
  • PARALLEL_DEFAULT_SCANSIZE parameter
  • PARALLEL_MAX_SERVERS parameter
  • PARALLEL_MIN_PERCENT parameter
  • PARALLEL_MIN_SERVERS parameter
  • PARALLEL_SERVER_IDLE_TIME parameter
  • PARTITION_VIEW_ENABLED parameter
  • performance tuning
  • PRE_PAGE_SGA parameter
  • PROCESSES parameter
  • RECOVERY_PARALLELISM parameter
  • REMOTE_DEPENDENCIES_MODE parameter
  • REMOTE_LOGIN_PASSWORDFILE parameter
  • REMOTE_OS_AUTHENT parameter
  • REMOTE_OS_ROLES parameter
  • RESOURCE_LIMIT parameter
  • rollback segments
  • ROLLBACK_CACHE_CURSORS parameter
  • ROLLBACK_SEGMENTS parameter
  • ROW_LOCKING parameter
  • SEQUENCE_CACHED_CURSORS parameter
  • SEQUENCE_CACHED_HASH_BUCKETS parameter
  • SEREIALIZABLE parameter
  • SESSION_CACHED_CURSORS parameter
  • SESSIONS parameter
  • SHARED_POOL_RESERVED_MIN_ALLOC parameter
  • SHARED_POOL_RESERVED_SIZE
  • SHARED_POOL_RESERVED_SIZE parameter
  • SHARED_POOL_SIZE parameter
  • SNAPSHOT_REFRESH_INTERVAL parameter
  • SNAPSHOT_REFRESH_PROCESS parameter
  • SORT_AREA_RETAINED_SIZE parameter
  • SORT_AREA_SIZE parameter
  • SORT_DIRECT_WRITES parameter
  • SORT_READ_FAC parameter
  • SORT_SPACEMAP_SIZE parameter
  • SORT_WRITE_BUFFER_SIZE parameter
  • SORT_WRITE_BUFFERS parameter
  • specifying in parameter files
  • SQL92_SECURITY parameter
  • SQL_TRACE parameter
  • TEMPORARY_TABLE_LOCKS parameter
  • THREAD parameter
  • TIMED_STATISTICS parameter
  • TRANSACTIONS parameter
  • TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter
  • USER_DUMP_DEST parameter
  • UTL_FILE_DIR parameter
  • variable
• inserts, locating free space
• INSTANCE option, allocating extents
• INSTANCE_NUMBER parameter
  • exclusive or parallel mode
• instances
  • checkpoint
  • startup order
• ISO standard, date format [2]
• ISO week number
• IW format element
• IY format element

  J

• JOB_QUEUE_INTERVAL parameter
• JOB_QUEUE_PROCESSES parameter

  K

  L

• L format element
• LABEL_CACHE_SIZE parameter
• language
  • database default language
  • language-dependent application behavior
• LCKn process
• least recently used (LRU) list, sequence numbers
• LICENSE_MAX_SESSIONS parameter
• LICENSE_MAX_USERS parameter
• LICENSE_SESSIONS_WARNING parameter
• licenses
  • maximum sessions
  • maximum users
  • warning for concurrent user sessions
• limits on the database
• linguistic definitions, NLS
• linguistic sorts [2]
• list separator
• listener process
• loadable character sets
• LOADER_COL_INFO view
• LOADER_CONSTRAINT_INFO view
• LOADER_FILE_TS view
• LOADER_IND_INFO view
• LOADER_INDCOL_INFO view
• LOADER_PARAM_INFO view
• LOADER_TAB_INFO view
• LOADER_TRIGGER_INFO view
• local currency
• local currency symbol
• lock conversion [2] [3] [4] [5]
• lock process (LCKn), specifying number
• locks
  • PCM lock
  • rollback segment
  • segment
  • table lock [2]
  • temporary tables
• LOG_ARCHIVE_BUFFER_SIZE parameter [2]
• LOG_ARCHIVE_BUFFERS parameter [2]
• LOG_ARCHIVE_DEST parameter
• LOG_ARCHIVE_FORMAT parameter
• LOG_ARCHIVE_START parameter
• LOG_BLOCK_CHECKSUM parameter
• LOG_BUFFER parameter
• LOG_CHECKPOINT_INTERVAL parameter
• LOG_CHECKPOINT_TIMEOUT parameter
• LOG_CHECKPOINTS_TO_ALERT parameter
• LOG_ENTRY_PREBUILD_THRESHOLD parameter
• LOG_FILE_STANDBY_NAME_CONVERT parameter
• LOG_FILES parameter
• LOG_SIMULTANEOUS_COPIES parameter
• LOG_SMALL_ENTRY_MAX_SIZE parameter
• lowercase significance
• LRU

  M

• manual archiving
• MAX_COMMIT_PROPAGATION_DELAY parameter
• MAX_DUMP_FILE_SIZE parameter
• MAX_ENABLED_ROLES parameter
• MAX_ROLLBACK_SEGMENTS parameter
• MAX_TRANSACTION_BRANCHES parameter
• MAXDATAFILES option
• MAXLOGFILES option
• MAXLOGMEMBERS option
• memory
  • amount used for sorting
  • distributed locks
  • minimum session memory
  • virtual
• migration scripts
• MLS_LABEL_FORMAT, Trusted ORACLE parameter
• modes, archiving
• monetary units characters
• MONITOR command, dynamic performance tables
• monitor, system statistics
• month
  • format element
  • language of names
• MTS dispatcher request statistics
• MTS_DISPATCHERS parameter
• MTS_LISTENER_ADDRESS parameter
• MTS_MAX_DISPATCHERS parameter
• MTS_MAX_SERVERS parameter
• MTS_MULTIPLE_LISTENERS parameter
• MTS_SERVERS parameter
• MTS_SERVICE parameter
• multi-byte character sets
• multi-byte encoding schemes
• multi-threaded server (MTS)
  • HASH_MULTIBLOCK_IO_COUNT
  • SESSIONS parameter
• multiple-process systems, number of processes

  N

• National Language Support (NLS)
  • architecture
  • calendars
  • enhancements
  • goals
  • language-dependent behavior
  • linguistic definitions
  • loadable character sets
  • NLS_LANGUAGE parameter [2]
• nested files
• NLS
• NLS_CALENDAR parameter
• NLS_CREDIT environment variable
• NLS_CURRENCY parameter [2]
  • defined by NLS_TERRITORY
• NLS_DATABASE_PARAMETERS view
• NLS_DATE_FORMAT parameter [2]
  • defined by NLS_NUMERIC_CHARACTERS
  • defined by NLS_TERRITORY
• NLS_DATE_LANGUAGE parameter [2]
• NLS_DEBIT parameter
• NLS_DISPLAY environment variable [2] [3]
• NLS_DISPLAY parameter
• NLS_INSTANCE_PARAMETERS view
• NLS_ISO_CURRENCY parameter
  • defined by NLS_TERRITORY
• NLS_LANG environment variable [2] [3] [4] [5] [6]
• NLS_LANGUAGE parameter [2] [3]
• NLS_LIST_SEPARATOR parameter
• NLS_MONETARY_CHARACTERS parameter
• NLS_NUMERIC_CHARACTERS parameter [2]
• NLS_SESSION_PARAMETERS view
• NLS_SORT parameter [2]
• NLS_TERRITORY parameter [2]
• NLSRTL
• NOARCHIVELOG mode, creating a database
• NOCACHE option
• numeric group separators

  O

• OBJ synonym for USER_OBJECTS
• objects
  • data dictionary
    • DBA
• offline tablespace
  • deferred rollback segments
  • restrictions
• online redo log
  • archiving
  • archiving mode
  • block
  • block size
  • file size
  • number of files [2]
  • setting checkpoint interval
• OPEN_CURSORS parameter
• OPEN_LINKS parameter
• OPEN_MOUNTS parameter, Trusted ORACLE parameter
• operating system
  • authenticating remote clients
  • authenticating users and passwords
  • operating system dependent parameters
  • redo log blocks [2]
  • roles for remote clients
• optimization, trading cursor space for time
• optimizer mode
  • FIRST_ROWS
  • RULE
• OPTIMIZER_MODE parameter
• OPTIMIZER_PERCENT_PARALLEL parameter
• ORACLE_TRACE_COLLECTION_NAME parameter
• ORACLE_TRACE_COLLECTION_PATH parameter
• ORACLE_TRACE_COLLECTION_SIZE parameter
• ORACLE_TRACE_ENABLE parameter
• ORACLE_TRACE_FACILITY_NAME parameter
• ORACLE_TRACE_FACILITY_PATH parameter
• ORDER BY clause, sorting character data
• OS_AUTHENT_PREFIX parameter
• OS_ROLES parameter

  P

• parallel mode, instance number
• parallel query
  • idle time
  • maximum number of instances
  • maximum number of servers
  • minimum number of queries
  • OPTIMIZER_PERCENT_PARALLEL
• PARALLEL_DEFAULT_MAX_INSTANCES parameter
• PARALLEL_DEFAULT_MAX_SCANS parameter
• PARALLEL_DEFAULT_SCANSIZE parameter
• PARALLEL_MAX_SERVERS parameter
• PARALLEL_MIN_PERCENT parameter
• PARALLEL_MIN_SERVERS parameter
• PARALLEL_SERVER_IDLE_TIME parameter
• parallelism, OPTIMIZER_PERCENT_PARALLEL
• parameter files
  • common file
  • embedded files
  • embedded parameter files
  • line continuation character (\)
• PARSED_PIECES view
• PARSED_SIZE view
• PARTITION_VIEW_ENABLED parameter
• partition, raw partition
• passwords, authenticating [2]
  • REMOTE_LOGIN_PASSWORDFILE parameter
• PCM lock
  • mapping blocks to
  • specifying total number
• performance
  • archiving
  • dynamic performance tables
  • effect of SGA size
  • full database import
  • maximum PGA memory
  • number of database buffers
  • rule-based optimizer
  • shared pool
  • sort performance
  • sort spacemap
  • tuning archiving
• PGA
• PIDIAN.SQL script
• pinging
• PIPIDL.SQL script
• PISTUB.SQL script
• PLAN_TABLE execution plan table
• PRE_PAGE_SGA parameter
• precision, NUMBER and FLOAT [2]
• private rollback segments, specifying
• privileges
  • remote login
  • RESTRICTED_SESSION privilege [2]
  • table-level select privileges
• procedures, shared pool
• PROCESSES parameter
  • increasing for CKPT
  • increasing for LCK0
• processes
  • derived parameter values
  • dispatcher process configuration
  • dispatcher process maximum number
  • listener process address
  • maximum shared server processes
  • number of server processes
  • recovery
  • snapshot refresh intervals
  • snapshot refreshes
  • trace files
  • user processes
• PRODUCT_COMPONENT_VERSION view
• profiles, resource limits
• Program Global Area (PGA), maximum for sorts
• PSTUBTBL view
• PUBLIC option, thread of redo
• public rollback segments
  • using by default
• PUBLIC user group, dynamic performance table access
• PUBLIC_DEPENDENCY view
• PUBLICSYN view

  Q

• queries
  • dictionary views
  • hints
  • ordering output
  • table-level read locks
• quotation marks

  R

• raw partition, LOG_ARCHIVE_DEST parameter
• read consistency, rollback information
• RECOVERY_PARALLELISM parameter
• recovery, number of required processes
• redo log buffers, size
• redo thread
• remarks, in parameter files
• remote clients, authenticating
• remote logins
• REMOTE_DEPENDENCIES_MODE parameter
• REMOTE_LOGIN_PASSWORDFILE parameter
• REMOTE_OS_AUTHENT parameter
• REMOTE_OS_ROLES parameter
• REPCAT$_REPOBJECT view
• replacement characters
• resource limits for profiles
• RESOURCE_COST view
• RESOURCE_LIMIT parameter
• RESOURCE_MAP view
• restrictions, number of files
• RM format element
• ROLE_ROLE_PRIVS view
• ROLE_SYS_PRIVS view
• ROLE_TAB_PRIVS view
• roles
  • remotes clients
• rollback segments, acquiring [2]
  • deferred
  • distributed locks [2] [3]
  • global constant parameters
  • initialization parameters
  • maximum size
  • multiple
  • number of concurrent transactions
  • private rollback segments
  • public rollback segments
  • specifying
  • SYSTEM [2]
  • total number
• ROLLBACK_SEGMENTS parameter
  • unique values
• Roman numerals, format mask for
• row cache cursor
• ROW_CACHE_CURSORS parameter
• ROW_LOCKING parameter
• RULE [2]
• rule-based optimizer

  S

• scripts
  • data dictionary
  • migration
  • SQL scripts
• segment, simultaneous space management
• SEQ synonym for USER_SEQUENCES
• SEQUENCE_CACHE_ENTRIES parameter
• SEQUENCE_CACHE_HASH_BUCKETS parameter
• sequences
  • data dictionary cache
  • not cached
• SERIALIZABLE parameter
• Server Manager, statistics
• server processes, number
• session memory, minimum
• SESSION_CACHED_CURSORS parameter
• SESSION_PRIVS view
• SESSION_ROLES view
• SESSIONS parameter
• SGA
• shared server processes, maximum number
• SHARED_POOL_RESERVED_MIN_ALLOC parameter
• SHARED_POOL_RESERVED_SIZE parameter
  • V$SHARED_POOL_RESERVED
• SHARED_POOL_SIZE parameter
• SHOW command, PARAMETERS option
• SNAPSHOT_REFRESH_INTERVAL parameter
• SNAPSHOT_REFRESH_PROCESS parameter
• snapshots
  • refresh interval
  • refresh processes per instance
• SNP background processes
• SORT_AREA_RETAINED_SIZE parameter
• SORT_AREA_SIZE parameter
• SORT_DIRECT_WRITES parameter
• SORT_READ_FAC parameter
• SORT_SPACEMAP_SIZE parameter
• SORT_WRITE_BUFFER_SIZE parameter
• SORT_WRITE_BUFFERS parameter
• sorting
  • character data
  • double characters
  • following language conventions
  • maximum memory
  • maximum PGA memory
  • minimum session memory
  • order
  • ORDER BY queries
  • specifying non-default
• SOURCE_SIZE view
• space
  • allocating extents
  • segment management
  • SGA [2]
• SQL scripts
  • creating the data dictionary
  • optional
  • required
• SQL.BSQ scripts
• SQL92_SECURITY parameter
• SQL_TRACE parameter
• STANDARD.SQL script
• START option, automatic archiving
• starting up
  • database name
  • instance number
  • startup order
• STARTUP command, database name
• statistics
  • dbwr checkpoints
  • effect of cache size [2]
  • timed
• STMT_AUDIT_OPTION_MAP table, auditing option type codes
• switch redo log file
• SYN synonym for USER_SYNONYMS
• SYNONYMS view
• SYS username, dynamic performance tables
• SYS_OBJECTS view
• SYSCATALOG view
• SYSFILES view
• SYSSEGOBJ view
• System Global Area (SGA), buffer areas [2]
  • buffer cache
  • maximum concurrent transactions
  • page size
  • PCM locks
  • rollback segment size
  • sequence cache
  • size of [2] [3]
  • tuning [2]
• system performance
• SYSTEM rollback segment
  • defining
  • global constant
• SYSTEM_PRIVILEGE_MAP view
• SYSTEM, tablespace

  T

• TAB view
• TABLE_PRIVILEGE_MAP table, access privilege codes
• TABLE_PRIVILEGES view
• tables
  • allocating extents
  • data dictionary
  • DML locks
  • free lists
  • locating free space
• tablespace, offline
• tables
  • row locking
  • simultaneous space management
  • temporary tables
• TABQUOTAS view
• TABS synonym for USER_TABLES
• tape archiving destination
• TEMPORARY_TABLE_LOCKS parameter
• territory [2]
• THREAD parameter
• TIMED_STATISTICS parameter
  • file read/write statistics
• TO_CHAR function
  • default date format
  • format masks
  • group separator
  • language for dates
  • spelling of days and months
• TO_DATE function
  • default date format
  • format masks
  • language for dates
  • spelling of days and months
• TO_NUMBER function
  • format masks
  • group separator
• trace files
  • ALERT file
  • destination [2]
  • location of
  • maximum size
• TRANSACTIONS parameter [2]
  • DML locks
• TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter [2]
• transactions
  • concurrent
  • data locking [2]
  • rollback segments
  • updates
• Trusted ORACLE
  • ALL_LABELS view
  • ALL_MOUNTED view
  • data dictionary

  U

• UNICODE [2] [3]
• updates
  • locating free space
  • serializable
  • transaction processing option
• uppercase characters
• user processes, trace files
• USER_AUDIT_OBJECT view
• USER_AUDIT_SESSION view
• USER_AUDIT_STATEMENT view
• USER_AUDIT_TRAIL view
• USER_CATALOG view
  • CAT synonym
• USER_CLU_COLUMNS view
• USER_CLUSTERS view
  • CLU synonym
• USER_COL_COMMENTS view, comments, on columns of user's tables and views
• USER_COL_PRIVS view
• USER_COL_PRIVS_MADE view
• USER_COL_PRIVS_RECD view
• USER_CONS_COLUMNS view
• USER_CONSTRAINTS view
• USER_DB_LINKS view
• USER_DEPENDENCIES view
• USER_DUMP_DEST parameter
• USER_ERRORS view
• USER_EXTENTS view
• USER_FREE_SPACE view
• USER_IND_COLUMNS view
• USER_INDEXES view
  • IND synonym
• USER_JOBS view
• USER_OBJ_AUDIT_OPTS view
• USER_OBJECT_SIZE view
• USER_OBJECTS view
  • OBJ syonym
• USER_REFRESH view
• USER_REFRESH_CHILDREN view
• USER_RESOURCE_LIMITS view
• USER_ROLE_PRIVS view
• USER_SEGMENTS view
• USER_SEQUENCES view
  • SEQ synonym
• USER_SNAPSHOT_LOGS view [2]
• USER_SNAPSHOTS view
• USER_SOURCE view
• USER_SYNONYMS view
  • SYN synonym
• USER_SYS_PRIVS view
• USER_TAB_COLUMNS view
• USER_TAB_COLUMNS, COLS synonym
• USER_TAB_COMMENTS view
• USER_TAB_PRIVS view
• USER_TAB_PRIVS_MADE view
• USER_TAB_PRIVS_RECD view
• USER_TABLES view
• USER_TABLESPACES view
• USER_TRIGGER_COLS view
• USER_TRIGGERS view
• USER_TS_QUOTAS view
• USER_UPDATABLE_COLUMNS view
• USER_USERS view
• USER_VIEWS view
• users
  • authenticating
  • multiple
• UTF2 encoding [2] [3]
• UTL_FILE_DIR parameter
• UTLBSTAT.SQL script
• UTLCHAIN.SQL script
• UTLDIDXS.SQL script
• UTLDTREE.SQL script
• UTLESTAT.SQL script
• UTLEXCPT.SQL script
• UTLEXP6.SQL script
• UTLLOCKT.SQL script
• UTLMAIL.SQL script
• UTLMONTR.SQL script [2]
• UTLOIDXS.SQL script
• UTLSAMPL.SQL script
• UTLSIDXS.SQL script
• UTLXPLAN.SQL script

  V

• V$ACCESS view
• V$ACTIVE_INSTANCES view
• V$ARCHIVE view
• V$BACKUP view
• V$BGPROCESS view
• V$BH view
• V$CACHE view
• V$CACHE_LOCK view
• V$CIRCUIT view
• V$COMPATIBILITY view
• V$COMPATSEG view
• V$CONTROLFILE view
• V$DATABASE view
• V$DATAFILE view
• V$DB_OBJECT_CACHE view
• V$DB_PIPES view
• V$DBFILE view
• V$DBLINK view
• V$DISPATCHER view
• V$ENABLEDPRIVS view
• V$EVENT_NAME view
• V$FALSE_PING view
• V$FILESTAT view
• V$FIXED_TABLE view
• V$FIXED_VIEW_DEFINITION view
• V$INDEXED_FIXED_COLUMN view
• V$INSTANCE view
• V$LATCH view
• V$LATCH_CHILDREN view
• V$LATCH_MISSES view
• V$LATCH_PARENT view
• V$LATCHHOLDER view
• V$LATCHNAME view
• V$LIBRARYCACHE view
• V$LICENSE view
• V$LOADCSTAT view
• V$LOADTSTAT view
• V$LOCK view
• V$LOCK_ACTIVITY view
• V$LOCK_ELEMENT view
• V$LOCKED_OBJECT view
• V$LOCKS_WITH_COLLISIONS view
• V$LOG view
• V$LOG_HISTORY view
• V$LOGFILE view
• V$LOGHIST view
• V$MLS_PARAMETERS view
• V$MTS view
• V$MYSTAT view
• V$NLS_PARAMETERS view
• V$NLS_VALID_VALUES view
• V$OBJECT_DEPENDENCY view
• V$OPEN_CURSOR view
• V$OPTION view
• V$PARAMETER view
• V$PING view [2]
• V$PQ_SESSTAT view
• V$PQ_SLAVE view
• V$PQ_SYSSTAT view
• V$PQ_TQSTAT view
• V$PROCESS view
• V$PWFILE_USERS view
• V$QUEUE view
• V$RECOVER_FILE view
• V$RECOVERY_FILE_STATUS view
• V$RECOVERY_LOG view
• V$RECOVERY_STATUS view
• V$REQDIST view
• V$RESOURCE view
• V$ROLLNAME view
• V$ROLLSTAT view
• V$ROWCACHE view
• V$SECONDARY view
• V$SESS_IO view
• V$SESSION view
• V$SESSION_CONNECT_INFO view
• V$SESSION_CURSOR_CACHE view
• V$SESSION_EVENT view
• V$SESSION_WAIT view
• V$SESSTAT view
• V$SGA view
• V$SGASTAT view
• V$SHARED_POOL_RESERVED view
• V$SHARED_SERVER view
• V$SORT_SEGMENT view
• V$SQL view
• V$SQLAREA view
• V$SQLTEXT view
• V$SQLTEXT_WITH_NEWLINES view
• V$STATNAME view
• V$SYSLABEL view
• V$SYSSTAT view
• V$SYSTEM_CURSOR_CACHE view
• V$SYSTEM_EVENT view
• V$SYSTEM_PARAMETER view
• V$THREAD view
• V$TIMER view
• V$TRANSACTION view
• V$TYPE_SIZE view
• V$VERSION view
• V$WAITSTAT view
• VARCHAR2 datatype, multi-byte character sets and
• variable parameters
• views
  • data dictionary views
  • data files
  • DBA views

  W

• week numbers

  X

• X$KCBCBH table
• X$KCBRBH table

  Y

  Z