ituaigaAoaoga a le potuaoga
Tusi Resitala

Aʻoaʻoga Faʻaauau

faaipoipo 21
Oracle Database 11g Performance Tuning DBA

Oracle Database 11g: Faʻatulagaina o Faʻamaumauga Faʻataʻitaʻiga a le DBA Course & Certifications

lagona

Tagata o loʻo faʻalogo ma faʻamuamua

Taʻiala o le Vasega

Faamatalaga & Totogifuapauina

faʻamaoniga

Oracle Database 11g: Faʻatulagaina o Faʻamaumauga DBA

This Oracle Database 11g Performance Tuning training starts with an unknown database that requires tuning. YouXCHARXll then learn the steps a DBA performs to identify problem areas, diagnose common problems and fix them.

sini

  • Faaaoga le Database Oracle e faʻaogaina ai auala e fetaui ma meafaigaluega e maua
  • Faʻaaogā faufautua o faʻamaumauga e faʻatautaia le faʻaogaina o le Oracle Database Database
  • Faʻaoga meafaigaluega e faʻavae i le Automatic Workload Repository e faʻalogo ai i le faʻamaumauga
  • Faʻamatalaga ma faʻafeiloaʻi faʻafitauli masani o loʻo aʻafia ai SQL
  • Faʻamatalaga ma faʻafeiloaʻi masani faʻafitauli o faʻalavelave faʻapitoa
  • Faʻaaoga itulau e faʻatatau i galuega faʻatonutonu a le Enterprise Manager e mataʻitu ai le Oracle Database

Faapotopotoga faamoemoe

  • Pule o le Faletupe
  • Lagolago Engineer
  • Faufautua Faapitoa

Prerequisites

  • Oracle Database 11g: Atinae Faʻaleaoga I
  • Oracle Database 11g: Atinaʻeina Pulega II

Course Outline Duration: 5 days

faʻatomuaga

  • Faʻatau Fesili
  • O ai e faʻalogo
  • Le mea e faʻalogo
  • Auala e faʻalogo

Mataituina I Mea Faʻatino

  • Mataʻitu mea e mataʻituina ai meafaigaluega
  • Pule Faʻatonu
  • V $ manatu, Fuainumera Faamauina ma Metotia
  • Faatali mea e tutupu
  • Faataʻitaʻiga Taimi: Vaaiga Aoao

Faʻaaogāina o le Faʻamaumauga Faʻamatalaga o Galuega

  • Faʻamaumauga o galuega faʻapitoa: Vaaiga Aoao
  • Faʻatonuina o Faʻamatalaga Faʻamaumauga
  • Puleaina o Nofoaga ma AWR
  • Fausia AWR Lipoti i le SQL * Plus

Faailoaina o le Faafitauli

  • Tuning Life Cycle Faʻasalaga
  • Faailoa se Suiga o le Suiga
  • Fofo se tasi faafitauli

Faailoaina o le Faafitauli Faamatalaga Tautino

  • Uiga o se faamatalaga leaga SQL
  • Matafaioi a le Optimizer
  • Faʻatele faʻamatala le fuafuaga
  • Faʻamatalaga Filifili Avanoa
  • Suʻe le faʻatinoga

Uunaia le Optimizer

  • Puleaina Fuainumera Faamau Fua
  • Faʻatonu I / O
  • Taugofie le Tau
  • Suʻeina o amioga e sili ona lelei

Fuafuaga o Fuafuaga a le SQL

  • Tausiga Tausiga Aunoa
  • Faʻamaumauga o SQL
  • Faufautua Faufautua SQL
  • Laasaga o SQL
  • Lisi Fuafuaga o le SQL

Suiga Pulega

  • Ituaiga o suiga
  • SQL Performance Analyzer
  • DB Replay
  • Faʻasalalau Faʻatonuina o le Tūmau

Faʻaaoga Metrics ma Alert

  • Faamanuiaga o Metrics
  • Faʻaaogaina o le faʻaaogaina o le database
  • Faʻamaumauga Faʻamaumauga a le Faʻamaumauga a le Tagata

Faʻaaogāina o AWR Tusiga Faʻatulagaina

  • Tausiga Tausiga Aunoa
  • Faaaogaina o le ADDM
  • Faʻaaogaina o Tala Faʻasolopito Faʻalāpotopotoga
  • Faʻamatalaga Faʻamatalaga Faasolopito

Mataituina o se Talosaga (Faʻaaogaina o Auaunaga)

  • Auaunaga Vaaiga
  • Puleaina o le Auaunaga
  • Faʻasalalauina ma Faʻasalalau Auaunaga
  • Faʻataʻitaʻiina o Lau Fonotaga

Faʻavae

  • Galulue ma Metric Baselines
  • Faʻatulagaina o Faʻasalalauga Faʻamaonia Talafeagai
  • Faʻasaʻoina o Metricist Normric

Faʻatulagaina o le Vaitafe Faʻatasi

  • Faʻaaogaina o Vaʻalele
  • Mutex
  • Faailoga Statspack / AWR
  • Faletusi o le Potutusi
  • Meafaigaluega Faʻamatalaga
  • UGA ma Oracle Shared Server
  • Vaituloto Tele

Faʻamanatuina le Buffer Cache

  • atiga
  • Faʻatulagaga o Manulauti ma Faʻamaumauga
  • O auga
  • fofo o Faafitauli

Faʻaopoopoina le PGA ma le Nofoaga lē tumau

  • Mataituina le Faaaogaina o le Faaaogaina o SQL
  • Faʻafoega le tumau o le laulau vaʻaia

Faʻamaumauga Faʻamaumau aunoa

  • Faʻamaumauga Faʻamatalaga Faʻamaumauga Faʻamatalaga Faʻamaumauga
  • Synamic SGA Feature
  • Puleaina o le Faʻamatalaga Faʻamatalaga Faʻamatalaga

Tuning Block Faʻasao Uiga

  • Pulega Space
  • Pulega Tele
  • Anatomy o se Database Block
  • Faʻasologa o le Pulega o Nofoaga

Faʻataʻitaʻu I / O

  • Faʻafanua I / O
  • Faʻasalalau ma le Faʻataʻi
  • Faʻaaoga RAID
  • I / O Diagnostics
  • Faʻaaogaina le Faʻamaumauga o le Teuina o Mea Tonu

Performance Tuning: Summary

  • Tuatusi Faʻamuamua Taua i le Aafiaga o Galuega
  • Maualuga Maualuga Maualuga: Faʻataʻitaʻiga Lelei
  • Tablespace: Faʻataʻitaʻiga Lelei
  • Fuainumera Faamaumauga

Faaaogaina o Statspack

  • Folasaga i Statspack
  • Faʻasologa o Snapshots Statspack
  • Lipoti ma Statspack
  • Statspack iloiloga
  • Statspack ma AWR

Faamolemole tusi mai ia i matou i info@itstechschool.com & faʻafesoʻotaʻi i matou i le 91-9870480053 mo le tau aʻoaʻoga & tusi faamaonia o tau, faʻasologa ma le nofoaga

Tuʻu mai ia i matou se Fesili

Mo nisi faʻamatalaga faʻafesoʻotaʻi lelei i matou.


iloiloga