Oracle Memory 19C Architecture Course

Oracle Memory 19C Architecture Course
Courses

In this course, participants will learn the new features of Oracle Database 19c, along with a clear understanding of the CDB–PDB architecture. The course provides a practical and easy-to-follow explanation of Oracle Database 19c Memory Architecture, which forms a critical foundation for performance tuning and troubleshooting.

The sessions explain how Oracle uses memory, why memory-related performance issues occur, and how correct memory configuration directly impacts database performance.

Topics Covered

  1. Overview of Oracle Memory Architecture-19C cdb and pdb
  2. Understanding SGA and PGA concepts and components
  3. Detailed explanation of:
  4. Database Buffer Cache
  5. Shared Pool
  6. Redo Log Buffer
  7. Large Pool
  8. Java Pool
  9. Streams Pool
  10. Automatic Memory Management (AMM)
  11. Automatic Shared Memory Management (ASMM)
  12. Differences between AMM, ASMM, and Manual Memory Management
  13. Memory-related initialization parameters in Oracle 19c
  14. Common memory performance issues and symptoms

Practical Learning

  1. Understand memory allocation using real-world DBA examples
  2. Identify and analyze memory bottlenecks
  3. Learn best practices for memory sizing in Oracle 19c
  4. Understand the performance impact of incorrect memory configuration

Who Should Attend

  1. Oracle DBAs (Freshers & Experienced)
  2. SQL Developers
  3. Performance Tuning Beginners
  4. Anyone preparing for Oracle DBA interviews

What You Get

  1. Structured and easy-to-follow PowerPoint slides
  2. Clear audio explanations
  3. Concept-focused learning with real DBA insights

Learning Outcome

After completing this course, you will be able to:

  1. Understand Oracle 19c memory internals
  2. Configure Oracle memory confidently and correctly
  3. Troubleshoot memory-related performance issues
  4. Build a strong foundation for performance tuning


Terms | Privacy
₹1,499
Terms | Privacy