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 2.6.3
• access paths, data 3.1.1, 3.4.2, 8.3.1, 8.3.3
• accounts, user 7.1
• ACID properties 11.1
• active transactions 11.2.2
• ADDM (Automatic Database Diagnostic Monitor) 19.3.4.3, 19.3.4.4
• administrative accounts 2.1.4, 7.1.1
• administrator privileges 2.1.4, 14.2.1.1, 17.2.4.2, 18.1.1.1
• ADR 14.6.1
• advanced index compression 3.2.5.2
• Advanced Queuing 18.5.2.2
• aggregate function 18.4.4.1
• alert logs 14.6.2, 16.4.1.6.2
• ALL_ data dictionary views 7.1.1.2
• ALTER TABLE statement 2.2.3
• analytic functions 18.4.4.1
• analytic views 18.4.4.2
• anonymous PL/SQL blocks 9.2
• ANSI/ISO standard 8.1.2
• APIs (application program interfaces) 17.3
  • client-side 20.3.2.2
  • embedded SQL statements 8.2.6
  • external tables 2.6.3
  • Java 9.3.1.1, 20.3.2.1.2, 20.3.2.2.2
  • JDBC 8.2.6, 11.4.2, 20.3.2.2.2
  • network services 17.2.1
  • OCI/OCCI 20.3.2.2.1
  • ODBC 8.2.6, 20.3.2.2.2
  • Oracle Database Advanced Queuing 18.5.2.2.2
  • Oracle Data Pump 19.2.5.2
• application and networking architecture 1.5.4.1, 17
• application contexts, auditing 18.1.6.1
• Application Continuity 11.4, 18.2.1.4
  • architecture 11.4.2
  • benefits 11.4.1
  • planned maintenance 11.4.1.2
  • use case 11.4.1.1
• application data usage
  • schema annotations 6.1
• application developers
  • duties of 20.1
  • tools for 20.2
  • topics for 20.3
• application domain indexes 3.5
• application processes 16.2
• application program interface
  • See: API
• applications
  • upgrades 18.2.2.3
• application servers 1.5.4.1, 9.3.1.2
  • about 17.1.2.2
• archived redo log files 12.3.3, 12.4.2.3, 19.3.1.4.4
• ARCHIVELOG mode 16.4.2.1
• archiver process (ARCn) 16.4.2.1
• ascending indexes 3.2.4
• ASSM tablespace 13.1.2.1.1
• asynchronous notifications 18.5.2.2.2
• atomicity, statement-level 11.1.3
• attribute-clustered tables
  • benefits 2.4.1
  • dimensional hierarchies 2.4.5
  • interleaved ordering 2.4.5
  • join attribute clustering 2.4.2
  • linear ordering 2.4.4
  • overview 2.4
  • zone maps 2.4.3, 2.4.3.1
• auditing 7.1, 7.1.3, 8.2.1, 9.4.1, 12.1.3, 14.2.1.4.1, 18.1.6.1
  • application contexts 18.1.6.1
  • Audit Administrator role 18.1.6.1.2
  • audit policies 18.1.5.3, 18.1.6.1.1
  • audit records 18.1.6.2
  • fine-grained 18.1.6.1
  • Oracle Audit Vault and Database Firewall 18.1.6.4
  • Oracle Database Vault 18.1.5.1
  • Oracle Label Security 18.1.5.3
  • standard 18.1.6.1
  • unified audit trail 17.1.2.3, 18.1.5.3, 18.1.6.2
• AUDIT statement 8.2.1
• authentication, database 8.2.4, 16.2.2, 18.1.2
• automated indexes 3.1.1, 3.1.7
• automatic big table caching 15.4.1.4.1, 15.4.1.5
• Automatic Database Diagnostic Monitor
  • See: ADDM
• Automatic Diagnostic Repository (ADR) 14.6.1, 14.6.2
• automatic maintenance tasks 19.3.4.2
• automatic memory management 19.3.2.1, 19.3.2.2
• automatic segment space management (ASSM) 13.1.2.1.1
• automatic undo management 13.4.3, 13.5.1.3.1
• Automatic Workload Repository (AWR) 19.3.4.2
• AutoTask 19.3.4.2
• AWR
  • See: Automatic Workload Repository (AWR)
• AWR reports 19.3.4.2

---

B

• background processes 1.5.3.1, 16.4
  • mandatory 16.4.1
  • optional 16.4.2
  • PMAN 16.4.1.2
• backup and recovery
  • definition 19.3.1
  • incremental-forever strategy 19.3.1.5.1
  • techniques 19.3.1.1
• backups 19.3.1
  • backup sets 19.3.1.3.3
  • image copies 19.3.1.3.3
  • partial database 19.3.1.3.1
  • Recovery Manager 19.3.1.1
  • technique comparisons 19.3.1.1
  • whole database 19.3.1.3.1
• big table cache 15.4.1.5
• BINARY_DOUBLE data type 2.2.4.2.2
• BINARY_FLOAT data type 2.2.4.2.2
• bitmap indexes 3.3
  • bitmap joins 3.3.2
  • locks 3.3
  • mapping table 3.6.3.2
  • single-table 3.3.1
  • storage 3.3.3
• bitmap tablespace management 13.1.2.1
• blocking transactions 10.2.1.2
• blocks, data
  • See: data blocks
• BOOLEAN data type 2.2.4, 3.2.2.3, 8.2.2.1, 9.4.4
• branch blocks, index 3.2.1
• B-tree indexes 2.2.6.3, 2.3.1, 3.2
  • branch level 3.2.1
  • height 3.2.1
  • prefix compression 3.2.5.1
  • reverse key 3.2.3
• buffer cache, database
  • See: database buffer cache
• buffers
  • See: database buffers
• business rules, enforcing 5.1.1, 5.1.2

---

C

• cache fusion 10.1.1.3
• cardinality, column 3.3, 8.3.2.2
• Cartesian joins 8.2.2.2
• cartridges 3.5
• cascading deletions 5.2.4.3
• catalog.sql script 7.2.1
• CDBs 1.5.1.1
  • Oracle Flashback Technology 19.3.1.4.1
• chaining, rows
  • See: row chaining
• character data types 2.2.4.1
  • VARCHAR2 2.2.4.1
• character sets 2.2.4.1
  • ASCII 2.2.4.1
  • client 20.3.3.1.1
  • database 20.3.3.1.1
  • EBCDIC 2.2.4.1
  • Unicode 2.2.4.1, 20.3.3.1.1
• CHAR data type 2.2.4.1.1
• check constraints 5.2, 5.2.5
• checkpoint process (CKPT) 16.4.1.7
• checkpoints
  • control files 12.3.1
  • database shutdowns 14.2.2.1
  • definition 14.3
  • inconsistent backups 19.3.1.3.2
  • incremental 14.3.2
  • position 14.4.4
  • thread 14.3.2
• chunk 4.2.1
• cleanup helper processes (CLnn) 16.4.1.1.3
• cleanup main process (CLMN) 16.4.1.1.2
• client/server architecture 17.1.1
  • advantages 17.1.1.2
• client processes 1.5.3.1, 16.2
  • connections and 16.2.2
  • sessions and 16.2.2
  • shared server processes and 17.2.4.1.2
• client result cache 15.4.3.3
• client-side programming 9.1
• CLMN background process 16.4.1.1.2
• CLnn background processes 16.4.1.1.3
• Cloud Control 19.2.1.1
• cluster indexes 2.3.1
• clusters, table 2.3.2
  • cluster keys 2.3
  • hash 2.3.2
  • index 2.3.2
• Codd, E. F. 1.1.2
• code points 2.2.4.1
• collections, PL/SQL 9.2.5, 9.2.5.1
• columns
  • cardinality 3.3, 8.3.2.2
  • definition 1.2.1, 2.2.1
  • invisible 2.2.1.2
  • multiple indexes on 3.1.4
  • order of 2.2.6.1
  • prohibiting nulls in 5.2.1
  • virtual 2.2.1.1, 2.2.6.1, 3.4.2
• COMMENT statement 8.2.1
• COMMIT statement 8.2.3
• committing transactions
  • COMMIT statement 8.2.3
  • defined 11.1
  • ending transactions 11.1.2.2
  • fast commit 16.4.1.6.1
  • group commits 16.4.1.6.1
  • implementation 16.4.1.6.1
  • implicit commits 8.2.1
  • lost commit problem 11.3.2.1
  • two-phase commit 11.6.1
• compiled PL/SQL
  • pseudocode 9.4.6
  • shared pool 9.2.6
  • triggers 9.4.6
• complete recovery 19.3.1.4.4
• complete refresh 4.4.2.1
• composite indexes 3.1.4
• composite partitioning 4.1.1.2.6
• compound triggers 9.4.3
• compression
  • advanced index 3.2.5.2
  • archive 2.2.7.2.1
  • basic table 2.2.7.1
  • data block 13.2.3
  • Hybrid Columnar Compression 2.2.7.2, 2.2.7.2.1
  • index 3.2.5
  • OLTP table 2.2.7.1
  • prefix index 3.2.5.1
  • table 2.2.7, 4.1.2.2
  • units of Hybrid Columnar Compression 2.2.7.2.2
  • warehouse 2.2.7.2.1
• concatenated indexes 3.1.4
• concurrency
  • definition 10.1
  • dirty reads 10.1.3
  • fuzzy reads 10.1.3
  • phantom reads 10.1.3
  • row locks 10.4.1.1.1
  • transaction isolation 10.1.3, 10.2.2, 10.2.3
• conditions, SQL 8.1.1, 8.2.2.1
• conflicting writes 10.2.1.2
• connections, client/server
  • administrator privileges 14.2.1.1
  • definition 16.2.2
  • embedded SQL 8.2.6, 20.3.2.1
  • listener process 1.5.4.2, 17.2.2
  • sessions contrasted with 16.2.2
• consistency
  • conflicting writes 10.2.1.2
  • definition 10.1
  • locks 10.1.2, 10.5
  • multiversioning 10.1, 10.1.1
• constraints, integrity
  • check 5.2, 5.2.5
  • default values 5.3.3.1
  • deferrable 5.2.3, 5.3.2.2, 8.2.3
  • enabling and disabling 5.3.1
  • enforced with indexes 5.2.3
  • foreign key 5.2, 5.2.4, 5.2.4.4
  • mechanisms of enforcement 5.3.3
  • nondeferrable 5.3.2.1
  • NOT NULL 2.2.3, 5.2, 5.2.1
  • primary key 2.2.3, 5.2, 5.2.3
  • REF 5.2
  • referential 5.2.4.3
  • self-referential 5.2.4.1
  • state of 5.3
  • unique key 5.2, 5.2.2
  • updates of foreign and parent keys 5.3.3.2
  • validating 5.3.1, 5.3.2
• contention
  • deadlocks 10.3.6
• contexts 2.1.1
• control files 1.5.2.1, 12.3
  • changes recorded 12.3.1
  • checkpoints and 12.3.1
  • contents 12.3.1
  • multiplexed 12.3.2
  • overview 12.3
  • used in mounting database 14.2.1.3
• cost-based optimizer
  • See: optimizer
• CREATE CLUSTER statement 2.3.1
• CREATE DIMENSION statement 4.6.2
• CREATE GLOBAL TEMPORARY TABLE statement 2.5.3
• CREATE INDEX statement 2.5.3, 3.1.3, 3.1.4, 3.1.8, 3.2.4, 3.4.1
• CREATE MATERIALIZED VIEW statement 4.4
• CREATE SEQUENCE statement 4.5.1
• CREATE SYNONYM statement 4.7
• CREATE TABLE statement 2.2, 2.2.3, 2.2.6
  • storage parameters 13.4.1.1
• CREATE UNIQUE INDEX statement 5.2.3
• CREATE USER statement
  • temporary segments 13.4.2.1
• cursors
  • embedded SQL 8.2.6
  • explicit 9.2.4
  • fetching rows 8.2.6

---

D

• data access languages 1.3
• database applications 1.1.1
• database authentication 8.2.4, 16.2.2
• database backups 19.3.1.3.1
• database buffer cache 2.2.7, 15.4.1, 16.4.1.5
  • cache hits and misses 15.4.1.4.3
  • caching of comments 7.1.3.2
  • force full database caching mode 15.4.1.6.5
• database buffers
  • after committing transactions 11.2.5
  • buffer bodies in flash cache 15.4.1.4.3
  • buffer cache 15.4.1
  • checkpoint position 16.4.1.5
  • committing transactions 16.4.1.6.1
  • definition 15.4.1
  • writing 16.4.1.5
• Database Configuration Assistant (DBCA) 19.2.3
• database instances 1.5.1
  • See: instances, database
  • duration 14.1.4
  • read/write 14.1.3
  • read-only 14.1.3
• database objects 1.2
  • metadata 7.3
• database operations 16.2.3
• database resident connection pooling 17.2.5
• Database Resource Manager 18.1.1.4, 18.3.1.3, 19.3.3.1
• databases
  • administrative accounts 2.1.4
  • closing 14.2.2.2
    • terminating the instance 14.2.2.2.2
  • definition 1.1, 1.5.1
  • distributed 18.5.1.1
    • changing global database name 15.4.3.1.3
  • hierarchical 1.1.1
  • history 1.1.4
  • incarnations 19.3.1.4.4
  • introduction 1
  • mounting 14.2.1.3
  • multiprocess 16.1.2
  • multiuser 16.1.2
  • name stored in control files 12.3.1
  • network 1.1.1
  • object-relational 1.1.3
  • opening 14.2.1.4, 14.2.1.4.1
  • relational 1.1.2, 1.1.3, 8.1
  • shutting down 14.2.2
  • starting up 2.1.4, 14.1
    • forced 14.2.2.4
  • structures
    • control files 12.3
    • data blocks 13, 13.2, 13.2.5
    • data files 12
    • extents 13.1, 13.3
    • logical 13
    • processes 16
    • segments 13.1, 13.4
    • tablespaces 12, 13.5
• Database Server Grid 18.3
  • description 18.3.1
• Database Storage Grid 18.3
  • description 18.3.3
• database structures
  • control files 12.3
  • data blocks 13, 13.2, 13.2.5
  • data files 12
  • extents 13.1
  • processes 16
  • segments 13.1, 13.4
  • tablespaces 12, 13.5
• Database Upgrade Assistant (DBUA) 19.2.3
• database writer process (DBW) 16.4.1.5
  • multiple DBWn processes 16.4.1.5
• database writer process (DBWn)
  • checkpoints 16.4.1.5
  • defined 16.4.1.5
  • least recently used algorithm (LRU) 15.4.1.6
  • write-ahead 16.4.1.6
• data blocks 1.5.2.2, 13.1
  • cached in memory 15.4.1.6
  • clustered rows 2.3
  • coalescing free space in blocks 13.2.4.2.2
  • compression 13.2.3
  • format 13.2.2, 13.2.2.2
  • locks stored in 10.4.1.1.2
  • overview 13.1.1
  • shown in rowids 13.2.2.2.3
  • stored in the buffer cache 15.4.1
  • writing to disk 15.4.1.6
• data concurrency
  • definition 1.4.2
• data consistency 1.4.3
• data conversion
  • program interface 17.3
• data corruption 18.2.1.4
• data dictionary 2.1.4, 2.2.5
  • ALL_ prefixed views 7.1.1.2
  • cache 15.4.3
  • comments in 8.2.1
  • content 7.1.1, 15.4.3.2
  • DBA_ prefixed views 7.1.1.1
  • dictionary managed tablespaces 13.1.2.2
  • DUAL table 7.1.1.4
  • how database uses 7.1.3
  • locks 10.4.2
  • overview 7.1
  • public synonyms 7.1.3.1
  • stored subprograms 9.2.1.2
  • USER_ prefixed views 7.1.1.3
• data dictionary cache 7.1.3.2, 15.4.3, 15.4.3.2
• data failures, protecting against human errors 11.3, 18.2.1.5
• data files 1.5.2.1
  • contents 12.2.4
  • data file 1 13.5.1.1
  • moving online 12.2.3
  • named in control files 12.3.1
  • shown in rowids 13.2.2.2.3
  • SYSTEM tablespace 13.5.1.1
  • temporary 12.2.2
• data integrity 5.1
  • enforcing 5.1, 5.1.1, 7.1.3
  • SQL and 8.1
• data manipulation language
  • See: DML
• data object number, extended rowid 13.2.2.2.3
• Data Recovery Advisor 19.3.1.4.2
• data redaction 18.1.4
  • random 18.1.4
• data segments 13.4.1
• data types
  • BOOLEAN 2.2.4, 3.2.2.3, 8.2.2.1, 9.4.4
  • built-in 2.2.4
  • character 2.2.4.1, 2.2.4.1.1
  • composite types 2.2.4
  • conversions by program interface 17.3
  • DATE 2.2.4.3.1
  • datetime 2.2.4.3
  • definition 2.2.4
  • format models 2.2.4.3.1
  • how they relate to tables 2.2.1
  • in PL/SQL 2.2.4
  • NCHAR 2.2.4.1.2
  • NUMBER 2.2.4.2.1
  • numeric 2.2.4.2
  • NVARCHAR2 2.2.4.1.2
  • object 2.9
  • reference types 2.2.4
  • ROWID 2.2.4.4, 2.2.4.4.1
  • TIMESTAMP 2.2.4.3.2
  • UROWID 2.2.4.4
  • user-defined 2.2.4, 4.3.3
• data warehouses
  • architecture 18.4.2
  • bitmap indexes in 3.3
  • dimensions 4.6
  • dimension tables 4.6.1, 4.6.2
  • materialized views 4.4
  • partitioning in 4.1
  • summaries 4.4
• DATE data type 2.2.4.3, 2.2.4.3.1
• datetime data types 2.2.4.3
• DBA_ views 7.1.1.1
• DBMS_METADATA package 7.3
• DBMS_RADM package 18.1.4
• DBMS_SERVICE package 11.4.1.2
• DBMS_SPACE_ADMIN package 13.4.1.1
• DBMS_SQL_MONITOR package 16.2.3
• DBMS_STATS package 8.3.4
• DBMS (database management system) 1.1.1
• DBW background process 16.4.1.5
• DDL (data definition language) 7.1
  • described 8.2.1
  • locks 10.4.2
• deadlocks 8.4.1.1
  • definition 10.3.6
• decision support systems (DSS)
  • materialized views 4.4
• default values
  • effect of constraints 5.3.3.1
