Index

A

about 1
access drivers, external table 1
access paths, data 1, 2, 3, 4
accounts, user 1
ACID properties 1
active transactions 1
ADDM (Automatic Database Diagnostic Monitor) 1, 2
administrative accounts 1, 2
administrator privileges 1, 2, 4, 5
ADR 1
advanced index compression 1
Advanced Queuing, Oracle Streams 1
advantages 1
aggregate function 1
alert log
- about 1
alert logs 1
ALL_ data dictionary views 1
ALTER DATABASE statement
- application roots 1
ALTER TABLE statement 1
analytic functions 1
anonymous PL/SQL blocks 1
ANSI/ISO standard 1
APIs (application program interfaces) 1
- client-side 1
- embedded SQL statements 1
- external tables 1
- Java 1, 2, 3
- JDBC 1, 3, 4
- network services 1
- OCI/OCCI 1
- ODBC 1, 2
- Oracle Database Advanced Queuing 1
- Oracle Data Pump 1
application and networking architecture 1
application architecture 1
application common objects 1, 2
- creation 1
- data-linked 1, 2
- extended data-linked objects 1
- metadata-linked common objects 1
- metadata links 1
- naming rules 1
application containers
- about 1
- application common objects 1, 2, 3, 4
- application roots 1
- applications 1, 2
- applications created implicitly 1
- application seeds 1
- application synchronization 1
- application versions 1
- container maps 1
- how an application upgrade works 1
- installing applications 1, 2, 3
- migrating an application 1
- naming rules 1
- patching applications 1
- purpose 1, 2, 3, 4
- upgrading applications 1, 2
application contexts, auditing 1
Application Continuity 1, 2
- architecture 1
- benefits 1
- planned maintenance 1
- use case 1
application developers
- duties of 1
- tools for 1
- topics for 1
application domain indexes 1
application PDBs 1
- application synchronization 1
- naming rules 1
- synchronization 1
application processes 1
application program interface
- See: API
application roots 1
applications
- in a CDB
  - metadata-linked common objects 1
- in application containers 1, 2, 3, 4
  - at different versions 1
  - created implicitly 1
  - migrating an application 1
  - patching 1
  - synchronization 1
- upgrades 1
applications containers
- application PDBs 1
application seeds 1, 2, 3
application servers 1, 2
- about 1
architecture 1
archived redo log files 1, 2, 3
ARCHIVELOG mode 1
archiver process (ARCn) 1
ascending indexes 1
ASSM tablespace 1
asynchronous notifications 1
atomicity, statement-level 1
attribute-clustered tables
- benefits 1
- dimensional hierarchies 1
- interleaved ordering 1
- join attribute clustering 1
- linear ordering 1
- overview 1
- zone maps 1, 2
auditing 1, 2, 3, 4, 5, 6, 7
- application contexts 1
- Audit Administrator role 1
- audit configurations 1
- audit policies 1, 3, 4
- audit records 1
- common objects 1
- fine-grained 1
- Oracle Audit Vault and Database Firewall 1
- Oracle Label Security 1
- standard 1
- unified audit trail 1, 2, 3
AUDIT statement 1
authentication, database 1, 2, 3
automatic big table caching 1, 2
Automatic Database Diagnostic Monitor
- See: ADDM
Automatic Diagnostic Repository (ADR) 1, 2
automatic maintenance tasks 1
automatic memory management 1, 2
automatic segment space management (ASSM) 1
automatic undo management 1, 2
automatic undo mode 1
Automatic Workload Repository (AWR) 1
AutoTask 1
AWR
- See: Automatic Workload Repository (AWR)
AWR reports 1

B

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

C

cache fusion 1
cardinality, column 1, 2
Cartesian joins 1
cartridges 1
cascading deletions 1
catalog.sql script 1
CDBs 1
- about 1
- application common objects 1, 2, 3
- application containers 1, 2, 3, 4, 5
  - application common objects 1
  - application upgrades 1
  - installing applications 1, 2
  - upgrading applications 1
- application PDBs 1
- application seeds 1
- backup and recovery 1
- character sets 1
- common objects 1, 2
- common privilege grants 1, 2
- common roles 1, 2
- common users 1, 2, 3, 4, 5
  - naming rules 1
- container data objects 1
- container maps 1
- containers 1
- creation 1
- cross-container operations 1
- current container 1
- data dictionary 1
- data links 1
- files 1
- flashback of PDBs 1
- granting common roles and privileges 1
- granting privileges and roles 1
- local roles 1, 2, 3
- local users 1, 2
- metadata links 1
- Oracle Data Pump 1
- Oracle Flashback Technology 1
- PDB lockdown profiles 1
- principles of grants 1
- resource management 1
- roles
  - granting common 1, 2
