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  Z  

A

  • access drivers, external table 1
  • access paths, data 1 , 2 , 3 , 4
  • accounts, user 1
  • ACID properties 1
  • active transactions 1
  • ADDM (Automatic Database Diagnostic Monitor) 1 , 2
  • administrative accounts 1 , 2
  • administrator privileges 1 , 2 , 4
  • ADR 1
  • advanced index compression 1
  • Advanced Queuing, Oracle Streams 1
  • aggregate function 1
  • alert log
    • about 1
  • alert logs 1
  • ALL_ data dictionary views 1
  • ALTER TABLE statement 1
  • analytic functions 1
  • anonymous PL/SQL blocks 1
  • ANSI/ISO standard 1
  • APIs (application program interfaces)
    • embedded SQL statements 1
    • external tables 1
    • Java 1 , 2 , 3
    • JDBC 1 , 3 , 4
    • network services 1
    • OCI/OCCI 1
    • ODBC 1 , 2
    • Oracle Database Advanced Queuing 1
    • Oracle Data Pump 1
    • SQLJ 1
  • application architecture 1
  • application contexts, auditing 1
  • Application Continuity
    • architecture 1
    • benefits 1
  • application developers
    • duties of 1
    • tools for 1
    • topics for 1
  • application domain indexes 1
  • application processes 1
  • application program interface
    • See: API
  • applications
    • upgrades 1
  • application servers
    • about 1
  • archived redo log files 1 , 2 , 3
  • ARCHIVELOG mode 1
  • archiver process (ARCn) 1
  • ascending indexes 1
  • ASSM tablespace 1
  • asynchronous notifications 1
  • atomicity, statement-level 1
  • attribute-clustered tables
    • benefits 1
    • dimensional hierarchies 1
    • interleaved ordering 1
    • join attribute clustering 1
    • linear ordering 1
    • overview 1
    • zone maps 1 , 2
  • auditing
    • application contexts 1
    • Audit Administrator role 1
    • audit configurations 1
    • audit policies 1 , 3 , 4
    • audit records 1
    • common objects 1
    • fine-grained 1
    • Oracle Audit Vault and Database Firewall 1
    • Oracle Label Security 1
    • standard 1
    • unified audit trail 1 , 2 , 3
  • AUDIT statement 1
  • authentication, database 1 , 2 , 3
  • automatic big table caching 1 , 2
  • Automatic Database Diagnostic Monitor
    • See: ADDM
  • Automatic Diagnostic Repository (ADR) 1 , 2
  • automatic maintenance tasks 1
  • automatic memory management 1 , 2
  • automatic segment space management (ASSM) 1
  • automatic undo management 1 , 2
  • automatic undo mode 1
  • Automatic Workload Repository (AWR) 1
  • AutoTask 1
  • AWR
    • See: Automatic Workload Repository (AWR)
  • AWR reports 1

B

  • background processes
    • mandatory 1
    • optional 1
  • backup and recovery
    • definition 1
    • techniques 1
  • backups
    • backup sets 1
    • image copies 1
    • partial database 1
    • Recovery Manager 1
    • technique comparisons 1
    • whole database 1
  • backup strategies
    • incremental-forever 1
  • big table cache 1
  • BINARY_DOUBLE data type 1
  • BINARY_FLOAT data type 1
  • bitmap indexes
    • bitmap joins 1
    • locks 1
    • mapping table 1
    • single-table 1
    • storage 1
  • bitmap tablespace management 1
  • blocking transactions 1
  • blocks, data
    • See: data blocks
  • BOOLEAN data type 1 , 2 , 3 , 4
  • branch blocks, index 1
  • B-tree indexes
    • branch level 1
    • height 1
    • prefix compression 1
    • reverse key 1
  • buffer cache, database
    • See: database buffer cache
  • buffers
    • See: database buffers
  • business rules, enforcing 1 , 2

C

  • cache fusion 1
  • cardinality, column 1 , 2
  • Cartesian joins 1
  • cartridges 1
  • cascading deletions 1
  • catalog.sql script 1
  • CDBs
    • about 1
    • common privilege grants 1 , 2
    • common users 1 , 2
    • container data objects 1
    • containers 1
    • creation 1
    • data dictionary 1
    • files 1
    • local roles 1
    • local users 1
    • metadata links 1
    • object links 1
    • Oracle Data Pump 1
    • roles
      • granting common 1 , 2
    • root container 1
  • chaining, rows
    • See: row chaining
  • character data types
    • VARCHAR2 1
  • character sets
    • ASCII 1
    • EBCDIC 1
    • Unicode 1
  • CHAR data type 1
  • check constraints 1 , 2
  • checkpoint process (CKPT) 1
  • checkpoints
    • control files 1
    • database shutdowns 1
    • definition 1
    • inconsistent backups 1
    • incremental 1
    • position 1
    • thread 1
  • client/server architecture
    • advantages 1
  • client processes
    • connections and 1
    • sessions and 1
    • shared server processes and 1
  • client result cache 1
  • client-side programming 1
  • cluster indexes 1
  • clusters, table
    • cluster keys 1
    • hash 1
    • index 1
  • Codd, E. F. 1
  • code points 1
  • collections
    • PL/SQL 1
  • collections, PL/SQL 1
  • columnar format 1 , 2
  • columns
    • cardinality 1 , 3
    • definition 1 , 2
    • invisible 1
    • multiple indexes on 1
    • order of 1
    • prohibiting nulls in 1
    • virtual 1 , 2 , 3
  • COMMENT statement 1
  • COMMIT statement 1
  • committing transactions
    • COMMIT statement 1
    • defined 1
    • ending transactions 1
    • fast commit 1
    • group commits 1
    • implementation 1
    • implicit commits 1
    • lost commit problem 1
    • two-phase commit 1
  • common privilege grants 1 , 2
  • common roles
    • granting 1 , 2
  • common users
    • granting privileges to 1 , 2
  • compiled PL/SQL
    • pseudocode 1
    • shared pool 1
    • triggers 1
  • complete recovery 1
  • complete refresh 1
  • composite indexes 1
  • compound triggers 1
  • compression
    • advanced index 1
    • basic table 1
    • data block 1
    • Hybrid Columnar Compression 1
    • index 1
    • In-Memory Column Store 1
    • OLTP table 1
    • online archival 1
    • prefix index 1
    • table 1 , 2
    • warehouse 1
  • compression, Hybrid Columnar 1
  • compression units, Hybrid Columnar 1
  • concatenated indexes 1
  • concurrency
    • definition 1
    • dirty reads 1
    • fuzzy reads 1
    • phantom reads 1
    • row locks 1
    • transaction isolation 1 , 2 , 3
  • conditions, SQL 1 , 2
  • conflicting writes 1
  • connections, client/server
    • administrator privileges 1
    • definition 1
    • embedded SQL 1
    • listener process 1
    • sessions contrasted with 1
  • connections, client server
    • listener process 1
  • consistency
    • conflicting writes 1
    • definition 1
    • locks 1 , 2
    • multiversioning 1 , 2
  • constraints, integrity
    • check 1 , 2
    • default values 1
    • deferrable 1 , 2 , 4
    • enabling and disabling 1
    • enforced with indexes 1
    • foreign key 1 , 2 , 3
    • mechanisms of enforcement 1
    • nondeferrable 1
    • NOT NULL 1 , 2 , 3
    • primary key 1 , 2 , 3
    • REF 1
    • referential 1
    • self-referential 1
    • state of 1
    • unique key 1 , 2
    • updates of foreign and parent keys 1
    • validating 1 , 2
  • container data objects 1
  • containers, CDB
    • root 1
  • contention
    • deadlocks 1
  • contexts 1
  • control files
    • changes recorded 1
    • checkpoints and 1
    • contents 1
    • multiplexed 1
    • overview 1
    • used in mounting database 1
  • cost-based optimizer
    • See: optimizer
  • CPU_COUNT initialization parameter 1
  • CREATE CLUSTER statement 1
  • CREATE DIMENSION statement 1
  • CREATE GLOBAL TEMPORARY TABLE statement 1
  • CREATE INDEX statement 1 , 2 , 3 , 4 , 5 , 7
  • CREATE MATERIALIZED VIEW statement 1
  • CREATE SEQUENCE statement 1
  • CREATE SYNONYM statement 1
  • CREATE TABLE statement
    • storage parameters 1
  • CREATE UNIQUE INDEX statement 1
  • CREATE USER statement
    • temporary segments 1
  • cursors
    • embedded SQL 1
    • explicit 1
    • fetching rows 1

