https://www.pluralsight.com/courses/understanding-database-architecture-oracle

The Oracle database system is quite complex, and understanding its architecture is the non-negotiable first step. This course will give you a solid foundation of the Oracle database architecture.

Understanding the Oracle database architecture is the first step to becoming an Oracle database professional. In this course, Understanding Database Architecture with Oracle, you’ll come to grips with the Oracle database architecture. First, you'll go over a quick architecture overview, and delve into the physical database structures. Next, you’ll explore the memory structures. Finally, you'll take a look at Oracle’s multitenant and sharding architectures. When you're finished with this course, you'll have the skills and knowledge to start your journey to becoming a Oracle database professional.