Index

A

access drivers, external table 4.6.3
access paths, data 5.1.1, 5.4.2, 9.3.1, 9.3.3
accounts, user 8.1
ACID properties 12.1
active transactions 12.2.2
administrative accounts 4.1.1.1.2, 8.1.2
administrator privileges 4.1.1.1.2, 15.2.1.1, 18.2.4.2
ADR 15.6.1
advanced index compression 5.2.5.2
alert logs 15.6.2, 17.4.1.6.2
ALL_ data dictionary views 8.1.2.3
ALTER DATABASE statement
- application roots 3.1.2
- RECOVER clause 3.4
ALTER TABLE statement 4.2.3
anonymous PL/SQL blocks 10.2
ANSI/ISO standard 9.1.2
APIs (application program interfaces) 18.3
- embedded SQL statements 9.2.6
- external tables 4.6.3
- Java 10.3.1.1
- JDBC 9.2.6, 12.4.2
- network services 18.2.1
- ODBC 9.2.6
application and networking architecture 1.5.4.1, 18
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 Continuity 12.4
- architecture 12.4.2
- benefits 12.4.1
- planned maintenance 12.4.1.2
- use case 12.4.1.1
application domain indexes 5.5
application PDBs 3.1.3
- naming rules 2.3.4
- synchronization 3.3
application processes 17.2
application program interface
- See: API
application roots 3.1.2
applications
- in a CDB
  - metadata-linked common objects 3.2.3
application seeds 2.3.1, 3.1.4
application servers 1.5.4.1, 10.3.1.2
- about 18.1.2.2
archived redo log files 13.3.3, 13.4.2.3
ARCHIVELOG mode 17.4.2.1
archiver process (ARCn) 17.4.2.1
ascending indexes 5.2.4
ASSM tablespace 14.1.2.1.1
atomicity, statement-level 12.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 8.1, 8.1.3, 9.2.1, 10.4.1, 13.1.2, 15.2.1.4.1
- unified audit trail 18.1.2.3
AUDIT statement 9.2.1
authentication, database 9.2.4, 17.2.2
automated indexes 5.1.1, 5.1.7
automatic big table caching 16.4.1.4.1, 16.4.1.5
Automatic Database Diagnostic Monitor
- See: ADDM
Automatic Diagnostic Repository (ADR) 15.6.1, 15.6.2
automatic segment space management (ASSM) 14.1.2.1.1
automatic undo management 14.4.3, 14.5.2.3.1

B

background processes 1.5.3.1, 17.4
- mandatory 17.4.1
- optional 17.4.2
- PMAN 17.4.1.2
big table cache 16.4.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 14.1.2.1
blocking transactions 11.2.1.2
blocks, data
- See: data blocks
BOOLEAN data type 4.2.4, 5.2.2.3, 9.2.2.1, 10.4.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 11.1.1.3
cardinality, column 5.3, 9.3.2.2
Cartesian joins 9.2.2.2
cartridges 5.5
cascading deletions 7.2.4.3
catalog.sql script 8.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 8.1.2.1
- container maps 3.3
- containers 2.1
- cross-container operations 3.4
- current container 17.2.3
- data links 8.1.3.1
- files 14.5.1
- local users 4.1.1, 4.1.1.2
- metadata links 8.1.3.1
- root container 2.2
- seed PDBs 2.3.1
- services 18.2.2.2
- system container 2.2
- temp files 14.5.1
- undo mode 14.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
- EBCDIC 4.2.4.1
- Unicode 4.2.4.1
CHAR data type 4.2.4.1.1
check constraints 7.2, 7.2.5
checkpoint process (CKPT) 17.4.1.7
checkpoints
- control files 13.3.1
- database shutdowns 15.2.2.1
- definition 15.3
- incremental 15.3.2
- position 15.4.4
- thread 15.3.2
cleanup helper processes (CLnn) 17.4.1.1.3
cleanup main process (CLMN) 17.4.1.1.2
client/server architecture 18.1.1
- advantages 18.1.1.2
client processes 1.5.3.1, 17.2
- connections and 17.2.2
- sessions and 17.2.2
- shared server processes and 18.2.4.1.2
client result cache 16.4.3.3
client-side programming 10.1
CLMN background process 17.4.1.1.2
CLnn background processes 17.4.1.1.3
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 10.2.5, 10.2.5.1
columns
- cardinality 5.3, 9.3.2.2
- definition 1.2.1, 4.2.1
- invisible 4.2.1.2
- 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 9.2.1
COMMIT statement 9.2.3
committing transactions
- COMMIT statement 9.2.3
- defined 12.1
- ending transactions 12.1.2.2
- fast commit 17.4.1.6.1
- group commits 17.4.1.6.1
- implementation 17.4.1.6.1
- implicit commits 9.2.1
- lost commit problem 12.3.2.1
- two-phase commit 12.6.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 10.4.6
- shared pool 10.2.6
- triggers 10.4.6
complete refresh 6.4.2.1
composite indexes 5.1.4
composite partitioning 6.1.1.2.6
compound triggers 10.4.3
compression
- advanced index 5.2.5.2
- archive 4.2.7.2.1
- basic table 4.2.7.1
- data block 14.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 11.1
- dirty reads 11.1.3
- fuzzy reads 11.1.3
- phantom reads 11.1.3
- row locks 11.4.1.1.1
- transaction isolation 11.1.3, 11.2.2, 11.2.3
conditions, SQL 9.1.1, 9.2.2.1
conflicting writes 11.2.1.2
connections, client/server
- administrator privileges 15.2.1.1
- definition 17.2.2
- embedded SQL 9.2.6
- listener process 1.5.4.2, 18.2.2
- sessions contrasted with 17.2.2
consistency
- conflicting writes 11.2.1.2
- definition 11.1
- locks 11.1.2, 11.5
- multiversioning 11.1, 11.1.1
constraints, integrity
- check 7.2, 7.2.5
- default values 7.3.3.1
- deferrable 7.2.3, 7.3.2.2, 9.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
container data objects 8.1.2.1
container maps 3.3
CONTAINERS_DEFAULT_TARGET property 3.4
containers, CDB 2, 2.1
- root 2.2
contention
- deadlocks 11.3.6
contexts 4.1.3
control files 1.5.2.1, 13.3
- changes recorded 13.3.1
- checkpoints and 13.3.1
- contents 13.3.1
- multiplexed 13.3.2
- overview 13.3
- used in mounting database 15.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 14.4.1.1
CREATE UNIQUE INDEX statement 7.2.3
CREATE USER statement
- temporary segments 14.4.2.1
cross-container operations 3.4
current container 17.2.3
cursors
- embedded SQL 9.2.6
- explicit 10.2.4
- fetching rows 9.2.6

