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