Course announcements

  • In this course monitoring and performance analysis of an Oracle database using the DBA Cockpit performance monitor is shown

Goals

  • This course will prepare you to:
    • Describe memory management in the Oracle database
    • Regularly monitoring an Oracle database with the SAP database monitor
    • Analyzing and optimizing database performance

Audience

  • Database Administrator
  • System Administrator
  • Technology Consultant

Prerequisites

Essential

  • SAPTEC SAP NetWeaver Application Server – Fundamentals
  • ADM505 Database Administration Oracle I

Recommended

  • ADM315 Workload Analysis AS ABAP

Course based on software release

  • SAP NetWeaver AS 7.40
  • Oracle 12 c

Content

  • Introduction to Oracle cache management
  • Monitoring of the Database Instance
  • Application Design Analysis
  • Index management and Optimization
  • Cost-Based Optimizer
  • Analysis of Physical and logical Layout
  • Memory Configuration Analysis
  • Wait Interface and Automatic Workload Repository