D

data access languages 1.3
database applications 1.1.1
database authentication 9.2.4, 17.2.2
database buffer cache 4.2.7, 16.4.1, 17.4.1.5
- cache hits and misses 16.4.1.4.3
- caching of comments 8.1.3.3
- force full database caching mode 16.4.1.6.5
database buffers
- after committing transactions 12.2.5
- buffer bodies in flash cache 16.4.1.4.3
- buffer cache 16.4.1
- checkpoint position 17.4.1.5
- committing transactions 17.4.1.6.1
- definition 16.4.1
- writing 17.4.1.5
database instances 1.5.1
- See: instances, database
- duration 15.1.4
- read/write 15.1.3
- read-only 15.1.3
database links, PDBs 2.3.5
database objects 1.2
- metadata 8.3
database operations 17.2.4
database resident connection pooling 18.2.5
databases
- administrative accounts 4.1.1.1.2
- closing 15.2.2.2
  - terminating the instance 15.2.2.2.2
- definition 1.1, 1.5.1
- distributed
  - changing global database name 16.4.3.1.3
- hierarchical 1.1.1
- history 1.1.4
- introduction 1
- mounting 15.2.1.3
- multiprocess 17.1.2
- multiuser 17.1.2
- name stored in control files 13.3.1
- network 1.1.1
- object-relational 1.1.3
- opening 15.2.1.4, 15.2.1.4.1
- relational 1.1.2, 1.1.3, 9.1
- shutting down 15.2.2
- starting up 4.1.1.1.2, 15.1
  - forced 15.2.2.4
- structures
  - control files 13.3
  - data blocks 14, 14.2, 14.2.5
  - data files 13
  - extents 14.1, 14.3
  - logical 14
  - processes 17
  - segments 14.1, 14.4
  - tablespaces 13, 14.5
database services 18.2.2.2.1, 18.2.2.2.1.2
- in a CDB 18.2.2.2.1.1
- PDBs 18.2.2.2
database structures
- control files 13.3
- data blocks 14, 14.2, 14.2.5
- data files 13
- extents 14.1
- processes 17
- segments 14.1, 14.4
- tablespaces 13, 14.5
database writer process (DBW) 17.4.1.5
- multiple DBWn processes 17.4.1.5
database writer process (DBWn)
- checkpoints 17.4.1.5
- defined 17.4.1.5
- least recently used algorithm (LRU) 16.4.1.6
- write-ahead 17.4.1.6
data blocks 1.5.2.2, 14.1
- cached in memory 16.4.1.6
- clustered rows 4.3
- coalescing free space in blocks 14.2.4.2.2
- compression 14.2.3
- format 14.2.2, 14.2.2.2
- locks stored in 11.4.1.1.2
- overview 14.1.1
- shown in rowids 14.2.2.2.3
- stored in the buffer cache 16.4.1
- writing to disk 16.4.1.6
data concurrency
- definition 1.4.2
data consistency 1.4.3
data conversion
- program interface 18.3
data dictionary 4.1.1.1.2, 4.2.5
- ALL_ prefixed views 8.1.2.3
- cache 16.4.3
- comments in 9.2.1
- content 8.1.2, 16.4.3.2
- DBA_ prefixed views 8.1.2.2
- dictionary managed tablespaces 14.1.2.2
- DUAL table 8.1.2.5
- how database uses 8.1.3
- locks 11.4.2
- overview 8.1
- public synonyms 8.1.3.2
- storage in a CDB 8.1.4
- stored subprograms 10.2.1.2
- USER_ prefixed views 8.1.2.4
data dictionary cache 8.1.3.3, 16.4.3, 16.4.3.2
data failures, protecting against human errors 12.3
data files 1.5.2.1
- contents 13.2.4
- data file 1 14.5.2.1
- moving online 13.2.3
- named in control files 13.3.1
- shown in rowids 14.2.2.2.3
- SYSTEM tablespace 14.5.2.1
- temporary 13.2.2
data integrity 7.1
- enforcing 7.1, 7.1.1, 8.1.3
- SQL and 9.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, 8.1.3.1
data manipulation language
- See: DML
data object number, extended rowid 14.2.2.2.3
data segments 14.4.1
data types
- BOOLEAN 4.2.4, 5.2.2.3, 9.2.2.1, 10.4.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 18.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 warehouses
- 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 8.1.2.2
DBMS_METADATA package 8.3
DBMS_SERVICE package 12.4.1.2
DBMS_SPACE_ADMIN package 14.4.1.1
DBMS_SQL_MONITOR package 17.2.4
DBMS_STATS package 9.3.4
DBMS (database management system) 1.1.1
DBW background process 17.4.1.5
DDL (data definition language) 8.1
- described 9.2.1
- locks 11.4.2
deadlocks 9.4.1.1
- definition 11.3.6
decision support systems (DSS)
- materialized views 6.4
default values
- effect of constraints 7.3.3.1
deferred inserts 11.1.1.4, 16.4.4.2
definer’s rights 10.2.1.1
DELETE statement 9.2.2
- freeing space in data blocks 14.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 11.4.3.3
dictionary managed tablespaces 14.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 11.1.1, 11.1.3
disk space
- data files used to allocate 13.2.4
dispatcher processes (Dnnn)
- client processes connect through Oracle Net Services 18.2.4, 18.2.4.1.1
- network protocols and 18.2.4.1.1
- prevent startup and shutdown 18.2.4.2
- response queue and 18.2.4.1
distributed databases
- client/server architectures and 18.1.1.1
- job queue processes 17.4.2.2
- recoverer process (RECO) and 17.4.1.9
- server can also be client in 18.1.1.1
- transactions 12.6
distributed transactions 12.2.1, 12.6
- in-doubt 12.6.2
- naming 12.2.1
- two-phase commit and 12.6
DML (data manipulation language)
- indexed columns 5.3
- invisible indexes 5.1.2
- locks 11.4.1
- overview 9.2.2
- referential actions 7.2.4.3
- triggers 10.4.1
drivers 18.3.2
DUAL table 8.1.2.5
dynamic partitioning 17.4.3.2.3
dynamic performance views 8.2, 8.2.1
- database object metadata 8.3
- storage 8.2.2
dynamic SQL
- DBMS_SQL package 10.2.4
- embedded 10.2.4

