A
- access drivers, external table 1
- access paths, data 1, 2, 3, 4
- accounts, user 1
- ACID properties 1
- active transactions 1
- ADDM (Automatic Database Diagnostic Monitor) 1, 2
- administrative accounts 1, 2
- administrator privileges 1, 2, 4, 5
- ADR 1
- advanced index compression 1
- Advanced Queuing 1
- aggregate function 1
- alert logs 1, 2
- ALL_ data dictionary views 1
- ALTER TABLE statement 1
- analytic functions 1
- analytic views 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, 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 processes 1
- application program interface
- applications
- application servers 1, 2
- 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 policies 1, 2
- audit records 1
- fine-grained 1
- Oracle Audit Vault and Database Firewall 1
- Oracle Database Vault 1
- Oracle Label Security 1
- standard 1
- unified audit trail 1, 2, 3
- AUDIT statement 1
- authentication, database 1, 2, 3
- automated indexes 1, 2
- automatic big table caching 1, 2
- Automatic Database Diagnostic Monitor
- 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 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
- definition 1
- incremental-forever strategy 1
- techniques 1
- backups 1
- backup sets 1
- image copies 1
- partial database 1
- Recovery Manager 1
- technique comparisons 1
- whole database 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
- 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
- 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
- Oracle Flashback Technology 1
- chaining, rows
- character data types 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
- chunk 1
- cleanup helper processes (CLnn) 1
- cleanup main process (CLMN) 1
- client/server architecture 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
- Cloud Control 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, 2
- columns
- cardinality 1, 3
- definition 1, 2
- invisible 1
- multiple indexes on 1
- order of 1
- prohibiting nulls in 1
- virtual 1, 2, 3
- COMMENT statement 1
- COMMIT statement 1
- committing transactions
- COMMIT statement 1
- defined 1
- ending transactions 1
- fast commit 1
- group commits 1
- implementation 1
- implicit commits 1
- lost commit problem 1
- two-phase commit 1
- 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, 2
- index 1
- OLTP table 1
- prefix index 1
- table 1, 2
- units of Hybrid Columnar Compression 1
- warehouse 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, 2
- sessions contrasted with 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
- contention
- 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
- CREATE CLUSTER statement 1
- CREATE DIMENSION statement 1
- CREATE GLOBAL TEMPORARY TABLE statement 1
- CREATE INDEX statement 1, 2, 3, 4, 5, 7
- CREATE MATERIALIZED VIEW statement 1
- CREATE SEQUENCE statement 1
- CREATE SYNONYM statement 1
- CREATE TABLE statement 1, 2, 3
- CREATE UNIQUE INDEX statement 1
- CREATE USER statement
- 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 instances 1
- duration 1
- read/write 1
- read-only 1
- database objects 1
- database operations 1
- database resident connection pooling 1
- Database Resource Manager 1, 2, 3
- databases
- administrative accounts 1
- closing 1
- terminating the instance 1
- definition 1, 2
- distributed 1
- changing global database name 1
- hierarchical 1
- history 1
- incarnations 1
- introduction 1
- mounting 1
- multiprocess 1
- multiuser 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
- 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
- Database Storage Grid 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
- 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
- data consistency 1
- data conversion
- data corruption 1
- data dictionary 1, 2
- ALL_ prefixed views 1
- cache 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
- public synonyms 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 manipulation language
- data object number, extended rowid 1
- Data Recovery Advisor 1
- data redaction 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
- deadlocks 1
- decision support systems (DSS)
- default values
- deferred inserts 1, 2
- 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
- dictionary cache locks 1
- dictionary managed tablespaces 1
- dimensions 1
- attribute-clustered tables 1, 2, 3
- attributes 1
- hierarchies 1
- normalized or denormalized tables 1
- tables 1
- dimension tables 1
- directory objects 1
- direct path loads
- Hybrid Columnar Compression 1
- dirty reads 1, 2
- disk space
- data files used to allocate 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 1
- 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, 3
- 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
- enqueued transactions 1
- Enterprise Grids
- with Oracle Real Application Clusters 1
- Enterprise Manager 1, 2
- alert log 1
- dynamic performance views usage 1
- executing a package 1
- lock and latch monitors 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 statement 1, 2
- explicit locking 1
- expressions, SQL 1, 2
- 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
- extraction, transformation, and loading (ETL)
F
- fact tables 1
- failures
- database buffers and 1
- statement and process 1
- fast commit 1
- fast full index scans 1
- Fast Ingest Coordinator (FICO) background process 1
- fast recovery area 1
- fast refresh 1, 2
- 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
- fixed SGA 1
- flash cache
- buffer reads 1
- optimized physical reads 1
- floating-point numbers 1, 2
- force full database caching mode 1
- foreign keys 1, 2
- changes in parent key values 1
- composite 1
- constraints 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
- default mode 1
- 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
- global indexes 1, 2
- globalization support 1
- 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 index 1
- hash partitioning 1
- headers, data block 1, 2
- Health Monitor 1
- heap-organized tables 1, 2
- height, index 1
- hierarchies
- high availability
- applications 1
- data corruption 1
- hints, optimizer 1, 2, 3
- Hybrid Columnar Compression 1, 2
- compression units 1
- 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
- automated 1, 2
- 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 1
- local partitioned 1
- multiple 1
- nonprefixed, local 1
- nonunique 1
- overview 1
- partitioned 1, 2, 3
- partitioning
- 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, updates 1
- index-organized tables 1, 2
- benefits 1
- bitmap indexes 1
- characteristics 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
- 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
- instances, database 1, 2, 3
- associating with databases 1
- duration 1
- failure 1
- failures 1
- memory structures of 1
- process structure 1, 2
- recovery of
- 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
- isolation levels, transaction 1
- read committed 1
- read-only 1
- setting 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
- joins, table 1, 2, 3
- Cartesian 1
- clustered tables 1
- conditions 1
- inner joins 1
- join conditions 1
- outer joins 1
- views 1
- JSON
- comparison to XML 1
- Oracle Database support 1
- overview 1
K
- key 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
- deferred inserts 1
- memory management 1
- latches
- leaf blocks, index 1
- least recently used (LRU) algorithm
- database buffers and 1
- full table scans and 1
- latches 1
- shared SQL pool 1, 3
- 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 temporary tablespaces 1
- locks 1
- after committing transactions 1
- automatic 1, 2
- bitmap indexes 1
- conversion 1, 3
- deadlocks 1, 2
- definition 1
- 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 Columnar 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 switches
- archiver process 1
- 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
- lost updates 1, 2
- lost writes
- LRU 1, 3
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
- refreshing 1, 2
- zone maps and 1
- media recovery
- memoptimize pool 1, 2
- 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
- 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
- multitenant container databases
- multiversion read consistency 1, 2, 3, 4, 5, 6
- deferred inserts 1
- 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
- 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
- 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
- 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
- online analytical processing
- online redo log 1, 2
- archiver process (ARCn) 1
- buffer management 1
- checkpoints 1
- committed data 1
- committing a transaction 1
- log switch
- 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, 3
- 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, 4
- Optimizer Statistics Advisor
- Oracle Advanced Analytics 1
- Oracle ASM (Automatic Storage Management) 1, 2, 3, 4
- Oracle Audit Vault and Database Firewall 1
- Oracle Automatic Storage Management
- Oracle blocks 1
- Oracle Call Interface
- Oracle code 1
- Oracle Connection Manager Control utility 1
- Oracle Database
- Oracle Database Vault 1, 2
- Oracle Data Mining 1
- Oracle Data Pump 1, 2, 3
- dump file set 1
- unified audit trail 1
- Oracle Enterprise Manager
- Oracle Enterprise Manager Cloud Control (Cloud Control)
- Oracle Flashback Technology 1, 2
- Oracle Flex Clusters 1
- Oracle GoldenGate 1, 2, 3
- 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 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, 2
- Oracle program interface (OPI) 1
- Oracle RAC
- See: Oracle Real Application Clusters
- Oracle Real Application Clusters
- Enterprise Grids 1
- Oracle Flex Clusters 1
- reverse key indexes 1
- Oracle R Enterprise 1
- Oracle Secure Backup 1
- Oracle Sharding
- Oracle Spatial and Graph 1
- Oracle Text 1
- Oracle Universal Installer (OUI) 1
- Oracle XA
- session memory in the large pool 1
- ORDBMS (object-relational database management system) 1
- outer joins 1
- out-of-place refresh method 1
P
- packages 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
- parameters
- parse locks 1
- parsing, SQL 1, 2
- embedded SQL 1
- hard parse 1
- storage of information 1
- partial global partitioned indexes 1
- partitioned change tracking refresh 1
- partitioned indexes 1
- partitioned tables 1
- partitioning
- by hash 1
- by interval 1
- by list 1
- by range 1
- by reference 1
- composite 1
- index 1
- indexes 1
- key 1
- partitions
- characteristics 1
- composite partitioning 1
- definition 1
- dynamic partitioning 1
- elimination from queries 1
- index 1
- keys 1
- materialized views 1
- overview 1
- partitions
- range 1
- segments 1
- single-level 1
- strategies 1
- table 1, 2, 3, 4
- passwords
- administrator privileges 1
- connecting with 1
- PCTFREE storage parameter
- PDBs 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
- records 1, 2, 3
- stored procedures 1, 2, 3, 4, 5, 6
- units 1
- plan
- planned downtime
- avoiding downtime during 1
- pluggable databases
- PMAN background process 1
- PMON background process 1
- pragmas, PL/SQL 1
- precompilers 1
- COBOL 1
- embedded SQL 1
- FORTRAN 1
- Pro*C/C++ 1
- predicates, SQL 1, 2
- 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, 2
- PL/SQL procedures and 1
- privilege profiler 1
- revoking 1
- procedures
- advantages 1
- execution 1, 2
- execution in a PL/SQL package 1
- 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
- log writer (LGWR) 1
- multithreaded 1
- Oracle 1
- parallel execution coordinator 1
- parallel execution servers 1
- process monitor (PMON) 1
- recoverer (RECO) 1
- server 1, 2
- shared server 1
- structure 1
- system monitor (SMON) 1
- user
- recovery from failure of 1
- sharing server processes 1
- processing
- process manager process (PMON)
- process monitor process (PMON)
- 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, 2
- program units
- protection policies
- pseudocode
- 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
- query plans 1
- query rewrite 1
- query transformer 1
R
- range partitioning 1
- range partitions 1
- range scans, index 1
- RDBMS (relational database management system) 1
- RDMA 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
- recovery
- complete 1
- database buffers and 1
- distributed processing in 1
- instance recovery
- media 1
- process recovery 1
- required after terminating instance 1
- rolling back transactions 1
- tablespace
- Recovery Appliance 1
- backup modules 1
- metadata database 1
- plug-in 1
- recovery catalog 1
- Recovery Manager 1, 2
- architecture 1
- auditing 1
- backups 1
- Recovery Appliance 1
- redaction, data 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
- relational database management system
- relations, simple 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, 5
- reverse key indexes 1
- REVOKE statement 1
- rights, definer’s and invoker’s 1
- roles 1, 2, 3
- rollback 1
- described 1
- ending a transaction 1
- implicit in DDL 1
- statement-level 1, 2
- to a savepoint 1
- transaction-level 1
- rollback segments
- locks on 1
- parallel recovery 1
- use of in recovery 1
- ROLLBACK statement 1
- rolling back 1, 2
- 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
- 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, 4
- 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
- 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
- segment advisor 1
- segments 1, 2
- data 1
- defined 1
- index 1, 2
- overview of 1
- table storage 1
- temporary 1, 2
- 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
- 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
- SERVICE_NAMES parameter 1
- service names 1
- service-oriented architecture 1, 2
- 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 (system global area) 1, 2
- allocating 1
- big table cache 1
- contents of 1
- database buffer cache 1
- data dictionary cache 1, 2
- fixed SGA 1
- large pool 1
- redo log buffer 1, 2
- rollback segments and 1
- shared and writable 1
- shared pool 1, 2
- variable parameters 1
- shadow lost write protection 1
- configuring 1
- enabling 1
- purpose 1
- shadow tablespaces 1
- creating 1
- how they work 1
- purpose 1
- user interface 1
- sharded database (SDB) 1
- sharded table 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
- 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)
- simple triggers 1
- single-level partitioning 1
- SMON background process 1
- SOA 1, 2
- SOAP (Simple Object Access Protocol) 1
- software code areas 1
- space management
- extents 1
- PCTFREE 1
- row chaining 1
- segments 1
- 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, 2
- 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
- SQL areas
- SQLJ standard 1
- SQL tuning advisor 1
- SRVCTL utility 1
- standard auditing 1
- standards
- 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
- optimizer 1
- undo retention 1
- storage
- logical structures 1
- nulls 1
- triggers 1
- stored 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, PL/SQL
- 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 (SCN) 1
- committed transactions 1
- defined 1
- definition 1
- when assigned 1
- system control statements 1
- system global area
- 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
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, 2
- heap-organized 1, 2
- index-organized 1, 2, 3, 4
- 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
- tablespace set 1
- tasks 1
- temp files 1
- temporary segments 1, 2
- allocating 1
- allocation for queries 1
- temporary tables 1
- creation 1
- global 1
- private 1
- purpose 1
- temporary tablespaces 1
- creation of default 1
- local 1
- shared 1
- threads
- TIMESTAMP data type 1, 2
- time zones 1
- TO_CHAR function 1
- TO_DATE function 1, 2
- trace files
- transaction control statements 1
- Transaction Guard 1, 2, 3
- benefits 1
- how it works 1
- transaction-level read consistency 1
- transaction management
- transactions 1
- ACID properties 1
- active 1, 2
- assigning system change numbers 1
- autonomous 1
- beginning 1
- blocking 1
- committing 1, 2
- conflicting writes 1
- deadlocks 1, 2
- definition 1, 2
- distributed 1, 2, 3
- 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
- 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
- triggers 1
- cascading 1
- components of 1
- compound 1
- effect of rollbacks 1
- firing (executing) 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
U
- undo management, automatic 1
- undo retention period 1
- undo segments 1, 2
- read consistency 1
- temporary 1, 2, 3
- undo space management
- automatic undo management mode 1
- undo tablespaces 1, 2, 3, 4
- 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
- tables with parent keys 1
- updatability of views 1, 2
- updatable join views 1
- UPDATE statement 1
- upgrades
- UROWID data type 1
- USER_ views 1
- user global area (UGA) 1
- user program interface (UPI) 1
- users, database 1
- authentication 1
- 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
- views 1
- analytic 1
- base tables 1
- characteristics 1
- constraints indirectly affect 1
- data access 1
- data dictionary
- 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
- Web services 1, 2
- write-ahead 1
X
- XA
- session memory in the large pool 1
- XMLType data type 1
- XStream 1
Z
- Zero Data Loss Recovery Appliance
- zone maps 1, 2
Back to main content