• deferred inserts 10.1.1.4, 15.4.4.2
• definer’s rights 9.2.1.1
• DELETE statement 8.2.2
  • freeing space in data blocks 13.2.4.2
• deletions, cascading 5.2.4.3
• denormalized tables 4.6.2
• dependencies, schema object 2.1.3
• descending indexes 3.2.4
• dictionary cache locks 10.4.3.3
• dictionary managed tablespaces 13.1.2.2
• dimensions 4.6
  • attribute-clustered tables 2.4, 2.4.1, 2.4.5
  • attributes 4.6.2
  • hierarchies 4.6.2
    • join key 4.6.2
  • normalized or denormalized tables 4.6.2
  • tables 4.6.1
• dimension tables 4.6.1
• directory objects 2.1.1
• direct path loads
  • Hybrid Columnar Compression 2.2.7.2.3
• dirty reads 10.1.1, 10.1.3
• disk space
  • data files used to allocate 12.2.4
• dispatcher processes (Dnnn)
  • client processes connect through Oracle Net Services 17.2.4, 17.2.4.1.1
  • network protocols and 17.2.4.1.1
  • prevent startup and shutdown 17.2.4.2
  • response queue and 17.2.4.1
• distributed databases 18.5.1.1
  • client/server architectures and 17.1.1.1
  • job queue processes 16.4.2.2
  • recoverer process (RECO) and 16.4.1.9
  • server can also be client in 17.1.1.1
  • transactions 11.6
• distributed transactions 11.2.1, 11.6, 18.5.1.1
  • in-doubt 11.6.2
  • naming 11.2.1
  • two-phase commit and 11.6
• DML (data manipulation language)
  • indexed columns 3.3
  • invisible indexes 3.1.2
  • locks 10.4.1
  • overview 8.2.2
  • referential actions 5.2.4.3
  • triggers 9.4.1
• downtime
  • avoiding during planned maintenance 18.2.2
  • avoiding during unplanned maintenance 18.2.1.2
• drivers 17.3.2
• DUAL table 7.1.1.4
• dynamic partitioning 16.4.3.2.3
• dynamic performance views 7.2, 7.2.1
  • database object metadata 7.3
  • storage 7.2.2
• dynamic SQL
  • DBMS_SQL package 9.2.4
  • embedded 9.2.4, 20.3.2.1

---

E

• embedded SQL 8.1, 8.2.6, 9.3.2.2.2, 20.3.2.1
• EM Express 19.2.1.2
• enqueued transactions 11.2.3.2
• Enterprise Grids
  • with Oracle Real Application Clusters 18.3
• Enterprise Manager 14.2.2.4, 19.2.1
  • alert log 14.6.2
  • dynamic performance views usage 7.2
  • executing a package 9.2.2.3
  • lock and latch monitors 10.4.3
  • shutdown 14.2.2.1, 14.2.2.4
• Enterprise Manager for Zero Data Loss Recovery Appliance plug-in
  • See: Recovery Appliance plug-in
• equijoins 3.3.2
• errors, recoverable 11.3, 18.2.1.4
• exceptions, PL/SQL 9.2.4
• exclusive locks 10.3.3
  • row locks (TX) 10.4.1.1
  • table locks (TM) 10.4.1.2
• EXECUTE statement 9.2.1.3
• execution plans 4.4.3, 8.3.1, 8.3.2.3, 19.3.4.5.5
  • EXPLAIN PLAN 8.2.2
• EXPLAIN PLAN statement 8.2.2, 19.3.4.5.1
• explicit locking 10.5
• expressions, SQL 3.1.3, 8.2.2.1
• extents 1.5.2.2
  • as collections of data blocks 13.3
  • deallocation 13.3.2
  • defined 13.1.1
  • dictionary managed 13.1.2.2
  • incremental 13.3.1
  • locally managed 13.1.2.1
  • overview of 13.3
• external procedures 9.2.6
• external tables 2.2, 2.6, 2.6.4
  • purpose 2.6.1
• extraction, transformation, and loading (ETL)
  • overview 18.4.3

---

F

• fact tables 4.6.1
• failures
  • database buffers and 14.4.1
  • statement and process 16.4.1.1
• fast commit 16.4.1.6.1
• fast full index scans 3.2.2.2
• fast recovery area 19.3.1.2
• fast refresh 4.4.2, 4.4.2.2
• fields 2.2.3
• file management locks 10.4.3.3
• files
  • alert log 16.4.1.6.2
  • initialization parameter 14.2.1.2, 14.5
  • password
    • administrator privileges 14.2.1.1
  • server parameter 14.2.1.2, 14.5
  • trace files 16.4.1.6.2
• fine-grained auditing 18.1.6.1
• fixed SGA 15.4.6
• flash cache
  • buffer reads 15.4.1.4.3
  • optimized physical reads 15.4.1.4.3
• floating-point numbers 2.2.4.2, 2.2.4.2.2
• force full database caching mode 15.4.1.6.5
• foreign keys 2.2.3, 5.2.4
  • changes in parent key values 5.2.4.3
  • composite 5.2.4
  • constraints 5.2
  • indexing 3.1.3, 5.2.4.4
  • nulls 5.2.4.2
  • updating parent key tables 5.2.4.3
  • updating tables 10.4.1.3
• format models, data type 2.2.4.3.1, 2.2.4.5
• free space
  • automatic segment space management 13.2.4
  • managing 13.2.4
• full index scans 3.2.2.1
• full table scans 3.1.1, 3.2.2.2, 8.3.3
  • default mode 15.4.1.6.1
  • LRU algorithm and 15.4.1.6
  • parallel exe 16.4.3.2.3
• function-based indexes 3.4, 3.4.1, 3.4.2
• functions 8.2.2.1
  • aggregate 18.4.4.1
  • analytic 18.4.4.1
  • function-based indexes 3.4
  • hash 4.1.1.2.4
  • PL/SQL 9.2.1
  • SQL 2.2.4.4.2
• fuzzy reads 10.1.3

---

G

• GDSCTL utility 11.4.1.2
• global database names
  • shared pool and 15.4.3.1.3
• global indexes 4.1.3, 4.1.3.2
• globalization support 20.3.3.1
• GRANT statement 4.7, 8.2.1
• grid computing
  • Database Server Grid 18.3
  • Database Storage Grid 18.3
• group commits 16.4.1.6.1

---

H

• handles for SQL statements 15.3.1.1
• hash clusters 2.3.2
  • cluster keys 2.3.2.1
  • hash collisions 2.3.2.4
  • hash key values 2.3.2.1
  • queries 2.3.2.2
  • single-table 2.3.2.3
  • storage 2.3.2.4
• hash functions 2.3.2, 4.1.1.2.4
• hash index 15.4.7.2
• hash partitioning 4.1.1.2.4
• headers, data block 10.4.1.1.2, 13.2.2.1
• Health Monitor 19.3.1.4.2
• heap-organized tables 2.1.2, 3.6
• height, index 3.2.1
• hierarchies
  • join key 4.6.2
  • levels 4.6.2
• high availability
  • applications 18.2.2.3
  • data corruption 18.2.1.4
• hints, optimizer 8.3.1, 8.3.5, 15.4.4.2
• Hybrid Columnar Compression 2.2.7.2, 2.2.7.2.1
  • compression units 2.2.7.2.2
  • DML 2.2.7.2.3
  • row-level locks 2.2.7.2.2

---

I

• image copies 19.3.1.3.3
• IM column store
  • See: In-Memory Column Store
• immutable tables
  • about 2.8
• IM space manager
  • See: In-Memory Space Manager
• incarnations, database 19.3.1.4.4
• incremental-forever strategy 19.3.1.5.1
• incremental refresh 4.4.2, 4.4.2.2
• index clustering factor 3.2.2.6
• index compression 3.2.5
• indexes
  • advanced index compression 3.2.5.2
  • application domain 3.5
  • ascending 3.2.4
  • automated 3.1.1, 3.1.7
  • benefits 3.1.1
  • bitmap 3.3, 3.3.1, 3.3.3, 3.6.3.2
  • bitmap join 3.3.2
  • branch blocks 3.2.1
  • B-tree 2.2.6.3, 3.2
  • cardinality 3.3
  • composite 3.1.4
  • compressed 3.2.5.1
  • concatenated 3.1.4
  • definition 1.2.2, 2.1.1
  • descending 3.2.4
  • domain 3.5
  • enforcing integrity constraints 5.2.3
  • extensible 3.5
  • fast full scans 3.2.2.2
  • function-based 3.4, 3.4.1, 3.4.2
  • global 4.1.3, 4.1.3.2
  • index clustering factor 3.2.2.6
  • invisible 3.1.2
  • keys 3.1.3, 5.2.3
  • leaf blocks 3.2.1
  • local 4.1.3
  • local partitioned 4.1.3.1
  • multiple 3.1.4
  • nonprefixed, local 4.1.3.1.1
  • nonunique 3.1.5
  • overview 3.1
  • partitioned 4.1.3, 4.1.3.1.2, 4.1.4
  • partitioning
    • index 4.1.3.1.2
  • prefixed, local 4.1.3.1.1
  • prefixes 3.2.5.1
  • range scans 3.2.2.3
  • reverse key 3.2.3
  • scans 3.2.2, 3.2.2.5, 8.3.3
  • secondary 3.6.3
  • segments 3.1.8, 3.3.3
  • selectivity 3.2.2.3
  • storage 3.1.8, 4.1.3.1.2
  • storage space 4.1.4
  • types 3.1.6
  • unique 3.1.5
  • unusable 3.1.2
