Ka poso ena e khuts'oane ke kopa ho tlosa ho se utloisisane ho le mong ho amanang le tlhahlobo ea li-database tsa AWR tse sebetsang ho Oracle Exadata. Hoo e ka bang lilemo tse 10, ke 'nile ka tobana le potso kamehla: monehelo oa Exadata Software ke ofe tlhahiso? Kapa ho sebelisa mantsoe a sa tsoa qaptjoa: "setsebi" ke mosebetsi oa database e itseng joang?
Hangata potso ena e nepahetseng, ka maikutlo a ka, e arajoa ka mokhoa o fosahetseng mabapi le lipalo-palo tsa AWR. E fana ka mokhoa oa ho leta oa sistimi, o nkang nako ea karabelo e le kakaretso ea nako ea ts'ebetso ea li-processor (DB CPUs) le nako ea ho leta ea lihlopha tse fapaneng.
Ka ho fihla ha Exadata, litebello tse khethehileng tsa tsamaiso tse amanang le ts'ebetso ea Exadata Software li hlahile lipalo-palo tsa AWR. Ha e le molao, mabitso a litebello tse joalo a qala ka lentsoe "sele" (seva ea Exadata Storage e bitsoa sele), eo e tloaelehileng ka ho fetisisa e emelang ka mabitso a itlhalosang "cell smart table scan", "cell multiblock". bala ka mmele” le “cell single block physical read”.
Maemong a mangata, karolo ea Exadata e leta ka nako eohle ea karabelo e nyane, ka hona ha e oele le ka har'a karolo ea Top10 Foreground Events by Total Wait Time (tabeng ena, o hloka ho li batla ho Foreground Wait. Karolo ea liketsahalo). Ka bothata bo boholo, re fumane mohlala oa AWR ea letsatsi le letsatsi ho tsoa ho bareki ba rona, moo litebello tsa Exadata li kenyelelitsoeng karolong ea Top10 mme ka kakaretso e ka ba 5%:
Event
Emetse
Kakaretso ea Nako ea ho Leta (metsotsoana)
Avg Ema
%DB nako
Leta Sehlopha
DB CPU
115.2K
70.4
SQL* Ho na le lintlha tse ling tse tsoang ho dblink
670,196
5471.5
8.16ms
3.3
Network
cell block single block ka 'mele
5,661,452
3827.6
EA 676.07
2.3
Mosebelisi I/O
Sync ASM rebalance
4,350,012
3481.3
EA 800.30
2.1
Other
seleng multiblock ho bala mmele
759,885
2252
2.96ms
1.4
Mosebelisi I/O
tsela e tobileng bala
374,368
1811.3
4.84ms
1.1
Mosebelisi I/O
SQL* Molaetsa oa marang-rang o tsoang ho dblink
7,983
1725
216.08ms
1.1
Network
cell smart table scan
1,007,520
1260.7
1.25ms
0.8
Mosebelisi I/O
tsela e tobileng bala temp
520,211
808.4
1.55ms
0.5
Mosebelisi I/O
enq: TM - likhang
652
795.8
1220.55ms
0.5
kopo
Liqeto tse latelang hangata li nkuoa ho tsoa lipalo-palo tse joalo tsa AWR:
1. Tlatsetso ea boselamose ba Exadata ho ts'ebetso ea database ha e phahame - ha e fete 5%, mme database "exadatizes" hampe.
2. Haeba database e joalo e fetisetsoa ho Exadata ho ea mohahong oa khale oa "server + array", joale ts'ebetso e ke ke ea fetoha haholo. Hobane le haeba sehlopha sena se bonahala se le butle ka makhetlo a mararo ho feta sistimi ea polokelo ea Exadata (e ke keng ea khonahala bakeng sa All Flash arrays ea sejoale-joale), ebe re atisa 5% ka 15 re fumana keketseho ea karolo ea I/O e emetse ho XNUMX% - database ka sebele e tla pholoha sena!
Liqeto tsena ka bobeli ha lia nepahala, ho feta moo, li sotha kutloisiso ea mohopolo oa Exadata Software. Exadata ha e fane ka I/O e potlakileng feela, e sebetsa ka tsela e fapaneng ha e bapisoa le li-server tsa khale + tsa meralo ea meralo. Haeba ts'ebetso ea database e hlile e "eketsehile", joale mohopolo oa SQL o fetisetsoa ho sistimi ea polokelo. Li-server tsa polokelo, ka lebaka la mekhoa e mengata e ikhethang (haholo-holo Li-Index tsa polokelo ea Exadata, empa eseng feela), fumana lintlha tse hlokahalang ka botsona ebe li romela DB ho li-server. Ba etsa sena ka katleho, kahoo karolo ea Exadata e tloaelehileng e emetse ka nako eohle ea karabelo e nyane.
Kabelo ee e tla fetoha joang kantle ho Exadata? See se tla ama ts'ebetso ea database ka kakaretso joang? Liteko li tla araba lipotso tsena hamolemo. Ka mohlala, ho emela "cell smart table scan" ka ntle ho Exadata ho ka fetoha Table Full Scan e boima hoo I/O e nkang nako eohle ea ho arabela le ts'ebetso e senyeha haholo. Ke ka lebaka leo ho leng phoso, ha ho hlahlojoa AWR, ho nahana ka kakaretso ea litebello tsa Exadata e le monehelo oa boselamose ba eona mosebetsing, 'me ho feta moo ho sebelisa peresente ena ho bolela esale pele tshebetso ka ntle ho Exadata. E le hore u utloisise hore na mosebetsi oa "database" o joang, o hloka ho ithuta lipalo-palo tsa AWR tsa karolo ea "Instance Activity Stats" (ho na le lipalo-palo tse ngata tse nang le mabitso a itlhalosang) le ho li bapisa le tse ling.
Le ho utloisisa hore na database e ka ntle ho Exadata e tla ikutloa joang, ho molemo ho etsa "database clone" ho tsoa ho "backup" ho moralo oa sepheo le ho sekaseka ts'ebetso ea clone ena tlas'a mojaro. Beng ba Exadata, joalo ka molao, ba na le monyetla ona.
Author: Alexey Struchenko, hlooho ea lefapha la database la Jet Infosystems
Source: www.habr.com