Index

A

access drivers, external table 4.6.3
access paths, data 5.1.1, 5.4.2, 10.3.1, 10.3.3
accounts, user 9.1
ACID properties 13.1
active transactions 13.2.2
ADDM (Automatic Database Diagnostic Monitor) 22.3.4.3, 22.3.4.4
administrative accounts 4.1.1.1.2, 9.1.2
administrator privileges 4.1.1.1.2, 16.2.1.1, 19.2.4.2, 20.1.1.1
ADR 16.6.1
advanced index compression 5.2.5.2
Advanced Queuing 20.5.2.2
aggregate function 20.4.4.1
alert logs 16.6.2, 18.4.1.6.2
ALL_ data dictionary views 9.1.2.3
ALTER DATABASE statement
- application roots 3.1.2
- RECOVER clause 3.4
ALTER TABLE statement 4.2.3
analytic functions 20.4.4.1
analytic views 20.4.4.2
anonymous PL/SQL blocks 11.2
ANSI/ISO standard 10.1.2
APIs (application program interfaces) 19.3
- client-side 23.3.2.2
- embedded SQL statements 10.2.6
- external tables 4.6.3
- Java 11.3.1.1, 23.3.2.2.2
- JDBC 10.2.6, 13.5.2, 23.3.2.2.2
- network services 19.2.1
- OCI/OCCI 23.3.2.2.1
- ODBC 10.2.6, 23.3.2.2.2
- Oracle Database Advanced Queuing 20.5.2.2.2
- Oracle Data Pump 22.2.5.2
application and networking architecture 1.5.4.1, 19
application common objects 3.2, 4.1.2
- creation 3.2.2
- data-linked 2.3.5, 3.2.4
- extended data-linked objects 3.2.5
- metadata-linked common objects 3.2.3
- metadata links 3.2.3.1
- naming rules 3.2.1.2
application containers
- about 3.1
- application common objects 3.2, 3.2.1.2, 3.2.2, 4.1.2
- application PDBs 3.1.3
- application roots 3.1.2
- application seeds 3.1.4
- container maps 3.3
- naming rules 2.3.4
- purpose 3.1.1, 3.1.1.1, 3.1.1.2, 3.1.1.3
application contexts, auditing 20.1.6.1
Application Continuity 13.5, 20.2.1.4
- architecture 13.5.2
- benefits 13.5.1
- planned maintenance 13.5.1.2
- use case 13.5.1.1
application data usage
- schema annotations 8.2
application developers
- duties of 23.1
- tools for 23.2
- topics for 23.3
application domain indexes 5.5
application PDBs 3.1.3
- naming rules 2.3.4
- synchronization 3.3
application processes 18.2
application program interface
- See: API
application roots 3.1.2
applications
- in a CDB
  - metadata-linked common objects 3.2.3
- upgrades 20.2.2.3
application seeds 2.3.1, 3.1.4
application servers 1.5.4.1, 11.3.1.2
- about 19.1.2.2
archived redo log files 14.3.3, 14.4.2.3, 22.3.1.4.3
ARCHIVELOG mode 18.4.2.1
archiver process (ARCn) 18.4.2.1
ascending indexes 5.2.4
ASSM tablespace 15.1.2.1.1
asynchronous notifications 20.5.2.2.2
atomicity, statement-level 13.1.3
attribute-clustered tables
- benefits 4.4.1
- dimensional hierarchies 4.4.5
- interleaved ordering 4.4.5
- join attribute clustering 4.4.2
- linear ordering 4.4.4
- overview 4.4
- zone maps 4.4.3, 4.4.3.2
auditing 9.1, 9.1.3, 10.2.1, 11.5.1, 14.1.2, 16.2.1.4.1, 20.1.6.1
- application contexts 20.1.6.1
- Audit Administrator role 20.1.6.1.2
- audit policies 20.1.5.3, 20.1.6.1.1
- audit records 20.1.6.2
- fine-grained 20.1.6.1
- Oracle Audit Vault and Database Firewall 20.1.6.4
- Oracle Database Vault 20.1.5.1
- Oracle Label Security 20.1.5.3
- standard 20.1.6.1
- unified audit trail 19.1.2.3, 20.1.5.3, 20.1.6.2
AUDIT statement 10.2.1
authentication, database 10.2.4, 18.2.2, 20.1.2
automated indexes 5.1.1, 5.1.7
automatic big table caching 17.2.1.4.1, 17.2.1.5
Automatic Database Diagnostic Monitor
- See: ADDM
Automatic Diagnostic Repository (ADR) 16.6.1, 16.6.2
automatic maintenance tasks 22.3.4.2
automatic memory management 22.3.2.1, 22.3.2.2
automatic segment space management (ASSM) 15.1.2.1.1
automatic undo management 15.4.3, 15.5.2.3.1
Automatic Workload Repository (AWR) 22.3.4.2
AutoTask 22.3.4.2
AWR
- See: Automatic Workload Repository (AWR)
AWR reports 22.3.4.2

B

background process (BGnn) 18.4.1.10
background processes 1.5.3.1, 18.4
- mandatory 18.4.1
- optional 18.4.2
- PMAN 18.4.1.2
backup and recovery
- definition 22.3.1
- incremental-forever strategy 22.3.1.5.1
- techniques 22.3.1.1
backups 22.3.1
- backup sets 22.3.1.3.3
- image copies 22.3.1.3.3
- partial database 22.3.1.3.1
- Recovery Manager 22.3.1.1
- technique comparisons 22.3.1.1
- whole database 22.3.1.3.1
big table cache 17.2.1.5
BINARY_DOUBLE data type 4.2.4.2.2
BINARY_FLOAT data type 4.2.4.2.2
bitmap indexes 5.3
- bitmap joins 5.3.2
- locks 5.3
- mapping table 5.6.3.2
- single-table 5.3.1
- storage 5.3.3
bitmap tablespace management 15.1.2.1
blocking transactions 12.2.1.2
blocks, data
- See: data blocks
BOOLEAN data type 4.2.4, 4.2.4.5, 5.2.2.3, 10.2.2.1, 11.5.4
branch blocks, index 5.2.1
B-tree indexes 4.2.6.3, 4.3.1, 5.2
- branch level 5.2.1
- height 5.2.1
- prefix compression 5.2.5.1
- reverse key 5.2.3
buffer cache, database
- See: database buffer cache
buffers
- See: database buffers
business rules, enforcing 7.1.1, 7.1.2

C

cache fusion 12.1.1.3
cardinality, column 5.3, 10.3.2.2
Cartesian joins 10.2.2.2
cartridges 5.5
cascading deletions 7.2.4.3
catalog.sql script 9.2.1
CDBs 1.5.1.1
- application common objects 3.2, 3.2.1.2, 3.2.2
- application containers 3.1, 3.1.1, 3.1.1.1, 3.1.1.2, 3.1.1.3
  - application common objects 2.3.5
- application PDBs 3.1.3
- application seeds 3.1.4
- character sets 2.2
- common objects 2.3.5, 4.1.2
- common users 4.1.1, 4.1.1.1
  - naming rules 3.2.1.2
