Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database Concepts
- 1 Introduction to Oracle Database
-
Part I Oracle Relational Data Structures
-
2
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
- 3 Indexes and Index-Organized Tables
- 4 Partitions, Views, and Other Schema Objects
- 5 Data Integrity
- 6 Data Dictionary and Dynamic Performance Views
-
2
Tables and Table Clusters
-
Part II Oracle Data Access
- 7 SQL
- 8 Server-Side Programming: PL/SQL and Java
-
Part III Oracle Transaction Management
-
9
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
- 10 Transactions
-
9
Data Concurrency and Consistency
-
Part IV Oracle Database Storage Structures
- 11 Physical Storage Structures
-
12
Logical Storage Structures
- Introduction to Logical Storage Structures
- Overview of Data Blocks
- Overview of Extents
- Overview of Segments
- Overview of Tablespaces
-
Part V Oracle Instance Architecture
- 13 Oracle Database Instance
-
14
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
-
15
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
- 16 Application and Oracle Net Services Architecture
-
Part VI Oracle Database Administration and Application Development
-
17
Topics for Database Administrators and Developers
- Overview of Database Security
- Overview of High Availability
- Overview of Grid Computing
- Overview of Data Warehousing and Business Intelligence
- Overview of Oracle Information Integration
-
18
Concepts for Database Administrators
- Duties of Database Administrators
- Tools for Database Administrators
- Topics for Database Administrators
- 19 Concepts for Database Developers
-
17
Topics for Database Administrators and Developers
-
Glossary
- Index