Database Administration Oracle II

Goals

• Describe memory management in the Oracle database
• Regularly monitoring of an Oracle database with the SAP database monitor
• Analyzing and optimizing database performance

Audience

• System Administrator
• Database Administrator
• Technology Consultant

Prerequisites

• ADM505

• none

Course based on software release

• SAP ERP 6.05
• Oracle 11g

Content

• Oracle Cache Management
• • Introducing Oracle System Global Area
  • Introducing Automatic Oracle Program Global Area (PGA)
• Monitoring of the Database Instance
• • Using the DBA Cockpit to Monitor the Database
  • Understanding the DBA Cockpit support of Oracle database features
• Application Design Analysis
• • Understanding the Impact of Expensive SQL Statements
  • Using SM50/SM66 to Find Expensive SQL Statements
  • Using ST03/STAD to Find Expensive SQL Statements
  • Using ST04 to Find Expensive SQL Statements
  • Using SQL Trace to Find Expensive SQL Statements
  • Monitoring Exclusive Lock Waits
• Index Management and Optimization
• • Utilizing Indexes
  • Creating an Index
• Cost-Based Optimizer
• • Updating Statistics
  • Detecting problems with Optimizer statistics
• Analysis of Physical and Logical Layout
• • Defragmenting Indexes
  • Working with I/O Contention
• Memory Configuration Analysis
• • Describing Data Buffer Utilization
  • Analyzing Efficiency of Shared Pool
  • Monitoring the Automatic Program Global Area (PGA)
• Wait Interface and Automatic Workload Repository
• • Observing Oracle Wait Interface
  • Reviewing Automatic Workload Repository and Histories

Notes

• Optimizing database parameters and the hardware configuration are not covered as part of this course

Popular tags

No tags submitted for this course yet