- container data objects 9.1.2.1
- container maps 3.3
- containers 2.1
- cross-container operations 3.4
- current container 18.2.3
- data links 9.1.3.1
- files 15.5.1
- local users 4.1.1, 4.1.1.2
- metadata links 9.1.3.1
- Oracle Flashback Technology 22.3.1.4.1
- root container 2.2
- seed PDBs 2.3.1
- services 19.2.2.2
- system container 2.2
- temp files 15.5.1
- undo mode 15.5.1
chaining, rows
- See: row chaining
character data types 4.2.4.1
- VARCHAR2 4.2.4.1
character sets 4.2.4.1
- ASCII 4.2.4.1
- client 23.3.3.1.1
- database 23.3.3.1.1
- EBCDIC 4.2.4.1
- Unicode 4.2.4.1, 23.3.3.1.1
CHAR data type 4.2.4.1.1
check constraints 7.2, 7.2.5
checkpoint process (CKPT) 18.4.1.7
checkpoints
- control files 14.3.1
- database shutdowns 16.2.2.1
- definition 16.3
- inconsistent backups 22.3.1.3.2
- incremental 16.3.2
- position 16.4.4
- thread 16.3.2
cleanup helper processes (CLnn) 18.4.1.1.3
cleanup main process (CLMN) 18.4.1.1.2
client/server architecture 19.1.1
- advantages 19.1.1.2
client processes 1.5.3.1, 18.2
- connections and 18.2.2
- sessions and 18.2.2
- shared server processes and 19.2.4.1.2
client result cache 17.2.3.3
client-side programming 11.1
CLMN background process 18.4.1.1.2
CLnn background processes 18.4.1.1.3
Cloud Control 22.2.1.1
cluster indexes 4.3.1
clusters, table 4.3.2
- cluster keys 4.3
- hash 4.3.2
- index 4.3.2
Codd, E. F. 1.1.2
code points 4.2.4.1
collections, PL/SQL 11.2.5, 11.2.5.1
columns
- cardinality 5.3, 10.3.2.2
- definition 1.2.1, 4.2.1
- expression column 4.2.1.1
- invisible 4.2.1.2
- lock-free reservation 4.2.1.3
- multiple indexes on 5.1.4
- order of 4.2.6.1
- prohibiting nulls in 7.2.1
- virtual 4.2.1.1, 4.2.6.1, 5.4.2
COMMENT statement 10.2.1
COMMIT statement 10.2.3
committing transactions
- COMMIT statement 10.2.3
- defined 13.1
- ending transactions 13.1.2.2
- fast commit 18.4.1.6.1
- group commits 18.4.1.6.1
- implementation 18.4.1.6.1
- implicit commits 10.2.1
- lost commit problem 13.4.2.1
- two-phase commit 13.7.1
commonality, principles of 3.2.1.1
common objects 4.1.2
common user accounts 2.1, 4.1.1
- naming rules 3.2.1.2
common users 4.1.1.1
compiled PL/SQL
- pseudocode 11.5.6
- shared pool 11.2.6
- triggers 11.5.6
complete recovery 22.3.1.4.3
complete refresh 6.4.2.1
composite indexes 5.1.4
composite partitioning 6.1.1.2.6
compound triggers 11.5.3
compression
- advanced index 5.2.5.2
- archive 4.2.7.2.1
- basic table 4.2.7.1
- data block 15.2.3
- Hybrid Columnar Compression 4.2.7.2, 4.2.7.2.1
- index 5.2.5
- OLTP table 4.2.7.1
- prefix index 5.2.5.1
- table 4.2.7, 6.1.2.2
- units of Hybrid Columnar Compression 4.2.7.2.2
- warehouse 4.2.7.2.1
concatenated indexes 5.1.4
concurrency
- definition 12.1
- dirty reads 12.1.3
- fuzzy reads 12.1.3
- phantom reads 12.1.3
- row locks 12.4.1.1.1
- transaction isolation 12.1.3, 12.2.2, 12.2.3
conditions, SQL 10.1.1, 10.2.2.1
conflicting writes 12.2.1.2
connections, client/server
- administrator privileges 16.2.1.1
- definition 18.2.2
- embedded SQL 10.2.6, 23.3.2.1
- listener process 1.5.4.2, 19.2.2
- sessions contrasted with 18.2.2
consistency
- conflicting writes 12.2.1.2
- definition 12.1
- locks 12.1.2, 12.5
- multiversioning 12.1, 12.1.1
constraints, integrity
- check 7.2, 7.2.5
- default values 7.3.3.1
- deferrable 7.2.3, 7.3.2.2, 10.2.3
- enabling and disabling 7.3.1
- enforced with indexes 7.2.3
- foreign key 7.2, 7.2.4, 7.2.4.4
- mechanisms of enforcement 7.3.3
- nondeferrable 7.3.2.1
- NOT NULL 4.2.3, 7.2, 7.2.1
- primary key 4.2.3, 7.2, 7.2.3
- REF 7.2
- referential 7.2.4.3
- self-referential 7.2.4.1
- state of 7.3
- unique key 7.2, 7.2.2
- updates of foreign and parent keys 7.3.3.2
- validating 7.3.1, 7.3.2
constraints, precheckable
- check 7.2.6
container data objects 9.1.2.1
container maps 3.3
CONTAINERS_DEFAULT_TARGET property 3.4
containers, CDB 2, 2.1
- root 2.2
contention
- deadlocks 12.3.6
contexts 4.1.3
control files 1.5.2.1, 14.3
- changes recorded 14.3.1
- checkpoints and 14.3.1
- contents 14.3.1
- multiplexed 14.3.2
- overview 14.3
- used in mounting database 16.2.1.3
cost-based optimizer
- See: optimizer
CREATE CLUSTER statement 4.3.1
CREATE DIMENSION statement 6.6.2
CREATE GLOBAL TEMPORARY TABLE statement 4.5.3
CREATE INDEX statement 4.5.3, 5.1.3, 5.1.4, 5.1.8, 5.2.4, 5.4.1
CREATE MATERIALIZED VIEW statement 6.4
CREATE PLUGGABLE DATABASE statement 2.3.1
- application containers 3.1
- AS PROXY clause 2.3.3
CREATE SEQUENCE statement 6.5.1
CREATE SYNONYM statement 6.7
CREATE TABLE statement 4.2, 4.2.3, 4.2.6
- storage parameters 15.4.1.1
CREATE UNIQUE INDEX statement 7.2.3
CREATE USER statement
- temporary segments 15.4.2.1
credential management
- object store files 6.1.5.3
cross-container operations 3.4
current container 18.2.3
cursors
- embedded SQL 10.2.6
- explicit 11.2.4
- fetching rows 10.2.6

D

data access languages 1.3
database applications 1.1.1
database authentication 10.2.4, 18.2.2
database backups 22.3.1.3.1
database buffer cache 4.2.7, 17.2.1, 18.4.1.5
- cache hits and misses 17.2.1.4.3
- caching of comments 9.1.3.3
- force full database caching mode 17.2.1.6.5
database buffers
- after committing transactions 13.2.5
- buffer bodies in flash cache 17.2.1.4.3
- buffer cache 17.2.1
- checkpoint position 18.4.1.5
- committing transactions 18.4.1.6.1
- definition 17.2.1
- writing 18.4.1.5
Database Configuration Assistant (DBCA) 22.2.3
database instances 1.5.1
- See: instances, database
- duration 16.1.4
- read/write 16.1.3
- read-only 16.1.3
database links, PDBs 2.3.5
database objects 1.2
- metadata 9.3
database operations 18.2.4
database resident connection pooling 19.2.5
Database Resource Manager 20.1.1.4, 20.3.1.3, 22.3.3.1
databases
- administrative accounts 4.1.1.1.2
- closing 16.2.2.2
  - terminating the instance 16.2.2.2.2
- definition 1.1, 1.5.1
- distributed 20.5.1.1
  - changing global database name 17.2.3.1.3
- hierarchical 1.1.1
- history 1.1.4
- incarnations 22.3.1.4.3
- introduction 1
- mounting 16.2.1.3
- multiprocess 18.1.2
- multiuser 18.1.2
- name stored in control files 14.3.1
- network 1.1.1
- object-relational 1.1.3
- opening 16.2.1.4, 16.2.1.4.1
- relational 1.1.2, 1.1.3, 10.1
- shutting down 16.2.2
- starting up 4.1.1.1.2, 16.1
  - forced 16.2.2.4
- structures
  - control files 14.3
  - data blocks 15, 15.2, 15.2.5
  - data files 14
  - extents 15.1, 15.3
  - logical 15
  - processes 18
  - segments 15.1, 15.4
  - tablespaces 14, 15.5
Database Server Grid 20.3
- description 20.3.1
database services 19.2.2.2.1, 19.2.2.2.1.2
- in a CDB 19.2.2.2.1.1
- PDBs 19.2.2.2
Database Storage Grid 20.3
- description 20.3.3
database structures
- control files 14.3
- data blocks 15, 15.2, 15.2.5
- data files 14
- extents 15.1
- processes 18
- segments 15.1, 15.4
- tablespaces 14, 15.5
Database Upgrade Assistant (DBUA) 22.2.3
database writer process (DBW) 18.4.1.5
- multiple DBWn processes 18.4.1.5
database writer process (DBWn)
- checkpoints 18.4.1.5
- defined 18.4.1.5
- least recently used algorithm (LRU) 17.2.1.6
- write-ahead 18.4.1.6
data blocks 1.5.2.2, 15.1
- cached in memory 17.2.1.6
- clustered rows 4.3
- coalescing free space in blocks 15.2.4.2.2
- compression 15.2.3
- format 15.2.2, 15.2.2.2
- locks stored in 12.4.1.1.2
- overview 15.1.1
- shown in rowids 15.2.2.2.3
- stored in the buffer cache 17.2.1
- writing to disk 17.2.1.6
data concurrency
- definition 1.4.2
data consistency 1.4.3
data conversion
- program interface 19.3
data corruption 20.2.1.4
data dictionary 4.1.1.1.2, 4.2.5
- ALL_ prefixed views 9.1.2.3
- cache 17.2.3
- comments in 10.2.1
- content 9.1.2, 17.2.3.2
- DBA_ prefixed views 9.1.2.2
- dictionary managed tablespaces 15.1.2.2
- DUAL table 9.1.2.5
- how database uses 9.1.3
- locks 12.4.2
- overview 9.1
- public synonyms 9.1.3.2
- storage in a CDB 9.1.4
- stored subprograms 11.2.1.2
- USER_ prefixed views 9.1.2.4
data dictionary cache 9.1.3.3, 17.2.3, 17.2.3.2
data failures, protecting against human errors 13.4, 20.2.1.5
data files 1.5.2.1
- contents 14.2.4
- data file 1 15.5.2.1
- moving online 14.2.3
- named in control files 14.3.1
- shown in rowids 15.2.2.2.3
- SYSTEM tablespace 15.5.2.1
- temporary 14.2.2
data integrity 7.1
- enforcing 7.1, 7.1.1, 9.1.3
- SQL and 10.1
data-linked application common objects 3.2.2
data-linked common objects 2.3.5, 3.2, 3.2.4
data links 3.2.4, 9.1.3.1
data manipulation language
- See: DML
data object number, extended rowid 15.2.2.2.3
data redaction 20.1.4
- random 20.1.4
data segments 15.4.1
data types
- BOOLEAN 4.2.4, 4.2.4.5, 5.2.2.3, 10.2.2.1, 11.5.4
- built-in 4.2.4
- character 4.2.4.1, 4.2.4.1.1
- composite types 4.2.4
- conversions by program interface 19.3
- DATE 4.2.4.3.1
- datetime 4.2.4.3
- definition 4.2.4
- format models 4.2.4.3.1
- how they relate to tables 4.2.1
- in PL/SQL 4.2.4
- NCHAR 4.2.4.1.2
- NUMBER 4.2.4.2.1
- numeric 4.2.4.2
- NVARCHAR2 4.2.4.1.2
- object 4.9
- reference types 4.2.4
- ROWID 4.2.4.4, 4.2.4.4.1
- TIMESTAMP 4.2.4.3.2
- UROWID 4.2.4.4
- user-defined 4.2.4, 6.3.3
data use case
- domains 8.1
data use case domain 8.1
data warehouses
- architecture 20.4.2
- bitmap indexes in 5.3
- dimensions 6.6
- dimension tables 6.6.1, 6.6.2
- materialized views 6.4
- partitioning in 6.1
- summaries 6.4
DATE data type 4.2.4.3, 4.2.4.3.1
datetime data types 4.2.4.3
DBA_ views 9.1.2.2
DBMS_DEVELOPER.GET_METADATA procedure 9.3
DBMS_METADATA package 9.3
DBMS_RADM package 20.1.4
DBMS_SERVICE package 13.5.1.2
DBMS_SPACE_ADMIN package 15.4.1.1
DBMS_SQL_MONITOR package 18.2.4
DBMS_STATS package 10.3.4
DBMS (database management system) 1.1.1
DBW background process 18.4.1.5
DDL (data definition language) 9.1
- described 10.2.1
- locks 12.4.2
deadlocks 10.4.1.1
- definition 12.3.6
decision support systems (DSS)
- materialized views 6.4
default values
- effect of constraints 7.3.3.1
deferred inserts 12.1.1.4, 17.2.4.2
definer’s rights 11.2.1.1
DELETE statement 10.2.2
- freeing space in data blocks 15.2.4.2
deletions, cascading 7.2.4.3
denormalized tables 6.6.2
dependencies, schema object 4.1.5
descending indexes 5.2.4
dictionary cache locks 12.4.3.3
dictionary managed tablespaces 15.1.2.2
dimensions 6.6
- attribute-clustered tables 4.4, 4.4.1, 4.4.5
- attributes 6.6.2
- hierarchies 6.6.2
  - join key 6.6.2