D

  • data access languages 1
  • database applications 1
  • database authentication 1 , 2
  • database backups 1
  • database buffer cache
    • cache hits and misses 1
    • caching of comments 1
    • force full database caching mode 1
  • database buffers
    • after committing transactions 1
    • buffer bodies in flash cache 1
    • buffer cache 1
    • checkpoint position 1
    • committing transactions 1
    • definition 1
    • writing 1
  • Database Configuration Assistant (DBCA) 1
  • database consolidation 1
  • database instances
    • duration 1
  • database links, PDBs 1
  • database objects
    • metadata 1
  • database operations 1
  • database resident connection pooling 1
  • Database Resource Manager 1 , 2 , 3 , 4
  • databases
    • administrative accounts 1
    • closing
      • terminating the instance 1
    • definition 1 , 2
    • distributed
      • changing global database name 1
    • hierarchical 1
    • history 1
    • incarnations 1
    • introduction 1
    • mounting 1
    • name stored in control files 1
    • network 1
    • object-relational 1
    • opening 1 , 2
    • relational 1 , 2 , 3
    • shutting down 1
    • starting up
      • forced 1
    • structures
      • control files 1
      • data blocks 1 , 2 , 3
      • data files 1
      • extents 1 , 2
      • logical 1
      • processes 1
      • segments 1 , 2
      • tablespaces 1 , 2
  • Database Server Grid
    • description 1
  • Database Storage Grid
    • description 1
  • database structures
    • control files 1
    • data blocks 1 , 2 , 3
    • data files 1
    • extents 1
    • processes 1
    • segments 1 , 2
    • tablespaces 1 , 2
  • Database Upgrade Assistant (DBUA)
    • multitenant architecture support 1
  • database writer process (DBW)
    • multiple DBWn processes 1
  • database writer process (DBWn)
    • checkpoints 1
    • defined 1
    • least recently used algorithm (LRU) 1
    • write-ahead 1
  • data blocks
    • cached in memory 1
    • clustered rows 1
    • coalescing free space in blocks 1
    • compression 1
    • format 1 , 2
    • locks stored in 1
    • overview 1
    • shown in rowids 1
    • stored in the buffer cache 1
    • writing to disk 1
  • data concurrency
    • definition 1
  • data consistency 1
  • data conversion
    • program interface 1
  • data corruption 1
  • data dictionary
    • ALL_ prefixed views 1
    • cache 1
    • CDBs 1
    • comments in 1
    • content 1 , 2
    • DBA_ prefixed views 1
    • dictionary managed tablespaces 1
    • DUAL table 1
    • how database uses 1
    • locks 1
    • overview 1
    • PDBs 1
    • public synonyms 1
    • storage in a CDB 1
    • stored subprograms 1
    • USER_ prefixed views 1
  • data dictionary cache 1 , 2 , 3
  • data failures, protecting against human errors 1 , 3
  • data files
    • contents 1
    • data file 1 1
    • moving online 1
    • named in control files 1
    • shown in rowids 1
    • SYSTEM tablespace 1
    • temporary 1
  • data integrity
    • enforcing 1 , 2 , 3
    • SQL and 1
  • data manipulation language
    • See: DML
  • data object number, extended rowid 1
  • Data Recovery Advisor 1
  • data redaction
    • random 1
  • data segments 1
  • data types
    • BOOLEAN 1 , 2 , 3 , 4
    • built-in 1
    • character 1 , 2
    • composite types 1
    • conversions by program interface 1
    • DATE 1
    • datetime 1
    • definition 1
    • format models 1
    • how they relate to tables 1
    • in PL/SQL 1
    • NCHAR 1
    • NUMBER 1
    • numeric 1
    • NVARCHAR2 1
    • object 1
    • reference types 1
    • ROWID 1 , 2
    • TIMESTAMP 1
    • UROWID 1
    • user-defined 1 , 2
  • data warehouses
    • architecture 1
    • bitmap indexes in 1
    • dimensions 1
    • dimension tables 1 , 2
    • materialized views 1
    • partitioning in 1
    • summaries 1
  • DATE data type 1 , 2
  • datetime data types 1
  • DBA_ views 1
  • DBMS_METADATA package 1
  • DBMS_RADM package 1
  • DBMS_SPACE_ADMIN package 1
  • DBMS_SQL_MONITOR package 1
  • DBMS_STATS package 1
  • DBMS (database management system) 1
  • DBW background process 1
  • DDL (data definition language)
    • described 1
    • locks 1
  • deadlocks
    • definition 1
  • decision support systems (DSS)
    • materialized views 1
  • default values
    • effect of constraints 1
  • definer’s rights 1
  • DELETE statement
    • freeing space in data blocks 1
  • deletions, cascading 1
  • denormalized tables 1
  • dependencies, schema object 1
  • descending indexes 1
  • dictionary cache locks 1
  • dictionary managed tablespaces 1
  • dimensions
    • attribute-clustered tables 1 , 2 , 3
    • attributes 1
    • hierarchies
      • join key 1
    • normalized or denormalized tables 1
    • tables 1
  • dimension tables 1
  • directory objects 1
  • direct-path load 1
  • dirty reads 1 , 2
  • disk space
    • data files used to allocate 1
  • dispatcher processes
    • described 1
  • dispatcher processes (Dnnn)
    • client processes connect through Oracle Net Services 1 , 2
    • network protocols and 1
    • prevent startup and shutdown 1
    • response queue and 1
  • distributed databases
    • client/server architectures and 1
    • job queue processes 1
    • recoverer process (RECO) and 1
    • server can also be client in 1
    • transactions 1
  • distributed transactions
    • in-doubt 1
    • naming 1
    • two-phase commit and 1
  • DML (data manipulation language)
    • indexed columns 1
    • invisible indexes 1
    • locks 1
    • overview 1
    • referential actions 1
    • triggers 1
  • downtime
    • avoiding during planned maintenance 1
    • avoiding during unplanned maintenance 1
  • drivers 1
  • DUAL table 1
  • dynamic partitioning 1
  • dynamic performance views
    • database object metadata 1
    • storage 1
  • dynamic SQL
    • DBMS_SQL package 1
    • embedded 1

E

  • embedded SQL 1 , 2 , 3
  • EM Express 1 , 2
  • enqueued transactions 1
  • Enterprise Grids
    • with Oracle Real Application Clusters 1
  • Enterprise Manager
    • alert log 1
    • dynamic performance views usage 1
    • executing a package 1
    • lock and latch monitors 1
    • multitenant architecture support 1
    • shutdown 1 , 2
  • Enterprise Manager for Zero Data Loss Recovery Appliance plug-in
    • See: Recovery Appliance plug-in
  • equijoins 1
  • errors, recoverable 1 , 2
  • exceptions, PL/SQL 1
  • exclusive locks
    • row locks (TX) 1
    • table locks (TM) 1
  • EXECUTE statement 1
  • execution plans
    • EXPLAIN PLAN 1
  • EXPLAIN PLAN statement 1 , 2
  • explicit locking 1
  • expressions, SQL 1 , 2
  • extents
    • as collections of data blocks 1
    • deallocation 1
    • defined 1
    • dictionary managed 1
    • incremental 1
    • locally managed 1
    • overview of 1
  • external procedures 1
  • external tables 1 , 2 , 3
  • extraction, transformation, and loading (ETL)
    • overview 1

F

  • fact tables 1
  • failures
    • database buffers and 1
    • statement and process 1
  • fast commit 1
  • fast full index scans 1
  • fast recovery area 1
  • fast refresh 1 , 2
  • fast-start
    • rollback on demand 1
  • fields 1
  • file management locks 1
  • files
    • alert log 1
    • initialization parameter 1 , 2
    • password
      • administrator privileges 1
    • server parameter 1 , 2
    • trace files 1
  • fine-grained auditing 1
  • flash cache
    • buffer reads 1
    • optimized physical reads 1
  • floating-point numbers 1 , 2
  • force full database caching mode 1
  • foreign key constraints 1
  • foreign keys
    • changes in parent key values 1
    • composite 1
    • indexing 1 , 2
    • nulls 1
    • updating parent key tables 1
    • updating tables 1
  • format models, data type 1 , 2
  • free space
    • automatic segment space management 1
    • managing 1
  • full index scans 1
  • full table scans
    • LRU algorithm and 1
    • parallel exe 1
  • function-based indexes 1 , 2 , 3
  • functions
    • aggregate 1
    • analytic 1
    • function-based indexes 1
    • hash 1
    • PL/SQL 1
    • SQL 1
  • fuzzy reads 1

G

  • global database names
    • shared pool and 1
  • Global Data Services
    • GDS configuration 1
    • overview 1
    • purpose 1
  • global indexes 1 , 2
  • GoldenGate 1 , 2 , 3
  • GRANT statement 1 , 2
  • grid computing
    • Database Server Grid 1
    • Database Storage Grid 1
  • group commits 1

H

  • handles for SQL statements 1
  • hash clusters
    • cluster keys 1
    • hash collisions 1
    • hash key values 1
    • queries 1
    • single-table 1
    • storage 1
  • hash functions 1 , 2
  • hash partitioning 1
  • headers, data block 1
  • headers, data blocks 1
  • Health Monitor 1
  • heap-organized tables 1 , 2
  • height, index 1
  • hierarchies
    • join key 1
    • levels 1
  • high availability
    • applications 1
    • data corruption 1
  • hints, optimizer 1 , 2
  • Hybrid Columnar
    • compression units 1
  • Hybrid Columnar Compression
    • row-level locks 1

