Table of Contents
- Title and Copyright Information
- Preface
- 1 Introduction to Oracle Database
- Part I Multitenant Architecture
-
Part II Oracle Relational Data Structures
-
4
Tables and Table Clusters
- Introduction to Schema Objects
- Overview of Tables
- Overview of Table Clusters
- Overview of Attribute-Clustered Tables
- Overview of Temporary Tables
- Overview of External Tables
- Overview of Blockchain Tables
- Overview of Immutable Tables
- Overview of Object Tables
- 5 Indexes and Index-Organized Tables
- 6 Partitions, Views, and Other Schema Objects
- 7 Data Integrity
- 8 Data Dictionary and Dynamic Performance Views
-
4
Tables and Table Clusters
-
Part III Oracle Data Access
- 9 SQL
- 10 Server-Side Programming: PL/SQL and Java
-
Part IV Oracle Transaction Management
-
11
Data Concurrency and Consistency
- Introduction to Data Concurrency and Consistency
- Overview of Oracle Database Transaction Isolation Levels
- Overview of the Oracle Database Locking Mechanism
- Overview of Automatic Locks
- Overview of Manual Data Locks
- Overview of User-Defined Locks
- 12 Transactions
-
11
Data Concurrency and Consistency
-
Part V Oracle Database Storage Structures
-
13
Physical Storage Structures
- Introduction to Physical Storage Structures
- Overview of Data Files
- Overview of Control Files
- Overview of the Online Redo Log
-
14
Logical Storage Structures
- Introduction to Logical Storage Structures
- Overview of Data Blocks
- Overview of Extents
- Overview of Segments
- Overview of Tablespaces
-
13
Physical Storage Structures
-
Part VI Oracle Instance Architecture
- 15 Oracle Database Instance
-
16
Memory Architecture
- Introduction to Oracle Database Memory Structures
- Overview of the User Global Area
- Overview of the Program Global Area (PGA)
- Overview of the System Global Area (SGA)
- Overview of Software Code Areas
-
17
Process Architecture
- Introduction to Processes
- Overview of Client Processes
- Overview of Server Processes
-
Overview of Background Processes
- Mandatory Background Processes
- Optional Background Processes
- Slave Processes
- 18 Application and Oracle Net Services Architecture
- Glossary
- Index