Oracle9i: Database Performance Tuning


Description:

The Oracle9i Database: Performance Tuning course provides you with the concepts needed to properly tune the Oracle9i® Database for optimal performance. You will examine the tools used to monitor, analyze, measure, and tune a database. This course also helps you to prepare for the Oracle9i Database: Performance Tuning (1Z0-033) exam.

This course carries the following professional education credits: 1.8 CEUs. For more information on accreditation bodies, please visit www.elementk.com/products/certification-and-accreditation.

Objectives:

  • In this course, you will examine the tools and methodologies that can be used to tune the database, monitor and tune the database buffer cache, library cache, dictionary cache, large pool, and other memory structures. You will also examine how to manage Java memory, tune Oracle processes, examine the physical structure of a database, tune disk I/O, identify and correct issues with locks and latches, and tune applications by using the correct table and index types. You will examine how to analyze and improve the performance of SQL statements, measure sort performance and manage sort-related parameters. You will also examine how to use Oracle Resource Manager to allocate operating system resources and tune the shared server.

Hardware and Software Required:

  • Browser Microsoft Internet Explorer 7 (or higher)
  • Browser Mozilla Firefox 2 (or higher)
  • Browser Apple Safari 2 (or higher)
  • Operating System Microsoft Windows 2000, XP, Vista, or Windows 7
  • Operating System Apple Mac OS X 10.4 (or higher)
  • Processor Pentium III 1 GHz (or better)
  • Processor Macintosh Intel-based or PowerPC G4 (or better)
  • RAM 512 MB (1 GB or more recommended)
  • Internet connection 256K (broadband recommended)
  • Adobe Flash Player 8 (current version recommended)
  • Adobe Reader 7 (or higher)
  • Other requirements may apply to supplemental offline activities. Omitting these optional activities does not affect course completion.



User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-ORCL9I-DPT
  • Duration: 17 hours 48 minutes
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend