Database Administration Oracle II

Course Details
Code ADM506-v015
Tuition (USD): $1,500.00 • Virtual (2 days)
$1,500.00 • Classroom (2 days)
Course Details
GSA (USD): $1,215.11 • Virtual (2 days)
$1,215.11 • Classroom (2 days)

Skills Gained

  • 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

Who Can Benefit

  • 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 Details

Course 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

Notes

  • Optimizing database parameters and the hardware configuration are not covered as part of this course.

Course based on software release

  • SAP NetWeaver AS 7.40
  • Oracle 12 c
Course Details
Code ADM506-v015
Tuition (USD): $1,500.00 • Virtual (2 days)
$1,500.00 • Classroom (2 days)
Course Details
GSA (USD): $1,215.11 • Virtual (2 days)
$1,215.11 • Classroom (2 days)