ADVANCE YOUR CAREER. TRANSFORM YOUR LIFE WITH IN-DEMAND SKILLS FOR AN ON.DEMAND WORLD. EARN MINIMUM £55K WITH YOUR ORACLE DATABASE PERFORMANCE TUNING SKILLS.


EXCELLENT SELF-TEACH TRAINING COURSE . IDEAL FOR DBA's AND THOSE DESIGNING AND DEVELOPING SQL BASED APPLICATIONS IN ANY ORACLE DEPLOYMENT ENVIRONMENT. 


EXCELLENT FOR IT DEVELOPERS/CONSULTANTS, DATABASE ADMINISTRATORS AND DEVELOPERS, DATA WAREHOUSE ARCHITECTS / CONSULTANTS PREPARING FOR THE ORACLE OCP CERTIFICATION EXAMS.

 

ALSO GOOD FOR ANALYSTS, IT DEVELOPERS/CONSULTANTS WHO WISH TO CROSS TRAIN/UPSKILL  FROM SQL SERVER, SYBASE OR IBM DB2 TO ORACLE DBMS 19c/12c ENVIRONMENT.

VERY GOOD HANDS-ON TRAINING MATERIAL (CBT) WITH REAL-LIFE BASED TASKS, ACTIVITIES AND LABS.


ORACLE DATABASE 19c: PERFORMANCE MANAGEMENT AND TUNING SELF-STUDY CBT

How This Course Is Organised

The Oracle Database 19c: Performance Management and Tuning course teaches you about the performance analysis and tuning tasks expected of a database administrator. 

Students will learn about how to apply a database tuning methodology by using the appropriate tools in order to monitor, diagnose and tune instance and SQL performance problems. 

Students will possess a profound knowledge of the Oracle Database architecture, great familiarity with day-to-day database administration, knowledge of which advisors can be used to inspect various aspects/areas of the Oracle Database environment, and a good working knowledge of SQL, its executions plans and generated statistics.


Certification 

This course will assist in preparation for the Oracle Database Administration and Application Development OCP 1Z0-083 Certification exams.

Duration: N/A


Audience: 

Database Administrators
Technical Consultant
Application Developers


Prerequisites:
Familiarity with data processing concepts and techniques

 

Course Objectives:

On successful Completion of the course you will be able to accomplish the following:

Basic Tuning Methods and Diagnostics
Using Statspack
Using Log and Trace Files to Monitor Performance
Using Metrics, Alerts and Baselines
Using AWR-Based Tools
Performing Oracle Database Application Monitoring
Identifying Problem SQL Statements
Influencing the Optimizer
SQL Performance Management
Tuning the Shared Pool
Tuning the Buffer Cache
Tuning the PGA
Using Automatic Memory Management

 

Course Topics:

Introduction to Performance Tuning 
Introduction to Performance Management Concepts
Proactive vs Reactive Performance Tuning
What Does the DBA Tune?
How to Tune
Tuning Methodology

Basic Tuning Methods and Diagnostics
Tuning Methodologies
Tuning Lifecyles phases
Describe the time model
Explain wait events
Diagnosing performance problems using V$ views

Using Statspack
Installing and configuring  Statspack
Create Statspack snapshots
Generate Statspack and AWR reports
Identify the major sections of the Statspack report

Using Log and Trace Files to Monitor Performance
Using the Alert Log  to Monitor Performance
Using Trace files  to Monitor Performance

Using Metrics, Alerts and Baselines
Monitoring performance using metric thresholds and alerts
Using AWR baselines to monitor performance

Using AWR-Based Tools
Diagnosing performance issues using ADDM
Diagnosing performance issues using ASH reports
Using Automated Maintenance Tasks to Manage Performance

Performing Oracle Database Application Monitoring
Implementing Real-Time Database Operation Monitoring
Configuring and using services to monitor database Application performance

Identifying Problem SQL Statements
Understand the phases for SQL statement processing
Interpreting execution plans
Using formatted output of SQL Trace or the optimizer trace to identify poorly performing SQL statements
Monitoring Adaptive / Dynamic Execution plans
Monitoring Automatic Reoptimization and SQL Plan Directives

Influencing the Optimizer
Explain how statistics influence the optimizer
Configuring parameters to influence the optimizer

Reducing the Cost of SQL Operations
Shrinking Segments
Managing Chaining and Migration
Configuring Index and Table Performance Options
Configuring table compression
Diagnosing and tuning space related issues

Using Real Application Testing
Using SQL Performance Analyzer to test the impact of database changes
Use Database Replay to check impact of system change on performance

SQL Performance Management
Managing optimizer statistics
Using the Optimizer Statistics Advisor
Using the  SQL Access and SQL Tuning advisors to Tune SQL statements
Use SQL Plan Management to tune SQL statements

Tuning the Shared Pool
Diagnosing and resolving performance problems related to the shared pool
Managing and Tuning the Result Cache

Tuning the Buffer Cache
Diagnosing and resolving performance problems related to the buffer cache
Diagnose database I/O issues
Configuring Big Table Caching
Configuring Flash Cache

Tuning the PGA
Diagnosing and resolving performance issues related to PGA
Diagnosing and resolving performance issues related to temporary tablespace

Using Automatic Memory Management
Configuring Automatic Shared Memory Management
Configuring Automatic Memory Management


NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY E-LEARNING FORMAT OR DISTANCE LEARNING. FEEL FREE TO ASK IF YOU PREFER DISTANCE LEARNING OR E-LEARNING FORMAT

What is Computer Based Training  - CBT?

CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This publishers CBT do NOT have voice.

Generally, CBT's tend to be more expensive. Our CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning.

Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. 

All CBT and Training Guide Learning formats are updated every 3 months and delivered with FULL LICENCE KEY.. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.

CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.

 The WebLearning unique Methodology

All WebLearning® Training Guide courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: A NEW, very effective and proven way of learning.


FACT:

  • Material retention with CBT’S are 45% better than with conventional training method
  • Your learning curve with CBT is 25%-55% less than conventional method
  • The cost of CBT training is 65% less than Classroom training
  • CBT’S are self pacing and Interactive

CBT’S simulate the actual software being studied so there is no need to have the actual software installed