Database Maintenance

Oracle 12c    |    Intermediate
  • 11 videos | 40m 9s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Oracle Database 12c includes many features that simplify routine database maintenance and performance tuning. Learn how to configure and use the automated database monitoring and maintenance features available in Oracle Database 12c.

WHAT YOU WILL LEARN

  • Describe database maintenance tasks and view alert history in oracle database 12c
    Describe the automatic workload repository (awr) and its infrastructure in oracle database 12c
    Create an automatic workload repository (awr) baseline in oracle database 12c
    Manage automatic workload repository (awr) settings in oracle database 12c
    Set the statistics_level parameter for a database in oracle database 12c
    Use the automatic database diagnostic monitor in enterprise manager in oracle database 12c
  • Describe the advisory framework in oracle database 12c
    Access the advisor central page in enterprise manager and identify the packages used to invoke advisors in oracle database 12c
    Describe and view the automated database maintenance tasks in oracle database 12c
    Describe server-generated alerts and set metric thresholds for them in oracle database 12c
    Recognize different alert types and clear alerts in oracle database 12c

IN THIS COURSE

  • Locked
    1.  Introduction to Database Maintenance
    5m 11s
    After completing this video, you will be able to describe database maintenance tasks and view alert history in Oracle Database 12c. FREE ACCESS
  • Locked
    2.  The Automatic Workload Repository
    5m 20s
    Upon completion of this video, you will be able to describe the Automatic Workload Repository (AWR) and its infrastructure in Oracle Database 12c. FREE ACCESS
  • Locked
    3.  Creating an AWR Baseline
    2m 38s
    In this video, you will learn how to create an Automatic Workload Repository (AWR) baseline in Oracle Database 12c. FREE ACCESS
  • Locked
    4.  Managing AWR
    3m 11s
    In this video, you will manage Automatic Workload Repository (AWR) settings in Oracle Database 12c. FREE ACCESS
  • Locked
    5.  Setting a Statistics Level
    2m 16s
    Learn how to set the STATISTICS_LEVEL parameter for a database in Oracle Database 12c. FREE ACCESS
  • Locked
    6.  Using the ADDM
    3m 13s
    Learn how to use the Automatic Database Diagnostic Monitor in Oracle Database 12c Enterprise Manager. FREE ACCESS
  • Locked
    7.  The Advisory Framework
    5m 33s
    Upon completion of this video, you will be able to describe the Advisory Framework in Oracle Database 12c. FREE ACCESS
  • Locked
    8.  Accessing Advisors
    2m 53s
    Learn how to access the Advisor Central page in Enterprise Manager and identify the packages used to invoke advisors in Oracle Database 12c. FREE ACCESS
  • Locked
    9.  Automated Maintenance Tasks
    3m 39s
    Upon completion of this video, you will be able to describe and view the automated database maintenance tasks in Oracle Database 12c. FREE ACCESS
  • Locked
    10.  Configuring Server-Generated Alerts
    4m
    After completing this video, you will be able to describe server-generated alerts and set metric thresholds for them in Oracle Database 12c. FREE ACCESS
  • Locked
    11.  Recognizing and Clearing Alerts
    2m 16s
    After completing this video, you will be able to recognize different alert types and clear alerts in Oracle Database 12c. 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

Channel Database Core Concepts
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group Functions
Rating 4.3 of 24 users Rating 4.3 of 24 users (24)
Course Performance Tuning
Rating 4.5 of 32 users Rating 4.5 of 32 users (32)
Course SQL & Concurrency Concepts
Rating 4.6 of 245 users Rating 4.6 of 245 users (245)