TestPrep 1Z0-033 Oracle9i Database: Performance Tuning

Overview/Description
Generally taken near the end of a program of certification-orientated study, the 1Z0-033 Oracle9i Database: Performance Tuning TestPrep enables the learner to test their knowledge in a simulated certification testing environment. Learners can take TestPrep in two different modes: Study and Certification. Study mode is designed to maximize learning by providing feedback, while Certification mode is designed to mimic a certification exam.

Target Audience
Individuals seeking practice in a simulated testing environment, covering the skills and competencies being measured by the actual certification exam.

Prerequisites
The associated SkillSoft certification content should be completed before attempting the TestPrep. This will maximize the effectiveness of the simulated preparation exam.

Expected Duration
N/A

Objectives:

TestPrep 1Z0-033 Oracle9i Database: Performance Tuning

  • Oracle Performance Tuning Methodology
  • Diagnostic and Tuning Tools
  • Sizing the Shared Pool
  • Sizing the Buffer Cache
  • Sizing other SGA Structures
  • Database Configuration and I/O Issues
  • Optimize Sort Operations
  • Diagnosing Contention For Latches
  • Tuning Rollback (or UNDO) Segments
  • Monitoring and Detecting Lock Contention
  • Tuning Oracle Shared Server
  • Application Tuning
  • Using Oracle Blocks Efficiently
  • SQL Statement Tuning
  • O/S Considerations


    • Course Number: TP1Z0033_eng