Susisiekite su mumis:
+370 5 2105044
info@protraining.lt

Oracle Database 12c: Performance Management and Tuning

DPMT/12c

Laikas: 2019.03.25 - 2019.03.29, 09:00 Trukmė: 40 Valandos Vieta: Švitrigailos g. 11M, Vilnius
Kaina:
1 590 € (+ PVM 21%)

Apie mokymus:

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.

Learn To:

  • Use the Oracle tuning methodology.
  • Use Oracle-supplied tools for monitoring and diagnosing SQL and instance performance issues.
  • Use database advisors to proactively correct performance problems.
  • Identify and tune problem SQL statements.
  • Monitor instance performance by using Enterprise Manager.
  • Tune instance components.
Dėstytojas: Gediminas Reimeris


Mokymų temos:
  1. Introduction
  2. Basic Tuning Diagnostics
  3. Using Automatic Workload Repository
  4. Defining the Scope of Performance Issues
  5. Using Metrics and Alerts
  6. Using Baselines
  7. Using AWR-Based Tools
  8. Real-Time Database Operation Monitoring
  9. Monitoring Applications
  10. Identifying Problem SQL Statements
  11. Influencing the Optimizer
  12. Reducing the Cost of SQL Operations
  13. Using SQL Performance Analyzer
  14. SQL Performance Management
  15. Using Database Replay
  16. Tuning the Shared Pool
  17. Tuning the Buffer Cache
  18. Tuning PGA and Temporary Space
  19. Automatic Memory
  20. Performance Tuning Summary with Waits