THIS IS ORACLE DATABASE 19c: PERFORMANCE MANAGEMENT & TUNING SELF-STUDY CBT BUNDLED WITH A DATABASE VIRTUAL MACHINE (VM) TRAINING APPLIANCE AND FULL LICENCE KEY.
LEARN AND PUT THE £££'S BACK IN YOUR POCKET. SKILL UP - MOVE ON - EARN MORE £££s....
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.
PERFECT INTERACTIVE TRAINING COURSE BUNDLED WITH A DATABASE VIRTUAL MACHINE FOR PRACTICAL HANDS-ON REAL-LIFE BASED PRACTICE SCENARIOS.
ORACLE DATABASE 19c: PERFORMANCE MANAGEMENT & TUNING CBT & VIRTUAL MACHINE BUNDLE
The Oracle Database 19c: Performance Management and Tuning is a CBT course bundled with a Database Virtual Machine - VM Training Appliance for practical hands-on training purposes. This 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 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 Lifecycle 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, CBT OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, E-LEARNING OR CBT LEARNING FORMATS. PRICES DIFFER
What is a 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 Publisher's CBT Titles 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. All CBT and Courseware Learning formats are delivered with FULL LICENCE KEY.
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. 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.
NOTE: This course is bundled with a Oracle Database Virtual Machine for hands-on practice purposes only.
FACT:
· Material retention with CBT’S are 45% better than with conventional training methods
· Your learning curve with CBT is 25%-55% less than conventional methods
· The cost of CBT training is over 65% less than Classroom training
· CBT’S are self pacing, interactive and simulate the actual software being studied