E

embedded SQL 9.1, 9.2.6, 10.3.2.2.2
enqueued transactions 12.2.3.2
Enterprise Manager 15.2.2.4
- alert log 15.6.2
- dynamic performance views usage 8.2
- executing a package 10.2.2.3
- lock and latch monitors 11.4.3
- shutdown 15.2.2.1, 15.2.2.4
equijoins 5.3.2
errors, recoverable 12.3
exceptions, PL/SQL 10.2.4
exclusive locks 11.3.3
- row locks (TX) 11.4.1.1
- table locks (TM) 11.4.1.2
EXECUTE statement 10.2.1.3
execution plans 6.4.4, 9.3.1, 9.3.2.3
- EXPLAIN PLAN 9.2.2
EXPLAIN PLAN statement 9.2.2
explicit locking 11.5
expressions, SQL 5.1.3, 9.2.2.1
extended data-linked objects 3.2.5
extents 1.5.2.2
- as collections of data blocks 14.3
- deallocation 14.3.2
- defined 14.1.1
- dictionary managed 14.1.2.2
- incremental 14.3.1
- locally managed 14.1.2.1
- overview of 14.3
external procedures 10.2.6
external tables 4.2, 4.6, 4.6.4
- purpose 4.6.1

F

fact tables 6.6.1
failures
- database buffers and 15.4.1
- statement and process 17.4.1.1
fast commit 17.4.1.6.1
fast full index scans 5.2.2.2
fast refresh 6.4.2, 6.4.2.2
fields 4.2.3
file management locks 11.4.3.3
files
- alert log 17.4.1.6.2
- initialization parameter 15.2.1.2, 15.5
- password
  - administrator privileges 15.2.1.1
- server parameter 15.2.1.2, 15.5
- trace files 17.4.1.6.2
fixed SGA 16.4.6
flash cache
- buffer reads 16.4.1.4.3
- optimized physical reads 16.4.1.4.3
floating-point numbers 4.2.4.2, 4.2.4.2.2
force full database caching mode 16.4.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 11.4.1.3
format models, data type 4.2.4.3.1, 4.2.4.5
free space
- automatic segment space management 14.2.4
- managing 14.2.4
full index scans 5.2.2.1
full table scans 5.1.1, 5.2.2.2, 9.3.3
- default mode 16.4.1.6.1
- LRU algorithm and 16.4.1.6
- parallel exe 17.4.3.2.3
function-based indexes 5.4, 5.4.1, 5.4.2
functions 9.2.2.1
- function-based indexes 5.4
- hash 6.1.1.2.4
- PL/SQL 10.2.1
- SQL 4.2.4.4.2
fuzzy reads 11.1.3

G

GDSCTL utility 12.4.1.2
global database names
- shared pool and 16.4.3.1.3
global indexes 6.1.3, 6.1.3.2
GRANT statement 6.7, 9.2.1
group commits 17.4.1.6.1

H

handles for SQL statements 16.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 16.4.7.2
hash partitioning 6.1.1.2.4
headers, data block 11.4.1.1.2, 14.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
hints, optimizer 9.3.1, 9.3.5, 16.4.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

IM column store
- See: In-Memory Column Store
immutable tables
- about 4.8
IM space manager
- See: In-Memory Space Manager
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, 9.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 12.3
information systems 1.1
INIT.ORA
- See: initialization parameter file.
initialization parameter file 15.2.1.2, 15.5
- startup 15.2.1.2
initialization parameters
- about 15.5.1.2
- basic 15.5.1
- OPEN_CURSORS 16.3.1.1
- SERVICE_NAMES 18.2.2.3
In-Memory Column Store 1.5.3.2, 4.2.7.2
- SQL execution 9.4.1.4
inner joins 9.2.2.2
in-place refresh method 6.4.2.3
INSERT statement 9.2.2
instances, database 1.5.1, 9.2.5, 15.1
- associating with databases 15.2.1.3
- duration 15.1.4
- failure 13.4.1
- failures 11.4.1.1
- memory structures of 16.1
- process structure 17.1, 17.1.2
- recovery of
  - SMON process 17.4.1.4
- service names 18.2.2
- shutting down 15.2.2, 15.2.2.4
- terminating 15.2.2.2.2
INSTEAD OF triggers 10.4.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
- updates of foreign and parent keys 7.3.3.2
- validating 7.3.2
- views 6.3.1.1
internal locks 11.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 10.2.1.1
isolation levels
- serialization 11.2.2
isolation levels, transaction 11.1.3
- read committed 11.2.1
- read-only 11.2.3
- setting 11.5

J

