Ngesi sithuba esifutshane ndingathanda ukukhupha ukungaqondi kakuhle okunxulumene nohlalutyo lwe-AWR yolwazi olusebenza kwi-Oracle Exadata. Phantse iminyaka eyi-10, ndihlala ndijongene nombuzo: yintoni igalelo le-Exadata Software kwimveliso? Okanye usebenzisa amagama asandul 'ukuqulunqwa: "ingcali" injani umsebenzi wedatha ethile?
Rhoqo lo mbuzo uchanekileyo, ngokoluvo lwam, uphendulwa ngokuchanekileyo ngokubhekisele kwizibalo ze-AWR. Ibonisa indlela yokulinda inkqubo, ephatha ixesha lokuphendula njengenani lexesha lokusebenza kweeprosesa (DB CPUs) kunye nexesha lokulinda leeklasi ezahlukeneyo.
Ngokufika kwe-Exadata, ukulindela kwenkqubo ethile ehambelana nokusebenza kwe-Software ye-Exadata kubonakala kwizibalo ze-AWR. Njengomthetho, amagama anjalo okulinda aqala ngegama elithi "iseli" (umncedisi we-Exadata Storage ubizwa ngokuba yiseli), apho awona aqhelekileyo alinda ngamagama achaza "i-cell smart table scan", "cell multiblock yokufunda ngokomzimba" kunye “nebloko enye yeseli yokufunda ngokomzimba”.
Kwiimeko ezininzi, isabelo se-Exadata silinda kwixesha lokuphendula lilonke lincinci, kwaye ngenxa yoko abaweli kwi-Top10 yeziganeko zangaphambili ngecandelo leXesha elipheleleyo (kulo mzekelo, kufuneka uzijonge kwi-Foreground Linda. Icandelo leziganeko). Ngobunzima obukhulu, sifumene umzekelo we-AWR yemihla ngemihla kubathengi bethu, apho ulindelo lwe-Exadata lufakwe kwicandelo le-Top10 kwaye lilonke lifikelela kwi-5%:
umcimbi
Ukulinda
Ixesha Lilonke lokulinda (umzuzwana)
Avg Linda
Ixesha le-%DB
Iklasi yokulinda
DB CPU
115.2K
70.4
SQL*Idatha eyongezelelekileyo evela kwi-dblink
670,196
5471.5
8.16ms
3.3
womnatha
iseli ibloko enye ifundeka ngokwasemzimbeni
5,661,452
3827.6
Ngama-676.07us
2.3
Umsebenzisi I/O
I-Sync ASM rebalance
4,350,012
3481.3
Ngama-800.30us
2.1
omnye
iseli multiblock ukufunda ngokomzimba
759,885
2252
2.96ms
1.4
Umsebenzisi I/O
indlela ethe ngqo yokufunda
374,368
1811.3
4.84ms
1.1
Umsebenzisi I/O
SQL*Umyalezo womnatha ovela kwi-dblink
7,983
1725
216.08ms
1.1
womnatha
cell smart table scan
1,007,520
1260.7
1.25ms
0.8
Umsebenzisi I/O
indlela ethe ngqo yokufunda temp
520,211
808.4
1.55ms
0.5
Umsebenzisi I/O
enq: TM - ingxabano
652
795.8
1220.55ms
0.5
isicelo
Ezi zigqibo zilandelayo zihlala zithathwa kwiinkcukacha-manani ze-AWR:
1. Igalelo lomlingo we-Exadata kwintsebenzo yedatha aliphezulu - ayidluli kwi-5%, kwaye i-database "i-exadatize" kakubi.
2. Ukuba i-database enjalo idluliselwa kwi-Exadata ukuya kwi-architecture ye-classic "server + array", ngoko ukusebenza akuyi kutshintsha kakhulu. Kuba nokuba olu luhlu lujika lucothe ngokuphindwe kathathu kunenkqubo yokugcina i-Exadata (eyinto engenakwenzeka kwimihla yangoku Zonke ii-Flash arrays), emva koko siphindaphinde i-5% ngesithathu sifumana ukwanda kwisabelo se-I/O silinda ukuya kwi-15% - i-database ngokuqinisekileyo iya kusinda kule nto!
Zombini ezi zigqibo azichanekanga, kwaye, ngaphezu koko, ziyayitshintsha indlela eqondwa ngayo ingcamango engasemva kwe-Exadata Software. I-Exadata ayiboneleli nje nge-I/O ekhawulezayo; isebenza ngokwahlukileyo kakhulu kuyilo lwe-"server + array" lwakudala. Ukuba i-database iba yi-"exadata" ngokwenene, ngoko ke i-SQL logic ifuduselwa kwinkqubo yokugcina. iiseva Ngenxa yeendlela ezahlukeneyo ezikhethekileyo (ngokuyintloko ii-Exadata Storage Indexes, kodwa zingaphelelanga apho), ziyifumana ngokuzenzekelayo idatha efunekayo kwaye ziyithumele kwiiseva ze-DB. Zikwenza oku ngokufanelekileyo, ngoko ke isabelo sokulinda kwe-Exadata eqhelekileyo kwixesha lokuphendula lilonke lincinci.
Ingaba esi sabelo siya kutshintsha njani ngaphandle kwe-Exadata? Oku kuya kuyichaphazela njani indlela yokusebenza kwesiseko sedatha xa iyonke? Uvavanyo luya kuyiphendula ngcono le mibuzo. Umzekelo, ukulinda "i-cell smart table scan" ngaphandle kwe-Exadata inokujika ibe yiTable enzima yeScan egcweleyo kangangokuba i-I/O ithatha lonke ixesha lokuphendula kunye nokusebenza kwehla kakhulu. Yingakho kuphosakele, xa uhlalutya i-AWR, ukuqwalasela ipesenti epheleleyo yokulindela i-Exadata njengegalelo lomlingo wayo ekusebenzeni, kwaye ngakumbi ukusebenzisa le pesenti ukuqikelela ukusebenza ngaphandle kwe-Exadata. Ukuqonda ukuba "uchanekileyo" njani umsebenzi wesiseko sedatha, kufuneka ufunde izibalo ze-AWR zecandelo elithi "Instance Activity Stats" (kukho amanani amaninzi anamagama azichazayo) kwaye uthelekise omnye nomnye.
Kwaye ukuqonda ukuba i-database engaphandle kwe-Exadata iya kuziva njani, kungcono ukwenza i-clone yedatha kwi-backup kwi-architecture ejoliswe kuyo kwaye uhlalutye ukusebenza kwale clone phantsi komthwalo. Njengomthetho, abanini be-Exadata banalo eli thuba.
umbhali: U-Alexey Struchenko, intloko yesebe leenkcukacha zeJet Infosystems
umthombo: www.habr.com