I

  • image copies 1
  • IM column store
    • See: In-Memory Column Store
  • implicit queries 1
  • IM space manager
    • See: In-Memory Space Manager
  • incarnations, database 1
  • incremental-forever strategy 1
  • incremental refresh 1 , 2
  • index clustering factor 1
  • index compression 1
  • indexes
    • advanced index compression 1
    • application domain 1
    • ascending 1
    • benefits 1
    • bitmap 1 , 2 , 3 , 4
    • bitmap join 1
    • branch blocks 1
    • B-tree 1 , 2
    • cardinality 1
    • composite 1
    • compressed 1
    • concatenated 1
    • definition 1 , 2
    • descending 1
    • domain 1
    • enforcing integrity constraints 1
    • extensible 1
    • fast full scans 1
    • function-based 1 , 2 , 3
    • global 1 , 2
    • index clustering factor 1
    • invisible 1
    • keys 1 , 2
    • leaf blocks 1
    • local partitioned 1
    • multiple 1
    • nonprefixed, local 1
    • nonunique 1
    • overview 1
    • partitioned 1
    • partitioning
      • index 1
    • partitions 1
    • prefixed, local 1
    • prefixes 1
    • range scans 1
    • reverse key 1
    • scans 1 , 2 , 3
    • secondary 1
    • segments 1 , 2
    • selectivity 1
    • storage 1 , 2
    • storage space 1
    • types 1
    • unique 1
    • unusable 1
  • indexes, local 1
  • indexes, partitioned
    • partial global 1
  • indexes, updates 1
  • index-organized tables
    • benefits 1
    • bitmap indexes 1
    • characteristics 1
    • partitioned 1
    • row overflow 1
    • secondary indexes 1
  • index unique scans 1
  • in-flight transactions 1
  • information systems 1
  • INIT.ORA
    • See: initialization parameter file.
  • initialization parameter file
    • startup 1
  • initialization parameters
    • about 1
    • basic 1
    • INMEMORY_SIZE 1
    • OPEN_CURSORS 1
    • SERVICE_NAMES 1
  • INMEMORY_MAX_POPULATE_SERVERS initialization parameter 1
  • INMEMORY_SIZE initialization parameter 1
  • In-Memory Column Store
    • benefits 1
    • columnar format 1
    • compression 1
    • consistency with buffer cache 1
    • dual memory formats 1
    • memory management 1
    • optimization of scans 1
    • Oracle RAC 1
    • population 1
    • population of columnar data 1
    • SQL execution 1
    • storage index 1
  • In-Memory Compression Units (IMCUs) 1
  • inner joins 1
  • in-place refresh method 1
  • INSERT statement 1
  • instance PGA
    • memory management 1
  • instances, database
    • associating with databases 1
    • duration 1
    • failure 1
    • failures 1
    • memory structures of 1
    • process structure 1
    • recovery of
      • SMON process 1
    • service names 1
    • shutting down 1 , 2
    • terminating 1
  • INSTEAD OF triggers 1
  • integrity constraints
    • advantages 1 , 2
    • check 1
    • definition 1
    • nondeferrable 1
    • updates of foreign and parent keys 1
    • validating 1
    • views 1
  • internal locks 1
  • internal tables 1
  • invisible columns 1
  • invisible indexes 1
  • invoker’s rights 1
  • isolation levels
    • read-only 1
    • serialization 1
    • setting 1
  • isolation levels, transaction
    • read committed 1

J

  • Java
    • overview 1
    • SQLJ translator 1
    • stored procedures 1 , 2
    • virtual machine 1
  • JDBC
    • accessing SQL 1
    • drivers 1
    • driver types 1
    • embedded SQL 1
  • job queue processes 1
  • jobs 1
  • join attribute clustering 1
  • joins
    • views 1
  • joins, table
    • Cartesian 1
    • clustered tables 1
    • conditions 1
    • inner joins 1
    • join conditions 1
    • outer joins 1
    • views 1
  • join views 1
  • JSON
    • comparison to XML 1
    • Oracle Database support 1
    • overview 1

K

  • key compression
    • See: prefix compression
  • keys
    • concatenation of index 1
    • foreign 1 , 3
    • indexes 1 , 2 , 3
    • natural 1
    • parent 1 , 2
    • partition 1
    • prefixed index 1
    • referenced 1 , 2
    • reverse 1
    • surrogate 1
    • unique 1
    • values 1

L

  • large pool 1
  • latches
    • definition 1
  • leaf blocks, index 1
  • least recently used (LRU) algorithm
    • database buffers and 1
    • full table scans and 1
    • latches 1
    • shared SQL pool 1
  • LGWR background process 1
  • library cache 1 , 2
  • Listener Control utility 1
  • listener process
    • service names 1
  • listeners
    • service names 1
  • list partitioning 1
  • local indexes 1
  • locally managed tablespaces 1
  • local partitioned indexes 1
  • local role 1
  • local roles 1
  • local rules 1
  • local users 1
  • lock
    • definition 1
  • locks
    • after committing transactions 1
    • automatic 1 , 2
    • bitmap indexes 1
    • conversion 1 , 3
    • deadlocks 1 , 2
    • dictionary 1
    • dictionary cache 1
    • DML 1
    • duration 1 , 2
    • escalation 1
    • exclusive 1
    • exclusive DDL 1
    • exclusive table 1
    • file management locks 1
    • Hybrid Column Compression 1
    • latches 1
    • log management locks 1
    • manual 1
    • overview of 1
    • parse 1
    • restrictiveness 1
    • rollback segments 1
    • row (TX) 1
    • row exclusive table 1
    • row share 1
    • share DDL 1
    • share locks 1
    • share row exclusive 1
    • share table 1
    • system 1
    • table 1 , 2
    • table (TM) 1
    • tablespace 1
    • types of 1
    • unindexed foreign keys and 1
    • user-defined 1
  • LOCK TABLE statement 1
  • log-based refresh 1
  • logical database structures
    • data blocks 1
    • definition 1
    • extents 1
    • segments 1
    • tablespaces 1 , 2
  • logical rowids 1
  • logical transaction IDs 1
  • log management locks 1
  • log switch
    • archiver process 1
  • log switches
    • log sequence numbers 1
  • log writer process (LGWR)
    • group commits 1
    • online redo logs available for use 1
    • redo log buffers and 1
    • write-ahead 1
    • writing to online redo log files 1
  • LONG data type
    • storage of 1
  • lost updates 1 , 2
  • LRU
    • shared SQL pool 1

M

  • maintenance tasks, automatic 1
  • maintenance window 1
  • manual locking 1
  • mapping tables 1
  • master tables 1
  • materialized views
    • characteristics 1
    • complete refresh 1
    • fast refresh 1
    • incremental refresh 1
    • in-place and out-of-place refresh 1
    • refresh
      • job queue processes 1
    • refreshing 1 , 2
    • zone maps and 1
  • media recovery
    • complete 1
    • overview 1
  • memory
    • allocation for SQL statements 1
    • content of 1
    • processes use of 1
    • stored procedures 1
  • memory management
    • about 1
    • automatic 1
    • automatic shared 1
    • instance PGA 1
  • MERGE statement 1
  • Messaging Gateway 1
  • metadata links, in CDBs 1
  • metrics 1 , 2
  • monitoring user actions 1
  • multiblock writes 1
  • multiplexing
    • control files 1
    • redo log file groups 1
    • redo log files 1
  • multitenant architecture
    • benefits 1 , 2
    • definition 1
    • user interfaces 1
  • multitenant container databases
    • See: CDBs
  • multiversion read consistency
    • dirty reads 1
    • read committed isolation level 1
    • statement-level 1 , 2
    • transaction-level 1
    • undo segments 1
  • mutexes 1