Java
- overview 10.3
- SQLJ translator 10.3.2.2.2
- stored procedures 1.3.2, 10.3.2.1
- virtual machine 10.3.1
JDBC
- accessing SQL 10.3.2.2
- drivers 10.3.2.2.1
- driver types 10.3.2.2.1
- embedded SQL 9.2.6
job queue processes 17.4.2.2
jobs 17.1
join attribute clustering 4.4.2
joins
- views 6.3.2
joins, table 5.3.2, 8.1.2, 9.2.2.2
- Cartesian 9.2.2.2
- clustered tables 4.3
- conditions 5.3.2
- inner joins 9.2.2.2
- join conditions 9.2.2.2
- outer joins 9.2.2.2
- views 6.3

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 16.4.4
- deferred inserts 16.4.4.2
- memory management 16.4.4.1
latches
- definition 11.4.3.1
leaf blocks, index 5.2.1
least recently used (LRU) algorithm
- database buffers and 16.4.1.4.1
- full table scans and 16.4.1.6
- latches 16.4.1.6
- shared SQL pool 16.4.3.1.3, 16.4.4.1
LGWR background process 17.4.1.6
library cache 16.4.3, 16.4.3.1
listener process 1.5.4.2, 18.2.2
- listener registration process (LREG) 17.4.1.3
- service names 18.2.2
listener registration process (LREG) 17.4.1.3
listeners 1.5.4.2, 18.2.2
- listener registration process (LREG) 17.4.1.3
- service names 18.2.2
list partitioning 6.1.1.2.3
local indexes 6.1.3
locally managed tablespaces 14.1.2.1
local partitioned indexes 6.1.3.1
local temporary tablespaces 14.5.3.1
local users 4.1.1, 4.1.1.2
locks 11.1.2
- after committing transactions 12.2.5
- automatic 11.3.2, 11.4
- bitmap indexes 5.3
- conversion 11.3.3, 11.3.4
- deadlocks 9.4.1.1, 11.3.6
- definition 1.4.2
- dictionary 11.4.2
- dictionary cache 11.4.3.3
- DML 11.4.1
- duration 11.3.2, 11.3.5
- escalation 11.3.3
- exclusive 11.3.3
- exclusive DDL 11.4.2.1
- exclusive table 11.4.1.2
- file management locks 11.4.3.3
- Hybrid Columnar Compression 4.2.7.2.2
- latches 11.4.3.1
- log management locks 11.4.3.3
- manual 11.5
- overview of 11.1.2
- parse 11.4.2.3
- restrictiveness 11.3.3
- rollback segments 11.4.3.3
- row (TX) 11.4.1.1
- row exclusive table 11.4.1.2
- row share 11.4.1.2
- share DDL 11.4.2.2
- share locks 11.3.3
- share row exclusive 11.4.1.2
- share table 11.4.1.2
- system 11.4.3
- table 5.1.1, 9.2.2
- table (TM) 11.4.1.2
- tablespace 11.4.3.3
- types of 11.4
- unindexed foreign keys and 11.4.1.3
- user-defined 11.6
LOCK TABLE statement 9.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, 14.5
logical rowids 5.6.3
logical transaction IDs 12.3.2.2
log management locks 11.4.3.3
log switches
- archiver process 17.4.2.1
- log sequence numbers 13.4.2.1
log writer process (LGWR) 17.4.1.6
- group commits 17.4.1.6.1
- online redo logs available for use 13.4.2.1
- redo log buffers and 16.4.2
- write-ahead 17.4.1.6
- writing to online redo log files 13.4.2.1
LONG data type
- storage of 4.2.6.1
lost updates 1.4.3, 11.2.1.2
lost writes
- shadow tablespaces 14.5.2.4.1
LRU 16.4.1.4.1, 16.4.1.6
- shared SQL pool 16.4.3.1.3

M

manual locking 11.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 17.4.2.2
- refreshing 6.4.2, 6.4.2.3
- zone maps and 4.4.3.2
memoptimize pool 16.4.7.2
memory
- allocation for SQL statements 16.4.3.1.1
- content of 16.1
- processes use of 17.1
- stored procedures 10.2.1.1
MERGE statement 9.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, 8.1.3.1
metrics 8.2
multiblock writes 17.4.1.5
multiplexing
- control files 13.3.2
- redo log file groups 13.4.2.2
- redo log files 13.4.2.2
multitenant architecture
- definition 1.5.1.1
multitenant container databases
- See: CDBs
multiversion read consistency 8.2.2, 11.1, 11.1.1, 11.1.3, 14.4.3, 14.4.3.2
- deferred inserts 11.1.1.4
- dirty reads 11.1.1
- read committed isolation level 11.2.1.1
- statement-level 1.4.3, 11.1.1.1
- transaction-level 11.1.1.2
- undo segments 11.1.1.3
mutexes 11.4.3.2

N

NaN (not a number) 4.2.4.2
natural keys 7.2.3
NCHAR data type 4.2.4.1.2
network listener process
- connection requests 18.2.4.1.1
networks
- client/server architecture use of 18.1.1
- communication protocols 18.3.2, 18.3.3
- dispatcher processes and 18.2.4.1.1
- drivers 18.3.2
- listener processes of 18.2.2
- Oracle Net Services 18.2
NLS_DATE_FORMAT parameter 4.2.4.3.1
NOAUDIT statement 9.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 tables 4.2, 4.9
object types 4.9, 6.3.3
object views 6.3.3
OLAP
- index-organized tables 5.6
OLTP
- table compression 4.2.7.1
online redo log 13.4.1, 14.4.3.2
- archiver process (ARCn) 17.4.2.1
- buffer management 17.4.1.6
- checkpoints 13.3.1
- committed data 15.4.1
- committing a transaction 17.4.1.6.1
- log switch
  - archiver process 17.4.2.1