- normalized or denormalized tables 6.6.2
- tables 6.6.1
dimension tables 6.6.1
directory objects 4.1.3
direct path loads
- Hybrid Columnar Compression 4.2.7.2.3
dirty reads 12.1.1, 12.1.3
disk space
- data files used to allocate 14.2.4
dispatcher processes (Dnnn)
- client processes connect through Oracle Net Services 19.2.4, 19.2.4.1.1
- network protocols and 19.2.4.1.1
- prevent startup and shutdown 19.2.4.2
- response queue and 19.2.4.1
distributed databases 20.5.1.1
- client/server architectures and 19.1.1.1
- job queue processes 18.4.2.2
- recoverer process (RECO) and 18.4.1.9
- server can also be client in 19.1.1.1
- transactions 13.7
distributed transactions 13.2.1, 13.7, 20.5.1.1
- in-doubt 13.7.2
- naming 13.2.1
- two-phase commit and 13.7
DML (data manipulation language)
- indexed columns 5.3
- invisible indexes 5.1.2
- locks 12.4.1
- overview 10.2.2
- referential actions 7.2.4.3
- triggers 11.5.1
downtime
- avoiding during planned maintenance 20.2.2
- avoiding during unplanned maintenance 20.2.1.2
drivers 19.3.2
DUAL table 9.1.2.5
dynamic partitioning 18.4.3.2.3
dynamic performance views 9.2, 9.2.1
- database object metadata 9.3
- storage 9.2.2
dynamic SQL
- DBMS_SQL package 11.2.4
- embedded 11.2.4, 23.3.2.1

E

embedded SQL 10.1, 10.2.6, 23.3.2.1
EM Express 22.2.1.2
enqueued transactions 13.2.3.2
Enterprise Grids
- with Oracle Real Application Clusters 20.3
Enterprise Manager 16.2.2.4, 22.2.1
- alert log 16.6.2
- dynamic performance views usage 9.2
- executing a package 11.2.2.3
- lock and latch monitors 12.4.3
- shutdown 16.2.2.1, 16.2.2.4
Enterprise Manager for Zero Data Loss Recovery Appliance plug-in
- See: Recovery Appliance plug-in
equijoins 5.3.2
errors, recoverable 13.4, 20.2.1.4
exceptions, PL/SQL 11.2.4
exclusive locks 12.3.3
- row locks (TX) 12.4.1.1
- table locks (TM) 12.4.1.2
EXECUTE statement 11.2.1.3
execution plans 6.4.4, 10.3.1, 10.3.2.3, 22.3.4.5.5
- EXPLAIN PLAN 10.2.2
EXPLAIN PLAN statement 10.2.2, 22.3.4.5.1
explicit locking 12.5
expression column 4.2.1.1
expressions, SQL 5.1.3, 10.2.2.1
extended data-linked objects 3.2.5
extents 1.5.2.2
- as collections of data blocks 15.3
- deallocation 15.3.2
- defined 15.1.1
- dictionary managed 15.1.2.2
- incremental 15.3.1
- locally managed 15.1.2.1
- overview of 15.3
external procedures 11.2.6
external tables 4.2, 4.6, 4.6.4
- purpose 4.6.1
extraction, transformation, and loading (ETL)
- overview 20.4.3

F

fact tables 6.6.1
failures
- database buffers and 16.4.1
- statement and process 18.4.1.1
fast commit 18.4.1.6.1
fast full index scans 5.2.2.2
fast recovery area 22.3.1.2
fast refresh 6.4.2, 6.4.2.2
fields 4.2.3
file management locks 12.4.3.3
files
- alert log 18.4.1.6.2
- initialization parameter 16.2.1.2, 16.5
- password
  - administrator privileges 16.2.1.1
- server parameter 16.2.1.2, 16.5
- trace files 18.4.1.6.2
fine-grained auditing 20.1.6.1
fixed SGA 17.2.6
flash cache
- buffer reads 17.2.1.4.3
- optimized physical reads 17.2.1.4.3
floating-point numbers 4.2.4.2, 4.2.4.2.2
force full database caching mode 17.2.1.6.5
foreign keys 4.2.3, 7.2.4
- changes in parent key values 7.2.4.3
- composite 7.2.4
- constraints 7.2
- indexing 5.1.3, 7.2.4.4
- nulls 7.2.4.2
- updating parent key tables 7.2.4.3
- updating tables 12.4.1.3
format models, data type 4.2.4.3.1, 4.2.4.6
free space
- automatic segment space management 15.2.4
- managing 15.2.4
full index scans 5.2.2.1
full table scans 5.1.1, 5.2.2.2, 10.3.3
- default mode 17.2.1.6.1
- LRU algorithm and 17.2.1.6
- parallel exe 18.4.3.2.3
function-based indexes 5.4, 5.4.1, 5.4.2
functions 10.2.2.1
- aggregate 20.4.4.1
- analytic 20.4.4.1
- function-based indexes 5.4
- hash 6.1.1.2.4
- PL/SQL 11.2.1
- SQL 4.2.4.4.2
fuzzy reads 12.1.3

G

GDSCTL utility 13.5.1.2
global database names
- shared pool and 17.2.3.1.3
global indexes 6.1.3, 6.1.3.2
globalization support 23.3.3.1
Globally Distributed Database
- architecture 1.5.1.2
GRANT statement 6.7, 10.2.1
grid computing
- Database Server Grid 20.3
- Database Storage Grid 20.3
group commits 18.4.1.6.1

H

handles for SQL statements 17.3.1.1
hash clusters 4.3.2
- cluster keys 4.3.2.1
- hash collisions 4.3.2.4
- hash key values 4.3.2.1
- queries 4.3.2.2
- single-table 4.3.2.3
- storage 4.3.2.4
hash functions 4.3.2, 6.1.1.2.4
hash index 17.2.7.2
hash partitioning 6.1.1.2.4
headers, data block 12.4.1.1.2, 15.2.2.1
heap-organized tables 4.1.4, 5.6
height, index 5.2.1
hierarchies
- join key 6.6.2
- levels 6.6.2
high availability
- applications 20.2.2.3
- data corruption 20.2.1.4
hints, optimizer 10.3.1, 10.3.5, 17.2.4.2
Hybrid Columnar Compression 4.2.7.2, 4.2.7.2.1
- compression units 4.2.7.2.2
- DML 4.2.7.2.3
- row-level locks 4.2.7.2.2

I

