Overview/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).
Target Audience
Data warehouse administrator; database administrators; database designers; support engineer; technical administrator
Database Maintenance and Performance Tuning in Oracle Database 12c
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
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
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
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
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
configure AWR retention parameters, generate an AWR report, review server-generated alerts, and enable Automatic Memory Management (AMM) in Oracle Database 12c