• indexes, updates 3.1.7
• index-organized tables 3.6, 3.6.3
  • benefits 3.6
  • bitmap indexes 3.6.3.2
  • characteristics 3.6.1
  • row overflow 3.6.2
  • secondary indexes 3.6.3
• index unique scans 3.2.2.4
• in-flight transactions 11.3
• information systems 1.1
• INIT.ORA
  • See: initialization parameter file.
• initialization parameter file 14.2.1.2, 14.5
  • startup 14.2.1.2
• initialization parameters
  • about 14.5.1.2
  • basic 14.5.1
  • OPEN_CURSORS 15.3.1.1
  • SERVICE_NAMES 17.2.2.2
• In-Memory Column Store 1.5.3.2, 2.2.7.2
  • memory management 19.3.2.1
  • SQL execution 8.4.1.4
• inner joins 8.2.2.2
• in-place refresh method 4.4.2.3
• INSERT statement 8.2.2
• instance PGA
  • memory management 19.3.2.3
• instances, database 1.5.1, 8.2.5, 14.1
  • associating with databases 14.2.1.3
  • duration 14.1.4
  • failure 12.4.1
  • failures 10.4.1.1
  • memory structures of 15.1
  • process structure 16.1, 16.1.2
  • recovery of
    • SMON process 16.4.1.4
  • service names 17.2.2
  • shutting down 14.2.2, 14.2.2.4
  • terminating 14.2.2.2.2
• INSTEAD OF triggers 9.4.2
• integrity constraints 5.1, 5.1.1
  • advantages 5.1, 5.1.2
  • check 5.2.5
  • definition 2.2.5
  • nondeferrable 5.3.2.1
  • updates of foreign and parent keys 5.3.3.2
  • validating 5.3.2
  • views 4.3.1.1
• internal locks 10.4.3.3
• internal tables 2.6.3
• interval partitioned tables 4.1.1.2.2
• invisible columns 2.2.1.2
• invisible indexes 3.1.2
• invoker’s rights 9.2.1.1
• isolation levels
  • serialization 10.2.2
• isolation levels, transaction 10.1.3
  • read committed 10.2.1
  • read-only 10.2.3
  • setting 10.5

---

J

• Java
  • overview 9.3
  • SQLJ translator 9.3.2.2.2
  • stored procedures 1.3.2, 9.3.2.1
  • virtual machine 9.3.1
• JDBC 20.3.2.2.2
  • accessing SQL 9.3.2.2
  • drivers 9.3.2.2.1
  • driver types 9.3.2.2.1
  • embedded SQL 8.2.6, 20.3.2.1
• job queue processes 16.4.2.2
• jobs 16.1
• join attribute clustering 2.4.2
• joins
  • views 4.3.2
• joins, table 3.3.2, 7.1.1, 8.2.2.2
  • Cartesian 8.2.2.2
  • clustered tables 2.3
  • conditions 3.3.2
  • inner joins 8.2.2.2
  • join conditions 8.2.2.2
  • outer joins 8.2.2.2
  • views 4.3
• JSON
  • comparison to XML 20.3.4.2.2
  • Oracle Database support 20.3.4.2.3
  • overview 20.3.4.2.1

---

K

• key compression
  • See: prefix compression
• keys
  • concatenation of index 3.2.5.1
  • foreign 5.2.4, 5.2.4.4
  • indexes 3.1.3, 3.2.5.1, 5.2.3
  • natural 5.2.3
  • parent 5.2.4, 5.2.4.4
  • partition 4.1.1.1
  • prefixed index 3.2.1
  • referenced 5.2.4, 5.2.4.4
  • reverse 3.2.3
  • surrogate 5.2.3
  • unique 5.2.2
  • values 5.2

---

L

• large pool 15.4.4
  • deferred inserts 15.4.4.2
  • memory management 15.4.4.1
• latches
  • definition 10.4.3.1
• leaf blocks, index 3.2.1
• least recently used (LRU) algorithm
  • database buffers and 15.4.1.4.1
  • full table scans and 15.4.1.6
  • latches 15.4.1.6
  • shared SQL pool 15.4.3.1.3, 15.4.4.1
• LGWR background process 16.4.1.6
• library cache 15.4.3, 15.4.3.1
• Listener Control utility 19.2.4
• listener process 1.5.4.2, 17.2.2
  • listener registration process (LREG) 16.4.1.3
  • service names 17.2.2
• listener registration process (LREG) 16.4.1.3
• listeners 1.5.4.2, 17.2.2
  • listener registration process (LREG) 16.4.1.3
  • service names 17.2.2
• list partitioning 4.1.1.2.3
• local indexes 4.1.3
• locally managed tablespaces 13.1.2.1
• local partitioned indexes 4.1.3.1
• local temporary tablespaces 13.5.2.1
• locks 10.1.2
  • after committing transactions 11.2.5
  • automatic 10.3.2, 10.4
  • bitmap indexes 3.3
  • conversion 10.3.3, 10.3.4
  • deadlocks 8.4.1.1, 10.3.6
  • definition 1.4.2
  • dictionary 10.4.2
  • dictionary cache 10.4.3.3
  • DML 10.4.1
  • duration 10.3.2, 10.3.5
  • escalation 10.3.3
  • exclusive 10.3.3
  • exclusive DDL 10.4.2.1
  • exclusive table 10.4.1.2
  • file management locks 10.4.3.3
  • Hybrid Columnar Compression 2.2.7.2.2
  • latches 10.4.3.1
  • log management locks 10.4.3.3
  • manual 10.5
  • overview of 10.1.2
  • parse 10.4.2.3
  • restrictiveness 10.3.3
  • rollback segments 10.4.3.3
  • row (TX) 10.4.1.1
  • row exclusive table 10.4.1.2
  • row share 10.4.1.2
  • share DDL 10.4.2.2
  • share locks 10.3.3
  • share row exclusive 10.4.1.2
  • share table 10.4.1.2
  • system 10.4.3
  • table 3.1.1, 8.2.2
  • table (TM) 10.4.1.2
  • tablespace 10.4.3.3
  • types of 10.4
  • unindexed foreign keys and 10.4.1.3
  • user-defined 10.6
• LOCK TABLE statement 8.2.2
• log-based refresh 4.4.2.2
• logical database structures
  • data blocks 1.5.2.2
  • definition 1.5.2.2
  • extents 1.5.2.2
  • segments 1.5.2.2
  • tablespaces 1.5.2.2, 13.5
• logical rowids 3.6.3
• logical transaction IDs 11.3.2.2
• log management locks 10.4.3.3
• log switches
  • archiver process 16.4.2.1
  • log sequence numbers 12.4.2.1
• log writer process (LGWR) 16.4.1.6
  • group commits 16.4.1.6.1
  • online redo logs available for use 12.4.2.1
  • redo log buffers and 15.4.2
  • write-ahead 16.4.1.6
  • writing to online redo log files 12.4.2.1
• LONG data type
  • storage of 2.2.6.1
• lost updates 1.4.3, 10.2.1.2
• lost writes
  • shadow tablespaces 13.5.1.4.1
• LRU 15.4.1.4.1, 15.4.1.6
  • shared SQL pool 15.4.3.1.3

---

M

• maintenance tasks, automatic 19.3.4.2
• maintenance window 19.3.4.2
• manual locking 10.5
• mapping tables 3.6.3.2
• master tables 4.4
• materialized views 4.4
  • characteristics 4.4.1
  • complete refresh 4.4.2.1
  • fast refresh 4.4.2.2
  • incremental refresh 4.4.2.2
  • in-place and out-of-place refresh 4.4.2.3
  • refresh
    • job queue processes 16.4.2.2
  • refreshing 4.4.2, 4.4.2.3
  • zone maps and 2.4.3.1
• media recovery
  • complete 19.3.1.4.4
  • overview 19.3.1.4.4
• memoptimize pool 15.4.7.2, 19.3.2.1
• memory
  • allocation for SQL statements 15.4.3.1.1
  • content of 15.1
  • processes use of 16.1
  • stored procedures 9.2.1.1
• memory management
  • about 19.3.2
  • automatic 19.3.2.1
  • automatic shared 19.3.2.2
  • instance PGA 19.3.2.3
• MERGE statement 8.2.2
• Messaging Gateway 18.5.2.2.2
• metrics 7.2, 19.3.4.1
• monitoring user actions 18.1.6.1
• multiblock writes 16.4.1.5
• multiplexing
  • control files 12.3.2
  • redo log file groups 12.4.2.2
  • redo log files 12.4.2.2
• multitenant architecture
  • definition 1.5.1.1
• multitenant container databases
  • See: CDBs
• multiversion read consistency 7.2.2, 10.1, 10.1.1, 10.1.3, 13.4.3, 13.4.3.2
  • deferred inserts 10.1.1.4
  • dirty reads 10.1.1
  • read committed isolation level 10.2.1.1
  • statement-level 1.4.3, 10.1.1.1
  • transaction-level 10.1.1.2
  • undo segments 10.1.1.3
• mutexes 10.4.3.2

---

N

• NaN (not a number) 2.2.4.2
• National Language Support (NLS) 20.3.3.1
• natural keys 5.2.3
• NCHAR data type 2.2.4.1.2
• network listener process
  • connection requests 17.2.4.1.1
