homKev Kawm hauv Chav Kawm
Sau npe

Oracle Database 11g Qhov Kev Kawm DBA

Oracle Database 11g: Kev Kawm Kev Kawm DBA Cov Kev Cob Qhia Ua Ntej & Ntawv Pov Thawj

Txheej txheem cej luam

Suab Seev & Seem Ua Ntej

Cov Qauv Dua

Teem & Cov Nqi

Certification

Oracle Database 11g: Kev Kawm DBA

No Oracle Database 11g Performance Tuning kev kawm pib nrog ib tug tsis paub database uas yuav tsum tau nyob. Koj mam li kawm cov kauj ruam uas DBA ua tau los txheeb xyuas cov teeb meem, nrhiav cov teeb meem tshwm sim thiab kho lawv.

Objectives

  • Siv lub Oracle Database tuning methodology tsim nyog rau cov cuab yeej muaj
  • Siv cov neeg tawm tswv yim los pab txhawb txoj kev tawm tsam Oracle Database Instance
  • Siv cov cuab yeej raws li Kev Ua Haujlwm Ntiag Tug Ua Haujlwm kom qhib lub database
  • Qhia thiab qhib ntau hom SQL txog kev ua haujlwm
  • Tshawb nrhiav thiab mloog ntau Instance ntsig txog cov teeb meem kev kawm
  • Siv Enterprise Manager ntawm kev ua haujlwm txog cov nplooj ntawv los soj ntsuam ib qho Oracle Database

npaj cov neeg tuaj saib

  • Database Thawj Coj
  • Txhawb Kws Tshawb Fawb
  • Tus kws pab tswv yim

yuavtsum tau kawm uantej

  • Oracle Database 11g: Kev Rhiav Kev Kawm Ntawv I
  • Oracle Database 11g: Cov Kev Kawm Raug Cai II

Course Outline Duration: 5 days

Introduction

  • Cov Lus Nug
  • Leej twg tunes
  • Yuav ua li cas yuav qhib
  • Yuav pib li cas

Kev Saib Xyuas Nrog Cov Cuab Yeej Siv

  • Saib xyuas cov cuab yeej tus txheej txheem
  • Enterprise Manager
  • V $ views, Txheeb xyuas thiab Metrics
  • Tos Txheej Txheem
  • Lub sij hawm qauv: Txheej txheem cej luam

Siv Automatic Workload Repository

  • Automatic Workload Repository: Txheej txheem cej luam
  • Cov Ntaub Ntawv Xov Xwm Tsis Siv Neeg Cov Ntaub Ntawv
  • Database Control thiab AWR
  • Generating AWR Reports hauv SQL * Plus

Nrhiav Teeb Meem

  • Taw lub voj voog ntawm lub neej
  • Txheeb xyuas Ib Qhov Teeb Tseg
  • Khwv ib qho teeb meem

Nrhiav Teeb Meem SQL Cov Lus

  • Cov yam ntxwv ntawm cov lus phem SQL
  • Lub luag haujlwm ntawm Optimizer
  • Tsim piav qhia txoj hau kev
  • Kev Nkag Mus Siv
  • Tig txoj kev tua

Txuam rau Tus Txhim Kho

  • Tswj Cov Kev Ntsuam Xyuas Tus Txheej Txheem
  • Calibrate I / O
  • Optimizer Nqi
  • Hloov Kho Tus Cwj Pwm Zoo

SQL Plan Management

  • Tsis siv neeg txij nkawm
  • SQL Profiles
  • SQL Advisor Saib
  • SQL nta
  • SQL Plan Baselines

Kev Tswj Cov Kev Hloov

  • Hom kev hloov
  • SQL Performance Analyzer
  • DB Replay
  • Lub Cim Ua Ntej Ceeb Toom

Siv Cov Metrics thiab Alerts

  • Cov txiaj ntsim ntawm kev ntsuas
  • Database Tswj Tus Qauv Siv
  • Tus neeg siv txhais cov Metrics

Siv AWR Based Tools

  • Tsis siv neeg txij nkawm
  • Siv ADDM
  • Siv Los Siv Zej Zog Keeb Kwm
  • Cov Ntaub Ntawv Qhia Txog Cov Keeb Kwm

Kev Saib Xyuas Daim Ntawv Thov (Siv Cov Kev Pabcuam)

  • Kev Pabcuam Kev Saib Xyuas
  • Tswj Cov Kev Pabcuam
  • Kev pab Aggregation thiab Tracing
  • Nrhiav Koj Qhov Kev Ntsuas

Baselines

  • Ua haujlwm nrog Metric Baselines
  • Teem Kev Cob Qhia Kev Cog Lus
  • Configuring Normalization Metrics

Tiav lub pas dej sib koom

  • Sib Koom Siv Kev Ua Phem
  • Mutex
  • Statspack / AWR Indicators
  • Kev Ceeb Toom Cache Lub Neej
  • diagnostic cuab yeej
  • UGA thiab Oracle sib koom txoos
  • Loj Pas

Tuning cov Cache ntas

  • Architecture
  • Cov Hom Phiaj thiab Cov Tswvyim
  • Cov tsos mob
  • Solutions

Tawm PGA thiab Chaw Mus Mus Ib Txhis

  • Saib SQL Nco Kev Pab
  • Temporary Management Management

Tsis siv neeg nco tswj

  • Tsis siv neeg nco tswj Architecture
  • Dynamic SGA Feature
  • Tswj tswj kev tswj hwm tsis zoo

Siv Qhov Chaw Pov Thaiv

  • Kev Tswj Chaw Lij Choj
  • Extent Management
  • Lub zauv ntawm qhov Database Block
  • Thaiv Chaw Tswj

Taw Kuv / O

  • I / O Architecture
  • Striping thiab Mirroring
  • Siv RAID
  • I / O Diagnostics
  • Siv Kev Tswj Tuaj Tswj Kev Siv Tshuaj

Performance Tuning: Summary

  • Tseem ceeb Initialization Parameters nrog Performance Impact
  • Database Highability: Cov Kev Xyaum Zoo Tshaj Plaws
  • Daim Phiaj: Qhov Zoo Tshaj Plaws
  • Sib Sau Ua Pej Xeem

Siv Statspack

  • Qhia rau Statspack
  • Txhawb nqa Statspack Snapshots
  • Tshaj tawm nrog Statspack
  • Statspack xav txog kev xav
  • Statspack thiab AWR

Thov sau ntawv rau peb ntawm info@itstechschool.com & hu rau peb ntawm + 91-9870480053 rau cov nqi kawm & daim ntawv teev nqi, sij hawm & qhov chaw

Tawm Peb ib qho lus nug

Rau ntau info kindly hu rau peb.


Xyuas