image copies 22.3.1.3.3
IM column store
- See: In-Memory Column Store
immutable tables
- about 4.8
IM space manager
- See: In-Memory Space Manager
incarnations, database 22.3.1.4.3
incremental-forever strategy 22.3.1.5.1
incremental refresh 6.4.2, 6.4.2.2
index clustering factor 5.2.2.6
index compression 5.2.5
indexes
- advanced index compression 5.2.5.2
- application domain 5.5
- ascending 5.2.4
- automated 5.1.1, 5.1.7
- benefits 5.1.1
- bitmap 5.3, 5.3.1, 5.3.3, 5.6.3.2
- bitmap join 5.3.2
- branch blocks 5.2.1
- B-tree 4.2.6.3, 5.2
- cardinality 5.3
- composite 5.1.4
- compressed 5.2.5.1
- concatenated 5.1.4
- definition 1.2.2, 4.1.3
- descending 5.2.4
- domain 5.5
- enforcing integrity constraints 7.2.3
- extensible 5.5
- fast full scans 5.2.2.2
- function-based 5.4, 5.4.1, 5.4.2
- global 6.1.3, 6.1.3.2
- index clustering factor 5.2.2.6
- invisible 5.1.2
- keys 5.1.3, 7.2.3
- leaf blocks 5.2.1
- local 6.1.3
- local partitioned 6.1.3.1
- multiple 5.1.4
- nonprefixed, local 6.1.3.1.1
- nonunique 5.1.5
- overview 5.1
- partitioned 6.1.3, 6.1.3.1.2, 6.1.4
- partitioning
  - index 6.1.3.1.2
- prefixed, local 6.1.3.1.1
- prefixes 5.2.5.1
- range scans 5.2.2.3
- reverse key 5.2.3
- scans 5.2.2, 5.2.2.5, 10.3.3
- secondary 5.6.3
- segments 5.1.8, 5.3.3
- selectivity 5.2.2.3
- storage 5.1.8, 6.1.3.1.2
- storage space 6.1.4
- types 5.1.6
- unique 5.1.5
- unusable 5.1.2
indexes, updates 5.1.7
index-organized tables 5.6, 5.6.3
- benefits 5.6
- bitmap indexes 5.6.3.2
- characteristics 5.6.1
- row overflow 5.6.2
- secondary indexes 5.6.3
index unique scans 5.2.2.4
in-flight transactions 13.4
information systems 1.1
INIT.ORA
- See: initialization parameter file.
initialization parameter file 16.2.1.2, 16.5
- startup 16.2.1.2
initialization parameters
- about 16.5.1.2
- basic 16.5.1
- OPEN_CURSORS 17.3.1.1
- SERVICE_NAMES 19.2.2.3
In-Memory Column Store 1.5.3.2, 4.2.7.2
- memory management 22.3.2.1
- SQL execution 10.4.1.4
inner joins 10.2.2.2
in-place refresh method 6.4.2.3
INSERT statement 10.2.2
instance PGA
- memory management 22.3.2.3
instances, database 1.5.1, 10.2.5, 16.1
- associating with databases 16.2.1.3
- duration 16.1.4
- failure 14.4.1
- failures 12.4.1.1
- memory structures of 17.1
- process structure 18.1, 18.1.2
- recovery of
  - SMON process 18.4.1.4
- service names 19.2.2
- shutting down 16.2.2, 16.2.2.4
- terminating 16.2.2.2.2
INSTEAD OF triggers 11.5.2
integrity constraints 7.1, 7.1.1
- advantages 7.1, 7.1.2
- check 7.2.5
- definition 4.2.5
- nondeferrable 7.3.2.1
- precheckable 7.2.6
- updates of foreign and parent keys 7.3.3.2
- validating 7.3.2
- views 6.3.1.1
internal locks 12.4.3.3
internal tables 4.6.3
interval partitioned tables 6.1.1.2.2
invisible columns 4.2.1.2
invisible indexes 5.1.2
invoker’s rights 11.2.1.1
isolation levels
- serialization 12.2.2
isolation levels, transaction 12.1.3
- read committed 12.2.1
- read-only 12.2.3
- setting 12.5

J

Java
- overview 11.3
- stored procedures 1.3.2, 11.3.2.1
- virtual machine 11.3.1
JavaScript
- execution 11.4.2
- inline stored procedures 11.4.3
- overview 11.4
- stored procedures 1.3.2
- storing business logic as modules 11.4.1
JDBC 23.3.2.2.2
- accessing SQL 11.3.2.2
- drivers 11.3.2.2.1
- driver types 11.3.2.2.1
- embedded SQL 10.2.6, 23.3.2.1
job queue processes 18.4.2.2
jobs 18.1
join attribute clustering 4.4.2
joins
- views 6.3.2
joins, table 5.3.2, 9.1.2, 10.2.2.2
- Cartesian 10.2.2.2
- clustered tables 4.3
- conditions 5.3.2
- inner joins 10.2.2.2
- join conditions 10.2.2.2
- outer joins 10.2.2.2
- views 6.3
JSON
- comparison to XML 23.3.4.2.2
- Oracle Database support 23.3.4.2.3
- overview 23.3.4.2.1

K

key compression
- See: prefix compression
keys
- concatenation of index 5.2.5.1
- foreign 7.2.4, 7.2.4.4
- indexes 5.1.3, 5.2.5.1, 7.2.3
- natural 7.2.3
- parent 7.2.4, 7.2.4.4
- partition 6.1.1.1
- prefixed index 5.2.1
- referenced 7.2.4, 7.2.4.4
- reverse 5.2.3
- surrogate 7.2.3
- unique 7.2.2
- values 7.2

L

large pool 17.2.4
- deferred inserts 17.2.4.2
- memory management 17.2.4.1
latches
- definition 12.4.3.1
leaf blocks, index 5.2.1
least recently used (LRU) algorithm
- database buffers and 17.2.1.4.1
- full table scans and 17.2.1.6
- latches 17.2.1.6
- shared SQL pool 17.2.3.1.3, 17.2.4.1
LGWR background process 18.4.1.6
library cache 17.2.3, 17.2.3.1
Listener Control utility 22.2.4
listener process 1.5.4.2, 19.2.2
- listener registration process (LREG) 18.4.1.3
- service names 19.2.2
listener registration process (LREG) 18.4.1.3
listeners 1.5.4.2, 19.2.2
- listener registration process (LREG) 18.4.1.3
- service names 19.2.2
list partitioning 6.1.1.2.3
local indexes 6.1.3
locally managed tablespaces 15.1.2.1
local partitioned indexes 6.1.3.1
local temporary tablespaces 15.5.3.1
local users 4.1.1, 4.1.1.2
lock-free reservation 4.2.1.3
locks 12.1.2
- after committing transactions 13.2.5
- automatic 12.3.2, 12.4
- bitmap indexes 5.3
- conversion 12.3.3, 12.3.4
- deadlocks 10.4.1.1, 12.3.6
- definition 1.4.2
- dictionary 12.4.2
- dictionary cache 12.4.3.3
- DML 12.4.1
- duration 12.3.2, 12.3.5
- escalation 12.3.3
- exclusive 12.3.3
- exclusive DDL 12.4.2.1
- exclusive table 12.4.1.2
- file management locks 12.4.3.3
- Hybrid Columnar Compression 4.2.7.2.2
- latches 12.4.3.1
- log management locks 12.4.3.3
- manual 12.5
- overview of 12.1.2
- parse 12.4.2.3
- restrictiveness 12.3.3
- rollback segments 12.4.3.3
- row (TX) 12.4.1.1
- row exclusive table 12.4.1.2
- row share 12.4.1.2
- share DDL 12.4.2.2
- share locks 12.3.3
- share row exclusive 12.4.1.2
- share table 12.4.1.2
- system 12.4.3
- table 5.1.1, 10.2.2
- table (TM) 12.4.1.2
- tablespace 12.4.3.3
- types of 12.4
- unindexed foreign keys and 12.4.1.3
- user-defined 12.6
LOCK TABLE statement 10.2.2
log-based refresh 6.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, 15.5
logical rowids 5.6.3
logical transaction IDs 13.4.2.2
log management locks 12.4.3.3
log switches
- archiver process 18.4.2.1
- log sequence numbers 14.4.2.1
log writer process (LGWR) 18.4.1.6
- group commits 18.4.1.6.1
- online redo logs available for use 14.4.2.1
- redo log buffers and 17.2.2
- write-ahead 18.4.1.6
- writing to online redo log files 14.4.2.1
LONG data type
- storage of 4.2.6.1
lost updates 1.4.3, 12.2.1.2
lost writes
- shadow tablespaces 15.5.2.4.1
LRU 17.2.1.4.1, 17.2.1.6
- shared SQL pool 17.2.3.1.3

M

maintenance tasks, automatic 22.3.4.2
maintenance window 22.3.4.2
manual locking 12.5
mapping tables 5.6.3.2
master tables 6.4
materialized views 6.4
- characteristics 6.4.1
- complete refresh 6.4.2.1
- fast refresh 6.4.2.2
- incremental refresh 6.4.2.2
- in-place and out-of-place refresh 6.4.2.3
- refresh
  - job queue processes 18.4.2.2
