Neiyi pfupi positi ndinoda kubvisa kusanzwisisa kumwe kwakabatana nekuongororwa kweAWR dhatabhesi rinomhanya paOracle Exadata. Kweanoda kusvika makore gumi, ndanga ndichigara ndakatarisana nemubvunzo: chii chinopihwa cheExadata Software mukubudirira? Kana kushandisa mazwi achangobva kuumbwa: sei "nyanzvi" ibasa reimwe dhatabhesi?
Kazhinji uyu mubvunzo wakarurama, mumaonero angu, unopindurwa zvisizvo maererano nenhamba dzeAWR. Inopa sisitimu yekumirira nzira, inobata nguva yekupindura sehuwandu hwenguva yekushanda yema processors (DB CPUs) uye nguva yekumirira yemakirasi akasiyana.
Nekuuya kweExadata, tarisiro yehurongwa hwakanangana nekushanda kweExadata Software yakaonekwa muhuwandu hweAWR. Sezvo mutemo, mazita ekumirira akadaro anotanga neshoko rekuti "sero" (iyo Exadata Storage server inonzi sero), iyo inonyanya kumirira ine mazita anozvitsanangura "cell smart table scan", "cell multiblock". kuverenga kwemuviriβ uye βsero rimwe chete block physical kuverengaβ.
Muzviitiko zvakawanda, mugove weExadata yakadaro inomirira munguva yose yekupindura idiki, uye nekudaro ivo havatombowira muTop10 Foreground Zviitiko neTotal Wait Time chikamu (munyaya iyi, unofanirwa kuvatsvaga muKumirira Kumberi. Zviitiko chikamu). Nekuomerwa kukuru, takawana muenzaniso wezuva nezuva AWR kubva kune vatengi vedu, umo maExadata tarisiro akaverengerwa muchikamu cheTop10 uye muhuwandu hwaisvika ku5%:
chiitiko
Mirira
Yese Yekumirira Nguva (sec)
Avg Wait
%DB nguva
Wait Kirasi
DB CPU
115.2K
70.4
SQL * Yakawanda data kubva kudblink
670,196
5471.5
8.16ms
3.3
Network
cell single block physical kuverenga
5,661,452
3827.6
676.07us
2.3
Mushandisi I/O
Sync ASM rebalance
4,350,012
3481.3
800.30us
2.1
mwe
sero multiblock yemuviri kuverenga
759,885
2252
2.96ms
1.4
Mushandisi I/O
nzira yakananga kuverenga
374,368
1811.3
4.84ms
1.1
Mushandisi I/O
SQL * Net meseji kubva kudblink
7,983
1725
216.08ms
1.1
Network
cell smart table scan
1,007,520
1260.7
1.25ms
0.8
Mushandisi I/O
nzira yakananga kuverenga temp
520,211
808.4
1.55ms
0.5
Mushandisi I/O
enq: TM - kukakavara
652
795.8
1220.55ms
0.5
kunyoresa
Mhedziso dzinotevera dzinowanzo kutorwa kubva kune dzakadai AWR manhamba:
1. Mupiro wemashiripiti eExadata kumabasa epa database haisi yakakwirira - haipfuuri 5%, uye dhatabhesi "inowedzera" zvisina kunaka.
2. Kana dhatabhesi yakadaro ichiendeswa kubva kuExadata kuenda kune yekare "server + array" architecture, ipapo kushanda hakuzoshanduki zvakanyanya. Nekuti kunyangwe iyi array ikaita inononoka katatu pane iyo Exadata yekuchengetedza system (iyo isingaite yemazuva ano All Flash arrays), towedzera 5% netatu tinowana kuwedzera kwechikamu cheI/O inomirira kusvika 15% - iyo dhatabhesi ichapona iyi!
Zvose izvi mhedziso hazvina kururama, uyezve, zvinokanganisa kunzwisisa kwemafungiro ari shure kweExadata Software. Exadata haingope nekukurumidza I / O, inoshanda zvakasiyana zvakasiyana kana ichienzaniswa neyekare server + array array architecture. Kana iyo dhatabhesi mashandiro ari "ekare", ipapo iyo SQL logic inoendeswa kune yekuchengetedza sisitimu. Masevha ekuchengetedza, nekuda kwehuwandu hwemaitiro akakosha (kunyanya Exadata Storage Indexes, asi kwete chete), tsvaga inodiwa data pachako uye utumire iyo DB kumaseva. Ivo vanoita izvi nemazvo, saka mugove weyakajairika Exadata inomirira munguva yakazara yekupindura idiki.
Mugove uyu uchachinja sei kunze kweExadata? Izvi zvichakanganisa sei kushanda kwedatabase rose? Kuedzwa kunopindura zvakanyanya mibvunzo iyi. Semuenzaniso, kumirira "cell smart table scan" kunze kweExadata inogona kushanduka kuita inorema Tafura Yakazara Scan zvekuti I/O inotora nguva yese yekupindura uye kuita kunodzikisira zvakanyanya. Ndicho chikonzero nei zvisina kunaka, kana uchiongorora AWR, kufunga nezvesero muzana zveExadata zvinotarisirwa semupiro wemashiripiti ayo kuita, uye zvakatonyanya kushandisa chikamu ichi kufanotaura kuita kunze kweExadata. Kuti unzwisise kuti "chaizvo" sei basa redhatabhesi, unofanirwa kudzidza nhamba dzeAWR dzechikamu che "Instance Activity Stats" (kune huwandu hwehuwandu hune mazita anozvitsanangura) uye uzvienzanise nemumwe.
Uye kuti unzwisise kuti dhatabhesi rekunze kweExadata richanzwa sei, zvakanakisa kugadzira dhatabhesi clone kubva kune backup pane yakanangwa dhizaini uye kuongorora mashandiro eiyi clone pasi pemutoro. Varidzi veExadata, sekutonga, vane mukana uyu.
Author: Alexey Struchenko, mukuru wedhipatimendi reJet Infosystems database
Source: www.habr.com