Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Z  

A

  • access drivers, external table [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]
  • ADR [1]
  • advanced index compression [1]
  • Advanced Queuing, Oracle Streams [1]
  • aggregate function [1]
  • alert log
  • alert logs [1]
  • ALL_ data dictionary views [1]
  • ALTER TABLE statement [1]
  • analytic functions [1]
  • anonymous PL/SQL blocks [1]
  • ANSI/ISO standard [1]
  • APIs (application program interfaces)
  • application architecture [1]
  • application contexts, auditing [1]
  • Application Continuity
    • architecture [1]
    • benefits [1]
  • application developers
  • application domain indexes [1]
  • application processes [1]
  • application program interface
    • See: API
  • applications
  • application servers
  • 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
    • 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
    • mandatory [1]
  • backup and recovery
    • definition [1]
    • techniques [1]
  • backup operations [1]
  • backups
    • Recovery Manager [1]
  • backups, database [1]
  • backup sets [1]
  • backup strategies
    • incremental-forever [1]
  • backup techniques, comparison [1]
  • big table cache [1]
  • BINARY_DOUBLE data type [1]
  • BINARY_FLOAT data type [1]
  • bitmap indexes
    • 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] , [5]
  • branch blocks, index [1]
  • B-tree indexes
    • 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
    • about [1]
    • container data objects [1]
    • containers [1]
    • creation [1]
    • data dictionary [1]
    • files [1]
    • metadata links [1]
    • object links [1]
    • Oracle Data Pump [1]
    • root container [1]
  • chaining, rows
    • See: row chaining
  • character data types
  • character sets
  • 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]
  • client/server architecture
    • advantages [1]
  • client processes
    • connections and [1]
    • sessions and [1]
    • shared server processes and [1]
  • client result cache [1]
  • client-side programming [1]
  • cluster indexes [1] , [2]
  • clusters, table
  • Codd, E. F. [1]
  • code points [1]
  • collections
  • collections, PL/SQL [1]
  • columnar format [1] , [2]
  • columns
  • 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]
  • common users [1] , [2]
  • compiled PL/SQL
    • pseudocode [1]
    • shared pool [1]
    • triggers [1]
  • complete recovery [1]
  • complete refresh [1]
  • composite indexes [1]
  • compound triggers [1]
  • compression
    • advanced index [1]
    • basic table [1]
    • data block [1]
    • Hybrid Columnar Compression [1]
    • index [1]
    • In-Memory Column Store [1]
    • OLTP table [1]
    • online archival [1]
    • prefix index [1]
    • table [1] , [2]
    • warehouse [1]
  • compression, Hybrid Columnar [1]
  • compression units, Hybrid Columnar [1]
  • concatenated indexes [1]
  • concurrency
  • conditions, SQL [1] , [2]
  • conflicting writes [1]
  • connections, client/server
    • administrator privileges [1]
    • definition [1]
    • embedded SQL [1]
    • listener process [1]
    • sessions contrasted with [1]
  • connections, client server
    • listener process [1]
  • consistency
  • constraints, integrity
  • container data objects [1]
  • containers, CDB
  • contention
    • deadlocks [1]
  • contexts [1]
  • control files
    • 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 SEQUENCE statement [1]
  • CREATE SYNONYM statement [1]
  • CREATE TABLE statement
    • storage parameters [1]
  • CREATE UNIQUE INDEX statement [1]
  • CREATE USER statement
    • temporary segments [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
    • 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
  • database links, PDBs [1]
  • database objects
  • database operations [1]
  • database resident connection pooling [1]
  • Database Resource Manager [1] , [2] , [3] , [4]
  • databases
    • administrative accounts [1]
    • closing
      • 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
    • structures
  • Database Server Grid
    • description [1]
  • Database Storage Grid
    • description [1]
  • database structures
  • Database Upgrade Assistant (DBUA)
    • multitenant architecture support [1]
  • database writer process (DBW)
    • multiple DBWn processes [1]
  • database writer process (DBWn)
    • checkpoints [1]
    • defined [1]
    • least recently used algorithm (LRU) [1]
    • write-ahead [1]
  • data blocks
    • 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
    • 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]
    • stored subprograms [1]
    • USER_ prefixed views [1]
  • data dictionary cache [1] , [2] , [3]
  • data failures, protecting against human errors [1] , [3]
  • data files
    • 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
  • data manipulation language
    • See: DML
  • data object number, extended rowid [1]
  • Data Recovery Advisor [1]
  • data redaction
  • data segments [1]
  • data types
  • 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_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)
  • deadlocks
    • definition [1]
  • decision support systems (DSS)
    • materialized views [1]
  • default values
    • effect of constraints [1]
  • definer’s rights [1]
  • DELETE statement
    • 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
    • attribute-clustered tables [1] , [2] , [3]
    • attributes [1]
    • hierarchies
    • normalized or denormalized tables [1]
    • tables [1]
  • dimension tables [1]
  • directory objects [1]
  • direct-path load [1]
  • dirty reads [1] , [2] , [3]
  • 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
    • 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
    • database object metadata [1]
    • storage [1]
  • dynamic SQL
    • DBMS_SQL package [1]
    • embedded [1]