- refreshing 6.4.2, 6.4.2.3
- zone maps and 4.4.3.2
media recovery
- complete 22.3.1.4.3
- overview 22.3.1.4.3
memoptimize pool 17.2.7.2, 22.3.2.1
memory
- allocation for SQL statements 17.2.3.1.1
- content of 17.1
- processes use of 18.1
- stored procedures 11.2.1.1
memory management
- about 22.3.2
- automatic 22.3.2.1
- automatic shared 22.3.2.2
- instance PGA 22.3.2.3
MERGE statement 10.2.2
Messaging Gateway 20.5.2.2.2
metadata-linked application common objects 3.2.2
metadata-linked common objects 3.2, 3.2.3
- metadata links 3.2.3.1
metadata links 3.2.3.1, 9.1.3.1
metrics 9.2, 22.3.4.1
MGA (managed global area)
- contents of 17.5
mle module
- example 11.4.1
monitoring user actions 20.1.6.1
multiblock writes 18.4.1.5
multiplexing
- control files 14.3.2
- redo log file groups 14.4.2.2
- redo log files 14.4.2.2
multitenant architecture
- definition 1.5.1.1
multitenant container databases
- See: CDBs
multiversion read consistency 9.2.2, 12.1, 12.1.1, 12.1.3, 15.4.3, 15.4.3.2
- deferred inserts 12.1.1.4
- dirty reads 12.1.1
- read committed isolation level 12.2.1.1
- statement-level 1.4.3, 12.1.1.1
- transaction-level 12.1.1.2
- undo segments 12.1.1.3
mutexes 12.4.3.2

N

NaN (not a number) 4.2.4.2
National Language Support (NLS) 23.3.3.1
natural keys 7.2.3
NCHAR data type 4.2.4.1.2
network listener process
- connection requests 19.2.4.1.1
networks
- client/server architecture use of 19.1.1
- communication protocols 19.3.2, 19.3.3
- dispatcher processes and 19.2.4.1.1
- drivers 19.3.2
- listener processes of 19.2.2
- Oracle Net Services 19.2
NLS_DATE_FORMAT parameter 4.2.4.3.1
NOAUDIT statement 10.2.1
nonunique indexes 5.1.5
normalized tables 6.6.2
NOT NULL constraints 7.2, 7.2.1
nulls 4.2.3
- foreign keys 7.2.4.2
- how stored 4.2.3, 4.2.6.4
- indexed 5.1.5
- prohibiting 7.2.1
NUMBER data type 4.2.4.2.1
numbers, floating point 4.2.4.2
numeric data types 4.2.4.2
- floating-point numbers 4.2.4.2.2
NVARCHAR2 data type 4.2.4.1.2

O

object store files
- accessing objects 6.1.5.2
- credential management 6.1.5.3
- deleting 6.1.5.5
- moving to traditional storage 6.1.5.4
object tables 4.2, 4.9
object types 4.9, 6.3.3
object views 6.3.3
ODBC 23.3.2.2.2
OLAP
- index-organized tables 5.6
OLTP
- table compression 4.2.7.1
online redo log 14.4.1, 15.4.3.2
- archiver process (ARCn) 18.4.2.1
- buffer management 18.4.1.6
- checkpoints 14.3.1
- committed data 16.4.1
- committing a transaction 18.4.1.6.1
- log switch
  - archiver process 18.4.2.1
- log writer process 17.2.2, 18.4.1.6
- rolling forward 16.4.1
- undo data in 15.4.3.3
- writing buffers 18.4.1.6
online redo log files 1.5.2.1
OPEN_CURSORS parameter
- managing private SQL areas 17.3.1.1
operating systems
- communications software 19.3.3
- privileges for administrator 16.2.1.1
optimized physical reads 17.2.1.4.3
optimizer 10.1.1, 10.3
- adaptive optimization 10.3.2.3
- components 10.3.2
- estimator 10.3.2.2
- execution 10.4.1.4
- execution plans 6.4.4, 10.3.1, 10.3.2.3, 10.4.1.3, 22.3.4.5.5
- function-based indexes 5.4.2
- hints 10.3.1, 10.3.5, 17.2.4.2
- invisible indexes 5.1.2
- partitions in query plans 6.1
- plan generator 10.3.2.3
- query plans 10.4.1.3
- query transformer 6.4.4, 10.3.2.1
- row sources 10.4.1.3
- statistics 4.2.6.1, 10.3.4, 10.4.1.2, 22.3.4.2
Optimizer Statistics Advisor
- about 22.3.4.5.2
Oracle Advanced Analytics 20.4.4.3
Oracle ASM (Automatic Storage Management) 14.1.3, 14.1.3.1, 20.3.3, 22.3.1.2
Oracle Audit Vault and Database Firewall 20.1.6.4
Oracle Automatic Storage Management
- See: Oracle ASM
Oracle blocks 15.1.1
Oracle Call Interface
- See: OCI
Oracle code 19.3
Oracle Connection Manager Control utility 22.2.4
Oracle Database
- history 1.1.4
Oracle Database Vault 20.1.5.1, 20.1.6.2
Oracle Data Mining 20.4.4.3.1
Oracle Data Pump 15.5.2, 20.1.5.1, 22.2.5.2
- dump file set 22.2.5.2
- unified audit trail 20.1.6.2
oracle data structures II
Oracle Enterprise Manager
- See: Enterprise Manager
Oracle Enterprise Manager Cloud Control (Cloud Control)
- See: Cloud Control
Oracle Flashback Technology 1.4.3, 22.3.1.4.1
Oracle Flex Clusters 20.3.2
Oracle GoldenGate 20.5.2, 20.5.2.1, 20.5.2.2.1
Oracle Internet Directory 19.2.2.3
Oracle JDeveloper 23.2.3
Oracle JVM
- main components 11.3.1.2
- overview 11.3.1.1
Oracle Label Security 20.1.5.3, 20.1.6.2
Oracle LogMiner 22.2.5.3
Oracle Machine Learning for R 20.4.4.3.2
Oracle Management Agents 22.2.1.1
Oracle Management Repository 22.2.1.1
Oracle Management Service (OMS) 22.2.1.1
Oracle Net 1.5.4.2
Oracle Net Configuration Assistant 22.2.4
Oracle Net Listener 1.5.4.2
Oracle Net Manager 22.2.4
Oracle Net Services 1.5.4.2, 19.2
- client/server systems use of 19.2
- overview 19.2
- shared server requirement 19.2.4.1.1
Oracle Net Services Connection Manager 11.3
Oracle processes 18.1.2, 18.3
Oracle program interface (OPI) 19.3.1
Oracle RAC
- See: Oracle Real Application Clusters
Oracle Real Application Clusters
- Enterprise Grids 20.3
- Oracle Flex Clusters 20.3.2
- reverse key indexes 5.2.3
Oracle Secure Backup 22.3.1.1
Oracle Sharding
- about 6.2
Oracle Spatial and Graph 23.3.4.5
Oracle Text 23.3.4.4
Oracle Universal Installer (OUI) 22.2.3
Oracle XA
- session memory in the large pool 17.2.4
ORDBMS (object-relational database management system) 1.1.3
outer joins 10.2.2.2
out-of-place refresh method 6.4.2.3

P

packages 11.2.2
- advantages of 11.2.2.1
- creation 11.2.2.2
- executing 11.2.6
- for locking 12.6
- private 11.2.2.1
- public 11.2.2.1
- shared SQL areas and 17.2.3.1.2
- subprogram executions 11.2.2.3
pages 15.1.1
parallel execution 18.4.3.2
- coordinator 18.4.3.2.3
- server 18.4.3.2.3
- servers 18.4.3.2.3
- tuning 18.4.3.2
parallel SQL 18.4.3.2
- coordinator process 18.4.3.2.3
- server processes 18.4.3.2.3
parameters
- initialization 16.5
  - locking behavior 12.4
parse locks 12.4.2.3
parsing, SQL 10.4.1, 10.4.1.1
- embedded SQL 10.2.6
- hard parse 12.4.3.1
- storage of information 9.1.3.3
partial global partitioned indexes 6.1.4
partitioned change tracking refresh 6.4.2.2
partitioned indexes 6.1.3.1
- global 6.1.3.2
- storage 6.1.3.1.2
partitioned tables 6.1.1.2.4
- interval 6.1.1.2.2
- reference 6.1.1.2.5
partitioning
- by hash 6.1.1.2.4
- by interval 6.1.1.2.2
- by list 6.1.1.2.3
- by range 6.1.1.2.1
- by reference 6.1.1.2.5
- composite 6.1.1.2.6
- index 6.1.3.2
- indexes 6.1.3.1
- key 6.1.1.1
partitions
- characteristics 6.1.1
- composite partitioning 6.1.1.2
- definition 4.1.3
- dynamic partitioning 18.4.3.2.3
- elimination from queries 6.1.3.1.1
- index 6.1.3
- keys 6.1.1.1
- materialized views 6.4.1
- moving to object store 6.1.5.1
- overview 6.1
- partitions
  - composite 6.1.1.2
