Database Maintenance and Performance Tuning in Oracle Database 12c

Data warehouse administrator; database administrators; database designers; support engineer; technical administrator

Prerequisite
None

Expected Duration
118 minutes

Description
Oracle Database 12c includes many features that simplify routine database maintenance and performance tuning. In this course, you’ll learn how to configure and use the automated database monitoring and maintenance features available in Oracle Database 12c. You’ll also learn how to monitor and tune both database and memory performance in Oracle Database 12c. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).

Objective

Gathering Statistics

  • start the course
  • 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
  • describe the STATISTICS_LEVEL parameter for a database in Oracle Database 12c

Using Automatic Monitoring and Advice

  • use the Automatic Database Diagnostic Monitor in Enterprise Manager in Oracle Database 12c
  • describe the Advisory Framework in Oracle Database 12c
  • identify the packages used to invoke advisors in Oracle Database 12c

Automated Tasks and Alerts

  • 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

Managing Performance

  • plan, monitor, and tune performance in Oracle Database 12c
  • tune the performance of a database instance in Oracle Database 12c
  • use EM Database Express and EM Cloud Control to monitor database performance in Oracle Database 12c
  • monitor session performance in Oracle Database 12c
  • monitor top services in Oracle Database 12c
  • describe and view wait events in Oracle Database 12c
  • use the data dictionary views to diagnose and tune performance problems in Oracle Database 12c

Memory Management

  • identify guidelines for memory management in Oracle Database 12c
  • describe Automatic Memory Management (AMM) and related memory parameters in Oracle Database 12c
  • enable and monitor Automatic Memory Management (AMM) in Oracle Database 12c
  • describe Automatic Shared Memory Management (ASMM) in Oracle Database 12c
  • describe and enable Automatic Shared Memory Management (ASMM) in Oracle Database 12c
  • describe values for autotuned SGA parameters in Oracle Database 12c
  • describe the program global area (PGA) in the Oracle Database 12c

Practice: Database Maintenance

  • configure AWR retention parameters, generate an AWR report, review server-generated alerts, and enable Automatic Memory Management (AMM) in Oracle Database 12c

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.