Oracle9i Database Performance Tuning 1Z0-033 Series: SQL Statement Tuning
Product Code: l_3311 Time: 1.0 hour(s) CEUs:

Summary:
This course discusses various tools that Oracle Database Administrators can use to tune SQL statements.

Objectives:

  • Describe how the Optimizer is used
  • Plan stability
  • Describe stored outlines
  • Use SQL trace and TKPROF
  • Collect statistics
  • Describe histograms
  • Copy statistics between databases


Topics:

    Technical Requirements:
    P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.

    Copyright Information:

    Trademark Information:

    Terms of Use:

    Copyright © 2009 MindLeaders. All rights reserved.