typeAikin Kwalejin
rajistar

Ma'aikatar Magana ta 11G ta Nuna DBA

Cibiyar Ma'anar Bayanai ta 11g: Ayyukan Tunatarwa ta DBA Training Course & Takaddun shaida

Overview

Masu sauraro & kaddara

Jagoran Bayanan

Jadawalin & Kudin

Certification

Ma'aikatar Bayanin Labaran 11g: Ayyukan Tunatar da DBA

Wannan Cibiyar Ma'adinan Ma'adinan 11g Ayyukan Tuning horo yana farawa tare da bayanan da ba'a sani ba wanda ke buƙatar kunna. Za ku koyi matakai da DBA ke yi don gano wuraren matsala, bincika matsalolin matsaloli da kuma gyara su.

manufofi

  • Yi amfani da Database Database wanda ya dace da hanyoyin da ya dace da kayayyakin aiki
  • Yi amfani da masu ba da shawara kan labaran bayanai don yin nazarin wani bayani na Database Oracle
  • Yi amfani da kayan aikin da aka dogara da Asusun Ayyuka na atomatik don tayi bayanai
  • Binciken da kuma sauke nau'ikan maganganun da ke cikin al'ada na SQL
  • Binciken da kuma tuntuɓi abubuwan da ke faruwa a cikin al'amuran da suka dace
  • Yi amfani da shafukan da ke da alaka da Ayyukan Kasuwanci don saka idanu kan Database Oracle

nufin masu saurare

  • Masu Gudanar da Bayanan Bayanan
  • Support Engineer
  • Mai ba da shawara na fasaha

abubuwan da ake bukata

  • Database 11 Maganag: Cibiyar Nazarin I
  • Database 11 Maganag: Cibiyar Nazarin II

Course Outline Duration: 5 days

Gabatarwa

  • Tambayoyi
  • Wane ne ya yi raira
  • Abin da za a kunna
  • Yadda za a kunna

Kulawa tare da Ƙananan kayan

  • Siffofin kayan aiki na saka idanu
  • Manajan Kasuwanci
  • V $ views, Statistics da Metrics
  • Jira jirage
  • Lokaci na lokaci: Hoto

Amfani da Mahimman Bayanan Ayyuka na Ayyuka

  • Saiti na aikin sarrafawa na atomatik: Bayani
  • Bayanan Rubuce-rubucen Aiki na atomatik
  • Sarrafa bayanai da kuma AWR
  • Samar da Rahoton AWR a cikin SQL * Plus

Gano Matsala

  • Tuning Life Cycle Farko
  • Gano Tambayar Tunatarwa
  • Amsa matsalar daya

Gano bayanin maganganu na matsala na SQL

  • Halaye na bayanin sanarwa mara kyau
  • Matsayin Mai Sanya
  • Samar da bayanin shirin
  • Samun hanyoyin Zaɓuɓɓuka
  • Sakamakon kisa

Yarda da Mai Sanya

  • Sarrafa Ƙididdiga Masu Gyara
  • Calibrate I / O
  • Ƙariyar Zazzage
  • Zabin Bunƙasa Mai Sanya

Gudanar da Shirin Shirin SQL

  • Ɗawainiyar Ayyukan atomatik
  • Bayanan martaba na SQL
  • Mai ba da shawara na SQL Access
  • Bayanan SQL
  • Shirye-shiryen Shirin Shirin SQL

Canja Canja

  • Irin canje-canje
  • Binciken Bincike na SQL
  • DB Replay
  • Masu faɗakarwa na Ayyuka

Amfani da matakan ƙira da faɗakarwa

  • Amfanin matakan
  • Magani mai amfani da bayanan bayanai
  • Damafin Bayanan na SQL

Yin amfani da kayan aikin AWR

  • Ɗawainiyar Ayyukan atomatik
  • Amfani da ADDM
  • Yin amfani da Tarihin Zama na Tarihi
  • Tarihin Tarihi na Tarihi

Kulawa da Aikace-aikacen (Amfani da Ayyuka)

  • Service Overview
  • Sarrafa Sabis
  • Ƙungiyar Sabis da Tafiya
  • Tsarin Zama naka

Baselines

  • Yin aiki tare da Bayanan Metric
  • Tsarin Allon Alamar Tsayawa
  • Haɓaka daidaitattun ƙaddamarwa

Gyara Ƙungiyar Shared

  • Haɗin Maɓallin Shared
  • Mutex
  • Statspack / AWR Indicators
  • Ayyukan Cache Library
  • Kayan kayan bincike
  • UGA da Oracle Shared Server
  • Babban Pool

Tunatar da Buffer Cache

  • Architecture
  • Tunani Goals da Dabaru
  • Alamun
  • Solutions

Gyara PGA da Space Space

  • Kulawa da yin amfani da ƙwaƙwalwar ajiyar SQL
  • Gudanar da Tsare-tsaren Gidan Gida

Gudanarwar Kulawa ta atomatik

  • Gudanarwar Memory Management Architecture
  • Dynamic SGA Feature
  • Gudanar da Gudanarwar Ƙwaƙwalwa na Aiki

Tuning Block Space Space

  • Space Management
  • Gudanar da Rage
  • Anatomy na Database Block
  • Block Gidan Gida

Tuning I / O

  • I / O Hikimar
  • Gyara da Mirroring
  • Amfani da RAID
  • I / O Diagnostics
  • Amfani da Gudanarwar Tattalin Yanki

Performance Tuning: Summary

  • Muhimman Bayanin Sake Gida tare da Tasirin Ayyuka
  • Database High Availability: Best Ayyuka
  • Tablespace: Ayyuka mafi kyau
  • Ƙididdigar Ƙididdiga

Yin amfani da Statspack

  • Gabatarwar zuwa Statspack
  • Kula da Statspack Snapshots
  • Rahoto tare da Statspack
  • Statspack sharudda
  • Statspack da AWR

Da fatan a rubuta mana a info@itstechschool.com & tuntube mu a + 91-9870480053 don farashin farashi & takardun shaida, tsarawa da wuri

Drop Us a Query

Don ƙarin bayani kyauta tuntube mu.


reviews