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

Book Practical Oracle SQL: Mastering the Full Power of Oracle Database
Book Oracle 19c AutoUpgrade Best Practices
Course Introduction to SQL Bootcamp: Session 4 Replay
Rating 4.5 of 151 users Rating 4.5 of 151 users (151)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Automatic Storage Management
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Course Database Performance Settings
Rating 4.3 of 19 users Rating 4.3 of 19 users (19)
Course Relational Database Concepts
Rating 4.4 of 645 users Rating 4.4 of 645 users (645)