N

  • NaN (not a number) 1
  • natural keys 1
  • NCHAR data type 1
  • network listener process
    • connection requests 1
  • networks
    • client/server architecture use of 1
    • communication protocols 1 , 2
    • dispatcher processes and 1
    • drivers 1
    • listener processes of 1
    • Oracle Net Services 1
  • NLS_DATE_FORMAT parameter 1
  • NOAUDIT statement 1
  • non-CDBs
    • cloning as CDBs 1
  • nonunique indexes 1
  • normalized tables 1
  • NOT NULL constraints 1 , 2
  • nulls
    • foreign keys 1
    • how stored 1 , 2
    • indexed 1
    • prohibiting 1
  • NUMBER data type 1
  • numbers, floating point 1
  • numeric data types
    • floating-point numbers 1
  • NVARCHAR2 data type 1

O

  • object links, in CDBs 1
  • object tables 1 , 2
  • object types 1 , 2
  • object views 1
  • OLAP
    • index-organized tables 1
    • introduction 1
  • OLTP
    • table compression 1
  • online analytical processing
    • See: OLAP
  • online redo log
    • archiver process (ARCn) 1
    • buffer management 1
    • checkpoints 1
    • committed data 1
    • committing a transaction 1
    • log switch
      • archiver process 1
    • log writer process 1 , 2
    • rolling forward 1
    • undo data in 1
    • writing buffers 1
  • online redo log files 1
  • OPEN_CURSORS parameter
    • managing private SQL areas 1
  • operating systems
    • communications software 1
    • privileges for administrator 1
  • optimized physical reads 1
  • optimizer
    • adaptive optimization 1
    • components 1
    • estimator 1
    • execution 1
    • execution plans 1 , 2 , 3 , 4 , 5
    • function-based indexes 1
    • hints 1 , 2
    • invisible indexes 1
    • partitions in query plans 1
    • plan generator 1
    • query plans 1
    • query transformer 1 , 2
    • row sources 1
    • statistics 1 , 2 , 3
  • optimizer statistics 1
  • Oracle ASM (Automatic Storage Management) 1 , 2 , 3 , 4
  • Oracle Audit Vault and Database Firewall 1
  • Oracle Automatic Storage Management
    • See: Oracle ASM
  • Oracle blocks 1
  • Oracle Call Interface
    • See: OCI
  • Oracle code 1
  • Oracle Connection Manager Control utility 1
  • Oracle Database
    • history 1
  • Oracle Database Configuration Assistant (DBCA) 1
  • Oracle Data Pump
    • dump file set 1
  • Oracle Enterprise Manager
    • See: Enterprise Manager
  • Oracle Enterprise Manager Cloud Control 1
  • Oracle Enterprise Manager Cloud Control (Cloud Control)
    • See: Cloud Control
  • Oracle Enterprise Manager Database Express
    • See: EM Express
  • Oracle Flashback Technology 1 , 2
  • Oracle GoldenGate 1
  • Oracle interMedia
    • See: Oracle Multimedia
  • Oracle Internet Directory 1
  • Oracle JVM
    • main components 1
    • overview 1
  • Oracle Label Security 1
  • Oracle LogMiner 1
  • Oracle Management Agents 1
  • Oracle Management Repository 1
  • Oracle Management Service (OMS) 1
  • Oracle Multimedia 1
  • Oracle Multitenant option 1
  • Oracle Net 1
  • Oracle Net Configuration Assistant 1
  • Oracle Net Listener 1
  • Oracle Net Manager 1
  • Oracle Net Services
    • client/server systems use of 1
    • overview 1
    • shared server requirement 1
  • Oracle Net Services Connection Manager 1
  • Oracle processes 1
  • Oracle program interface (OPI) 1
  • Oracle RAC
    • See: Oracle Real Application Clusters
  • Oracle Real Application Clusters
    • Enterprise Grids 1
    • reverse key indexes 1
  • Oracle Secure Backup 1
  • Oracle Spatial and Graph 1
  • Oracle Text 1
  • Oracle Universal Installer (OUI) 1
  • Oracle XA
    • session memory in the large pool 1
  • ORDBMS (object-relational database management system) 1
  • outer joins 1
  • out-of-place refresh method 1

