TRAINING CATEGORIES
(Click Category to List Courses)

38 - IT-D Information Technology - Databases and Related Technologies


IT-D 236 - Oracle Database 12c: Performance Management and Tuning

Code Start Date Duration Venue
IT-D 236 16 December 2024 5 Days Istanbul Registration Form Link
IT-D 236 17 February 2025 5 Days Istanbul Registration Form Link
IT-D 236 14 April 2025 5 Days Istanbul Registration Form Link
IT-D 236 23 June 2025 5 Days Istanbul Registration Form Link
IT-D 236 04 August 2025 5 Days Istanbul Registration Form Link
IT-D 236 29 September 2025 5 Days Istanbul Registration Form Link
IT-D 236 24 November 2025 5 Days Istanbul Registration Form Link
IT-D 236 22 December 2025 5 Days Istanbul Registration Form Link
Please contact us for fees

 

Course Description

In the Oracle Database 12c: Performance Management and Tuning course, participants will 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, they will be introduced to Oracle Database Cloud Service.

Course Objectives

  • Using the Oracle tuning methodology
  • Using Oracle-supplied tools for monitoring and diagnosing SQL and instance performance issues
  • Using database advisors to proactively correct performance problems
  • Identifying and tune problem SQL statements
  • Monitoring instance performance by using Enterprise Manager
  • Tuning instance components
  • Gaining an understanding of the Oracle Database Cloud Service

Who Should Attend?

  • Programmers 
  • Database Administrators
  • Data Warehouse Administrators

Course Details/Schedule

Day 1

  • Basic Tuning Diagnostics
  • CPU and Wait Time Tuning Dimensions
  • Performance Tuning Diagnostics
  • Using Automatic Workload Repository
  • Defining the Scope of Performance Issues

Day 2

  • Using Metrics and Alerts
  • Using Baselines
  • Using AWR-Based Tools
  • Real-Time Database Operation Monitoring
  • Monitoring Applications

Day 3

  • Identifying Problem SQL Statements
  • Influencing the Optimizer
  • Reducing the Cost of SQL Operations
  • Using SQL Performance Analyzer

Day 4

  • SQL Performance Management
  • Using Database Replay
  • Tuning the Shared Pool
  • Tuning the Buffer Cache

Day 5

  • Tuning PGA and Temporary Space
  • Automatic Memory
  • Performance Tuning Summary with Waits
  • Oracle Database Cloud Service: Overview

 

ETABS and SAFE. Training 24 CCE 210 5 SAP 2000. Training 25 CCE 305 5 Quality Assurance in Pavement Construction 26 CCE 401 5 Construction Project Management 27 CCE 402 10 Construction Project Management (10 Days) 28 CCE 403 5 Construction Project Management-Intensive 29 CCE 405 5 Principles of Construction Project Management 30 CCE 406 10 Principles of Construction Project Management (10 Days) 31 CCE 410 10 Construction Project and Risk Management (10 days) 32 CCE 411 5 Project & Contract Management for Marine Construction 33 CCE 412 5 Application of GIS in Construction Management 34 CCE 415 4 Sustainable Water Management Techniques, Innovation and Solution (4 Days) 35 CCE 419 5 Construction Management of Hydraulic Projects 36 CCE 420 5 Water Project Management 37 CCE 421 10 Modern Technologies in the Supervision and Quality Control of Irrigation Projects and Dealing with Contractors (10 Days) 38 CCE 422 5 Rapid Earthquake Hazard Evaluation of Buildings 39 CCE 425 10 Practical Application of Computers in Structural Engineering (10 Days) 40 CCE 428 5 Survey & Profile Using Total Station 41 CCE 430 5 Bridge Construction and Maintenance 42 CCE 435 5 Bridge Inspection and Maintenance 43 CCE-A 410 10 إدارة المشاريع الهندسية -10 أيام
21 - TTC - Transportation and Traffic Control
22 - ADV - Architectural Design and Visualization
23 - SRM - Safety and Occupational Health
24 - CSM - Public Relations, Communication Skills & Office Management
25 - TEM - Training and Education Management
26 - CMR - Customer Relations