Automatic Workload Repository

Oracle 12c    |    Intermediate
  • 9 videos | 25m 42s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 7 users Rating 4.4 of 7 users (7)
The Automatic Workload Repository provides services to database components to collect, maintain, and use statistics for issue detection and self-tuning. Explore AWR in Oracle Database 12c, including administration and reporting.

WHAT YOU WILL LEARN

  • Describe the automatic workload repository
    Describe the types of statistics stored in awr and the awr architecture
    Use em cloud control to configure awr
    Use a pl/sql package to manage and modify awr snapshot settings
    Use em cloud control and sql*plus to generate an awr report
  • Describe the sections of an awr report
    Describe how to compare two periods in awr
    Describe the structure of an awr comparison report
    Use em cloud control to generate and review an awr report

IN THIS COURSE

  • Locked
    1.  Automatic Workload Repository
    2m 33s
    After completing this video, you will be able to describe the Automatic Workload Repository (AWR). FREE ACCESS
  • Locked
    2.  AWR Architecture
    1m 50s
    Upon completion of this video, you will be able to describe the types of statistics stored in AWR and the AWR architecture. FREE ACCESS
  • Locked
    3.  AWR Administration
    2m 21s
    During this video, you will learn how to configure AWR using EM cloud control. FREE ACCESS
  • Locked
    4.  Managing Snapshots with PL/SQL
    2m 15s
    Learn how to use a PL/SQL package to manage and modify settings for AWR snapshots. FREE ACCESS
  • Locked
    5.  Generating AWR Reports
    3m 1s
    In this video, learn how to use EM Cloud Control and SQL*Plus to generate an AWR report. FREE ACCESS
  • Locked
    6.  Reading an AWR Report
    3m 17s
    After completing this video, you will be able to describe the sections of an AWR report. FREE ACCESS
  • Locked
    7.  Producing Reports Comparing Periods
    2m 23s
    Upon completion of this video, you will be able to describe how to compare two periods in Oracle's Automatic Workload Repository. FREE ACCESS
  • Locked
    8.  Reading an AWR Comparison Report
    2m 13s
    After completing this video, you will be able to describe the structure of an AWR comparison report. FREE ACCESS
  • Locked
    9.  Exercise: Review an AWR Report
    5m 49s
    In this video, you will use EM cloud control to generate and review an AWR report. 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 Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Rating 4.6 of 254 users Rating 4.6 of 254 users (254)
Course Database Services
Rating 4.5 of 60 users Rating 4.5 of 60 users (60)
Channel Oracle Database 12c Administrator Certified Associate
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Book Oracle Database 12c PL/SQL Programming
Course Performance Tuning
Rating 4.5 of 32 users Rating 4.5 of 32 users (32)
Course Oracle Database 12c R2 SQL: Creating Other Schema Objects
Rating 4.4 of 48 users Rating 4.4 of 48 users (48)