P

  • packages
    • advantages of 1
    • creation 1
    • executing 1
    • for locking 1
    • private 1
    • public 1
    • shared SQL areas and 1
    • subprogram executions 1
  • pages 1
  • parallel execution
    • coordinator 1
    • server 1
    • servers 1
    • tuning 1
  • parallel SQL
    • coordinator process 1
    • server processes 1
  • parameter
    • server 1
  • parameters
    • initialization
      • locking behavior 1
  • parse locks 1
  • parsing
    • embedded SQL 1
    • storage of information 1
  • parsing, SQL
    • hard parse 1
  • partial global partitioned indexes 1
  • partitioned change tracking refresh 1
  • partitioned indexes
    • global 1
    • storage 1
  • partitioned tables 1
  • partitioning
    • by hash 1
    • by list 1
    • by range 1
    • index 1
    • indexes 1
    • index-organized tables 1
    • key 1
  • partitions
    • characteristics 1
    • composite partitioning 1
    • definition 1
    • dynamic partitioning 1
    • elimination from queries 1
    • index 1
    • index-organized tables 1
    • keys 1
    • materialized views 1
    • overview 1
    • partitions
      • composite 1
    • range 1
    • segments 1
    • single-level 1
    • strategies 1
    • table 1 , 2 , 3
    • tables 1
  • partitions, table 1
  • passwords
    • administrator privileges 1
    • connecting with 1
  • PCTFREE storage parameter
    • how it works 1
  • PDBs
    • about 1
    • benefits 1
    • consolidation of data into 1
    • containers 1
    • creating by plugging in 1
    • creation 1
    • database links 1
    • data dictionary 1
    • definition 1
    • purpose of 1
  • performance
    • group commits 1
    • packages 1
  • PGA
    • See: program global area (PGA)
  • PGA_AGGREGATE_LIMIT initialization parameter 1
  • PGA_AGGREGATE_TARGET initialization parameter 1
  • phantom reads 1
  • physical database structures
    • control files 1 , 2
    • data files 1
    • online redo log files 1
  • physical guesses 1
  • PL/SQL
    • anonymous blocks 1 , 2
    • collections 1 , 2
    • data types 1
    • dynamic SQL 1
    • exceptions 1
    • execution 1
    • execution of subprograms 1
    • language constructs 1
    • overview 1
    • package creation 1
    • packages 1 , 2 , 3
    • PL/SQL engine 1
    • program units
      • compiled 1
      • shared SQL areas and 1
    • records 1 , 2 , 3
    • stored procedures 1 , 2 , 3 , 4 , 5 , 6
  • plan
    • SQL execution 1
  • planned downtime
    • avoiding downtime during 1
  • pluggable databases
    • See: PDBs
  • PMON background process 1
  • pragmas, PL/SQL 1
  • precompilers
    • embedded SQL 1
  • predicates, SQL
    • SQL
      • predicates 1
  • primary key constraints 1
  • primary keys
    • constraints 1
    • hash clusters 1
    • index-organized tables 1
  • private SQL areas
    • described 1
    • how managed 1
    • parsing and 1
  • private synonyms 1
  • privileges
    • administrator 1
    • granting 1
    • granting common 1 , 2
    • PL/SQL procedures and 1
    • revoking 1
  • privileges, database
    • granting 1
    • privilege profiler 1
  • procedures
    • advantages 1
    • execution 1 , 2
    • external 1
    • memory allocation 1
    • security 1
    • shared SQL areas and 1
    • stored procedures 1 , 2 , 3 , 4
  • processes
    • archiver (ARCn) 1
    • background 1 , 2
    • checkpoints and 1
    • client 1 , 2
    • dedicated server 1
    • definition 1
    • distributed transaction resolution 1
    • job queue 1
    • listener
      • shared servers and 1
    • log writer (LGWR) 1
    • Oracle 1
    • parallel execution coordinator 1
    • parallel execution servers 1
    • process monitor (PMON) 1
    • recoverer (RECO) 1
    • server
      • shared 1 , 2
    • shared server
      • client requests and 1
    • structure 1
    • system monitor (SMON) 1
    • user
      • recovery from failure of 1
      • sharing server processes 1
  • processing
    • parallel SQL 1
  • process monitor process (PMON)
    • described 1
  • program global area (PGA)
    • shared server 1
    • shared servers 1
  • program interface
    • Oracle side (OPI) 1
    • structure of 1
    • user side (UPI) 1
  • programming
    • server-side 1
  • programming, server-side 1
  • program units
    • shared pool and 1
  • protection policies
    • benefits 1
  • pseudocode
    • triggers 1
  • pseudocolumns 1 , 2
  • public synonyms 1

Q

  • queries
    • blocks 1
    • definition 1
    • implicit 1 , 2
    • in DML 1
    • parallel processing 1
    • query blocks 1
    • query transformer 1
    • SQL language and 1
    • stored 1
    • subqueries 1 , 2 , 3
  • query blocks 1
  • query optimizer
    • See: optimizer
  • query plans
    • partitioning and 1
  • query rewrite 1
  • query transformer 1

R

  • range partitioning 1
  • range partitions 1
  • range scans, index 1
  • RDBMS (relational database management system) 1
  • read committed isolation 1
  • read consistency
    • See: multiversion read consistency
  • read-only isolation level 1
  • read uncommitted 1
  • Real Application Clusters
    • cache fusion 1
    • system monitor process and 1
    • threads of online redo log 1
  • records, PL/SQL 1 , 2 , 3
  • recoverable errors 1 , 2
  • recoverer process (RECO)
    • in-doubt transactions 1
  • recovery
    • complete 1
    • database buffers and 1
    • distributed processing in 1
    • instance recovery
      • SMON process 1
    • media 1
    • media recovery
      • dispatcher processes 1
    • process recovery 1
    • required after terminating instance 1
    • rolling back transactions 1
    • tablespace
      • point-in-time 1
  • Recovery Appliance 1
  • Recovery Appliance backup modules 1
  • Recovery Appliance metadata database 1
  • Recovery Appliance plug-in 1
  • recovery catalog 1
  • Recovery Manager
    • backups 1
    • Recovery Appliance 1
  • Recovery Manager (RMAN)
    • architecture 1
  • redaction, data
    • policies 1
  • redo log buffer 1
  • redo log files
    • available for use 1
    • circular use of 1
    • contents of 1
    • distributed transaction information in 1
    • group members 1
    • groups, defined 1
    • instance recovery use of 1
    • LGWR and the 1
    • members 1
    • multiplexed 1
    • online, defined 1
    • redo entries 1
    • threads 1
  • redo logs buffer 1
  • redo records 1
  • REF constraints 1
  • referential integrity
    • examples of 1
    • self-referential constraints 1
  • refresh
    • incremental 1
    • job queue processes 1
    • materialized views 1 , 2
  • relational database management system
    • See: RDBMS
  • relations, simple 1
  • replication, Oracle Streams
    • master database 1
  • reserved words 1
  • response queues 1
  • RESULT_CACHE clause 1
  • result cache 1 , 2
  • result sets, SQL 1 , 2 , 3 , 4
  • results sets, SQL 1
  • reverse key indexes 1
  • REVOKE statement 1
  • rights, definer’s and invoker’s 1
  • roles
    • local 1 , 2
  • rollback
    • described 1
    • ending a transaction 1
    • implicit in DDL 1
    • statement-level 1
    • to a savepoint 1
  • rollback, statement-level 1
  • rollback, transaction 1
  • rollback segments
    • locks on 1
    • parallel recovery 1
    • use of in recovery 1
  • ROLLBACK statement 1
  • rolling back 1 , 2
  • root container 1 , 3 , 4
  • row chaining 1
  • row data (section of data block) 1
  • row directories 1
  • ROWID data type 1 , 2
  • rowids
    • foreign 1
    • index 1
    • logical 1 , 2
    • physical 1
    • row migration 1
    • scans 1
    • universal 1
  • row locks
    • concurrency 1
    • storage 1
  • row pieces 1
  • rows
    • addresses 1
    • chaining across blocks 1 , 2
    • clustered 1
    • definition 1 , 2
    • format of in data blocks 1
    • locking 1
    • locks on 1
    • migrating to new block 1
    • row set 1
    • row source 1
    • shown in rowids 1
    • storage 1
    • triggers 1
  • row source generation 1

