Oracle Database 11g: Segment Space, I/O, and Performance Tuning


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
Oracle Database 11g provides various methods for tuning segment space usage and input/output (I/O). This course explains how to use Automatic Segment Space Management (ASSM) to tune segment space usage, how to shrink segments using SQL or the Enterprise Manager, and how to use table compression. Automatic Storage Management (ASM) capabilities save you time by automating manual storage and thereby increasing your ability to manage larger databases (and more of them) with increased efficiency. This course discusses the implementation and tuning of ASM using a variety of Redundant Array of Independent Disks (RAID) solutions, depending on the business requirements of the organization. This course also explores the performance tuning methodology and identifies industry-recognized best practices for performance tuning.

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

Expected Duration (hours)
2.5

Lesson Objectives

Oracle Database 11g: Segment Space, I/O, and Performance Tuning

  • identify the characteristics of extents
  • identify the characteristics of blocks
  • identify the characteristics of Automatic Segment Space Management (ASSM)
  • recognize how to manage row migration and chaining
  • recognize how to shrink segments using SQL or the Enterprise Manager
  • recognize how to use table compression
  • identify the characteristics of I/O
  • recognize how to tune I/O effectively
  • identify the characteristics of RAID
  • recognize how to manage and monitor ASM
  • recognize best practices for performance tuning
  • tune I/O in a given scenario
  • view I/O statistics in a given scenario
  • Course Number:
    od_odpt_a08_it_enus