E

  • embedded SQL [1] , [2] , [3]
  • EM Express [1] , [2]
  • enqueued transactions [1]
  • Enterprise Grids
    • with Oracle Real Application Clusters [1]
  • Enterprise Manager
    • 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
    • row locks (TX) [1]
    • table locks (TM) [1]
  • EXECUTE statement [1]
  • execution plans
    • EXPLAIN PLAN [1]
  • EXPLAIN PLAN statement [1] , [2]
  • explicit locking [1]
  • expressions, SQL [1] , [2]
  • extents
    • 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 refresh [1] , [2]
  • fast-start
    • rollback on demand [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]
  • 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
    • 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
    • LRU algorithm and [1]
    • parallel exe [1]
  • function-based indexes [1] , [2] , [3]
  • functions
  • fuzzy reads [1]

G

  • global database names
    • shared pool and [1]
  • Global Data Services
  • global indexes [1] , [2]
  • 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
    • 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
  • high availability
    • applications [1]
    • data corruption [1]
  • hints, optimizer [1] , [2]
  • Hybrid Columnar
    • compression units [1]
  • Hybrid Columnar Compression
    • row-level locks [1]

I

  • image copies [1]
  • IM column store
    • See: In-Memory Column Store
  • implicit queries [1]
  • 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
  • indexes, local [1]
  • indexes, partitioned
    • partial global [1]
  • indexes, updates [1]
  • index-organized tables
    • 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
  • initialization parameters
  • INMEMORY_SIZE initialization parameter [1]
  • In-Memory Column Store
    • benefits [1]
    • columnar format [1]
    • compression [1]
    • consistency with buffer cache [1]
    • dual memory formats [1]
    • memory management [1]
    • optimization of scans [1]
    • Oracle RAC [1]
    • population [1]
    • population of columnar data [1]
    • SQL execution [1]
    • storage index [1]
  • inner joins [1]
  • in-place refresh method [1]
  • INSERT statement [1]
  • instance PGA
    • memory management [1]
  • instances, database
    • associating with databases [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
    • 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]
  • invisible columns [1]
  • invisible indexes [1]
  • invoker’s rights [1]
  • isolation levels
    • read-only [1]
    • serialization [1]
    • setting [1]
  • isolation levels, transaction
    • read committed [1]

J

  • Java
    • overview [1]
    • SQLJ translator [1]
    • stored procedures [1] , [2]
    • virtual machine [1]
  • JDBC
    • accessing SQL [1]
    • drivers [1]
    • driver types [1]
    • embedded SQL [1]
  • job queue processes [1]
  • jobs [1]
  • join attribute clustering [1]
  • joins
  • joins, table
    • 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

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
    • service names [1]
  • listeners
    • service names [1]
  • list partitioning [1]
  • local indexes [1]
  • locally managed tablespaces [1]
  • local partitioned indexes [1]
  • local role [1]
  • local rules [1]
  • local users [1]
  • lock
    • definition [1]
  • locks
    • 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
  • 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)
    • 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
    • shared SQL pool [1]

M

  • maintenance tasks, automatic [1]
  • maintenance window [1]
  • manual locking [1]
  • mapping tables [1]
  • master tables [1]
  • materialized views
    • 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
  • 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 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
  • multitenant container databases
    • See: CDBs
  • multiversion read consistency
    • dirty reads [1] , [2]
    • read committed isolation level [1]
    • statement-level [1] , [2]
    • transaction-level [1]
    • undo segments [1]
  • mutexes [1]