• networks
  • client/server architecture use of 17.1.1
  • communication protocols 17.3.2, 17.3.3
  • dispatcher processes and 17.2.4.1.1
  • drivers 17.3.2
  • listener processes of 17.2.2
  • Oracle Net Services 17.2
• NLS_DATE_FORMAT parameter 2.2.4.3.1
• NOAUDIT statement 8.2.1
• non-CDBs 1.5.1.1
• nonunique indexes 3.1.5
• normalized tables 4.6.2
• NOT NULL constraints 5.2, 5.2.1
• nulls 2.2.3
  • foreign keys 5.2.4.2
  • how stored 2.2.3, 2.2.6.4
  • indexed 3.1.5
  • prohibiting 5.2.1
• NUMBER data type 2.2.4.2.1
• numbers, floating point 2.2.4.2
• numeric data types 2.2.4.2
  • floating-point numbers 2.2.4.2.2
• NVARCHAR2 data type 2.2.4.1.2

---

O

• object tables 2.2, 2.9
• object types 2.9, 4.3.3
• object views 4.3.3
• ODBC 20.3.2.2.2
• OLAP
  • index-organized tables 3.6
  • introduction 18.4.4.3
• OLTP
  • table compression 2.2.7.1
• online analytical processing
  • See: OLAP
• online redo log 12.4.1, 13.4.3.2
  • archiver process (ARCn) 16.4.2.1
  • buffer management 16.4.1.6
  • checkpoints 12.3.1
  • committed data 14.4.1
  • committing a transaction 16.4.1.6.1
  • log switch
    • archiver process 16.4.2.1
  • log writer process 15.4.2, 16.4.1.6
  • rolling forward 14.4.1
  • undo data in 13.4.3.3
  • writing buffers 16.4.1.6
• online redo log files 1.5.2.1
• OPEN_CURSORS parameter
  • managing private SQL areas 15.3.1.1
• operating systems
  • communications software 17.3.3
  • privileges for administrator 14.2.1.1
• optimized physical reads 15.4.1.4.3
• optimizer 8.1.1, 8.3
  • adaptive optimization 8.3.2.3
  • components 8.3.2
  • estimator 8.3.2.2
  • execution 8.4.1.4
  • execution plans 4.4.3, 8.3.1, 8.3.2.3, 8.4.1.3, 19.3.4.5.5
  • function-based indexes 3.4.2
  • hints 8.3.1, 8.3.5, 15.4.4.2
  • invisible indexes 3.1.2
  • partitions in query plans 4.1
  • plan generator 8.3.2.3
  • query plans 8.4.1.3
  • query transformer 4.4.3, 8.3.2.1
  • row sources 8.4.1.3
  • statistics 2.2.6.1, 8.3.4, 8.4.1.2, 19.3.4.2
• Optimizer Statistics Advisor
  • about 19.3.4.5.2
• Oracle Advanced Analytics 18.4.4.4
• Oracle ASM (Automatic Storage Management) 12.1.2, 12.1.2.1, 18.3.3, 19.3.1.2
• Oracle Audit Vault and Database Firewall 18.1.6.4
• Oracle Automatic Storage Management
  • See: Oracle ASM
• Oracle blocks 13.1.1
• Oracle Call Interface
  • See: OCI
• Oracle code 17.3
• Oracle Connection Manager Control utility 19.2.4
• Oracle Database
  • history 1.1.4
• Oracle Database Vault 18.1.5.1, 18.1.6.2
• Oracle Data Mining 18.4.4.4.1
• Oracle Data Pump 13.5.1, 18.1.5.1, 19.2.5.2
  • dump file set 19.2.5.2
  • unified audit trail 18.1.6.2
• Oracle Enterprise Manager
  • See: Enterprise Manager
• Oracle Enterprise Manager Cloud Control (Cloud Control)
  • See: Cloud Control
• Oracle Flashback Technology 1.4.3, 19.3.1.4.1
• Oracle Flex Clusters 18.3.2
• Oracle GoldenGate 18.5.2, 18.5.2.1, 18.5.2.2.1
• Oracle Internet Directory 17.2.2.2
• Oracle JDeveloper 20.2.3
• Oracle JVM
  • main components 9.3.1.2
  • overview 9.3.1.1
• Oracle Label Security 18.1.5.3, 18.1.6.2
• Oracle LogMiner 19.2.5.3
• Oracle Machine Learning for R 18.4.4.4.2
• Oracle Management Agents 19.2.1.1
• Oracle Management Repository 19.2.1.1
• Oracle Management Service (OMS) 19.2.1.1
• Oracle Net 1.5.4.2
• Oracle Net Configuration Assistant 19.2.4
• Oracle Net Listener 1.5.4.2
• Oracle Net Manager 19.2.4
• Oracle Net Services 1.5.4.2, 17.2
  • client/server systems use of 17.2
  • overview 17.2
  • shared server requirement 17.2.4.1.1
• Oracle Net Services Connection Manager 9.3
• Oracle processes 16.1.2, 16.3
• Oracle program interface (OPI) 17.3.1
• Oracle RAC
  • See: Oracle Real Application Clusters
• Oracle Real Application Clusters
  • Enterprise Grids 18.3
  • Oracle Flex Clusters 18.3.2
  • reverse key indexes 3.2.3
• Oracle Secure Backup 19.3.1.1
• Oracle Sharding
  • about 4.2
  • architecture 1.5.1.2
• Oracle Spatial and Graph 20.3.4.5
• Oracle Text 20.3.4.4
• Oracle Universal Installer (OUI) 19.2.3
• Oracle XA
  • session memory in the large pool 15.4.4
• ORDBMS (object-relational database management system) 1.1.3
• outer joins 8.2.2.2
• out-of-place refresh method 4.4.2.3

---

P

• packages 9.2.2
  • advantages of 9.2.2.1
  • creation 9.2.2.2
  • executing 9.2.6
  • for locking 10.6
  • private 9.2.2.1
  • public 9.2.2.1
  • shared SQL areas and 15.4.3.1.2
  • subprogram executions 9.2.2.3
• pages 13.1.1
• parallel execution 16.4.3.2
  • coordinator 16.4.3.2.3
  • server 16.4.3.2.3
  • servers 16.4.3.2.3
  • tuning 16.4.3.2
• parallel SQL 16.4.3.2
  • coordinator process 16.4.3.2.3
  • server processes 16.4.3.2.3
• parameters
  • initialization 14.5
    • locking behavior 10.4
• parse locks 10.4.2.3
• parsing, SQL 8.4.1, 8.4.1.1
  • embedded SQL 8.2.6
  • hard parse 10.4.3.1
  • storage of information 7.1.3.2
• partial global partitioned indexes 4.1.4
• partitioned change tracking refresh 4.4.2.2
• partitioned indexes 4.1.3.1
  • global 4.1.3.2
  • storage 4.1.3.1.2
• partitioned tables 4.1.1.2.4
  • interval 4.1.1.2.2
  • reference 4.1.1.2.5
• partitioning
  • by hash 4.1.1.2.4
  • by interval 4.1.1.2.2
  • by list 4.1.1.2.3
  • by range 4.1.1.2.1
  • by reference 4.1.1.2.5
  • composite 4.1.1.2.6
  • index 4.1.3.2
  • indexes 4.1.3.1
  • key 4.1.1.1
• partitions
  • characteristics 4.1.1
  • composite partitioning 4.1.1.2
  • definition 2.1.1
  • dynamic partitioning 16.4.3.2.3
  • elimination from queries 4.1.3.1.1
  • index 4.1.3
  • keys 4.1.1.1
  • materialized views 4.4.1
  • overview 4.1
  • partitions
    • composite 4.1.1.2
  • range 4.1.1.2
  • segments 13.4.1
  • single-level 4.1.1.2
  • strategies 4.1.1.2
  • table 4.1.1.2.1, 4.1.1.2.3, 4.1.2, 4.1.4
• passwords
  • administrator privileges 14.2.1.1
  • connecting with 16.2.2
• PCTFREE storage parameter
  • how it works 13.2.4.1
• PDBs 1.5.1.1
  • flashback 19.3.1.4.1
• performance
  • group commits 16.4.1.6.1
  • packages 9.2.2.1
• PGA
  • See: program global area (PGA)
• PGA_AGGREGATE_LIMIT initialization parameter 19.3.2.3
• PGA_AGGREGATE_TARGET initialization parameter 19.3.2.3
• phantom reads 10.1.3
• physical database structures
  • control files 1.5.2.1, 12.3
  • data files 1.5.2.1
  • online redo log files 1.5.2.1
• physical guesses 3.6.3.1
• PL/SQL
  • anonymous blocks 9.2, 9.2.3
  • collections 9.2.5, 9.2.5.1
  • data types 2.2.4
  • dynamic SQL 9.2.4
  • exceptions 9.2.4
  • execution 9.2.6
  • execution of subprograms 9.2.1.3
  • language constructs 9.2.4
  • overview 9.2
  • package creation 9.2.2.2
  • packages 7.3, 9.2.2, 9.2.2.1
  • PL/SQL engine 9.2.6
  • program units 9.2.1.1, 15.4.3.1.2
    • shared SQL areas and 15.4.3.1.2
  • records 9.2.5, 9.2.5.1, 9.2.5.2
  • stored procedures 1.3.2, 7.1.1.2, 9.2, 9.2.1, 9.2.1.1, 9.2.2.1
  • units 9.2
    • compiled 9.2.6