- log writer process 16.4.2, 17.4.1.6
- rolling forward 15.4.1
- undo data in 14.4.3.3
- writing buffers 17.4.1.6
online redo log files 1.5.2.1
OPEN_CURSORS parameter
- managing private SQL areas 16.3.1.1
operating systems
- communications software 18.3.3
- privileges for administrator 15.2.1.1
optimized physical reads 16.4.1.4.3
optimizer 9.1.1, 9.3
- adaptive optimization 9.3.2.3
- components 9.3.2
- estimator 9.3.2.2
- execution 9.4.1.4
- execution plans 6.4.4, 9.3.1, 9.3.2.3, 9.4.1.3
- function-based indexes 5.4.2
- hints 9.3.1, 9.3.5, 16.4.4.2
- invisible indexes 5.1.2
- partitions in query plans 6.1
- plan generator 9.3.2.3
- query plans 9.4.1.3
- query transformer 6.4.4, 9.3.2.1
- row sources 9.4.1.3
- statistics 4.2.6.1, 9.3.4, 9.4.1.2
Oracle ASM (Automatic Storage Management) 13.1.3, 13.1.3.1
Oracle Automatic Storage Management
- See: Oracle ASM
Oracle blocks 14.1.1
Oracle Call Interface
- See: OCI
Oracle code 18.3
Oracle Database
- history 1.1.4
Oracle Data Pump 14.5.2
Oracle Enterprise Manager
- See: Enterprise Manager
Oracle Flashback Technology 1.4.3
Oracle Internet Directory 18.2.2.3
Oracle JVM
- main components 10.3.1.2
- overview 10.3.1.1
Oracle Net 1.5.4.2
Oracle Net Listener 1.5.4.2
Oracle Net Services 1.5.4.2, 18.2
- client/server systems use of 18.2
- overview 18.2
- shared server requirement 18.2.4.1.1
Oracle Net Services Connection Manager 10.3
Oracle processes 17.1.2, 17.3
Oracle program interface (OPI) 18.3.1
Oracle RAC
- See: Oracle Real Application Clusters
Oracle Real Application Clusters
- reverse key indexes 5.2.3
Oracle Sharding
- about 6.2
- architecture 1.5.1.2
Oracle XA
- session memory in the large pool 16.4.4
ORDBMS (object-relational database management system) 1.1.3
outer joins 9.2.2.2
out-of-place refresh method 6.4.2.3

P

packages 10.2.2
- advantages of 10.2.2.1
- creation 10.2.2.2
- executing 10.2.6
- for locking 11.6
- private 10.2.2.1
- public 10.2.2.1
- shared SQL areas and 16.4.3.1.2
- subprogram executions 10.2.2.3
pages 14.1.1
parallel execution 17.4.3.2
- coordinator 17.4.3.2.3
- server 17.4.3.2.3
- servers 17.4.3.2.3
- tuning 17.4.3.2
parallel SQL 17.4.3.2
- coordinator process 17.4.3.2.3
- server processes 17.4.3.2.3
parameters
- initialization 15.5
  - locking behavior 11.4
parse locks 11.4.2.3
parsing, SQL 9.4.1, 9.4.1.1
- embedded SQL 9.2.6
- hard parse 11.4.3.1
- storage of information 8.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 17.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
- overview 6.1
- partitions
  - composite 6.1.1.2
- range 6.1.1.2
- segments 14.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
passwords
- administrator privileges 15.2.1.1
- connecting with 17.2.2
PCTFREE storage parameter
- how it works 14.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 18.2.2.2.2
- containers 2
- current container 17.2.3
- database links 2.3.5
- definition 2.3
- naming rules 2.3.4
- proxy 2.3.1, 2.3.3
- purpose of 2.3.2
- services 18.2.2.2, 18.2.2.2.1, 18.2.2.2.1.1, 18.2.2.2.1.2
- temp files 14.5.1
- types 2.3.1
performance
- group commits 17.4.1.6.1
- packages 10.2.2.1
PGA
- See: program global area (PGA)
phantom reads 11.1.3
physical database structures
- control files 1.5.2.1, 13.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 10.2, 10.2.3
- collections 10.2.5, 10.2.5.1
- data types 4.2.4
- dynamic SQL 10.2.4
- exceptions 10.2.4
- execution 10.2.6
- execution of subprograms 10.2.1.3
- language constructs 10.2.4
- overview 10.2
- package creation 10.2.2.2
- packages 8.3, 10.2.2, 10.2.2.1
- PL/SQL engine 10.2.6
- program units 10.2.1.1, 16.4.3.1.2
  - shared SQL areas and 16.4.3.1.2
- records 10.2.5, 10.2.5.1, 10.2.5.2
- stored procedures 1.3.2, 8.1.2.3, 10.2, 10.2.1, 10.2.1.1, 10.2.2.1
- units 10.2
  - compiled 10.2.6
plan
- SQL execution 9.2.2
pluggable databases
- See: PDBs
PMAN background process 17.4.1.2
PMON background process 17.4.1.1.1
pragmas, PL/SQL 12.5
precompilers 10.1
- embedded SQL 9.2.6
predicates, SQL 5.2.2.1, 9.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 16.4.3.1.1
- described 16.4.3.1.1
- how managed 16.3.1.1
- parsing and 9.4.1.1
private synonyms 6.7
privileges 8.1, 9.2.4
- administrator 15.2.1.1
- granting 9.2.1
- PL/SQL procedures and 10.2.1.1
- revoking 9.2.1
procedures
- advantages 10.2.1.1
- execution 10.2.1.3, 10.2.6
- execution in a PL/SQL package 10.2.2.3
- external 10.2.6
- memory allocation 10.2.1.1
- security 10.2.1.1
- shared SQL areas and 16.4.3.1.2
- stored procedures 1.3.2, 8.1.2.3, 10.2, 10.2.6
processes 17.1
- archiver (ARCn) 17.4.2.1
- background 1.5.3.1, 17.4
- checkpoints and 17.4.1.5
- client 1.5.3.1, 17.2
- dedicated server 18.2.4.1.2
- definition 1.5.3.1
- distributed transaction resolution 17.4.1.9
- job queue 17.4.2.2
- listener 18.2.2
  - shared servers and 18.2.4.1.1
- log writer (LGWR) 17.4.1.6
- multithreaded 17.1.2
- Oracle 17.3
- parallel execution coordinator 17.4.3.2.3
- parallel execution servers 17.4.3.2.3
- process monitor (PMON) 17.4.1.1.1
- recoverer (RECO) 17.4.1.9
- server 1.5.3.1, 17.3
  - shared 18.2.4.1.1, 18.2.4.1.2
- shared server 18.2.4
  - client requests and 18.2.4.1
- structure 17.1
- system monitor (SMON) 17.4.1.4
- user
  - recovery from failure of 17.4.1.1
  - sharing server processes 18.2.4.1.1
