mhandoChikoro Kudzidzisa
nyoresa

Oracle Database 11g Kugadzira Kuita DBA

Oracle Database 11g: Kugadzira Kugadzira DBA Training Course & Certifications

tsananguro

Vateereri & Prerequisites

Course Outline

Purogiramu nemitengo

kutaura kuti ichokwadi

Oracle Database 11g: Performance Tuning 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.

zvinangwa

  • Shandisai Oracle Database tuning methodology yakakodzera kune zvishandiso zviripo
  • Shandisa vadzidzisi vepa database kuti vateerere Oracle Database Instance
  • Shandisa zvishandiso zvinoenderana neAppatic Workload Repository kuti uite zvinyorwa
  • Kuongorora uye kutarisa zvinowanzoitwa SQL zvine chokuita nehutano matambudziko
  • Kuongorora uye kutarisa maitiro anowanzoenderana nehutano hwematambudziko
  • Shandisa mapeji eDhizinesi Chekuita Kwemabhizimisi ekufambisa maitiro ekutarisa Dhaigiramu yeOracle

chinangwa Audience

  • Database Administrators
  • Support Engineer
  • Technical Consultant

Zvinotarisirwa

  • Oracle Database 11g: Kutungamirira Basa I
  • Oracle Database 11g: Kutungamirira Basa II

Course Outline Duration: 5 days

ziviso

  • Kutaura Mibvunzo
  • Who tunes
  • Chii chatinofanira kuita
  • Nzira yekugadzirisa sei

Kuongorora neChina Zvishandiso

  • Kuongorora zvishandiso zvakaongororwa
  • Bhizimisi Bhizimisi
  • V $ maonero, Matanho neMatriki
  • Mirira Zviitiko
  • Muenzaniso Wenguva: Musoro

Kushandisa Automatic Workload Repository

  • Automatic Workload Repository: Musoro
  • Automatic Workload Repository Data
  • Database Control uye AWR
  • Kugadzira Mhinduro dzeAWR muSQL * Plus

Kuziva Chinetso

  • Kuronga Upenyu Hwepakati Pamuviri
  • Zivai Nyaya Yokugadzirira
  • Kugadzirisa dambudziko rimwe

Kuziva Chinetso SQL Zvinyorwa

  • Mamiriro ezvakaipa SQL statement
  • Basa re Optimizer
  • Ita zvinotsanangurwa plan
  • Kufamba Nzira Maitiro
  • Tsvakai kuurayiwa

Inofadza Optimizer

  • Shandisa Optimizer Statistics
  • Calibrate I / O
  • Optimizer Cost
  • Changing Optimizer Behavior

SQL Plan Management

  • Automatic Maintenance Tasks
  • SQL Madzimai
  • SQL Access Advisor
  • SQL Outlines
  • SQL Plan Baselines

Change Management

  • Mhando dzekuchinja
  • SQL Performance Analyzer
  • DB Replay
  • Server-Yakaitwa Alerts

Kushandisa Metrics uye Alerts

  • Kubatsirwa kweMetrics
  • Database Control Usage Model
  • User-Defined SQL Metrics

Kushandisa AWR Based Based Tools

  • Automatic Maintenance Tasks
  • Kushandisa ADDM
  • Achishandisa Active Session History
  • Historical Data View

Kuongorora Kuongorora (Kushandisa Mabasa)

  • Service Overview
  • Kutarisira Basa
  • Chikamu Chebasa neTracking
  • Kuchengeta Session Yako

Baseline

  • Kushanda neMetric Baselines
  • Kugadzirisa Adaptive Alert Thresholds
  • Kugadzira Normalization Metrics

Kutarisa Dhairiro Yakagoverwa

  • Yakagoverwa Puri Pabasa
  • Mutex
  • Statspack / AWR Zviratidzo
  • Library Cache Activity
  • Zvidzidzo zvekuona
  • UGA uye Oracle Shared Server
  • Dziva Guru

Kutaura neBache Cache

  • akitekicha
  • Kutarisa Zvinangwa neMasu
  • zviratidzo
  • Solutions

Kuronga PGA uye Temporary Space

  • Kuongorora SQL Memory Memory
  • Temporary Tablespace Management

Automatic Memory Management

  • Automatic Memory Management Architecture
  • Dynamic SGA Feature
  • Kutarisira Kushandura Memory Memory

Kugadzira Kubvisa Kushandiswa Kwemhepo

  • Space Management
  • Extent Management
  • Anatomy yeDatabase Database
  • Block Space Management

Kugadzira I / O

  • I / O Architecture
  • Kutamba uye Kuratidza Mifananidzo
  • Kushandisa RAID
  • I / O Diagnostics
  • Kushandisa Automatic Storage Management

Performance Tuning: Summary

  • Zvinokosha Pakutanga Parameters ne Performance Impact
  • Database High Availability: Best Practices
  • Tablespace: Best Practices
  • Nhamba Kuunganidza

Uchishandisa Statspack

  • Nhanganyaya kuStatspack
  • Kutora Statspack Snapshots
  • Kuzivisa ne Statspack
  • Statspack kufunga
  • Statspack uye AWR

Ndapota nyorera kwatiri info@itstechschool.com & taura nesu pa + 91-9870480053 pamutengo wematengo & chikwata chemari, purogiramu & nzvimbo

Dhidzai Mhinduro

Kana uchida mamwe mashoko tibvunzane nesu zvakanaka.


Reviews