• plan
  • SQL execution 8.2.2
• planned downtime
  • avoiding downtime during 18.2.2
• pluggable databases
  • See: PDBs
• PMAN background process 16.4.1.2
• PMON background process 16.4.1.1.1
• pragmas, PL/SQL 11.5
• precompilers 9.1
  • COBOL 20.3.2.1.1
  • embedded SQL 8.2.6
  • FORTRAN 20.3.2.1.1
  • Pro*C/C++ 20.3.2.1.1
• predicates, SQL 3.2.2.1, 8.1.1
• primary key constraints 5.2
• primary keys 2.2.3, 3.1.1
  • constraints 5.2.3
  • hash clusters 2.3.2.3
  • index-organized tables 2.2
• private SQL areas 15.4.3.1.1
  • described 15.4.3.1.1
  • how managed 15.3.1.1
  • parsing and 8.4.1.1
• private synonyms 4.7
• privileges 7.1, 8.2.4, 18.1.1.1
  • administrator 14.2.1.1
  • granting 8.2.1, 18.1.1.3
  • PL/SQL procedures and 9.2.1.1
  • privilege profiler 18.1.1.3
  • revoking 8.2.1
• procedures
  • advantages 9.2.1.1
  • execution 9.2.1.3, 9.2.6
  • execution in a PL/SQL package 9.2.2.3
  • external 9.2.6
  • memory allocation 9.2.1.1
  • security 9.2.1.1
  • shared SQL areas and 15.4.3.1.2
  • stored procedures 1.3.2, 7.1.1.2, 9.2, 9.2.6
• processes 16.1
  • archiver (ARCn) 16.4.2.1
  • background 1.5.3.1, 16.4
  • checkpoints and 16.4.1.5
  • client 1.5.3.1, 16.2
  • dedicated server 17.2.4.1.2
  • definition 1.5.3.1
  • distributed transaction resolution 16.4.1.9
  • job queue 16.4.2.2
  • listener 17.2.2
    • shared servers and 17.2.4.1.1
  • log writer (LGWR) 16.4.1.6
  • multithreaded 16.1.2
  • Oracle 16.3
  • parallel execution coordinator 16.4.3.2.3
  • parallel execution servers 16.4.3.2.3
  • process monitor (PMON) 16.4.1.1.1
  • recoverer (RECO) 16.4.1.9
  • server 1.5.3.1, 16.3
    • shared 17.2.4.1.1, 17.2.4.1.2
  • shared server 17.2.4
    • client requests and 17.2.4.1
  • structure 16.1
  • system monitor (SMON) 16.4.1.4
  • user
    • recovery from failure of 16.4.1.1
    • sharing server processes 17.2.4.1.1
• processing
  • parallel SQL 16.4.3.2
• process manager process (PMON)
  • state objects 16.4.1.1.4
• process monitor process (PMON)
  • described 16.4.1.1.1
• program global area (PGA) 1.5.3.2, 15.1.1
  • shared server 17.2.4.1.2
  • shared servers 17.2.4.1.2
• program interface 17.3
  • Oracle side (OPI) 17.3.1
  • structure of 17.3.1
  • user side (UPI) 17.3.1
• programming, server-side 1.3.2, 9.1
• program units
  • shared pool and 15.4.3.1.2
• protection policies
  • benefits 19.3.1.5.1
• pseudocode
  • triggers 9.4.6
• pseudocolumns 2.2.4.4.2, 3.6.1
• public synonyms 4.7

---

Q

• queries
  • blocks 8.2.2.3
  • definition 8.2.2.1
  • implicit 10.2.1.1
  • in DML 8.2.2
  • parallel processing 16.4.3.2
  • query blocks 8.3.2.3
  • query transformer 8.3.2.1
  • SQL language and 8.1
  • stored 4.3
  • subqueries 4.3, 8.2.2, 8.2.2.3
• query blocks 8.3.2.3
• query optimizer
  • See: optimizer
• query plans 8.4.1.3
  • partitioning and 4.1
• query rewrite 4.6
• query transformer 4.4.3

---

R

• range partitioning 4.1.1.2.1
• range partitions 4.1.1.2
• range scans, index 3.2.2.3
• RDBMS (relational database management system) 1.1.3
• RDMA 15.4.7.2
• read committed isolation 10.2.1
• read consistency
  • See: multiversion read consistency
• read-only isolation level 10.2.3
• read uncommitted 10.1.3
• Real Application Clusters
  • cache fusion 10.1.1.3
  • system monitor process and 16.4.1.4
  • threads of online redo log 12.4.2
• records, PL/SQL 9.2.5, 9.2.5.1, 9.2.5.2
• recoverable errors 11.3, 18.2.1.4
• recoverer process (RECO) 16.4.1.9
  • in-doubt transactions 11.6.2
• recovery
  • complete 19.3.1.4.4
  • database buffers and 14.4.1
  • distributed processing in 16.4.1.9
  • instance recovery
    • SMON process 16.4.1.4
  • media 19.3.1.4.4
    • dispatcher processes 17.2.4.2
  • process recovery 16.4.1.1
  • required after terminating instance 14.2.2.2.2
  • rolling back transactions 14.4.4
  • tablespace
    • point-in-time 19.3.1.4.4
• Recovery Appliance 19.3.1.5.1
  • backup modules 19.3.1.5.2
  • metadata database 19.3.1.5.2
  • plug-in 19.3.1.5.1
• recovery catalog 19.3.1.5.2
• Recovery Manager 7.2, 19.3.1.1
  • architecture 19.3.1.2
  • auditing 18.1.6.2
  • backups 19.3.1.3.3
  • Recovery Appliance 19.3.1.5.1
• redaction, data 18.1.4
  • policies 18.1.4
• redo log buffer 12.4.1
• redo log files
  • available for use 12.4.2.1
  • circular use of 12.4.2.1
  • contents of 12.4.3
  • distributed transaction information in 12.4.2
  • group members 12.4.2.2
  • groups, defined 12.4.2.2
  • instance recovery use of 12.4
  • LGWR and the 12.4.2.1
  • members 12.4.2.2
  • multiplexed 12.4.2.2
  • online, defined 12.4
  • redo entries 12.4.3
  • threads 12.4.2
• redo logs buffer 15.4.2
• redo records 12.4.3
• REF constraints 5.2
• reference partitioned tables 4.1.1.2.5
• referential integrity
  • examples of 5.3.3
  • self-referential constraints 5.3.3
• refresh
  • incremental 4.4.2
  • job queue processes 16.4.2.2
  • materialized views 4.4.2, 4.4.2.3
• relational database management system
  • See: RDBMS
• relations, simple 1.1.2
• reserved words 8.2
• resource management 19.3.3.1
• response queues 17.2.4.1
• RESULT_CACHE clause 15.4.3.3.1
• result cache 15.4.3.3, 15.4.3.3.1
• result sets, SQL 2.2, 2.2.4.4.2, 2.5, 4.3.2, 8.2.2.1
• reverse key indexes 3.2.3
• REVOKE statement 8.2.1
• rights, definer’s and invoker’s 9.2.1.1
• roles 2.1.1, 7.1.1.2, 8.2.4
• rollback 11.2.4
  • described 11.2.4
  • ending a transaction 11.2.4
  • implicit in DDL 8.2.1
  • statement-level 10.3.6, 11.1.3
  • to a savepoint 11.2.3.1
  • transaction-level 8.2.3
• rollback segments
  • locks on 10.4.3.3
  • parallel recovery 14.4.4
  • use of in recovery 14.4.4
• ROLLBACK statement 11.2
• rolling back 11.1, 11.2.4
• row chaining 13.2.4.3
• row data (section of data block) 13.2.2.2
• row directories 13.2.2.1
• ROWID data type 2.2.4.4, 2.2.4.4.1
• rowids 2.2.6.3
  • foreign 2.2.4.4
  • index 3.1.5
  • logical 2.2.4.4, 3.6.3
  • physical 2.2.4.4
  • row migration 13.2.4.3
  • scans 8.3.3
  • universal 2.2.4.4
• row locks 10.4.1.1
  • concurrency 10.4.1.1.1
  • storage 10.4.1.1.2
• row pieces 2.2.6.2
• rows
  • addresses 2.2.6.3
  • chaining across blocks 2.2.6.2, 13.2.4.3
  • clustered 2.2.6.2
  • definition 1.2.1, 2.2.2
  • format of in data blocks 13.2.2.1
  • locking 10.4.1.1
  • locks on 10.4.1.1
  • migrating to new block 13.2.4.3
  • row set 8.4.1.3
  • row source 8.4.1.3
  • shown in rowids 13.2.2.2.3
  • storage 2.2.6.2
  • triggers 9.4.2
• row source generation 8.4.1.3

---

S

• sample schemas 2.1.5
• savepoints 8.2.3, 11.2.3
  • definition 11.2.3
  • implicit 11.1.3
  • rolling back to 11.2.3.1
  • SAVEPOINT statement 11.2
