К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Advanced Oracle Monitoring and Tuning Techniques · LearnSpace
Назад в каталог
courseraIT и технологии

Advanced Oracle Monitoring and Tuning Techniques

Курс от Packt
Продвинутый≈ 18.1 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Updated in May 2025. This course now features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. Elevate your Oracle database management skills with this in-depth course on advanced monitoring and tuning techniques. Gain mastery over critical database performance tools and strategies to ensure your systems operate at peak efficiency. From Active Session History (ASH) to tuning the Program Global Area (PGA) and buffer cache, this course empowers you with the expertise to handle complex database challenges. Begin your journey with foundational concepts in ASH, learning to monitor real-time activities and analyze performance metrics. Progress into advanced techniques for linking ASH data to dimension views, optimizing database services, and tracing SQL for pinpointing bottlenecks. Explore hands-on practices in key areas like shared pool tuning, managing server result caches, and leveraging Smart Flash Cache for performance gains. Dive deeper into specialized topics like tuning the redo path and handling latches, mutexes, and enqueue waits. Develop a comprehensive understanding of automated maintenance tasks and real-time monitoring to proactively manage database operations. Each module combines theoretical knowledge with practical exercises, ensuring you can confidently implement your skills in real-world scenarios. Designed for database administrators and IT professionals, this course suits those with a solid Oracle database foundation looking to advance their expertise. It’s perfect for intermediate to advanced learners eager to optimize and monitor complex Oracle systems.

Навыки, которые вы освоите

Data MaintenanceMemory ManagementOperational DatabasesDatabase Management SystemsDatabase Architecture and Administration

Программа курса

12 модулей · 136 учебных материалов

01Using Active Session History (ASH)19 материалов

Using Active Session History (ASH)

Introduction to the Course 'Advanced Oracle Monitoring and Tuning Techniques'ЧтениеFull Course ResourcesЧтениеUsing Active Session History (ASH) 1 of 3ВидеоUsing Active Session History (ASH) 2 of 3Видео

Учитесь у экспертов

Packt - Course Instructors

Преподаватель курса

Advanced Oracle Monitoring and Tuning Techniques
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 18.1 ч

12 модулей

Язык: Английский

Субтитры: Казахский

Часть программы вашего университета
Using Active Session History (ASH) 3 of 3Видео
Querying ASH 1 of 4Видео
Querying ASH 2 of 4Видео
Querying ASH 3 of 4Видео
Querying ASH 4 of 4Видео
Practice 11 - Using Active Session History (ASH) 1 of 4Видео
Practice 11 - Using Active Session History (ASH) 2 of 4Видео
Practice 11 - Using Active Session History (ASH) 3 of 4Видео
Practice 11 - Using Active Session History (ASH) 4 of 4Видео
Practice 12 - Linking ASH to Its Dimension Views 1 of 4Видео
Practice 12 - Linking ASH to Its Dimension Views 2 of 4Видео
Practice 12 - Linking ASH to Its Dimension Views 3 of 4Видео
Practice 12 - Linking ASH to Its Dimension Views 4 of 4Видео
Using Active Session History (ASH) in Oracle DatabasesDIALOGUE
Using Active Session History (ASH) - AssessmentЗадание
02Using Database Services15 материалов

Using Database Services

Introducing Database Services 1 of 4ВидеоIntroducing Database Services 2 of 4ВидеоIntroducing Database Services 3 of 4ВидеоIntroducing Database Services 4 of 4ВидеоPractice 13 - Using Database Service Performance Statistics 1 of 2ВидеоPractice 13 - Using Database Service Performance Statistics 2 of 2ВидеоUsing Module Action and Client Identifier 1 of 3ВидеоUsing Module Action and Client Identifier 2 of 3ВидеоUsing Module Action and Client Identifier 3 of 3ВидеоPractice 14 - Using Module, Action, and Client Identifier Attributes 1 of 4ВидеоPractice 14 - Using Module, Action, and Client Identifier Attributes 2 of 4ВидеоPractice 14 - Using Module, Action, and Client Identifier Attributes 3 of 4ВидеоPractice 14 - Using Module, Action, and Client Identifier Attributes 4 of 4ВидеоUsing Oracle Database Services EffectivelyDIALOGUEUsing Database Services - AssessmentЗадание
03SQL Tracing11 материалов

SQL Tracing

SQL Tracing 1 of 3ВидеоSQL Tracing 2 of 3ВидеоSQL Tracing 3 of 3ВидеоUsing tkprof Utility 1 of 2ВидеоUsing tkprof Utility 2 of 2ВидеоPractice 15 - Tracing SQL Statements Using DBMS_MONITOR 1 of 4ВидеоPractice 15 - Tracing SQL Statements Using DBMS_MONITOR 2 of 4ВидеоPractice 15 - Tracing SQL Statements Using DBMS_MONITOR 3 of 4ВидеоPractice 15 - Tracing SQL Statements Using DBMS_MONITOR 4 of 4ВидеоSQL Tracing and Analysis with TK ProfDIALOGUESQL Tracing - AssessmentЗадание
04Monitoring Database Operations in Real Time8 материалов

Monitoring Database Operations in Real Time

Monitoring Database Operations in Real Time 1 of 3ВидеоMonitoring Database Operations in Real Time 2 of 3ВидеоMonitoring Database Operations in Real Time 3 of 3ВидеоPractice 16 - Monitoring Database Operations in Real Time 1 of 3ВидеоPractice 16 - Monitoring Database Operations in Real Time 2 of 3ВидеоPractice 16 - Monitoring Database Operations in Real Time 3 of 3ВидеоReal-Time Database Monitoring with DBMS_SQL_MONITORDIALOGUEMonitoring Database Operations in Real Time - AssessmentЗадание
05Managing the Automated Maintenance Tasks5 материалов