- range 6.1.1.2
- segments 15.4.1
- single-level 6.1.1.2
- strategies 6.1.1.2
- table 6.1.1.2.1, 6.1.1.2.3, 6.1.2, 6.1.4
- using object store 6.1.5
passwords
- administrator privileges 16.2.1.1
- connecting with 18.2.2
PCTFREE storage parameter
- how it works 15.2.4.1
PDB$SEED 2.3.1
PDBs 1.5.1.1
- character sets 2.2
- cloning 2.3.2
- common users 3.2.1.2
- connecting to 19.2.2.2.2
- containers 2
- current container 18.2.3
- database links 2.3.5
- definition 2.3
- flashback 22.3.1.4.1
- naming rules 2.3.4
- proxy 2.3.1, 2.3.3
- purpose of 2.3.2
- services 19.2.2.2, 19.2.2.2.1, 19.2.2.2.1.1, 19.2.2.2.1.2
- temp files 15.5.1
- types 2.3.1
performance
- group commits 18.4.1.6.1
- packages 11.2.2.1
PGA
- See: program global area (PGA)
PGA_AGGREGATE_LIMIT initialization parameter 22.3.2.3
PGA_AGGREGATE_TARGET initialization parameter 22.3.2.3
phantom reads 12.1.3
physical database structures
- control files 1.5.2.1, 14.3
- data files 1.5.2.1
- online redo log files 1.5.2.1
physical guesses 5.6.3.1
PL/SQL
- anonymous blocks 11.2, 11.2.3
- collections 11.2.5, 11.2.5.1
- data types 4.2.4
- dynamic SQL 11.2.4
- exceptions 11.2.4
- execution 11.2.6
- execution of subprograms 11.2.1.3
- language constructs 11.2.4
- overview 11.2
- package creation 11.2.2.2
- packages 9.3, 11.2.2, 11.2.2.1
- PL/SQL engine 11.2.6
- program units 11.2.1.1, 17.2.3.1.2
  - shared SQL areas and 17.2.3.1.2
- records 11.2.5, 11.2.5.1, 11.2.5.2
- stored procedures 1.3.2, 9.1.2.3, 11.2, 11.2.1, 11.2.1.1, 11.2.2.1
- units 11.2
  - compiled 11.2.6
plan
- SQL execution 10.2.2
planned downtime
- avoiding downtime during 20.2.2
pluggable databases
- See: PDBs
PMAN background process 18.4.1.2
PMON background process 18.4.1.1.1
pragmas, PL/SQL 13.6
precheckable check constraints 7.2.6
precompilers 11.1
- COBOL 23.3.2.1.1
- embedded SQL 10.2.6
- FORTRAN 23.3.2.1.1
- Pro*C/C++ 23.3.2.1.1
predicates, SQL 5.2.2.1, 10.1.1
primary key constraints 7.2
primary keys 4.2.3, 5.1.1
- constraints 7.2.3
- hash clusters 4.3.2.3
- index-organized tables 4.2
private SQL areas 17.2.3.1.1
- described 17.2.3.1.1
- how managed 17.3.1.1
- parsing and 10.4.1.1
private synonyms 6.7
privileges 9.1, 10.2.4, 20.1.1.1
- administrator 16.2.1.1
- granting 10.2.1, 20.1.1.3
- PL/SQL procedures and 11.2.1.1
- privilege profiler 20.1.1.3
- revoking 10.2.1
procedures
- advantages 11.2.1.1
- execution 11.2.1.3, 11.2.6
- execution in a PL/SQL package 11.2.2.3
- external 11.2.6
- memory allocation 11.2.1.1
- security 11.2.1.1
- shared SQL areas and 17.2.3.1.2
- stored procedures 1.3.2, 9.1.2.3, 11.2, 11.2.6
processes 18.1
- archiver (ARCn) 18.4.2.1
- background 1.5.3.1, 18.4
- background (BGnn) 18.4.1.10
- checkpoints and 18.4.1.5
- client 1.5.3.1, 18.2
- dedicated server 19.2.4.1.2
- definition 1.5.3.1
- distributed transaction resolution 18.4.1.9
- job queue 18.4.2.2
- listener 19.2.2
  - shared servers and 19.2.4.1.1
- log writer (LGWR) 18.4.1.6
- multithreaded 18.1.2
- Oracle 18.3
- parallel execution coordinator 18.4.3.2.3
- parallel execution servers 18.4.3.2.3
- process monitor (PMON) 18.4.1.1.1
- recoverer (RECO) 18.4.1.9
- server 1.5.3.1, 18.3
  - shared 19.2.4.1.1, 19.2.4.1.2
- shared server 19.2.4
  - client requests and 19.2.4.1
- structure 18.1
- system monitor (SMON) 18.4.1.4
- user
  - recovery from failure of 18.4.1.1
  - sharing server processes 19.2.4.1.1
- virtual operating system daemon process (VOSD) 18.4.1.11
processing
- parallel SQL 18.4.3.2
process manager process (PMON)
- state objects 18.4.1.1.4
process monitor process (PMON)
- described 18.4.1.1.1
program global area (PGA) 1.5.3.2, 17.1.1
- shared server 19.2.4.1.2
- shared servers 19.2.4.1.2
program interface 19.3
- Oracle side (OPI) 19.3.1
- structure of 19.3.1
- user side (UPI) 19.3.1
programming, server-side 1.3.2, 11.1
program units
- shared pool and 17.2.3.1.2
Property Graph 23.3.4.6
protection policies
- benefits 22.3.1.5.1
proxy PDBs 2.3.1, 2.3.3, 2.3.5
pseudocode
- triggers 11.5.6
pseudocolumns 4.2.4.4.2, 5.6.1
public synonyms 6.7

Q

quarantined transaction 13.3
queries
- blocks 10.2.2.3
- definition 10.2.2.1
- implicit 12.2.1.1
- in DML 10.2.2
- parallel processing 18.4.3.2
- query blocks 10.3.2.3
- query transformer 10.3.2.1
- SQL language and 10.1
- stored 6.3
- subqueries 6.3, 10.2.2, 10.2.2.3
query blocks 10.3.2.3
query optimizer
- See: optimizer
query plans 10.4.1.3
- partitioning and 6.1
query rewrite 6.6
query transformer 6.4.4

R

range partitioning 6.1.1.2.1
range partitions 6.1.1.2
range scans, index 5.2.2.3
RDBMS (relational database management system) 1.1.3
RDMA 17.2.7.2
read committed isolation 12.2.1
read consistency
- See: multiversion read consistency
read-only isolation level 12.2.3
read-only tablespaces
- moving to object store 6.1.5.1
read uncommitted 12.1.3
Real Application Clusters
- cache fusion 12.1.1.3
- system monitor process and 18.4.1.4
- threads of online redo log 14.4.2
records, PL/SQL 11.2.5, 11.2.5.1, 11.2.5.2
recoverable errors 13.4, 20.2.1.4
recoverer process (RECO) 18.4.1.9
- in-doubt transactions 13.7.2
recovery
- complete 22.3.1.4.3
- database buffers and 16.4.1
- distributed processing in 18.4.1.9
- instance recovery
  - SMON process 18.4.1.4
- media 22.3.1.4.3
  - dispatcher processes 19.2.4.2
- process recovery 18.4.1.1
- required after terminating instance 16.2.2.2.2
- rolling back transactions 16.4.4
- tablespace
  - point-in-time 22.3.1.4.3
Recovery Appliance 22.3.1.5.1
- backup modules 22.3.1.5.2
- metadata database 22.3.1.5.2
- plug-in 22.3.1.5.1
recovery catalog 22.3.1.5.2
Recovery Manager 9.2, 22.3.1.1
- architecture 22.3.1.2
- auditing 20.1.6.2
- backups 22.3.1.3.3
- Recovery Appliance 22.3.1.5.1
redaction, data 20.1.4
- policies 20.1.4
redo log buffer 14.4.1
redo log files
- available for use 14.4.2.1
- circular use of 14.4.2.1
- contents of 14.4.3
- distributed transaction information in 14.4.2
- group members 14.4.2.2
- groups, defined 14.4.2.2
- instance recovery use of 14.4
- LGWR and the 14.4.2.1
- members 14.4.2.2
- multiplexed 14.4.2.2
- online, defined 14.4
- redo entries 14.4.3
- threads 14.4.2
redo logs buffer 17.2.2
redo records 14.4.3
REF constraints 7.2
reference partitioned tables 6.1.1.2.5
referential integrity
- examples of 7.3.3
- self-referential constraints 7.3.3
refresh
- incremental 6.4.2
- job queue processes 18.4.2.2
- materialized views 6.4.2, 6.4.2.3
relational database management system
- See: RDBMS
relations, simple 1.1.2
reserved words 10.2
resource management 22.3.3.1
response queues 19.2.4.1
RESULT_CACHE clause 17.2.3.3.1
result cache 17.2.3.3, 17.2.3.3.1
result sets, SQL 4.2, 4.2.4.4.2, 4.5, 6.3.2, 10.2.2.1
reverse key indexes 5.2.3
REVOKE statement 10.2.1
rights, definer’s and invoker’s 11.2.1.1
roles 4.1.3, 9.1.2.3, 10.2.4
rollback 13.2.4
- described 13.2.4
- ending a transaction 13.2.4
- implicit in DDL 10.2.1
- statement-level 12.3.6, 13.1.3
- to a savepoint 13.2.3.1
- transaction-level 10.2.3
rollback segments
- locks on 12.4.3.3
- parallel recovery 16.4.4
- use of in recovery 16.4.4
ROLLBACK statement 13.2
rolling back 13.1, 13.2.4
root container 2.1, 2.2
row chaining 15.2.4.3
row data (section of data block) 15.2.2.2
row directories 15.2.2.1
ROWID data type 4.2.4.4, 4.2.4.4.1
rowids 4.2.6.3
- foreign 4.2.4.4
- index 5.1.5
- logical 4.2.4.4, 5.6.3
- physical 4.2.4.4
- row migration 15.2.4.3
- scans 10.3.3
- universal 4.2.4.4
row locks 12.4.1.1
- concurrency 12.4.1.1.1
- storage 12.4.1.1.2
row pieces 4.2.6.2
rows
- addresses 4.2.6.3
- chaining across blocks 4.2.6.2, 15.2.4.3
- clustered 4.2.6.2
- definition 1.2.1, 4.2.2
- format of in data blocks 15.2.2.1
- locking 12.4.1.1
- locks on 12.4.1.1
- migrating to new block 15.2.4.3
- row set 10.4.1.3
- row source 10.4.1.3
- shown in rowids 15.2.2.2.3
- storage 4.2.6.2
- triggers 11.5.2
row source generation 10.4.1.3