• SAVEPOINT statement 8.2.3
• SBT libraries 19.3.1.5.2
• scans
  • cluster 8.3.3
  • fast full index 3.2.2.2
  • full index 3.2.2.1
  • full table 3.1.1, 8.3.3, 15.4.1.6, 15.4.1.6.1
  • index 3.2.2, 8.3.3
  • index skip 3.2.2.5
  • range 2.3.2.2
  • rowid 8.3.3
  • unique index 3.2.2.4
• schema objects
  • definitions 1.2, 7.1, 8.2.1
  • dependencies 2.1.3, 4.3.1
  • dimensions 4.6
  • indexes 3.1
  • introduction 2.1
  • materialized views 4.4
  • relationship to data files 12.2.1
  • sequences 4.5
  • storage 2.1.2
• schemas 1.2, 2.1
  • sample 2.1.5
• SCN
  • See: system change numbers
• secondary indexes 3.6.3
  • benefits 3.6.3
  • physical guesses 3.6.3.1
• SecureFiles 20.3.4.3.3
• security
  • administrator privileges 14.2.1.1, 18.1.1.1
  • auditing 18.1.6.1
  • definer’s rights 9.2.1.1
  • program interface enforcement of 17.3
  • views 4.3
• segment advisor 19.3.4.2
• segments 1.5.2.2, 13.4
  • data 13.4.1
  • defined 13.1.1
  • index 3.1.8, 3.3.3
  • overview of 13.4
  • table storage 2.2.6
  • temporary 2.5.2, 13.4.2
    • allocating 13.4.2
  • user 13.4.1.1
• selectivity 3.2.2.3
• select lists, SQL 8.2.2.1
• SELECT statement 8.2.2
• self-referential integrity constraints 5.2.4.1
• sequences
  • characteristics 4.5.1
  • concurrent access 4.5.2
  • definition 2.1.1, 4.5
  • surrogate keys 5.2.3
• serializability, transactional 10.1
• serialization isolation level 10.2.2
• server parameter file
  • about 14.5.2
  • startup 14.2.1.2
• server processes 1.5.3.1, 16.3
  • creation 16.3.3
  • listener process 17.2.2
• servers
  • client/server architecture 17.1.1
  • shared
    • architecture 16.1.1, 17.2.4
    • processes of 17.2.4, 17.2.4.1.2
• server-side programming 9.1
  • overview 9, 9.1
• SERVICE_NAMES parameter 17.2.2.2
• service names 17.2.2
• service-oriented architecture 1.5.4.1, 17.1.2.4
• service tiers
  • See: Recovery Appliance service tiers
• session control statements 8.2.4
• sessions 8.2.4
  • connections contrasted with 16.2.2
  • defined 16.2.2
  • memory allocation in the large pool 15.4.4
  • sequence generation in 4.5.2
• SET CONSTRAINT statement 8.2.3
• SET TRANSACTION statement 8.2.3, 11.1.2.1
• SGA (system global area) 1.5.3.2, 15.1.1
  • allocating 14.2.1.2
  • big table cache 15.4.1.5
  • contents of 15.4
  • database buffer cache 15.4.1
  • data dictionary cache 7.1.3.2, 15.4.3.2
  • fixed SGA 15.4.6
  • large pool 15.4.4
  • redo log buffer 11.2.2, 15.4.2
  • rollback segments and 11.2.2
  • shared and writable 15.4
  • shared pool 9.2.1.1, 15.4.3
  • variable parameters 14.5.1.1
• shadow lost write protection 13.5.1.4
  • configuring 13.5.1.4.4
  • enabling 13.5.1.4.2
  • purpose 13.5.1.4.1
• shadow tablespaces 13.5.1.4
  • creating 13.5.1.4.4
  • how they work 13.5.1.4.2
  • purpose 13.5.1.4.1
  • user interface 13.5.1.4.3
• sharded database (SDB) 4.2
• sharded table 4.2.1
• sharded tables 4.2
• shards 4.2
• share DDL locks 10.4.2.2
• shared pool 9.2.6, 15.4.3, 15.4.3.1.3
  • allocation of 15.4.3.1.3
  • dependency management and 15.4.3.1.3
  • described 15.4.3
  • flushing 15.4.3.1.3
  • latches 10.4.3.1
  • parse locks 10.4.2.3
• shared server
  • described 16.1.1
  • dispatcher processes 17.2.4.1.1
  • Oracle Net Services or SQL*Net V2 requirement 17.2.4.1.1
  • processes 17.2.4.1.2
  • processes needed for 17.2.4
  • restricted operations in 17.2.4.2
  • session memory in the large pool 15.4.4
• shared server processes (Snnn) 17.2.4.1.2
  • described 17.2.4.1.2
• shared SQL areas 4.3.1.2, 15.4.3, 15.4.3.1.1, 15.4.3.1.3
  • dependency management and 15.4.3.1.3
  • described 15.4.3.1.1
  • parse locks 10.4.2.3
  • procedures, packages, triggers and 15.4.3.1.2
• shared temporary tablespaces 13.5.2.1
• share locks 10.3.3
• shutdown 14.2.2, 14.2.2.4
  • abnormal 14.2.2.4
  • prohibited by dispatcher processes 17.2.4.2
  • steps 14.2.2
• SHUTDOWN ABORT statement 14.2.2.4
• Simple Object Access Protocol (SOAP)
  • See: SOAP
• simple triggers 9.4.3
• single-level partitioning 4.1.1.2
• SMON background process 16.4.1.4
• SOA 1.5.4.1, 17.1.2.4
• SOAP (Simple Object Access Protocol) 1.5.4.1
• software code areas 15.1.1
• space management
  • extents 13.3
  • PCTFREE 13.2.4.1
  • row chaining 13.2.4.3
  • segments 13.4
• Space Management Coordinator Process (SMCO) background process 15.4.4.2
• SQL 8.1, 8.2
  • conditions 8.1.1, 8.2.2.1
  • data definition language (DDL) 8.2.1
  • data manipulation language (DML) 8.2.2
  • definition 1.3.1
  • dictionary cache locks 10.4.3.3
  • dynamic SQL 9.2.4
  • embedded 8.1, 8.2.6, 20.3.2.1
  • executable 11.1.2.1
  • execution 8.4.1.4, 11.1.3
  • expressions 3.1.3, 8.2.2.1
  • functions 2.2.4.4.2
  • interactive 8.1
  • memory allocation for 15.4.3.1.1
  • operators 8.1.1
  • optimization 8.4.1.2
  • Oracle 1.3.1, 8.1.2
  • overview 8.1
  • parallel execution 16.4.3.2
  • parsing 8.4.1, 8.4.1.1
  • PL/SQL and 9.2
  • predicates 3.2.2.1, 8.1.1
  • processing 8.4.1
  • reserved words 8.2
  • result sets 2.2, 2.2.4.4.2, 2.5, 4.3.2, 8.2.2.1
  • select lists 8.2.2.1
  • session control statements 8.2.4
  • standards 8.1.2
  • statements 8.2
  • subqueries 4.3, 8.2.2.3
  • system control statements 8.2.5
  • transaction control statements 8.2.3
  • transactions 11.1
  • types of statements 8.2
• SQL*Loader 19.2.5.1
• SQL*Plus 19.2.2
  • alert log 14.6.2
  • executing a package 9.2.2.3
  • lock and latch monitors 10.4.3
• SQL areas
  • private 15.4.3.1.1
  • shared 15.4.3.1.1
• SQLJ standard 9.3.2.2.2
• SQL tuning advisor 19.3.4.2
• SRVCTL utility 11.4.1.2
• standard auditing 18.1.6.1
• standards
  • ANSI/ISO 8.1.2
    • isolation levels 10.1.3
• star schemas 2.4.5
• startup 14.1
  • prohibited by dispatcher processes 17.2.4.2
• statement-level atomicity 11.1.3
• statement-level read consistency 10.1.1.1
• statement-level rollback 10.3.6, 11.1.3
• statements, SQL 8.2
• statistics 2.2.6.1, 7.2, 8.3.1, 15.4.3.1.3
  • ASH 19.3.4.4
  • AWR 19.3.4.2
  • definition 8.3.4
  • gathering for optimizer 19.3.4.2
  • Java-related 15.4.5
  • join order 8.2.2.2
  • optimizer 8.4.1.2
  • undo retention 13.5.1.3.2
• storage
  • logical structures 13.5
  • nulls 2.2.3
  • triggers 9.4.6
• stored procedures
  • See: procedures
• Structured Query Language (SQL) 8.1
• structures
  • locking 10.4.2
  • logical 13
    • data blocks 13, 13.2, 13.2.5
    • extents 13.1, 13.3
    • segments 13.1, 13.4
    • tablespaces 12, 13.5
  • physical
    • control files 12.3
    • data files 12
  • processes 16
• subprograms, PL/SQL
  • See: procedures
• subqueries 4.3, 8.2.2, 8.2.2.3
• summaries 4.4
• surrogate keys 5.2.3
• synonyms
  • constraints indirectly affect 5.3.3.2
  • data dictionary views 7.1.3.1
  • definition 2.1.1, 4.7
  • private 4.7
  • public 4.7, 7.1.1.3
  • securability 4.7
• SYSDBA privilege 14.2.1.1
• SYSOPER privilege 14.2.1.1
• system change numbers (SCN) 11.1.4
  • committed transactions 11.2.5
  • defined 11.2.5
  • definition 10.1.1.3.1
  • when assigned 12.4.3
• system control statements 8.2.5
• system global area
  • See: SGA
