Oracle Database: Performance Management and Tuning Новый курс

направление: Oracle
вендор: ORACLE
Даты проведения курса
Array
(
)


Learn To:

  • Use the Oracle tuning methodology
  • Use Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues
  • Use database advisors to proactively correct performance problems
  • Identify problem SQL statements
  • Tune SQL performance problems
  • Monitor instance performance by using Enterprise Manager
  • Tune instance components by primarily using instance parameters

    Suggested Prerequisite

  • Oracle Database: Deploy, Patch and Upgrade Workshop
  • Familiarity with Oracle Database installation
  • Familiarity with Oracle Database configuration concepts

    Required Prerequisite

  • Oracle Database: Administration Workshop
  • Basic knowledge of Linux operating system
  • A working knowledge of SQL and PL/SQL packages
  • Basic understanding of Oracle Database architecture
  • Familiarity with basic database monitoring procedures

  • Цель курса:

  • Use the Oracle Database tuning methodology appropriate to the available tools
  • Utilize database advisors to proactively tune an Oracle Database Instance
  • Use the tools based on the Automatic Workload Repository to tune the database
  • Diagnose and tune common SQL related performance problems
  • Diagnose and tune common Instance related performance problems
  • Use Enterprise Manager performance-related pages to monitor an Oracle Database

  • Аудитория курса:

  • Administrator
  • Database Administrator