S

sample schemas 4.1.6
savepoints 10.2.3, 13.2.3
- definition 13.2.3
- implicit 13.1.3
- rolling back to 13.2.3.1
- SAVEPOINT statement 13.2
SAVEPOINT statement 10.2.3
SBT libraries 22.3.1.5.2
scans
- cluster 10.3.3
- fast full index 5.2.2.2
- full index 5.2.2.1
- full table 5.1.1, 10.3.3, 17.2.1.6, 17.2.1.6.1
- index 5.2.2, 10.3.3
- index skip 5.2.2.5
- range 4.3.2.2
- rowid 10.3.3
- unique index 5.2.2.4
schema objects
- definitions 1.2, 9.1, 10.2.1
- dependencies 4.1.5, 6.3.1
- dimensions 6.6
- indexes 5.1
- introduction 4.1
- materialized views 6.4
- relationship to data files 14.2.1
- sequences 6.5
- storage 4.1.4
schemas 1.2, 4.1
- sample 4.1.6
SCN
- See: system change numbers
secondary indexes 5.6.3
- benefits 5.6.3
- physical guesses 5.6.3.1
SecureFiles 23.3.4.3.3
security
- administrator privileges 16.2.1.1, 20.1.1.1
- auditing 20.1.6.1
- definer’s rights 11.2.1.1
- program interface enforcement of 19.3
- views 6.3
seed PDB 2.1
segment advisor 22.3.4.2
segments 1.5.2.2, 15.4
- data 15.4.1
- defined 15.1.1
- index 5.1.8, 5.3.3
- overview of 15.4
- table storage 4.2.6
- temporary 4.5.2, 15.4.2
  - allocating 15.4.2
- user 15.4.1.1
selectivity 5.2.2.3
select lists, SQL 10.2.2.1
SELECT statement 10.2.2
self-referential integrity constraints 7.2.4.1
sequences
- characteristics 6.5.1
- concurrent access 6.5.2
- definition 4.1.3, 6.5
- surrogate keys 7.2.3
serializability, transactional 12.1
serialization isolation level 12.2.2
server parameter file
- about 16.5.2
- startup 16.2.1.2
server processes 1.5.3.1, 18.3
- creation 18.3.3
- listener process 19.2.2
servers
- client/server architecture 19.1.1
- shared
  - architecture 18.1.1, 19.2.4
  - processes of 19.2.4, 19.2.4.1.2
server-side programming 11.1
- overview 11, 11.1
SERVICE_NAMES parameter 19.2.2.3
service names 19.2.2
service-oriented architecture 1.5.4.1, 19.1.2.4
service tiers
- See: Recovery Appliance service tiers
session control statements 10.2.4
sessions 10.2.4
- connections contrasted with 18.2.2
- defined 18.2.2
- memory allocation in the large pool 17.2.4
- sequence generation in 6.5.2
SET CONSTRAINT statement 10.2.3
SET TRANSACTION statement 10.2.3, 13.1.2.1
SGA (system global area) 1.5.3.2, 17.1.1
- allocating 16.2.1.2
- big table cache 17.2.1.5
- contents of 17.2
- database buffer cache 17.2.1
- data dictionary cache 9.1.3.3, 17.2.3.2
- fixed SGA 17.2.6
- large pool 17.2.4
- redo log buffer 13.2.2, 17.2.2
- rollback segments and 13.2.2
- shared and writable 17.2
- shared pool 11.2.1.1, 17.2.3
- variable parameters 16.5.1.1
shadow lost write protection 15.5.2.4
- configuring 15.5.2.4.4
- enabling 15.5.2.4.2
- purpose 15.5.2.4.1
shadow tablespaces 15.5.2.4
- creating 15.5.2.4.4
- how they work 15.5.2.4.2
- purpose 15.5.2.4.1
- user interface 15.5.2.4.3
sharded database (SDB) 6.2
sharded tables 6.2
shards 6.2
share DDL locks 12.4.2.2
shared pool 11.2.6, 17.2.3, 17.2.3.1.3
- allocation of 17.2.3.1.3
- dependency management and 17.2.3.1.3
- described 17.2.3
- flushing 17.2.3.1.3
- latches 12.4.3.1
- parse locks 12.4.2.3
shared server
- described 18.1.1
- dispatcher processes 19.2.4.1.1
- Oracle Net Services or SQL*Net V2 requirement 19.2.4.1.1
- processes 19.2.4.1.2
- processes needed for 19.2.4
- restricted operations in 19.2.4.2
- session memory in the large pool 17.2.4
shared server processes (Snnn) 19.2.4.1.2
- described 19.2.4.1.2
shared SQL areas 6.3.1.2, 17.2.3, 17.2.3.1.1, 17.2.3.1.3
- dependency management and 17.2.3.1.3
- described 17.2.3.1.1
- parse locks 12.4.2.3
- procedures, packages, triggers and 17.2.3.1.2
shared temporary tablespaces 15.5.3.1
share locks 12.3.3
shutdown 16.2.2, 16.2.2.4
- abnormal 16.2.2.4
- prohibited by dispatcher processes 19.2.4.2
- steps 16.2.2
SHUTDOWN ABORT statement 16.2.2.4
Simple Object Access Protocol (SOAP)
- See: SOAP
simple triggers 11.5.3
single-level partitioning 6.1.1.2
SMON background process 18.4.1.4
SOA 1.5.4.1, 19.1.2.4
SOAP (Simple Object Access Protocol) 1.5.4.1
software code areas 17.1.1
space management
- extents 15.3
- PCTFREE 15.2.4.1
- row chaining 15.2.4.3
- segments 15.4
Space Management Coordinator Process (SMCO) background process 17.2.4.2
SQL 10.1, 10.2
- conditions 10.1.1, 10.2.2.1
- data definition language (DDL) 10.2.1
- data manipulation language (DML) 10.2.2
- definition 1.3.1
- dictionary cache locks 12.4.3.3
- dynamic SQL 11.2.4
- embedded 10.1, 10.2.6, 23.3.2.1
- executable 13.1.2.1
- execution 10.4.1.4, 13.1.3
- expressions 5.1.3, 10.2.2.1
- functions 4.2.4.4.2
- interactive 10.1
- memory allocation for 17.2.3.1.1
- operators 10.1.1
- optimization 10.4.1.2
- Oracle 1.3.1, 10.1.2
- overview 10.1
- parallel execution 18.4.3.2
- parsing 10.4.1, 10.4.1.1
- PL/SQL and 11.2
- predicates 5.2.2.1, 10.1.1
- processing 10.4.1
- reserved words 10.2
- result sets 4.2, 4.2.4.4.2, 4.5, 6.3.2, 10.2.2.1
- select lists 10.2.2.1
- session control statements 10.2.4
- standards 10.1.2
- statements 10.2
- subqueries 6.3, 10.2.2.3
- system control statements 10.2.5
- transaction control statements 10.2.3
- transactions 13.1
- types of statements 10.2
SQL*Loader 22.2.5.1
SQL*Plus 22.2.2
- alert log 16.6.2
- executing a package 11.2.2.3
- lock and latch monitors 12.4.3
SQL areas
- private 17.2.3.1.1
- shared 17.2.3.1.1
SQL tuning advisor 22.3.4.2
SRVCTL utility 13.5.1.2
standard auditing 20.1.6.1
standards
- ANSI/ISO 10.1.2
  - isolation levels 12.1.3
star schemas 4.4.5
startup 16.1
- prohibited by dispatcher processes 19.2.4.2
statement-level atomicity 13.1.3
statement-level read consistency 12.1.1.1
statement-level rollback 12.3.6, 13.1.3
statements, SQL 10.2
statistics 4.2.6.1, 9.2, 10.3.1, 17.2.3.1.3
- ASH 22.3.4.4
- AWR 22.3.4.2
- definition 10.3.4
- gathering for optimizer 22.3.4.2
- Java-related 17.2.5
- join order 10.2.2.2
- optimizer 10.4.1.2
- undo retention 15.5.2.3.2
storage
- logical structures 15.5
- nulls 4.2.3
- triggers 11.5.6
stored procedures
- See: procedures
Structured Query Language (SQL) 10.1
structures
- locking 12.4.2
- logical 15
  - data blocks 15, 15.2, 15.2.5
  - extents 15.1, 15.3
  - segments 15.1, 15.4
  - tablespaces 14, 15.5
- physical
  - control files 14.3
  - data files 14
