Back to Courses

Oracle Database: Performance Management and Tuning

ENDED

Training by EZY

Inquire Now

On-Site / Training

Inquire for Price

Inquire Enroll Now

RESPONSE RATE

Details
About the Provider

Enroll Now

Inquire

Details

Oracle Database: Performance Management and Tuning

Students learn how to use Oracle Database automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement and operation performance, and tuning the Oracle Database Instance components.

Learn To

Use the Oracle tuning methodology
Use Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues
Use database advisors to proactively correct performance problems
Identify problem SQL statements
Tune SQL performance problems
Monitor instance performance by using Enterprise Manager
Tune instance components by primarily using instance parameters

Prerequisites

Suggested Prerequisite

Oracle Database: Deploy, Patch and Upgrade Workshop
Familiarity with Oracle Database installation
Familiarity with Oracle Database configuration concepts

Required Prerequisite

Oracle Database: Administration Workshop
Basic knowledge of Linux operating system
A working knowledge of SQL and PL/SQL packages
Basic understanding of Oracle Database architecture
Familiarity with basic database monitoring procedures

Audience

Administrator
Database Administrator

Course Objectives

Use the Oracle Database tuning methodology appropriate to the available tools
Utilize database advisors to proactively tune an Oracle Database Instance
Use the tools based on the Automatic Workload Repository to tune the database
Diagnose and tune common SQL related performance problems
Diagnose and tune common Instance related performance problems
Use Enterprise Manager performance-related pages to monitor an Oracle Database

Enroll Now and Get Certified!

For more details please call us at (632) 531-7587 / (63) 917-6264-762 or email at [email protected]

Reviews

Be the first to write a review about this course.

Write a Review

EZY Intellect is a training provider deliver official courses from our partner - Microsoft, EC-Council, ITIL, PMP, Oracle, VMWare, RedHat, and Scrum Study.

View Complete Profile

Educational Technology Database & Information Systems