Managing the Automated Maintenance Tasks

Managing the Automated Maintenance Tasks 1 of 2ВидеоManaging the Automated Maintenance Tasks 2 of 2ВидеоPractice 17 - Managing Automated Maintenance TasksВидеоManaging Automated Maintenance Tasks in OracleDIALOGUEManaging the Automated Maintenance Tasks - AssessmentЗадание
06Overview of the Tools Covered So Far3 материалов

Overview of the Tools Covered So Far

Overview of the Tools Covered So FarВидеоUnderstanding Oracle Database Performance ToolsDIALOGUEAssessment 6Задание
07Handling Enqueue Waits8 материалов

Handling Enqueue Waits

Handling Enqueue Waits 1 of 3ВидеоHandling Enqueue Waits 2 of 3ВидеоHandling Enqueue Waits 3 of 3ВидеоPractice 18 - Handling Enqueue Waits 1 of 3ВидеоPractice 18 - Handling Enqueue Waits 2 of 3ВидеоPractice 18 - Handling Enqueue Waits 3 of 3ВидеоUnderstanding Oracle In-Q MechanismsDIALOGUEAssessment 7Задание
08Handling Latches and Mutexes14 материалов

Handling Latches and Mutexes

Introducing Latches and Mutex 1 of 2ВидеоIntroducing Latches and Mutex 2 of 2ВидеоHandling Latch and Mutex Contention 1 of 2ВидеоHandling Latch and Mutex Contention 2 of 2ВидеоHandling Cache Buffer Chain (CBC) Latch 1 of 2ВидеоHandling Cache Buffer Chain (CBC) Latch 2 of 2ВидеоHandling Other Latch Types 1 of 2ВидеоHandling Other Latch Types 2 of 2ВидеоPractice 19 - Handling Latch and Mutex Contention 1 of 4ВидеоPractice 19 - Handling Latch and Mutex Contention 2 of 4ВидеоPractice 19 - Handling Latch and Mutex Contention 3 of 4ВидеоPractice 19 - Handling Latch and Mutex Contention 4 of 4ВидеоUnderstanding Latches and MutexesDIALOGUEHandling Latches and Mutexes - AssessmentЗадание
09Tuning the Shared Pool17 материалов

Tuning the Shared Pool

Tuning the Shared Pool 1 of 4ВидеоTuning the Shared Pool 2 of 4ВидеоTuning the Shared Pool 3 of 4ВидеоTuning the Shared Pool 4 of 4ВидеоSizing the Shared PoolВидеоPractice 20 - Tuning the Shared Pool 1 of 2ВидеоPractice 20 - Tuning the Shared Pool 2 of 2ВидеоCaching Session Cursors 1 of 2ВидеоCaching Session Cursors 2 of 2ВидеоPractice 21 - Caching Session Cursors 1 of 2ВидеоPractice 21 - Caching Session Cursors 2 of 2ВидеоManaging Server Result Cache 1 of 2ВидеоManaging Server Result Cache 2 of 2ВидеоPractice 22 - Managing Server Result Cache 1 of 2ВидеоPractice 22 - Managing Server Result Cache 2 of 2ВидеоOptimizing the Shared Pool in OracleDIALOGUETuning the Shared Pool - AssessmentЗадание
10Tuning the Buffer Cache15 материалов

Tuning the Buffer Cache

Tuning the Buffer Cache 1 of 5ВидеоTuning the Buffer Cache 2 of 5ВидеоTuning the Buffer Cache 3 of 5ВидеоTuning the Buffer Cache 4 of 5ВидеоTuning the Buffer Cache 5 of 5ВидеоPractice 23 - Tuning the Buffer Cache 1 of 3ВидеоPractice 23 - Tuning the Buffer Cache 2 of 3ВидеоPractice 23 - Tuning the Buffer Cache 3 of 3ВидеоUsing Smart Flash Cache 1 of 3ВидеоUsing Smart Flash Cache 2 of 3ВидеоUsing Smart Flash Cache 3 of 3ВидеоPractice 24 - Using Smart Flash Cache 1 of 2ВидеоPractice 24 - Using Smart Flash Cache 2 of 2ВидеоTuning Oracle Database Buffer CacheDIALOGUETuning the Buffer Cache - AssessmentЗадание
11Tuning the PGA11 материалов

Tuning the PGA

Tuning the PGA 1 of 6ВидеоTuning the PGA 2 of 6ВидеоTuning the PGA 3 of 6ВидеоTuning the PGA 4 of 6ВидеоTuning the PGA 5 of 6ВидеоTuning the PGA 6 of 6ВидеоPractice 25 - Tuning the PGA 1 of 3ВидеоPractice 25 - Tuning the PGA 2 of 3ВидеоPractice 25 - Tuning the PGA 3 of 3ВидеоUnderstanding PGA Memory ManagementDIALOGUETuning the PGA - AssessmentЗадание
12Tuning the Redo Path10 материалов

Tuning the Redo Path

Tuning the Redo Path 1 of 4ВидеоTuning the Redo Path 2 of 4ВидеоTuning the Redo Path 3 of 4ВидеоTuning the Redo Path 4 of 4ВидеоPractice 26 - Tuning the Redo PathВидеоDatabase Redo Log File Tuning and Performance OptimizationDIALOGUEConclusion to the Course 'Advanced Oracle Monitoring and Tuning Techniques'ЧтениеTuning the Redo Path - AssessmentЗаданиеFull Course Practice AssessmentЗаданиеFull Course AssessmentЗадание