- processes 18
subprograms, PL/SQL
- See: procedures
subqueries 6.3, 10.2.2, 10.2.2.3
summaries 6.4
surrogate keys 7.2.3
synonyms
- constraints indirectly affect 7.3.3.2
- data dictionary views 9.1.3.2
- definition 4.1.3, 6.7
- private 6.7
- public 6.7, 9.1.2.4
- securability 6.7
SYSDBA privilege 16.2.1.1
SYSOPER privilege 16.2.1.1
system change numbers (SCN) 13.1.4
- committed transactions 13.2.5
- defined 13.2.5
- definition 12.1.1.3.1
- when assigned 14.4.3
system container 2.2
system control statements 10.2.5
system global area
- See: SGA
system locks 12.4.3
- internal 12.4.3.3
- latches 12.4.3.1
- mutexes 12.4.3.2
system monitor process (SMON) 18.4.1.4
- defined 18.4.1.4
- Real Application Clusters and 18.4.1.4
- rolling back transactions 16.4.4
SYSTEM tablespace
- data dictionary stored in 15.5.2.1
- online requirement of 15.5.4.2
SYSTEM user name 4.1.1.1.2
SYS user name 4.1.1.1.2
- data dictionary tables 9.1.3

T

table clusters
- cluster keys 4.3
- definition 4.3
- hash clusters 4.3.2, 4.3.2.2, 4.3.2.3
- hash cluster storage 4.3.2.4
- indexed 4.3.1
- overview 4
- scans 10.3.3
table partitions 6.1.1.2.1
tables
- attribute-clustered 4.4.2
- automatic big table caching 17.2.1.4.1, 17.2.1.5
- base 6.3.1
- characteristics 4.2.3
- clustered 4.3
- compression 4.2.7, 6.1.2.2
- definition 1.1.2, 1.2.1, 4.1.3
- dimension 6.6.1
- directories 15.2.2.1
- DUAL 9.1.2.5
- dynamic partitioning 18.4.3.2.3
- external 4.6, 4.6.3, 4.6.4
- fact 6.6.1
- full table scans 5.1.1, 17.2.1.6.1
- heap-organized 4.1.4, 5.6
- index-organized 5.6, 5.6.1, 5.6.2, 5.6.3
- integrity constraints 7.1
- joins 5.3.2
- master 6.4
- normalized or denormalized 6.6.2
- object 4.9
- overview 4, 4.2
- partitioned 6.1.1.1, 6.1.1.2.3, 6.1.1.2.4
- partitions 6.1.2
- permanent 4.2
- storage 4.2.6
- temporary 4.5, 4.5.3, 15.4.2.2
- transaction 13.1.2.1
- truncating 10.2.1, 15.3.2
- views of 6.3
- virtual 9.2.2
tables, attribute-clustered 4.4
- dimensional hierarchies 4.4.5
- linear ordering 4.4.4
- zone maps 4.4.3, 4.4.3.2
tables, base 6.3
tables, external 4.2
tables, object 4.2
tables, temporary 4.2
tablespace point-in-time recovery 22.3.1.4.3
tablespaces 1.5.2.2, 15.5
- described 15.5
- dictionary managed 15.1.2.2
- locally managed 15.1.2.1
- locks on 12.4.3.3
- offline 15.5.4.2
- online 15.5.4.2
- overview of 15.5
- recovery 22.3.1.4.3
- schema objects 4.1.4
- space allocation 15.1.2
- used for temporary segments 15.4.2.1
tasks 18.1
temp files 14.2.2
temporary segments 4.5.2, 15.4.2.2
- allocating 15.4.2.1
- allocation for queries 15.4.2.1
temporary tables 4.2
- creation 4.5.3
- global 4.5
- private 4.5
- purpose 4.5.1
temporary tablespaces 15.5.3
- creation of default 15.5.3.2.1
- local 15.5.3.1
- shared 15.5.3.1
threads
- online redo log 14.4.2
TIMESTAMP data type 4.2.4.3, 4.2.4.3.2
time zones 4.2.4.3.2
- in date/time columns 4.2.4.3.2
TO_CHAR function 4.2.4.6
TO_DATE function 4.2.4.3.1, 4.2.4.6
trace files
- LGWR trace file 18.4.1.6.2
transaction control statements 10.2.3
Transaction Guard 13.4, 13.5.2, 20.2.1.4
- benefits 13.4.1
- how it works 13.4.2
transaction-level read consistency 12.1.1.2
transaction management
- definition 1.4
transactions 13
- ACID properties 13.1
- active 13.2.2, 15.4.3
- assigning system change numbers 13.2.5
- autonomous 13.6
  - within a PL/SQL block 13.6
- beginning 13.1.2.1
- blocking 12.2.1.2
- committing 13.4.2.1, 18.4.1.6.1
  - group commits 18.4.1.6.1
- conflicting writes 12.2.1.2
- deadlocks 12.3.6, 13.1.3
- definition 1.4.1, 13.1
- distributed 13.2.1, 13.7, 20.5.1.1
  - resolving automatically 18.4.1.9
- DML statements 10.2.2
- ending 13.1.2.2
- enqueued 13.2.3.2
- idempotence 13.4, 20.2.1.4
- in-doubt
  - resolving automatically 13.7.2
- in-flight 13.4
- isolation levels 12.1.3, 12.2.2, 12.2.3
- isolation of 12.1.3
- logical transaction ID 13.4.2.2
- naming 13.2.1
- read consistency 12.1.1.2
- rolling back 13.2.4
  - partially 13.2.3.1
- savepoints in 13.2.3
- serializability 12.1
- setting properties 10.2.3
- structure 13.1.2
- terminated 15.4.3
- terminating the application and 13.1.2.2
- transaction control statements 10.2.3
- transaction history 12.1.1.3.2
- transaction ID 13.1, 13.1.2.1
transactions (
- quarantine 13.3
transaction tables 13.1.2.1
- reset at recovery 18.4.1.1
triggers 11.1
- cascading 11.5.1
- components of 11.5.4
- compound 11.5.3
- effect of rollbacks 13.1.3
- firing (executing) 11.5.5
  - privileges required 11.5.5
- INSTEAD OF 11.5.2
- overview 11.5
- restrictions 11.5.4
- row 11.5.2
- shared SQL areas and 17.2.3.1.2
- simple 11.5.3
- statement 11.5.2
- storage of 11.5.6
- timing 11.5.3
- UNKNOWN does not fire 11.5.4
- uses of 11.5.1
TRUNCATE statement 10.2.1, 15.3.2
tuples, definition 1.1.2
two-phase commit
- transaction management 13.7

U

undo management, automatic 15.4.3
undo mode
- CDBs 15.5.1
undo retention period 15.5.2.3.2
undo segments 13.1.2.1, 15.4.3
- read consistency 12.1.1.3
- temporary 14.4.1, 15.4.3, 15.4.3.3
undo space management
- automatic undo management mode 15.5.2.3.1
undo tablespaces 15.4.3, 15.5.2.3, 15.5.2.3.1, 15.5.2.3.2
- undo retention period 12.2.3
Unicode 4.2.4.1
unified audit trail 19.1.2.3, 20.1.5.3, 20.1.6.2
unique indexes 5.1.5
unique key constraints 7.2, 7.2.2
- composite keys 7.2.2
- NOT NULL constraints and 7.2.2
unplanned downtime
- avoiding downtime during 20.2.1.2
updatable join views 6.3.2
update no action constraint 7.2.4.3
updates
- lost 12.2.1.2
- tables with parent keys 12.4.1.3
- updatability of views 6.3.2, 11.5.2
- updatable join views 6.3.2
UPDATE statement 10.2.2
upgrades
- database 9.1.1.2, 15.5.2.2, 15.5.2.3.1, 20.2.2.3, 23.3.1
UROWID data type 4.2.4.4
USER_ views 9.1.2.4
user global area (UGA) 17.1.1
user program interface (UPI) 19.3.1
users
- common 2.1, 3.2.1.2, 4.1.1.1
users, database 4.1.3
- authentication 20.1.2
- names 9.1
  - sessions and connections 18.2.2
- privileges 4.1, 20.1.1.1
- temporary tablespaces 15.4.2.1
user segments 15.4.1.1
UTL_HTTP package 11.2.2

V

V$ views 9.2.1
- database object metadata 9.3
- storage 9.2.2
VARCHAR2 data type 4.2.4.1, 4.2.4.1.1
variables
- embedded SQL 10.2.6
views 6.3
- analytic 20.4.4.2
- base tables 6.3
- characteristics 6.3.1
- constraints indirectly affect 7.3.3.2
- data access 6.3.1.2
- data dictionary
  - updatable columns 6.3.2
- definition 4.1.3
- DML 6.3.1.1
- dynamic performance 9.2, 9.2.1
- indexes 6.3.1.2
- INSTEAD OF triggers 11.5.2
- integrity constraints 6.3.1.1
- materialized 6.4
- object 6.3.3
- schema object dependencies 6.3.1
- storage 6.3.1
- updatability 6.3.2
- uses 6.3
- V$ 9.2
virtual columns 4.2.1.1, 4.2.6.1, 5.4.2
virtual operating system daemon process process (VOSD) 18.4.1.11

W

warehouse
- materialized views 6.4
Web services 1.5.4.1, 19.1.2.4
write-ahead 18.4.1.6

X

XA
- session memory in the large pool 17.2.4
XMLType data type 23.3.4.1
XStream 20.5.2.2.1

Z

Zero Data Loss Recovery Appliance
- See: Recovery Appliance
zone maps 4.4.3, 4.4.3.2