Курсы Oracle
Oracle Database: Performance Management and Tuning
 |
Код: ODBPMT |  |
Предварительная запись |  |
Кол-во часов: 40 , Кол-во дней: 5 | ||
Prerequisites
- Oracle Database 12c R2: Install and Upgrade Workshop Ed 2
- Familiarity with Oracle Database installation
- Familiarity with Oracle Database configuration concepts
- Oracle Database 18c: Administration Workshop Ed 1
- Basic knowledge of Linux operating system
- A working knowledge of SQL and PL/SQL packages
- Basic understanding of Oracle Database architecture
- Familiarity with basic database monitoring procedures
Audience
- Administrator
- Database Administrator
- Use the Oracle Database tuning methodology appropriate to the available tools
- Utilize database advisors to proactively tune an Oracle Database Instance
- Use the tools based on the Automatic Workload Repository to tune the database
- Diagnose and tune common SQL related performance problems
- Diagnose and tune common Instance related performance problems
- Use Enterprise Manager performance-related pages to monitor an Oracle Database
- Introduction
- Defining the Scope of Performance Issues
- Using AWR-Based Tools
- Identifying Problem SQL Statements
- Using SQL Performance Analyzer
- Tuning the Shared Pool
- Automatic Memory
- Basic Tuning Diagnostics
- Using Metrics and Alerts
- Real-Time Database Operation Monitoring
- Influencing the Optimizer
- SQL Performance Management
- Tuning the Buffer Cache
- Performance Tuning Summary with Waits
- Using Automatic Workload Repository
- Using Baselines
- Monitoring Applications
- Reducing the Cost of SQL Operations
- Using Database Replay
- Tuning PGA and Temporary Space
| Ссылка курса обучения | http://muk.training/courses/oracle/12359/ |
| Назад в раздел |
Для предварительной записи на курсы или
+38 (044) 492-29-29, 594-98-98
e-mail: training@muk.com.ua
Или заполните заявку на нашем сайте.