• system locks 10.4.3
  • internal 10.4.3.3
  • latches 10.4.3.1
  • mutexes 10.4.3.2
• system monitor process (SMON) 16.4.1.4
  • defined 16.4.1.4
  • Real Application Clusters and 16.4.1.4
  • rolling back transactions 14.4.4
• SYSTEM tablespace 7.1.2
  • data dictionary stored in 13.5.1.1
  • online requirement of 13.5.3.2
• SYSTEM user name 2.1.4
• SYS user name 2.1.4
  • data dictionary tables 7.1.3

---

T

• table clusters
  • cluster keys 2.3
  • definition 2.3
  • hash clusters 2.3.2, 2.3.2.2, 2.3.2.3
  • hash cluster storage 2.3.2.4
  • indexed 2.3.1
  • overview 2
  • scans 8.3.3
• table partitions 4.1.1.2.1
• tables
  • attribute-clustered 2.4.2
  • automatic big table caching 15.4.1.4.1, 15.4.1.5
  • base 4.3.1, 7.1.2
  • characteristics 2.2.3
  • clustered 2.3
  • compression 2.2.7, 4.1.2.2
  • definition 1.1.2, 1.2.1, 2.1.1
  • dimension 4.6.1
  • directories 13.2.2.1
  • DUAL 7.1.1.4
  • dynamic partitioning 16.4.3.2.3
  • external 2.6, 2.6.3, 2.6.4
  • fact 4.6.1
  • full table scans 3.1.1, 15.4.1.6.1
  • heap-organized 2.1.2, 3.6
  • index-organized 3.6, 3.6.1, 3.6.2, 3.6.3
  • integrity constraints 5.1
  • joins 3.3.2
  • master 4.4
  • normalized or denormalized 4.6.2
  • object 2.9
  • overview 2, 2.2
  • partitioned 4.1.1.1, 4.1.1.2.3, 4.1.1.2.4
  • partitions 4.1.2
  • permanent 2.2
  • storage 2.2.6
  • temporary 2.5, 2.5.3, 13.4.2.2
  • transaction 11.1.2.1
  • truncating 8.2.1, 13.3.2
  • views of 4.3
  • virtual 7.2.2
• tables, attribute-clustered 2.4
  • dimensional hierarchies 2.4.5
  • linear ordering 2.4.4
  • zone maps 2.4.3, 2.4.3.1
• tables, base 4.3
• tables, external 2.2
• tables, object 2.2
• tables, temporary 2.2
• tablespace point-in-time recovery 19.3.1.4.4
• tablespaces 1.5.2.2, 13.5
  • described 13.5
  • dictionary managed 13.1.2.2
  • locally managed 13.1.2.1
  • locks on 10.4.3.3
  • offline 13.5.3.2
  • online 13.5.3.2
  • overview of 13.5
  • recovery 19.3.1.4.4
  • schema objects 2.1.2
  • space allocation 13.1.2
  • SYSTEM 7.1.2
  • used for temporary segments 13.4.2.1
• tablespace set 4.2.1
• tasks 16.1
• temp files 12.2.2
• temporary segments 2.5.2, 13.4.2.2
  • allocating 13.4.2.1
  • allocation for queries 13.4.2.1
• temporary tables 2.2
  • creation 2.5.3
  • global 2.5
  • private 2.5
  • purpose 2.5.1
• temporary tablespaces 13.5.2
  • creation of default 13.5.2.2.1
  • local 13.5.2.1
  • shared 13.5.2.1
• threads
  • online redo log 12.4.2
• TIMESTAMP data type 2.2.4.3, 2.2.4.3.2
• time zones 2.2.4.3.2
  • in date/time columns 2.2.4.3.2
• TO_CHAR function 2.2.4.5
• TO_DATE function 2.2.4.3.1, 2.2.4.5
• trace files
  • LGWR trace file 16.4.1.6.2
• transaction control statements 8.2.3
• Transaction Guard 11.3, 11.4.2, 18.2.1.4
  • benefits 11.3.1
  • how it works 11.3.2
• transaction-level read consistency 10.1.1.2
• transaction management
  • definition 1.4
• transactions 11
  • ACID properties 11.1
  • active 11.2.2, 13.4.3
  • assigning system change numbers 11.2.5
  • autonomous 11.5
    • within a PL/SQL block 11.5
  • beginning 11.1.2.1
  • blocking 10.2.1.2
  • committing 11.3.2.1, 16.4.1.6.1
    • group commits 16.4.1.6.1
  • conflicting writes 10.2.1.2
  • deadlocks 10.3.6, 11.1.3
  • definition 1.4.1, 11.1
  • distributed 11.2.1, 11.6, 18.5.1.1
    • resolving automatically 16.4.1.9
  • DML statements 8.2.2
  • ending 11.1.2.2
  • enqueued 11.2.3.2
  • idempotence 11.3, 18.2.1.4
  • in-doubt
    • resolving automatically 11.6.2
  • in-flight 11.3
  • isolation levels 10.1.3, 10.2.2, 10.2.3
  • isolation of 10.1.3
  • logical transaction ID 11.3.2.2
  • naming 11.2.1
  • read consistency 10.1.1.2
  • rolling back 11.2.4
    • partially 11.2.3.1
  • savepoints in 11.2.3
  • serializability 10.1
  • setting properties 8.2.3
  • structure 11.1.2
  • terminated 13.4.3
  • terminating the application and 11.1.2.2
  • transaction control statements 8.2.3
  • transaction history 10.1.1.3.2
  • transaction ID 11.1, 11.1.2.1
• transaction tables 11.1.2.1
  • reset at recovery 16.4.1.1
• triggers 9.1
  • cascading 9.4.1
  • components of 9.4.4
  • compound 9.4.3
  • effect of rollbacks 11.1.3
  • firing (executing) 9.4.5
    • privileges required 9.4.5
  • INSTEAD OF 9.4.2
  • overview 9.4
  • restrictions 9.4.4
  • row 9.4.2
  • shared SQL areas and 15.4.3.1.2
  • simple 9.4.3
  • statement 9.4.2
  • storage of 9.4.6
  • timing 9.4.3
  • UNKNOWN does not fire 9.4.4
  • uses of 9.4.1
• TRUNCATE statement 8.2.1, 13.3.2
• tuples, definition 1.1.2
• two-phase commit
  • transaction management 11.6

---

U

• undo management, automatic 13.4.3
• undo retention period 13.5.1.3.2
• undo segments 11.1.2.1, 13.4.3
  • read consistency 10.1.1.3
  • temporary 12.4.1, 13.4.3, 13.4.3.3
• undo space management
  • automatic undo management mode 13.5.1.3.1
• undo tablespaces 13.4.3, 13.5.1.3, 13.5.1.3.1, 13.5.1.3.2
  • undo retention period 10.2.3
• Unicode 2.2.4.1
• unified audit trail 17.1.2.3, 18.1.5.3, 18.1.6.2
• unique indexes 3.1.5
• unique key constraints 5.2, 5.2.2
  • composite keys 5.2.2
  • NOT NULL constraints and 5.2.2
• unplanned downtime
  • avoiding downtime during 18.2.1.2
• updatable join views 4.3.2
• update no action constraint 5.2.4.3
• updates
  • lost 10.2.1.2
  • tables with parent keys 10.4.1.3
  • updatability of views 4.3.2, 9.4.2
  • updatable join views 4.3.2
• UPDATE statement 8.2.2
• upgrades
  • database 13.5.1.2, 13.5.1.3.1, 18.2.2.3, 20.3.1
• UROWID data type 2.2.4.4
• USER_ views 7.1.1.3
• user global area (UGA) 15.1.1
• user program interface (UPI) 17.3.1
• users, database 2.1.1
  • authentication 18.1.2
  • names 7.1
    • sessions and connections 16.2.2
  • privileges 2.1, 18.1.1.1
  • temporary tablespaces 13.4.2.1
• user segments 13.4.1.1
• UTL_HTTP package 9.2.2

---

V

• V$ views 7.2.1
  • database object metadata 7.3
  • storage 7.2.2
• VARCHAR2 data type 2.2.4.1, 2.2.4.1.1
• variables
  • embedded SQL 8.2.6
• views 4.3
  • analytic 18.4.4.2
  • base tables 4.3
  • characteristics 4.3.1
  • constraints indirectly affect 5.3.3.2
  • data access 4.3.1.2
  • data dictionary
    • updatable columns 4.3.2
  • definition 2.1.1
  • DML 4.3.1.1
  • dynamic performance 7.2, 7.2.1
  • indexes 4.3.1.2
  • INSTEAD OF triggers 9.4.2
  • integrity constraints 4.3.1.1
  • materialized 4.4
  • object 4.3.3
  • schema object dependencies 4.3.1
  • storage 4.3.1
  • updatability 4.3.2
  • uses 4.3
  • V$ 7.2
• virtual columns 2.2.1.1, 2.2.6.1, 3.4.2

---

W

• warehouse
  • materialized views 4.4
• Web services 1.5.4.1, 17.1.2.4
• write-ahead 16.4.1.6

---

X

• XA
  • session memory in the large pool 15.4.4
• XMLType data type 20.3.4.1
• XStream 18.5.2.2.1

---

Z

• Zero Data Loss Recovery Appliance
  • See: Recovery Appliance
• zone maps 2.4.3, 2.4.3.1