Oracle Database 11g Release 2: Managing Database Memory and Performance
Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which includes the hardware and software infrastructure needed to meet your requirements. This course explores the database's memory structures, focusing on how to configure SGA parameters and how to implement Automatic Memory Management and Automatic Shared Memory Management, and how to configure automatic PGA memory management. This course also explains how to monitor the performance of sessions and services, including how the Automatic Workload Repository (AWR) works, and how to use the SQL Tuning Advisor to identify and tune SQL statements that are using the most resources. This course also describes the benefits of Database Replay within your Oracle environment. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration II (1Z0-053) exam.
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators
Expected Duration (hours)
2.0
Lesson Objectives
Oracle Database 11g Release 2: Managing Database Memory and Performance
od_odat_a06_it_enus
Expertise Level
Intermediate