цена: 13000 руб.
Для юридических лиц: 13000 руб.

Чтобы забронировать место авторизуйтесь на сайте или пройдите регистрацию.

Oracle Database 11g: Performance Tuning



Oracle
Код: 1Z0-054
продолжительность: 135 минут
Язык обучения: English
Тестовая система: Pearson VUE
Филиал: Москва

Содержание

Exam Topics:

Basic Tuning Tools

  • Diagnose performance issues using top wait events and the time model
  • Use dynamic performance views to view statistics and wait events
  • Use Enterprise Manager Monitoring
  • Identify the key tuning components of the alert logs

Using Automatic Workload Repository

  • Create and manage AWR snapshots
  • Generate and read AWR reports, analyze Compare Periods reports

Defining Problems

  • Identify performance issues & set tuning priorities
  • Interpret tuning diagnostics
  • Tune for life cycle phase

Using Metrics and Alerts

  • Interprete metric views and alerts

Baseline

  • Create and manage AWR baselines
  • Create AWR baselines for future time periods
  • Monitor performance and enable adaptive thresholds

Using AWR-Based Tools

  • Tune automatic maintenance tasks
  • Analyze ADDM reports
  • Analyze Active Session History (ASH) reports

Monitoring an Application

  • Configure and manage services
  • Use services with client applications, Database Resource Manager and Scheduler
  • Configure services aggregation, tracing, and set performance-metric thresholds

Identifying Problem SQL Statements

  • Describe SQL statement processing
  • View the SQL statement statistics to identify the SQL statements that perform poorly
  • Describe and use methods for Viewing Execution Plans

Influencing the Optimizer

  • Describe the optimizer's behavior
  • Adjust parameters to influence the optimizer
  • Influence the optimizer (access methods, join techniques and adjust data structures)

SQL Performance Management

  • Manage optimizer statistics
  • Configure automatic SQL tuning and SQL profiling
  • Set up and use SQL plan baseline

Using SQL Performance Analyzer

  • Describe SQL Performance Analyzer process and benefits
  • Use SQL Performance Analyzer

Using Database Replay

  • Identify when and how to use Database Replay
  • Use Enterprise Manager to record and replay workloads

Tuning the Shared Pool

  • Describe Latches and Mutexes
  • Diagnose and change cursor sharing
  • Diagnose and resolve shared pool fragmentation
  • Manage the results cache and tune the large pool
  • Tune the data dictionary cache

Tuning the Buffer Cache

  • Describe the buffer cache architecture
  • Explain the symptoms that indicate a buffer cache problem
  • Tune the buffer cache for performance issues

Tuning PGA and Temporary Space

  • Diagnose PGA memory issues and size the PGA
  • Diagnose temporary space issues
  • Specify temporary tablespace parameters for efficient operation

Automatic Memory Management

  • Implement Automatic Shared Memory Management (ASMM)
  • Implement Automatic Memory Management (AMM)

Tuning Segment Space Usage

  • Tune segment space management
  • Use Automatic Segment Space Management
  • Diagnose row migration and c haining
  • Use segment shrinking and table compression

Tuning I/O

  • Diagnose database I/O issues
  • Describe the Stripe and Mirror Everything (SAME) concept
  • Set filesystemio_options and Choose appropriate I/O solutions
  • Tune Automatic Storage Management (ASM)

Appendix B Using Statspack

  • Using Statspack

Наименование
Пакет
Вендор
Цена, руб
(Физ.лица)
Цена, руб
(Юр.лица)
Array
(
    [ID] => 65
    [IBLOCK_ID] => 26
    [NAME] => Пакет
    [ACTIVE] => Y
    [SORT] => 500
    [CODE] => FORM_CATALOG
    [DEFAULT_VALUE] => 
    [PROPERTY_TYPE] => E
    [ROW_COUNT] => 1
    [COL_COUNT] => 30
    [LIST_TYPE] => L
    [MULTIPLE] => Y
    [XML_ID] => 65
    [FILE_TYPE] => 
    [MULTIPLE_CNT] => 5
    [LINK_IBLOCK_ID] => 37
    [WITH_DESCRIPTION] => N
    [SEARCHABLE] => N
    [FILTRABLE] => N
    [IS_REQUIRED] => Y
    [VERSION] => 1
    [USER_TYPE] => EList
    [USER_TYPE_SETTINGS] => Array
        (
            [size] => 1
            [width] => 0
            [group] => N
            [multiple] => Y
        )

    [HINT] => 
    [~NAME] => Пакет
    [~DEFAULT_VALUE] => 
    [VALUE_ENUM] => 
    [VALUE_XML_ID] => 
    [VALUE_SORT] => 
    [VALUE] => Array
        (
            [0] => 1262
            [1] => 1264
        )

    [PROPERTY_VALUE_ID] => Array
        (
            [0] => 20893489
            [1] => 20893490
        )

    [DESCRIPTION] => Array
        (
            [0] => 
            [1] => 
        )

    [~VALUE] => Array
        (
            [0] => 1262
            [1] => 1264
        )

    [~DESCRIPTION] => Array
        (
            [0] => 
            [1] => 
        )

    [DISPLAY_VALUE] => Array
        (
            [0] => Экспресс - очное обучение
            [1] => Экспресс+ - онлайн обучение
        )

    [LINK_ELEMENT_VALUE] => 
    [IMAGE] => Array
        (
            [0] => Array
                (
                    [src] => /upload/resize_cache/iblock/c37/25_25_1/c37be456262a8024990992582260c269.png
                    [width] => 0
                    [height] => 0
                    [size] => 
                )

            [1] => Array
                (
                    [src] => /upload/resize_cache/iblock/b05/25_25_1/b05172dba43d723c975fcd58de9fb30d.png
                    [width] => 0
                    [height] => 0
                    [size] => 
                )

        )

)
Экспресс - очное обучение Экспресс - очное обучение
Экспресс+ - онлайн обучение Экспресс+ - онлайн обучение


Оставить отзыв
Об этом экзамене отзывов пока нет. Будьте первым.