Overview/Description
Oracle Database 11g provides various methods for tuning, monitoring and managing memory and temporary tablespaces. Automatic Program Global Area (PGA) memory management adapts the SQL memory allocation based on PGA memory available, SQL operator needs, and system workload. A temporary tablespace is used to store transient data generated explicitly by the user and implicitly by the system. This course explains how to diagnose PGA memory and temporary tablespace issues and demonstrates how to size the PGA memory and manage temporary tablespaces. In addition, in Oracle 11g, Automatic Shared Memory Management (ASMM) uses dynamic System Global Area (SGA) and memory advisors to automatically adapt to workload changes. Automatic Memory Management (AMM) automates the sizing of PGA and SGA according to your workload. This course demonstrates the methods for enabling and configuring ASMM and AMM using Enterprise Manager, memory advisors, SQL, and V-dollar views for monitoring memory management.
Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.
Prerequisites
Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Administration Workshop II