N

  • NaN (not a number) [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
    • cloning as CDBs [1]
  • nonunique indexes [1]
  • normalized tables [1]
  • NOT NULL constraints [1] , [2]
  • nulls
  • NUMBER data type [1]
  • numbers, floating point [1]
  • numeric data types
    • floating-point numbers [1]
  • NVARCHAR2 data type [1]

O

  • object links, in CDBs [1]
  • object tables [1] , [2]
  • object types [1] , [2]
  • object views [1]
  • OLAP
    • index-organized tables [1]
    • introduction [1]
  • OLTP
    • table compression [1]
  • online analytical processing
    • See: OLAP
  • online redo log
    • 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
  • optimizer statistics [1]
  • Oracle ASM (Automatic Storage Management) [1] , [2] , [3]
  • 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
  • Oracle Database Configuration Assistant (DBCA) [1]
  • Oracle Data Pump
    • dump file set [1]
  • Oracle Enterprise Manager
    • See: Enterprise Manager
  • 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 JVM
    • main components [1]
    • overview [1]
  • Oracle Label Security [1]
  • 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
    • 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 Secure Backup [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]

P

  • packages
    • 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
  • parallel SQL
    • coordinator process [1]
    • server processes [1]
  • parameter
  • parameters
    • initialization
      • locking behavior [1]
  • parse locks [1]
  • parsing
    • embedded SQL [1]
    • storage of information [1]
  • parsing, SQL
    • hard parse [1]
  • partial global partitioned indexes [1]
  • partitioned change tracking refresh [1]
  • partitioned indexes
  • partitioned tables [1]
  • partitioning
  • 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]
  • PDBs
    • about [1]
    • benefits [1]
    • consolidation of data into [1]
    • containers [1]
    • creating by plugging in [1]
    • creation [1]
    • database links [1]
    • data dictionary [1]
    • definition [1]
    • purpose of [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
  • plan
    • SQL execution [1]
  • planned downtime
    • avoiding downtime during [1]
  • pluggable databases
    • See: PDBs
  • PMON background process [1]
  • pragmas, PL/SQL [1]
  • precompilers
    • embedded SQL [1]
  • predicates, SQL
    • SQL
      • predicates [1]
  • primary key constraints [1]
  • primary keys
    • constraints [1]
    • hash clusters [1]
    • index-organized tables [1]
  • private SQL areas
    • described [1]
    • how managed [1]
    • parsing and [1]
  • private synonyms [1]
  • privileges
    • administrator [1]
    • granting [1]
    • PL/SQL procedures and [1]
    • revoking [1]
  • privileges, database
    • granting [1]
    • privilege profiler [1]
  • procedures
  • processes
    • 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
      • 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
    • shared server
      • 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 monitor process (PMON)
    • described [1]
  • program global area (PGA)
    • shared server [1]
    • shared servers [1]
  • program interface
    • 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
  • pseudcolumns [1]
  • pseudocode
  • pseudocolumns [1]
  • public synonyms [1]

Q

  • queries
  • query blocks [1]
  • query optimizer
    • See: optimizer
  • query plans
    • 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)
    • 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
    • backups [1]
    • Recovery Appliance [1]
  • Recovery Manager (RMAN) [1]
  • redaction, data
  • 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]
  • referential integrity
    • examples of [1]
    • self-referential constraints [1]
  • refresh
    • incremental [1]
    • job queue processes [1]
    • materialized views [1] , [2]
  • relational database management system
    • See: RDBMS
  • relations, simple [1]
  • replication, Oracle Streams
    • master database [1]
  • reserved words [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
  • rollback
    • 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
  • row locks
  • 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
    • definition [1]
    • implicit [1]
    • rolling back to [1]
    • SAVEPOINT statement [1]
  • SAVEPOINT statement [1]
  • SBT libraries [1]
  • scans
  • schema objects
  • schemas [1] , [2]
  • schemas, sample [1]
  • SCN
    • See: system change numbers
  • secondary indexes
    • benefits [1]
    • physical guesses [1]
  • SecureFiles [1]
  • security
    • administrator privileges [1]
    • auditing [1]
    • definer’s rights [1]
    • program interface enforcement of [1]
    • views [1]
  • seed PDB [1] , [3]
  • segment advisor [1]
  • segments
  • 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
    • listener process [1]
  • servers
    • client/server architecture [1]
    • shared
  • server-side programming
  • SERVICE_NAMES parameter [1]
  • service names [1]
  • service oriented architecture [1]
  • service-oriented architecture [1]
  • service tiers
    • See: Recovery Appliance service tiers
  • session control statements [1]
  • sessions
    • 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]
    • In-Memory Column Store [1]
  • SGA (system global area)
    • 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]
  • share DDL locks [1]
  • shared pool
    • 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)
    • described [1]
  • shared SQL areas
    • dependency management and [1]
    • described [1]
    • parse locks [1]
    • procedures, packages, triggers and [1]
  • share locks [1]
  • shutdown
    • 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]
  • SOA [1] , [2]
  • SOAP (Simple Object Access Protocol) [1]
  • software code areas [1]
  • space management
  • SQL
    • 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]
    • executable [1]
    • execution [1] , [2]
    • expressions [1] , [2]
    • functions [1]
    • implicit queries [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
    • alert log [1]
    • executing a package [1]
    • lock and latch monitors [1]
    • multitenant architecture support [1]
  • SQL areas
  • SQLJ standard [1]
  • SQL tuning advisor [1]
  • standard auditing [1]
  • standards
    • ANSI/ISO
      • isolation levels [1]
  • star schemas [1]
  • startup
    • prohibited by dispatcher processes [1]
  • statement-level atomicity [1]
  • statement-level read consistency [1]
  • statement-level rollback [1] , [2]
  • statements, SQL [1]
  • statistics
    • 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
  • 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)
    • committed transactions [1]
    • defined [1]
  • system control statements [1]
  • system global area
    • See: SGA
  • system global area (SGA) [1]
  • system locks
  • system monitor process (SMON)
    • defined [1]
    • Real Application Clusters and [1]
    • rolling back transactions [1]
  • SYSTEM tablespace
    • data dictionary stored in [1]
    • online requirement of [1]
  • SYSTEM user name [1]
  • SYS user name
    • data dictionary tables [1]