processing
- parallel SQL 17.4.3.2
process manager process (PMON)
- state objects 17.4.1.1.4
process monitor process (PMON)
- described 17.4.1.1.1
program global area (PGA) 1.5.3.2, 16.1.1
- shared server 18.2.4.1.2
- shared servers 18.2.4.1.2
program interface 18.3
- Oracle side (OPI) 18.3.1
- structure of 18.3.1
- user side (UPI) 18.3.1
programming, server-side 1.3.2, 10.1
program units
- shared pool and 16.4.3.1.2
proxy PDBs 2.3.1, 2.3.3, 2.3.5
pseudocode
- triggers 10.4.6
pseudocolumns 4.2.4.4.2, 5.6.1
public synonyms 6.7

Q

queries
- blocks 9.2.2.3
- definition 9.2.2.1
- implicit 11.2.1.1
- in DML 9.2.2
- parallel processing 17.4.3.2
- query blocks 9.3.2.3
- query transformer 9.3.2.1
- SQL language and 9.1
- stored 6.3
- subqueries 6.3, 9.2.2, 9.2.2.3
query blocks 9.3.2.3
query optimizer
- See: optimizer
query plans 9.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 16.4.7.2
read committed isolation 11.2.1
read consistency
- See: multiversion read consistency
read-only isolation level 11.2.3
read uncommitted 11.1.3
Real Application Clusters
- cache fusion 11.1.1.3
- system monitor process and 17.4.1.4
- threads of online redo log 13.4.2
records, PL/SQL 10.2.5, 10.2.5.1, 10.2.5.2
recoverable errors 12.3
recoverer process (RECO) 17.4.1.9
- in-doubt transactions 12.6.2
recovery
- database buffers and 15.4.1
- distributed processing in 17.4.1.9
- instance recovery
  - SMON process 17.4.1.4
- media
  - dispatcher processes 18.2.4.2
- process recovery 17.4.1.1
- required after terminating instance 15.2.2.2.2
- rolling back transactions 15.4.4
Recovery Manager 8.2
redo log buffer 13.4.1
redo log files
- available for use 13.4.2.1
- circular use of 13.4.2.1
- contents of 13.4.3
- distributed transaction information in 13.4.2
- group members 13.4.2.2
- groups, defined 13.4.2.2
- instance recovery use of 13.4
- LGWR and the 13.4.2.1
- members 13.4.2.2
- multiplexed 13.4.2.2
- online, defined 13.4
- redo entries 13.4.3
- threads 13.4.2
redo logs buffer 16.4.2
redo records 13.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 17.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 9.2
response queues 18.2.4.1
RESULT_CACHE clause 16.4.3.3.1
result cache 16.4.3.3, 16.4.3.3.1
result sets, SQL 4.2, 4.2.4.4.2, 4.5, 6.3.2, 9.2.2.1
reverse key indexes 5.2.3
REVOKE statement 9.2.1
rights, definer’s and invoker’s 10.2.1.1
roles 4.1.3, 8.1.2.3, 9.2.4
rollback 12.2.4
- described 12.2.4
- ending a transaction 12.2.4
- implicit in DDL 9.2.1
- statement-level 11.3.6, 12.1.3
- to a savepoint 12.2.3.1
- transaction-level 9.2.3
rollback segments
- locks on 11.4.3.3
- parallel recovery 15.4.4
- use of in recovery 15.4.4
ROLLBACK statement 12.2
rolling back 12.1, 12.2.4
root container 2.1, 2.2
row chaining 14.2.4.3
row data (section of data block) 14.2.2.2
row directories 14.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 14.2.4.3
- scans 9.3.3
- universal 4.2.4.4
row locks 11.4.1.1
- concurrency 11.4.1.1.1
- storage 11.4.1.1.2
row pieces 4.2.6.2
rows
- addresses 4.2.6.3
- chaining across blocks 4.2.6.2, 14.2.4.3
- clustered 4.2.6.2
- definition 1.2.1, 4.2.2
- format of in data blocks 14.2.2.1
- locking 11.4.1.1
- locks on 11.4.1.1
- migrating to new block 14.2.4.3
- row set 9.4.1.3
- row source 9.4.1.3
- shown in rowids 14.2.2.2.3
- storage 4.2.6.2
- triggers 10.4.2
row source generation 9.4.1.3

S

sample schemas 4.1.6
savepoints 9.2.3, 12.2.3
- definition 12.2.3
- implicit 12.1.3
- rolling back to 12.2.3.1
- SAVEPOINT statement 12.2
SAVEPOINT statement 9.2.3
scans
- cluster 9.3.3
- fast full index 5.2.2.2
- full index 5.2.2.1
- full table 5.1.1, 9.3.3, 16.4.1.6, 16.4.1.6.1
- index 5.2.2, 9.3.3
- index skip 5.2.2.5
- range 4.3.2.2
- rowid 9.3.3
- unique index 5.2.2.4
schema objects
- definitions 1.2, 8.1, 9.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 13.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
security
- administrator privileges 15.2.1.1
- definer’s rights 10.2.1.1
- program interface enforcement of 18.3
- views 6.3
seed PDB 2.1
segments 1.5.2.2, 14.4
- data 14.4.1
- defined 14.1.1
- index 5.1.8, 5.3.3
- overview of 14.4
- table storage 4.2.6
- temporary 4.5.2, 14.4.2
  - allocating 14.4.2
- user 14.4.1.1
selectivity 5.2.2.3
select lists, SQL 9.2.2.1
SELECT statement 9.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 11.1
serialization isolation level 11.2.2
server parameter file
- about 15.5.2
- startup 15.2.1.2
server processes 1.5.3.1, 17.3
- creation 17.3.3
- listener process 18.2.2
servers
- client/server architecture 18.1.1
- shared
  - architecture 17.1.1, 18.2.4
  - processes of 18.2.4, 18.2.4.1.2
