Table of Contents
- Title and Copyright Information
- Preface
- 1 Introduction to Oracle Database
- Part I Multitenant Architecture
-
Part II Oracle 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
- Overview of Partitions
- Overview of Sharded Tables
- Overview of Views
- Overview of Materialized Views
- Overview of Sequences
- Overview of Dimensions
- Overview of Synonyms
- 7 Data Integrity
- 8 Application Data Usage
- 9 Data Dictionary and Dynamic Performance Views
-
4
Tables and Table Clusters
-
Part III Oracle Data Access
- 10 SQL
- 11 Server-Side Programming: PL/SQL, Java, and JavaScript
-
Part IV Oracle Transaction Management
-
12
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
- 13 Transactions
-
12
Data Concurrency and Consistency
-
Part V Oracle Database Storage Structures
-
14
Physical Storage Structures
- Introduction to Physical Storage Structures
- Overview of Data Files
- Overview of Control Files
- Overview of the Online Redo Log
-
15
Logical Storage Structures
- Introduction to Logical Storage Structures
- Overview of Data Blocks
- Overview of Extents
- Overview of Segments
- Overview of Tablespaces
-
14
Physical Storage Structures
-
Part VI Oracle Instance Architecture
- 16 Oracle Database Instance
-
17
Memory Architecture
- Introduction to Oracle Database Memory Structures
- Overview of the System Global Area (SGA)
- Overview of the Program Global Area (PGA)
- Overview of the User Global Area
- Overview of the Managed Global Area (MGA)
- Overview of Software Code Areas
-
18
Process Architecture
- Introduction to Processes
- Overview of Client Processes
- Overview of Server Processes
-
Overview of Background Processes
-
Mandatory Background Processes
- Process Monitor Process (PMON) Group
- Process Manager (PMAN)
- Listener Registration Process (LREG)
- System Monitor Process (SMON)
- Database Writer Process (DBW)
- Log Writer Process (LGWR)
- Checkpoint Process (CKPT)
- Manageability Monitor Processes (MMON and MMNL)
- Recoverer Process (RECO)
- Background Process (BGnn)
- Virtual Operating System Daemon Process (VOSD)
- Optional Background Processes
- Secondary Processes
-
Mandatory Background Processes
- 19 Application and Oracle Net Services Architecture
-
Part VII Oracle Database Administration and Application Development
-
20
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
- 21 Artificial Intelligence in the Oracle Database
-
22
Concepts for Database Administrators
- Duties of Database Administrators
- Tools for Database Administrators
- Topics for Database Administrators
- 23 Concepts for Database Developers
-
20
Topics for Database Administrators and Developers
- Glossary
- Index