ADM506 – Database Administration Oracle II

Length

2 days

Price

$2640.00 inc GST

Overview

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

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

This course is based on software release:

SAP NetWeaver AS 7.40
Oracle 12 c

Key Topics

Detailed Info

Introduction to Oracle cache management
Monitoring of the Database Instance
Application Design Analysis
Index Management and Optimisation
Cost-Based Optimiser
Analysis of Physical and Logical Layout
Memory Configuration Analysis
Wait Interface and Automatic Workload Repository

Skills Gained

Key Topics

Target Audience

Prerequisites

Skills Gained

This course will prepare you to:

Describe memory management in the Oracle database
Regularly monitor an Oracle database with the SAP database monitor
Analyse and optimise database performance

Key Topics

Introduction to Oracle cache management
Monitoring of the Database Instance
Application Design Analysis
Index Management and Optimisation
Cost-Based Optimiser
Analysis of Physical and Logical Layout
Memory Configuration Analysis
Wait Interface and Automatic Workload Repository

Target 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

Print course details

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

You don't appear to have Javascript enabled, our contact forms & booking process unfortunately requires it.

If you'd like more information, or to book a course please email us

Email Course Outline

Request a Callback

Enter your details below and we'll email you a pdf of the course outline.

Enter your details below and one of our team will give you a call to answer any questions you may have.

Course Registration Notes

DDLS offers certification and training through our partnership with SAP Inc. This arrangement requires DDLS to provide your details to SAP for course and exam registration purposes.

SAP e-Learning

SAP Learning Hub subscriptions are now available.

Click here to find out more

Length

Price

Overview

Key Topics

Skills Gained

Key Topics

Target Audience

Prerequisites

Request Course Information

Testimonials

YOUR IT TRAINING PARTNER

FOLLOW US