server-side programming 10.1
- overview 10, 10.1
SERVICE_NAMES parameter 18.2.2.3
service names 18.2.2
service-oriented architecture 1.5.4.1, 18.1.2.4
session control statements 9.2.4
sessions 9.2.4
- connections contrasted with 17.2.2
- defined 17.2.2
- memory allocation in the large pool 16.4.4
- sequence generation in 6.5.2
SET CONSTRAINT statement 9.2.3
SET TRANSACTION statement 9.2.3, 12.1.2.1
SGA (system global area) 1.5.3.2, 16.1.1
- allocating 15.2.1.2
- big table cache 16.4.1.5
- contents of 16.4
- database buffer cache 16.4.1
- data dictionary cache 8.1.3.3, 16.4.3.2
- fixed SGA 16.4.6
- large pool 16.4.4
- redo log buffer 12.2.2, 16.4.2
- rollback segments and 12.2.2
- shared and writable 16.4
- shared pool 10.2.1.1, 16.4.3
- variable parameters 15.5.1.1
shadow lost write protection 14.5.2.4
- configuring 14.5.2.4.4
- enabling 14.5.2.4.2
- purpose 14.5.2.4.1
shadow tablespaces 14.5.2.4
- creating 14.5.2.4.4
- how they work 14.5.2.4.2
- purpose 14.5.2.4.1
- user interface 14.5.2.4.3
sharded database (SDB) 6.2
sharded tables 6.2
shards 6.2
share DDL locks 11.4.2.2
shared pool 10.2.6, 16.4.3, 16.4.3.1.3
- allocation of 16.4.3.1.3
- dependency management and 16.4.3.1.3
- described 16.4.3
- flushing 16.4.3.1.3
- latches 11.4.3.1
- parse locks 11.4.2.3
shared server
- described 17.1.1
- dispatcher processes 18.2.4.1.1
- Oracle Net Services or SQL*Net V2 requirement 18.2.4.1.1
- processes 18.2.4.1.2
- processes needed for 18.2.4
- restricted operations in 18.2.4.2
- session memory in the large pool 16.4.4
shared server processes (Snnn) 18.2.4.1.2
- described 18.2.4.1.2
shared SQL areas 6.3.1.2, 16.4.3, 16.4.3.1.1, 16.4.3.1.3
- dependency management and 16.4.3.1.3
- described 16.4.3.1.1
- parse locks 11.4.2.3
- procedures, packages, triggers and 16.4.3.1.2
shared temporary tablespaces 14.5.3.1
share locks 11.3.3
shutdown 15.2.2, 15.2.2.4
- abnormal 15.2.2.4
- prohibited by dispatcher processes 18.2.4.2
- steps 15.2.2
SHUTDOWN ABORT statement 15.2.2.4
Simple Object Access Protocol (SOAP)
- See: SOAP
simple triggers 10.4.3
single-level partitioning 6.1.1.2
SMON background process 17.4.1.4
SOA 1.5.4.1, 18.1.2.4
SOAP (Simple Object Access Protocol) 1.5.4.1
software code areas 16.1.1
space management
- extents 14.3
- PCTFREE 14.2.4.1
- row chaining 14.2.4.3
- segments 14.4
Space Management Coordinator Process (SMCO) background process 16.4.4.2
SQL 9.1, 9.2
- conditions 9.1.1, 9.2.2.1
- data definition language (DDL) 9.2.1
- data manipulation language (DML) 9.2.2
- definition 1.3.1
- dictionary cache locks 11.4.3.3
- dynamic SQL 10.2.4
- embedded 9.1, 9.2.6
- executable 12.1.2.1
- execution 9.4.1.4, 12.1.3
- expressions 5.1.3, 9.2.2.1
- functions 4.2.4.4.2
- interactive 9.1
- memory allocation for 16.4.3.1.1
- operators 9.1.1
- optimization 9.4.1.2
- Oracle 1.3.1, 9.1.2
- overview 9.1
- parallel execution 17.4.3.2
- parsing 9.4.1, 9.4.1.1
- PL/SQL and 10.2
- predicates 5.2.2.1, 9.1.1
- processing 9.4.1
- reserved words 9.2
- result sets 4.2, 4.2.4.4.2, 4.5, 6.3.2, 9.2.2.1
- select lists 9.2.2.1
- session control statements 9.2.4
- standards 9.1.2
- statements 9.2
- subqueries 6.3, 9.2.2.3
- system control statements 9.2.5
- transaction control statements 9.2.3
- transactions 12.1
- types of statements 9.2
SQL*Plus
- alert log 15.6.2
- executing a package 10.2.2.3
- lock and latch monitors 11.4.3
SQL areas
- private 16.4.3.1.1
- shared 16.4.3.1.1
SQLJ standard 10.3.2.2.2
SRVCTL utility 12.4.1.2
standards
- ANSI/ISO 9.1.2
  - isolation levels 11.1.3
star schemas 4.4.5
startup 15.1
- prohibited by dispatcher processes 18.2.4.2
statement-level atomicity 12.1.3
statement-level read consistency 11.1.1.1
statement-level rollback 11.3.6, 12.1.3
statements, SQL 9.2
statistics 4.2.6.1, 8.2, 9.3.1, 16.4.3.1.3
- definition 9.3.4
- Java-related 16.4.5
- join order 9.2.2.2
- optimizer 9.4.1.2
- undo retention 14.5.2.3.2
storage
- logical structures 14.5
- nulls 4.2.3
- triggers 10.4.6
stored procedures
- See: procedures
Structured Query Language (SQL) 9.1
structures
- locking 11.4.2
- logical 14
  - data blocks 14, 14.2, 14.2.5
  - extents 14.1, 14.3
  - segments 14.1, 14.4
  - tablespaces 13, 14.5
- physical
  - control files 13.3
  - data files 13
