Ngalokhu okuthunyelwe okufushane ngithanda ukususa ukungaqondi okukodwa okuhlobene nokuhlaziywa kolwazi lwe-AWR olusebenza ku-Oracle Exadata. Cishe iminyaka eyi-10, bengilokhu ngibhekene nombuzo: uyini umnikelo we-Exadata Software ekukhiqizeni? Noma usebenzisa amagama asanda kuqanjwa: "uchwepheshe" uwumsebenzi kanjani wesizindalwazi esithile?
Ngokuvamile lo mbuzo olungile, ngokubona kwami, uphendulwa ngokungalungile ngokubhekisela kuzibalo ze-AWR. Yethula indlela yokulinda yesistimu, ephatha isikhathi sokuphendula njengesamba sesikhathi sokusebenza samaphrosesa (ama-DB CPU) kanye nesikhathi sokulinda samakilasi ahlukahlukene.
Ngokufika kwe-Exadata, okulindelwe ohlelweni oluthile oluhlobene nokusebenza kwe-Exadata Software kuvele kwizibalo ze-AWR. Njengomthetho, amagama anjalo okulinda aqala ngegama elithi "cell" (iseva ye-Exadata Storage ibizwa ngokuthi iseli), okuvame kakhulu ukulinda ngamagama azichazayo "cell smart table scan", "cell multiblock". ukufunda ngokomzimba” kanye “nokufundwa komzimba kweseli elilodwa”.
Ezimweni eziningi, isabelo saleyo Exadata elindayo esikhathini esiphelele sokuphendula sincane, ngakho-ke akuweli ngisho nasesigabeni se-Top10 Semicimbi Yangaphambili nge-Total Wait Time ingxenye (kulokhu, udinga ukubheka kokuthi Ukulinda Okungaphambili. Isigaba semicimbi). Ngobunzima obukhulu, sithole isibonelo se-AWR yansuku zonke kumakhasimende ethu, lapho okulindelwe kwe-Exadata kufakwe esigabeni se-Top10 futhi sekukonke kufinyelele cishe ku-5%:
Indawo
Ukulinda
Isikhathi Esiphelele Sokulinda (isekhondi)
Avg Linda
%DB isikhathi
Linda Ikilasi
DB CPU
115.2K
70.4
I-SQL*Idatha eningi evela ku-dblink
670,196
5471.5
Ama-8.16ms
3.3
Network
iseli ibhulokhi elilodwa elifundwa ngokomzimba
5,661,452
3827.6
676.07us
2.3
Umsebenzisi I/O
Vumelanisa ibhalansi ye-ASM
4,350,012
3481.3
800.30us
2.1
Izincwajana zemininingwane
iseli multiblock ukufunda ngokomzimba
759,885
2252
Ama-2.96ms
1.4
Umsebenzisi I/O
indlela eqondile ifundwe
374,368
1811.3
Ama-4.84ms
1.1
Umsebenzisi I/O
SQL*Net umyalezo ovela ku-dblink
7,983
1725
Ama-216.08ms
1.1
Network
cell smart table scan
1,007,520
1260.7
Ama-1.25ms
0.8
Umsebenzisi I/O
indlela eqondile yokufunda izinga lokushisa
520,211
808.4
Ama-1.55ms
0.5
Umsebenzisi I/O
enq: TM - umbango
652
795.8
Ama-1220.55ms
0.5
Isicelo
Iziphetho ezilandelayo zivame ukuthathwa kulezo zibalo ze-AWR:
1. Umnikelo womlingo we-Exadata ekusebenzeni kwedathabheyisi awuphezulu - aweqeli u-5%, futhi isizindalwazi “sikhulisa” kabi.
2. Uma isizindalwazi esinjalo sidluliswa sisuka ku-Exadata siye esakhiweni sakudala se-“server + array”, khona-ke ukusebenza ngeke kushintshe kakhulu. Ngoba noma ngabe lolu hlu lubonakala luhamba kancane ngokuphindwe kathathu kunesistimu yokugcina i-Exadata (okuyinto engenakwenzeka kuma-All Flash array yesimanje), bese siphindaphinda u-5% ngokuthathu sithola ukwenyuka kwesabelo se-I/O esilinda sibe ngu-15% - i-database ngokuqinisekile izosinda kulokhu!
Zombili lezi ziphetho azilungile, ngaphezu kwalokho, zihlanekezela ukuqonda komqondo ngemuva kwe-Exadata Software. I-Exadata ayinikezi nje i-I/O esheshayo, isebenza ngokuhluke kakhulu uma iqhathaniswa neseva yakudala + ukwakheka kwesakhiwo. Uma ukusebenza kwedathabhesi "kushintshiwe", ingqondo ye-SQL idluliselwa ohlelweni lokugcina. Amaseva wesitoreji, ngenxa yezinombolo zezindlela ezikhethekile (ikakhulukazi I-Exadata Storage Indexes, kodwa hhayi kuphela), thola idatha edingekayo ngokwazo futhi uthumele i-DB kumaseva. Lokhu bakwenza kahle kakhulu, ngakho isabelo se-Exadata esijwayelekile esilindwayo ngesikhathi sokuphendula sincane.
Lesi sabelo sizoshintsha kanjani ngaphandle kwe-Exadata? Lokhu kuzokuthinta kanjani ukusebenza kwesizindalwazi sisonke? Ukuhlola kuzophendula le mibuzo kangcono. Isibonelo, ukulinda "i-cell smart table scan" ngaphandle kwe-Exadata kungashintsha kube i-Table Full Scan esindayo kangangokuthi i-I/O ithatha sonke isikhathi sokuphendula futhi ukusebenza kwehle kakhulu. Yingakho kungalungile, lapho uhlaziya i-AWR, ukucabangela isamba sephesenti lokulindelwe kwe-Exadata njengomnikelo womlingo wayo ekusebenzeni, futhi ngisho nangokwengeziwe ukusebenzisa leli phesenti ukubikezela ukusebenza ngaphandle kwe-Exadata. Ukuze uqonde ukuthi "unembile" kanjani umsebenzi wesizindalwazi, udinga ukufunda izibalo ze-AWR zesigaba esithi "Izibalo Zomsebenzi Wesimo" (kunezibalo eziningi ezinamagama azichazayo) futhi uziqhathanise nezinye.
Futhi ukuze uqonde ukuthi isizindalwazi esingaphandle kwe-Exadata sizozizwa kanjani, kungcono ukwenza ikhophi yedathabheyisi kusuka kukhophi yasenqolobaneni yezakhiwo eziqondiwe futhi uhlaziye ukusebenza kwale clone ngaphansi komthwalo. Abanikazi be-exadata, njengomthetho, banalo leli thuba.
Author: U-Alexey Struchenko, inhloko yomnyango wedatha ye-Jet Infosystems
Source: www.habr.com