Maintaining SQL Performance

Oracle 12c    |    Intermediate
  • 8 videos | 25m 4s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 7 users Rating 4.7 of 7 users (7)
Database Replay can help with performance tuning by allowing you to capture a workload and replay it on a test system to see the effect of changes outside of the production database. Learn about Database Replay in Oracle Database 12c.

WHAT YOU WILL LEARN

  • Define the concept of database replay
    Describe the architecture of the components that make up database replay
    Describe the workflow implementation of database replay within enterprise manager
    Describe how the initial workload is captured
  • Describe how to properly cater for the database replay tasks
    Describe the process of replaying a workload
    Compare the results of a workload replay report
    List the packages and views applicable to using and configuring database replay

IN THIS COURSE

  • Locked
    1.  Database Replay
    2m 29s
    This video will teach you how to define the concept of database replay. FREE ACCESS
  • Locked
    2.  Database Replay Architecture
    3m 39s
    After completing this video, you will be able to describe the architecture of the components that make up database replay. FREE ACCESS
  • Locked
    3.  Database Replay Integration
    3m 18s
    Upon completion of this video, you will be able to describe the workflow implementation of database replay within Oracle Enterprise Manager. FREE ACCESS
  • Locked
    4.  Capturing Workload
    2m 22s
    After completing this video, you will be able to describe how the initial workload is captured. FREE ACCESS
  • Locked
    5.  Replay Tasks and Considerations
    4m 44s
    After completing this video, you will be able to describe how to properly cater to the database replay tasks. FREE ACCESS
  • Locked
    6.  Running a Replay
    3m 6s
    After completing this video, you will be able to describe the process of replaying a workload. FREE ACCESS
  • Locked
    7.  Replay Analysis
    2m 54s
    In this video, you will compare the results of a workload replay report. FREE ACCESS
  • Locked
    8.  Replay Packages and Views
    2m 32s
    Upon completion of this video, you will be able to list the packages and views for using and configuring database replay. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Query Optimization
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Book Database Performance at Scale: A Practical Guide
Book Pro Oracle SQL Development: Best Practices for Writing Advanced Queries, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Measuring SQL Performance
Rating 4.5 of 10 users Rating 4.5 of 10 users (10)
Course Grid Infrastructure
Rating 4.4 of 34 users Rating 4.4 of 34 users (34)
Course Implementing Performance Tuning
Rating 4.3 of 6 users Rating 4.3 of 6 users (6)