- root container 1
- seed PDB 1
- seed PDBs 1
- services 1
- system container 1
- temp files 1
- undo mode 1
chaining, rows
- See: row chaining
character data types 1
- VARCHAR2 1
character sets 1
- ASCII 1
- client 1
- database 1
- EBCDIC 1
- Unicode 1, 2
CHAR data type 1
check constraints 1, 2
checkpoint process (CKPT) 1
checkpoints
- control files 1
- database shutdowns 1
- definition 1
- inconsistent backups 1
- incremental 1
- position 1
- thread 1
cleanup helper processes (CLnn) 1
cleanup main process (CLMN) 1
client/server architecture 1
- advantages 1
client processes 1, 2
- connections and 1
- sessions and 1
- shared server processes and 1
client result cache 1
client-side programming 1
CLMN background process 1
CLnn background processes 1
cluster indexes 1
clusters, table 1
- cluster keys 1
- hash 1
- index 1
Codd, E. F. 1
code points 1
collections
- PL/SQL 1
collections, PL/SQL 1
columns
- cardinality 1, 3
- definition 1, 2
- invisible 1
- multiple indexes on 1
- order of 1
- prohibiting nulls in 1
- virtual 1, 2, 3
COMMENT statement 1
COMMIT statement 1
committing transactions
- COMMIT statement 1
- defined 1
- ending transactions 1
- fast commit 1
- group commits 1
- implementation 1
- implicit commits 1
- lost commit problem 1
- two-phase commit 1
commonality, principles of 1
common objects 1
common privilege grants 1, 2
common roles 1, 2
- granting 1, 2
common users 1, 2, 3, 4, 5
- granting privileges to 1, 2
- naming rules 1
compiled PL/SQL
- pseudocode 1
- shared pool 1
- triggers 1
complete recovery 1
complete refresh 1
composite indexes 1
composite partitioning 1
compound triggers 1
compression
- advanced index 1
- archive 1
- basic table 1
- data block 1
- Hybrid Columnar Compression 1
- index 1
- OLTP table 1
- prefix index 1
- table 1, 2
- warehouse 1
compression, Hybrid Columnar 1
compression units, Hybrid Columnar 1
concatenated indexes 1
concurrency
- definition 1
- dirty reads 1
- fuzzy reads 1
- phantom reads 1
- row locks 1
- transaction isolation 1, 2, 3
conditions, SQL 1, 2
conflicting writes 1
connections, client/server
- administrator privileges 1
- definition 1
- embedded SQL 1, 2
- listener process 1
- sessions contrasted with 1
connections, client server
- listener process 1
consistency
- conflicting writes 1
- definition 1
- locks 1, 2
- multiversioning 1, 2
constraints, integrity
- check 1, 2
- default values 1
- deferrable 1, 2, 4
- enabling and disabling 1
- enforced with indexes 1
- foreign key 1, 2, 3
- mechanisms of enforcement 1
- nondeferrable 1
- NOT NULL 1, 2, 3
- primary key 1, 2, 3
- REF 1
- referential 1
- self-referential 1
- state of 1
- unique key 1, 2
- updates of foreign and parent keys 1
- validating 1, 2
container data objects 1
CONTAINERS_DEFAULT_TARGET property 1
containers, CDB 1, 2, 3
- root 1
contention
- deadlocks 1
contexts 1
control files 1, 2
- changes recorded 1
- checkpoints and 1
- contents 1
- multiplexed 1
- overview 1
- used in mounting database 1
cost-based optimizer
- See: optimizer
CREATE CLUSTER statement 1
CREATE DIMENSION statement 1
CREATE GLOBAL TEMPORARY TABLE statement 1
CREATE INDEX statement 1, 2, 3, 4, 5, 7
CREATE MATERIALIZED VIEW statement 1
CREATE PLUGGABLE DATABASE statement 1, 2, 3, 4
- application containers 1
- AS PROXY clause 1, 2
- RELOCATE clause 1
- SNAPSHOT COPY clause 1
- USING clause 1
CREATE ROLE statement 1
CREATE SEQUENCE statement 1
CREATE SYNONYM statement 1
CREATE TABLE statement 1, 2, 3
- storage parameters 1
CREATE UNIQUE INDEX statement 1
CREATE USER statement
- temporary segments 1
cross-container operations 1
current container 1
cursors
- embedded SQL 1
- explicit 1
- fetching rows 1

D

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

E

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

F

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

G

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

H

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

I

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

J

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

K

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

L

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

M

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

N

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

O

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

P

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

Q

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

R

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

S

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

T

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

U

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

V

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

W

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

X

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

Z

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