T

  • table clusters
  • table partitions [1]
  • tables
  • tables, attribute-clustered
    • 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
    • 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
    • allocating [1]
    • allocation for queries [1]
  • temporary tables
  • threads
    • online redo log [1]
  • TIMESTAMP data type [1] , [2]
  • time zones
    • 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]
  • transaction-level read consistency [1]
  • transaction management
    • definition [1]
  • transactions
    • ACID properties [1]
    • active [1] , [2]
    • assigning system change numbers [1]
    • autonomous
      • within a PL/SQL block [1]
    • beginning [1]
    • blocking [1]
    • committing
      • group commits [1]
    • conflicting writes [1]
    • deadlocks [1]
    • deadlocks and [1]
    • definition [1] , [2]
    • distributed
      • 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
      • partially [1]
    • savepoints in [1]
    • serializability [1]
    • setting properties [1]
    • terminated [1]
    • terminating the application and [1]
    • transaction control statements [1]
    • transaction history [1]
    • transaction ID [1] , [2]
  • transaction tables
    • reset at recovery [1]
  • triggers
    • cascading [1]
    • components of [1]
    • compound [1]
    • effect of rollbacks [1]
    • firing (executing)
      • 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 retention period [1]
  • undo segments
    • read consistency [1]
  • undo segments, temporary [1] , [2] , [3]
  • undo space management
    • automatic undo management mode [1]
  • undo tablespaces
    • undo retention period [1]
  • Unicode [1]
  • unified audit trail [1] , [2] , [3]
  • unique indexes [1]
  • unique key constraints
    • 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
  • UROWID data type [1]
  • USER_ views [1]
  • user global area (UGA) [1]
  • user program interface (UPI) [1]
  • users, database
    • authentication [1]
    • common [1] , [2]
    • local [1]
    • names
      • sessions and connections [1]
    • privileges [1]
    • temporary tablespaces [1]
  • user segments [1]
  • UTL_HTTP package [1]

V

  • V$ views
    • database object metadata [1]
    • storage [1]
  • VARCHAR2 data type [1] , [2]
  • variables
    • embedded SQL [1]
  • views
    • 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 (ZDLRA)
    • See: Recovery Appliance
  • zone maps [1] , [2]