S

  • sample schemas 1
  • savepoints
    • definition 1
    • implicit 1
    • rolling back to 1
    • SAVEPOINT statement 1
  • SAVEPOINT statement 1
  • SBT libraries 1
  • scans
    • cluster 1
    • fast full index 1
    • full index 1
    • full table 1 , 2 , 3
    • index 1 , 2
    • index skip 1
    • range 1
    • rowid 1
    • unique index 1
  • schema objects
    • definitions 1 , 2 , 3
    • dependencies 1 , 2
    • dimensions 1
    • indexes 1
    • introduction 1
    • materialized views 1
    • relationship to data files 1
    • sequences 1
    • storage 1
  • schemas 1 , 2
  • schemas, sample 1
  • SCN
    • See: system change numbers
  • secondary indexes
    • benefits 1
    • physical guesses 1
  • SecureFiles 1
  • security
    • administrator privileges 1
    • auditing 1
    • definer’s rights 1
    • program interface enforcement of 1
    • views 1
  • seed PDB 1 , 3
  • segment advisor 1
  • segments
    • data 1
    • defined 1
    • index 1 , 2
    • overview of 1
    • table storage 1
    • temporary
      • allocating 1
    • user 1
  • selectivity 1
  • select lists, SQL 1
  • SELECT statement 1
  • self-referential integrity constraints 1
  • sequences
    • characteristics 1
    • concurrent access 1
    • definition 1 , 2
    • surrogate keys 1
  • serializability, transactional 1
  • serialization isolation level 1
  • server parameter file
    • startup 1
  • server processes
    • listener process 1
  • servers
    • client/server architecture 1
    • shared
      • architecture 1 , 2
      • processes of 1 , 2
  • server-side programming
    • overview 1 , 2
  • SERVICE_NAMES parameter 1
  • service names 1
  • service oriented architecture 1
  • service-oriented architecture 1
  • service tiers
    • See: Recovery Appliance service tiers
  • session control statements 1
  • sessions
    • connections contrasted with 1
    • defined 1
    • memory allocation in the large pool 1
    • sequence generation in 1
  • SET CONSTRAINT statement 1
  • SET TRANSACTION statement 1 , 2
  • SGA
    • big table cache 1
    • In-Memory Column Store 1
  • SGA (system global area)
    • allocating 1
    • contents of 1
    • database buffer cache 1
    • data dictionary cache 1 , 2
    • large pool 1
    • redo log buffer 1 , 2
    • rollback segments and 1
    • shared and writable 1
    • shared pool 1 , 2
    • variable parameters 1
  • share DDL locks 1
  • shared pool
    • allocation of 1
    • dependency management and 1
    • described 1
    • flushing 1
    • latches 1
    • parse locks 1
  • shared server
    • described 1
    • dispatcher processes 1
    • Oracle Net Services or SQL*Net V2 requirement 1
    • processes 1
    • processes needed for 1
    • restricted operations in 1
    • session memory in the large pool 1
  • shared server processes (Snnn)
    • described 1
  • shared SQL areas
    • dependency management and 1
    • described 1
    • parse locks 1
    • procedures, packages, triggers and 1
  • share locks 1
  • shutdown
    • abnormal 1
    • prohibited by dispatcher processes 1
    • steps 1
  • SHUTDOWN ABORT statement 1
  • Simple Object Access Protocol (SOAP)
    • See: SOAP
  • simple triggers 1
  • single-level partitioning 1
  • SMON background process 1
  • SOA 1 , 2
  • SOAP (Simple Object Access Protocol) 1
  • software code areas 1
  • space management
    • extents 1
    • PCTFREE 1
    • row chaining 1
    • segments 1
  • Space Management Worker Processes (Wnnn) 1
  • SQL
    • conditions 1 , 2
    • data definition language (DDL) 1
    • data manipulation language (DML) 1
    • definition 1
    • dictionary cache locks 1
    • dynamic SQL 1
    • embedded 1 , 2
    • executable 1
    • execution 1 , 2
    • expressions 1 , 2
    • functions 1
    • implicit queries 1
    • interactive 1
    • memory allocation for 1
    • operators 1
    • optimization 1
    • Oracle 1 , 2
    • overview 1
    • parallel execution 1
    • parsing 1 , 2
    • PL/SQL and 1
    • predicates 1
    • processing 1
    • reserved words 1
    • result sets 1 , 2 , 3 , 4 , 5
    • select lists 1
    • session control statements 1
    • standards 1
    • statements 1
    • subqueries 1 , 2
    • system control statements 1
    • transaction control statements 1
    • transactions 1
    • types of statements 1
  • SQL*Loader 1
  • SQL*Plus
    • alert log 1
    • executing a package 1
    • lock and latch monitors 1
    • multitenant architecture support 1
  • SQL areas
    • private 1
    • shared 1
  • SQLJ standard 1
  • SQL tuning advisor 1
  • standard auditing 1
  • standards
    • ANSI/ISO
      • isolation levels 1
  • star schemas 1
  • startup
    • prohibited by dispatcher processes 1
  • statement-level atomicity 1
  • statement-level read consistency 1
  • statement-level rollback 1 , 2
  • statements, SQL 1
  • statistics
    • ASH 1
    • AWR 1
    • definition 1
    • gathering for optimizer 1
    • Java-related 1
    • join order 1
    • undo retention 1
  • statistics, optimizer 1
  • storage
    • logical structures 1
    • nulls 1
    • triggers 1
  • stored procedures
    • See: procedures
  • Structured Query Language (SQL) 1
  • structures
    • locking 1
    • logical
      • data blocks 1 , 2 , 3
      • extents 1 , 2
      • segments 1 , 2
      • tablespaces 1 , 2
    • physical
      • control files 1
      • data files 1
    • processes 1
  • subprograms
    • execution in a PL/SQL package 1
  • subprograms, PL/SQL
    • See: procedures
  • subqueries 1 , 2 , 3
  • summaries 1
  • surrogate keys 1
  • synonyms
    • constraints indirectly affect 1
    • data dictionary views 1
    • definition 1 , 2
    • private 1
    • public 1 , 2
    • securability 1
  • SYSDBA privilege 1
  • SYSOPER privilege 1
  • system change numbers
    • definition 1
    • when assigned 1
  • system change numbers (SCN)
    • committed transactions 1
    • defined 1
  • system control statements 1
  • system global area
    • See: SGA
  • system global area (SGA) 1
  • system locks
    • internal 1
    • latches 1
    • mutexes 1
  • system monitor process (SMON)
    • defined 1
    • Real Application Clusters and 1
    • rolling back transactions 1
  • SYSTEM tablespace
    • data dictionary stored in 1
    • online requirement of 1
  • SYSTEM user name 1
  • SYS user name
    • data dictionary tables 1