- processes 17
subprograms, PL/SQL
- See: procedures
subqueries 6.3, 9.2.2, 9.2.2.3
summaries 6.4
surrogate keys 7.2.3
synonyms
- constraints indirectly affect 7.3.3.2
- data dictionary views 8.1.3.2
- definition 4.1.3, 6.7
- private 6.7
- public 6.7, 8.1.2.4
- securability 6.7
SYSDBA privilege 15.2.1.1
SYSOPER privilege 15.2.1.1
system change numbers (SCN) 12.1.4
- committed transactions 12.2.5
- defined 12.2.5
- definition 11.1.1.3.1
- when assigned 13.4.3
system container 2.2
system control statements 9.2.5
system global area
- See: SGA
system locks 11.4.3
- internal 11.4.3.3
- latches 11.4.3.1
- mutexes 11.4.3.2
system monitor process (SMON) 17.4.1.4
- defined 17.4.1.4
- Real Application Clusters and 17.4.1.4
- rolling back transactions 15.4.4
SYSTEM tablespace
- data dictionary stored in 14.5.2.1
- online requirement of 14.5.4.2
SYSTEM user name 4.1.1.1.2
SYS user name 4.1.1.1.2
- data dictionary tables 8.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 9.3.3
table partitions 6.1.1.2.1
tables
- attribute-clustered 4.4.2
- automatic big table caching 16.4.1.4.1, 16.4.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 14.2.2.1
- DUAL 8.1.2.5
- dynamic partitioning 17.4.3.2.3
- external 4.6, 4.6.3, 4.6.4
- fact 6.6.1
- full table scans 5.1.1, 16.4.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, 14.4.2.2
- transaction 12.1.2.1
- truncating 9.2.1, 14.3.2
- views of 6.3
- virtual 8.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
tablespaces 1.5.2.2, 14.5
- described 14.5
- dictionary managed 14.1.2.2
- locally managed 14.1.2.1
- locks on 11.4.3.3
- offline 14.5.4.2
- online 14.5.4.2
- overview of 14.5
- schema objects 4.1.4
- space allocation 14.1.2
- used for temporary segments 14.4.2.1
tasks 17.1
temp files 13.2.2
temporary segments 4.5.2, 14.4.2.2
- allocating 14.4.2.1
- allocation for queries 14.4.2.1
temporary tables 4.2
- creation 4.5.3
- global 4.5
- private 4.5
- purpose 4.5.1
temporary tablespaces 14.5.3
- creation of default 14.5.3.2.1
- local 14.5.3.1
- shared 14.5.3.1
threads
- online redo log 13.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.5
TO_DATE function 4.2.4.3.1, 4.2.4.5
trace files
- LGWR trace file 17.4.1.6.2
transaction control statements 9.2.3
Transaction Guard 12.3, 12.4.2
- benefits 12.3.1
- how it works 12.3.2
transaction-level read consistency 11.1.1.2
transaction management
- definition 1.4
transactions 12
- ACID properties 12.1
- active 12.2.2, 14.4.3
- assigning system change numbers 12.2.5
- autonomous 12.5
  - within a PL/SQL block 12.5
- beginning 12.1.2.1
- blocking 11.2.1.2
- committing 12.3.2.1, 17.4.1.6.1
  - group commits 17.4.1.6.1
- conflicting writes 11.2.1.2
- deadlocks 11.3.6, 12.1.3
- definition 1.4.1, 12.1
- distributed 12.2.1, 12.6
  - resolving automatically 17.4.1.9
- DML statements 9.2.2
- ending 12.1.2.2
- enqueued 12.2.3.2
- idempotence 12.3
- in-doubt
  - resolving automatically 12.6.2
- in-flight 12.3
- isolation levels 11.1.3, 11.2.2, 11.2.3
- isolation of 11.1.3
- logical transaction ID 12.3.2.2
- naming 12.2.1
- read consistency 11.1.1.2
- rolling back 12.2.4
  - partially 12.2.3.1
- savepoints in 12.2.3
- serializability 11.1
- setting properties 9.2.3
- structure 12.1.2
- terminated 14.4.3
- terminating the application and 12.1.2.2
- transaction control statements 9.2.3
- transaction history 11.1.1.3.2
- transaction ID 12.1, 12.1.2.1
transaction tables 12.1.2.1
- reset at recovery 17.4.1.1
triggers 10.1
- cascading 10.4.1
- components of 10.4.4
- compound 10.4.3
- effect of rollbacks 12.1.3
- firing (executing) 10.4.5
  - privileges required 10.4.5
- INSTEAD OF 10.4.2
- overview 10.4
- restrictions 10.4.4
- row 10.4.2
- shared SQL areas and 16.4.3.1.2
- simple 10.4.3
- statement 10.4.2
- storage of 10.4.6
- timing 10.4.3
- UNKNOWN does not fire 10.4.4
- uses of 10.4.1
TRUNCATE statement 9.2.1, 14.3.2
tuples, definition 1.1.2
two-phase commit
- transaction management 12.6

U

undo management, automatic 14.4.3
undo mode
- CDBs 14.5.1
undo retention period 14.5.2.3.2
undo segments 12.1.2.1, 14.4.3
- read consistency 11.1.1.3
- temporary 13.4.1, 14.4.3, 14.4.3.3
undo space management
- automatic undo management mode 14.5.2.3.1
undo tablespaces 14.4.3, 14.5.2.3, 14.5.2.3.1, 14.5.2.3.2
- undo retention period 11.2.3
Unicode 4.2.4.1
unified audit trail 18.1.2.3
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
updatable join views 6.3.2
update no action constraint 7.2.4.3
updates
- lost 11.2.1.2
- tables with parent keys 11.4.1.3
- updatability of views 6.3.2, 10.4.2
- updatable join views 6.3.2
UPDATE statement 9.2.2
upgrades
- database 8.1.1.2, 14.5.2.2, 14.5.2.3.1
UROWID data type 4.2.4.4
USER_ views 8.1.2.4
user global area (UGA) 16.1.1
user program interface (UPI) 18.3.1
users
- common 2.1, 3.2.1.2, 4.1.1.1
users, database 4.1.3
- names 8.1
  - sessions and connections 17.2.2
- privileges 4.1
- temporary tablespaces 14.4.2.1
user segments 14.4.1.1
UTL_HTTP package 10.2.2

V

V$ views 8.2.1
- database object metadata 8.3
- storage 8.2.2
VARCHAR2 data type 4.2.4.1, 4.2.4.1.1
variables
- embedded SQL 9.2.6
views 6.3
- 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 8.2, 8.2.1
- indexes 6.3.1.2
- INSTEAD OF triggers 10.4.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$ 8.2
virtual columns 4.2.1.1, 4.2.6.1, 5.4.2

W

warehouse
- materialized views 6.4
Web services 1.5.4.1, 18.1.2.4
write-ahead 17.4.1.6

X

XA
- session memory in the large pool 16.4.4

Z

zone maps 4.4.3, 4.4.3.2