TestPrep 1Z0-024 Oracle8i: Performance Tuning

Overview/Description
Generally taken near the end of a program of certification-orientated study, the 1Z0-024 Oracle8i: 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-024 Oracle8i: Performance Tuning

  • Tuning overview
  • Oracle Alert and Trace Files
  • Utilities and dynamic performance views
  • Tuning the shared pool
  • Tuning the buffer cache
  • Tuning the redo log buffer
  • Database configuration and I/O issues
  • Using Oracle blocks efficiently
  • Optimizing sort operations
  • Tuning rollback segments
  • Monitoring and detecting lock contention
  • SQL issues and tuning considerations for different applications
  • Managing a mixed workload
  • Tuning with Oracle Expert
  • Multithreaded server tuning issues


    • Course Number: TP1Z0024_eng