Read more
Month/20 Hours Price:45,000
40,000
Oracle Database – DBA 12c/11g Performance Tuning Course
In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service.
Benefits To You:
The DBA will analyze the SQL performance with available tools. The DBA will be introduced to various methods of identifying the SQL statements that require tuning and the diagnostic tools used to find ways to improve performance. This will include the use of statistics, profiles to influence the optimizer, and using the SQL Advisors.
COURSE DETAILS:
Introduction
Course ObjectivesCourse Organization
Course Agenda
Topics Not Included in the Course
Who Tunes?
What Does the DBA Tune?
How to Tune
Tuning Methodology
Basic Tuning Diagnostics
Performance Tuning DiagnosticsPerformance Tuning Tools
Tuning Objectives
Top Timed Events
DB Time
CPU and Wait Time Tuning Dimensions
Time Model
Dynamic Performance Views
Using Automatic Workload Repository
Automatic Workload Repository OverviewAutomatic Workload Repository Data
Enterprise Manager Cloud Control and AWR
Snapshots
Reports
Compare Periods
Defining the Scope of Performance Issues
Defining the ProblemLimiting the Scope
Setting the Priority
Top SQL Reports
Common Tuning Problems
Tuning During the Life Cycle
ADDM Tuning Session
Performance Versus Business Requirements
Using Metrics and Alerts
Metrics and Alerts OverviewLimitation of Base Statistics
Benefits of Metrics
Viewing Metric History Information
Viewing Histograms
Server-Generated Alerts
Setting Thresholds
Metrics and Alerts Views
Using Baselines
Comparative Performance Analysis with AWR BaselinesAutomatic Workload Repository Baselines
Moving Window Baseline
Baselines in Performance Page Settings
Baseline Templates
AWR Baseslines
Creating AWR Baselines
Managing Baselines with PL/SQL
Using AWR-Based Tools
Automatic Maintenance TasksADDM Performance Monitoring
Using Compare Periods ADDM
Active Session History
New or Enhanced Automatic Workload Repository Views
Emergency Monitoring
Real-time ADDM
Real-Time Database Operation Monitoring
OverviewUse Cases
Defining a Database Operation
Scope of a Composite Database Operation
Database Operation Concepts
Identifying a Database Operation
Enabling Monitoring of Database Operations
Monitoring Applications
What is a Service?Service Attributes
Service Types
Creating Services
Managing Services in a Single-Instance Environment
Where are Services Used?
Using Services with Client Applications
Services and Pluggable Databases
Identifying Problem SQL Statements
SQL Statement Processing PhasesRole of the Oracle Optimizer
Identifying Bad SQL
Top SQL Reports
SQL Monitoring
What is an Execution Plan?
Methods for Viewing Execution Plans
Uses of Execution Plans
Influencing the Optimizer
Functions of the Query OptimizerSelectivity
Cardinality and Cost
Changing Optimizer Behavior
Optimizer Statistics
Extended Statistics
Controlling the Behavior of the Optimizer with Parameters
Enabling Query Optimizer Features
Reducing the Cost of SQL Operations
Reducing the CostIndex Maintenance
SQL Access Advisor
Table Maintenance for Performance
Table Reorganization Methods
Space Management
Extent Management
Using SQL Performance Analyzer
Real Application Testing: OverviewReal Application Testing: Use Cases
SQL Performance Analyzer: Process
Capturing the SQL Workload
Creating a SQL Performance Analyzer Task
SQL Performance Analyzer: Tasks
Parameter Change
SQL Performance Analyzer Task Page
SQL Performance Management
Maintaining SQL PerformanceMaintaining Optimizer Statistics
Automated Maintenance Tasks
Statistic Gathering Options
Setting Statistic Preferences
Restore Statistics
Deferred Statistics Publishing
Automatic SQL Tuning
Using Database Replay
Using Database ReplayThe Big Picture
System Architecture
Capture Considerations
Replay Considerations: Preparation
Replay Considerations
Replay Options
Replay Analysis
Tuning the Shared Pool
Shared Pool ArchitectureShared Pool Operation
The Library Cache
Latch and Mutex
Diagnostic Tools for Tuning the Shared Pool
Avoiding Hard Parses
Reducing the Cost of Soft Parses
Sizing the Shared Pool
Tuning the Buffer Cache
Oracle Database Architecture: Buffer CacheBuffer Cache: Highlights
Database Buffers
Buffer Hash Table for Lookups
Working Sets
Buffer Cache Tuning Goals and Techniques
Buffer Cache Performance Symptoms
Buffer Cache Performance Solutions
Tuning PGA and Temporary Space
SQL Memory UsagePerformance Impact
Automatic PGA Memory
SQL Memory Manager
Configuring Automatic PGA Memory
Setting PGA_AGGREGATE_TARGET Initially
Limiting the size of the Program Global Area (PGA)
SQL Memory Usage
Automatic Memory
- Oracle Database Architecture
- Dynamic SGA
- Granule
- Memory Advisories
- Manually Adding Granules to Components
- Increasing the Size of an SGA Component
- Automatic Shared Memory Management: Overview
- SGA Sizing Parameters: Overview
Performance Tuning Summary with Waits
Commonly Observed Wait EventsAdditional Statistics
Top 10 Mistakes Found in Customer Systems
Symptoms
Oracle Database Cloud Service: Overview
Database as a Service Architecture, Features and ToolingSoftware Editions: Included Database Options and Management Packs
Accessing the Oracle Database Cloud Service Console & Automated Database Provisioning
Managing the Compute Node Associated With a Database Deployment
Managing Network Access to Database as a Service & Scaling a Database Deployment
Performance Management in the Database Cloud Environment
Performance Monitoring and Tuning
What Can be Tuned in a DBCS Environment?
International Student Fee : 250USD | 330 CAD | 940 AED | 940 SAR
Job Interview Preparation (Soft Skills Questions & Answers)
Tough Open-Ended Job Interview Questions
What to Wear for Best Job Interview Attire
Job Interview Question- What are You Passionate About?
How to Prepare for a Job Promotion Interview
Stay connected even when you’re apart
Join our WhatsApp Channel – Get discount offers
500+ Free Certification Exam Practice Question and Answers
Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Join Internships and Referral Program (click for details)
Work as Freelancer or Full-Time Employee (click for details)
Flexible Class Options
Week End Classes For Professionals SAT | SUN
Corporate Group Trainings Available
Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
Oracle Techno Functional Consultant – Oracle Apps R12
0 Reviews