T

  • table clusters
    • cluster keys 1
    • definition 1
    • hash clusters 1 , 2 , 4
    • hash cluster storage 1
    • indexed 1
    • overview 1
    • scans 1
  • table partitions 1
  • tables
    • attribute-clustered 1
    • automatic big table caching 1 , 2
    • base 1 , 2
    • characteristics 1
    • clustered 1
    • compression 1 , 2
    • definition 1 , 2 , 3
    • dimension 1
    • directories 1
    • DUAL 1
    • dynamic partitioning 1
    • external 1 , 2 , 3
    • fact 1
    • full table scans 1
    • heap-organized 1 , 2
    • index-organized 1 , 2 , 3 , 4 , 5
    • integrity constraints 1
    • joins 1
    • master 1
    • normalized or denormalized 1
    • object 1
    • overview 1 , 2
    • partitioned 1 , 2 , 3
    • partitions 1
    • permanent 1
    • storage 1
    • temporary 1 , 3 , 4
    • transaction 1
    • truncating 1 , 2
    • views of 1
    • virtual 1
  • tables, attribute-clustered
    • dimensional hierarchies 1
    • linear ordering 1
    • zone maps 1 , 2
  • tables, base 1
  • tables, external 1
  • tables, object 1
  • tables, temporary 1
  • tablespace point-in-time recovery 1
  • tablespaces
    • described 1
    • dictionary managed 1
    • locally managed 1
    • locks on 1
    • offline 1
    • online 1
    • overview of 1
    • recovery 1
    • schema objects 1
    • space allocation 1
    • SYSTEM 1
    • used for temporary segments 1
  • tasks 1
  • temp files 1
  • temporary segments
    • allocating 1
    • allocation for queries 1
  • temporary tables
    • creation 1
  • threads
    • online redo log 1
  • TIMESTAMP data type 1 , 2
  • time zones
    • in date/time columns 1
  • TO_CHAR function 1
  • TO_DATE function 1 , 2
  • trace files
    • LGWR trace file 1
  • transaction control statements 1
  • Transaction Guard 1 , 2 , 3
  • transaction-level read consistency 1
  • transaction management
    • definition 1
  • transactions
    • ACID properties 1
    • active 1 , 2
    • assigning system change numbers 1
    • autonomous
      • within a PL/SQL block 1
    • beginning 1
    • blocking 1
    • committing
      • group commits 1
    • conflicting writes 1
    • deadlocks 1
    • deadlocks and 1
    • definition 1 , 2
    • distributed
      • resolving automatically 1
    • DML statements 1
    • ending 1
    • enqueued 1
    • idempotence 1 , 2
    • in-doubt
      • resolving automatically 1
    • in-flight 1
    • isolation levels 1 , 2 , 3
    • isolation of 1
    • logical transaction ID 1
    • naming 1
    • read consistency 1
    • rolling back
      • partially 1
    • savepoints in 1
    • serializability 1
    • setting properties 1
    • terminated 1
    • terminating the application and 1
    • transaction control statements 1
    • transaction history 1
    • transaction ID 1 , 2
  • transaction tables
    • reset at recovery 1
  • triggers
    • cascading 1
    • components of 1
    • compound 1
    • effect of rollbacks 1
    • firing (executing)
      • privileges required 1
    • INSTEAD OF 1
    • overview 1
    • restrictions 1
    • row 1
    • shared SQL areas and 1
    • simple 1
    • statement 1
    • storage of 1
    • timing 1
    • UNKNOWN does not fire 1
    • uses of 1
  • TRUNCATE statement 1 , 2
  • tuples, definition 1
  • two-phase commit
    • transaction management 1

U

  • undo management, automatic 1
  • undo retention period 1
  • undo segments
    • read consistency 1
  • undo segments, temporary 1 , 2 , 3
  • undo space management
    • automatic undo management mode 1
  • undo tablespaces
    • undo retention period 1
  • Unicode 1
  • unified audit trail 1 , 2 , 3
  • unique indexes 1
  • unique key constraints
    • composite keys 1
    • NOT NULL constraints and 1
  • unplanned downtime
    • avoiding downtime during 1
  • updatable join views 1
  • update no action constraint 1
  • updates
    • lost 1
    • updatability of views 1 , 2
    • updatable join views 1
  • UPDATE statement 1
  • updating tables
    • with parent keys 1
  • upgrades
    • database 1 , 2 , 3 , 4 , 5 , 6
  • UROWID data type 1
  • USER_ views 1
  • user global area (UGA) 1
  • user program interface (UPI) 1
  • users, database
    • authentication 1
    • common 1 , 2
    • names
      • sessions and connections 1
    • privileges 1
    • temporary tablespaces 1
  • user segments 1
  • UTL_HTTP package 1

V

  • V$ views
    • database object metadata 1
    • storage 1
  • VARCHAR2 data type 1 , 2
  • variables
    • embedded SQL 1
  • views
    • base tables 1
    • characteristics 1
    • constraints indirectly affect 1
    • data access 1
    • data dictionary
      • updatable columns 1
    • definition 1
    • DML 1
    • dynamic performance 1 , 2
    • indexes 1
    • INSTEAD OF triggers 1
    • integrity constraints 1
    • materialized 1
    • object 1
    • schema object dependencies 1
    • storage 1
    • updatability 1
    • uses 1
    • V$ 1
  • virtual columns 1 , 2 , 3

W

  • warehouse
    • materialized views 1
  • Web services 1 , 2
  • write-ahead 1

X

  • XA
    • session memory in the large pool 1
  • XMLType data type 1

Z

  • Zero Data Loss Recovery Appliance
    • See: Recovery Appliance
  • zone maps 1 , 2