ụdịỌzụzụ klas
Deba aha

Ọrụ Ntanye 11G arụmọrụ DBA

Oracle Database 11g: Ịrụ ọrụ ntanyere DBA Training Course & Certifications

Overview

Ndị na-ege ntị na ihe ndị dị mkpa

Ihe ndepụta

Nhazi & Ụgwọ

Asambodo

Data nchịkọta data 11g: Ịrụ ọrụ ntinye DBA

Usoro ntanetị a nke 11g arụ ọrụ na-amalite site na nchekwa data na-achọ ntanye. Mgbe ahụ, ị ​​ga-ahụ ihe ndị DBA na-eme iji chọpụta ebe nsogbu, chọpụta nsogbu dị iche iche na idozi ha.

ebumnobi

  • Jiri usoro ntanetị nke Oracle na-echegharị usoro kwesịrị ekwesị maka ngwaọrụ ndị dịnụ
  • Jiri ndi nduzi ntaneti data iji gbasaa usoro Oracle database
  • Jiri ngwá ọrụ dabere na Nchekwa Ọrụ Na-arụ ọrụ na akpaaka nchekwa data
  • Nyochaa ma nụ nsogbu SQL arụmọrụ na-arụkarị
  • Nyochaa ma gụọ nsogbu gbasara arụmọrụ na-emekarị
  • Jiri akwukwo ndi oru ozo nke oru oru ahia iji nyochaa Oracle database

bu n'obi ege Ntị

  • Ndị nchịkọta data
  • nkwado Engineer
  • Nkà na ụzụ

Prerequisites

  • 11 Oracle Oracleg: Ụlọ Ọrụ Nchịkwa M
  • 11 Oracle Oracleg: Ụlọ Ọrụ Nchịkwa II

Course Outline Duration: 5 days

Okwu Mmalite

  • Ajuju Ajuju
  • Ònye na-eti mkpu
  • Ihe ị ga-akụ
  • Otu esi egwu

Nlekota na ngwa ngwa

  • Nyochaa ngwaọrụ nyocha
  • Onye njikwa oru
  • V $ nghọta, Ndepụta ihe na Metrics
  • Ihe Nlere Anya
  • Ụdị oge: Isi

Iji Nchekwa Ọrụ Ọrụ Akpaka

  • Akụrụngwa arụ ọrụ akpaaka: Isi
  • Data nchekwa data na arụ ọrụ akpaaka
  • Njikwa nchekwa na AWR
  • Na-emepụta AWR Akụkọ na SQL * Plus

Ịmata Nsogbu ahụ

  • Ịgbanye Ndụ Ndụ Ụzọ
  • Chọpụta Usoro ntinye
  • Ngwọta otu nsogbu

Ịchọta Okwu Nkwupụta SQL

  • Àgwà nke nkwupụta ọjọọ SQL
  • Ọrụ nke Optimizer
  • Na-akọwa usoro atụmatụ
  • Ụzọ Nhọrọ Ụzọ
  • Chọpụta mmegbu ahụ

Na-emetụta ihe kachasị mma

  • Jikwaa Ndepụta Ngwaọrụ Optimizer
  • Calibrate I / O
  • Nkwụsịtụ Ụgwọ
  • Igbanwe Agbanwe Omume

SQL Atụmatụ Management

  • Ọrụ Nchọgharị Na-akpaghị aka
  • Profaili SQL
  • Onye Nduzi Nduzi SQL
  • Ihe ngosi SQL
  • Usoro Ntọala SQL

Gbanwee Management

  • Ụdị mgbanwe
  • Nyocha nhazi SQL
  • DB Replay
  • Alerts na-arụ ọrụ

N'iji Ngwaọrụ na Alert

  • Uru nke usoro
  • Ntuziaka eji eji nchịkwa data
  • Nkọwapụta SQL nke onye ọrụ

Iji Ngwa AWR

  • Ọrụ Nchọgharị Na-akpaghị aka
  • Iji ADDM
  • Iji oge akụkọ ihe mere eme
  • Ihe ngosi akụkọ ihe mere eme

Nlekota Ngwa (Iji Ọrụ)

  • Isi Ọrụ
  • Ọrụ Ijikwa
  • Agụmakwụkwọ na nlekota ọrụ
  • Idebe oge gị

Ntọala

  • Na-arụ ọrụ na ntọala Metric
  • Ịtọ ntọala nchetara
  • Ịhazi Normric Metrics

Na-echeghari Ọgba Mmiri

  • Ọrụ nchịkọta nkekọrịta
  • Mutex
  • Statspack / AWR egosi
  • Ọrụ Nchekwa Ụlọ Akwụkwọ
  • Ngwa nchọpụta
  • Njikwa na Nzuzo Mgbasa Ozi
  • Nnukwu ọdọ mmiri

Ichegharị Nchekwa Buffer

  • Architecture
  • Ntughari Ebumnuche na Usoro
  • mgbaàmà
  • Solutions

Ntughari PGA na Oge Obere

  • Nlekota njikwa ejiji SQL
  • Njikwa na tebụl n'oge

Aka nchekwa nchekwa akpaaka

  • Nchekwa Nchekwa Akụrụngwa na-arụ ọrụ
  • Ọnọdụ SGA Di omimi
  • Ijikwa Achịkwa Nchekwa Akụrụngwa

Ntugharia Njikere Oghere Ubi

  • Njikwa Ebe
  • Njikwa dị egwu
  • Ntụtị nke Ogige Data
  • Gbanwee Ogige Ebe Ochie

Ntughari I / O

  • I / O Ụlọ Nzukọ
  • Ịgbagharị na Mirroring
  • Iji RAID
  • Nchọpụta I / O
  • Iji Nchekwa Nchekwa Akpa

Performance Tuning: Summary

  • Mmetụta Mbụ Mkpa na Mmetụta Ọrụ
  • Ogologo Ụlọ Elu Elu: Best Practices
  • Tablespace: Best Practices
  • Ịkọkọta ọnụ ọgụgụ

Iji Statspack

  • Okwu Mmalite na Statspack
  • Idebe Statspack Snapshots
  • Ịkọ akụkọ na Statspack
  • Atụmatụ statspack
  • Statspack na AWR

Biko dee anyị na info@itstechschool.com & kpọtụrụ anyị na 91-9870480053 maka ọnụahịa ego & akwụkwọ nkwụ ụgwọ, oge na ọnọdụ

Wepụ Anyị Ajụjụ

Maka ozi ndị ọzọ na-akpọtụrụ anyị.


Nyocha