Nrog rau qhov luv luv no kuv xav kom tshem tawm ib qho kev nkag siab yuam kev cuam tshuam nrog kev tsom xam ntawm AWR databases khiav ntawm Oracle Exadata. Yuav luag 10 xyoo, kuv tau ntsib nrog cov lus nug: dab tsi yog qhov txiaj ntsig ntawm Exadata Software rau kev tsim khoom? Los yog siv cov lus sau tshiab: "tus kws tshaj lij" ua haujlwm li cas ntawm cov ntaub ntawv tshwj xeeb?
Feem ntau cov lus nug no, hauv kuv lub tswv yim, tau teb tsis raug nrog siv rau AWR txheeb cais. Nws nthuav qhia cov txheej txheem tos, uas kho lub sijhawm teb raws li qhov suav ntawm lub sijhawm ua haujlwm ntawm cov txheej txheem (DB CPUs) thiab lub sijhawm tos ntawm ntau chav kawm.
Nrog rau qhov tshwm sim ntawm Exadata, cov kev cia siab tshwj xeeb ntsig txog kev ua haujlwm ntawm Exadata Software tau tshwm sim hauv AWR txheeb cais. Raws li txoj cai, cov npe ntawm kev tos pib nrog lo lus "cell" (Exadata Storage server yog hu ua cell), uas feem ntau tos nrog qhia cov npe "cell smart table scan", "cell multiblock lub cev nyeem" thiab "cell tib thaiv lub cev nyeem".
Feem ntau, qhov sib faib ntawm Exadata tos nyob rau hauv tag nrho lub sij hawm teb yog me me, thiab yog li ntawd lawv tsis txawm poob rau hauv lub Top10 Foreground Txheej xwm los ntawm tag nrho tos sij hawm seem (hauv qhov no, koj yuav tsum nrhiav rau lawv nyob rau hauv lub Foreground tos. Cov xwm txheej). Nrog kev nyuaj heev, peb pom ib qho piv txwv ntawm AWR txhua hnub los ntawm peb cov neeg siv khoom, uas Exadata cov kev cia siab tau suav nrog hauv ntu Top10 thiab tag nrho cov nyiaj tau los txog li 5%:
Cov kev tshwm sim
Tos
Tag Nrho Sijhawm Tos (sec)
Avg Tos
% DB lub sijhawm
Tos Chav
DB CPU
115.2K
70.4
SQL * Net ntau cov ntaub ntawv los ntawm dblink
670,196
5471.5
8.16ms
3.3
network
cell ib block lub cev nyeem
5,661,452
3827.6
676.07 mus
2.3
Tus neeg siv I/O
Sync ASM rebalance
4,350,012
3481.3
800.30 mus
2.1
lwm yam
cell multiblock lub cev nyeem
759,885
2252
2.96ms
1.4
Tus neeg siv I/O
ncaj qha nyeem
374,368
1811.3
4.84ms
1.1
Tus neeg siv I/O
SQL * Net lus los ntawm dblink
7,983
1725
216.08ms
1.1
network
cell smart table scan
1,007,520
1260.7
1.25ms
0.8
Tus neeg siv I/O
ncaj txoj kev nyeem temp
520,211
808.4
1.55ms
0.5
Tus neeg siv I/O
enq: TM - kev sib cav
652
795.8
1220.55ms
0.5
Daim ntawv thov
Cov lus xaus hauv qab no feem ntau tau txais los ntawm AWR cov txheeb cais:
1. Kev koom tes ntawm Exadata khawv koob rau kev ua haujlwm hauv database tsis siab - nws tsis tshaj 5%, thiab cov ntaub ntawv "exadatizes" tsis zoo.
2. Yog hais tias xws li ib tug database yog pauv los ntawm Exadata mus rau classic "server + array" architecture, ces qhov kev ua tau zoo yuav tsis hloov ntau. Vim hais tias txawm tias qhov array no hloov mus ua peb zaug qeeb dua li Exadata cia qhov system (uas yog tsis tshua muaj peev xwm rau niaj hnub Tag nrho Flash arrays), ces muab 5% los ntawm peb peb tau txais kev nce hauv feem ntawm I / O tos rau 15% - lub database yeej yuav ciaj sia no!
Ob qho ntawm cov lus xaus no tsis raug, ntxiv rau, lawv cuam tshuam kev nkag siab ntawm lub tswv yim qab Exadata Software. Exadata tsis yog tsuas yog muab ceev I / O, nws ua haujlwm sib txawv piv rau cov neeg rau zaub mov classic + array architecture. Yog tias kev ua haujlwm database yog tiag tiag "exadapted", ces SQL logic yog pauv mus rau qhov system cia. Cia cov servers, ua tsaug rau ntau lub tshuab tshwj xeeb (feem ntau Exadata Storage Indexs, tab sis tsis yog xwb), nrhiav cov ntaub ntawv tsim nyog lawv tus kheej thiab xa DB mus rau cov servers. Lawv ua qhov no tau zoo heev, yog li qhov sib koom ntawm Exadata ib txwm tos nyob rau hauv tag nrho cov lus teb yog me me.
Qhov kev sib faib no yuav hloov li cas sab nraud ntawm Exadata? Qhov no yuav cuam tshuam li cas rau kev ua haujlwm ntawm database tag nrho? Kev sim yuav teb cov lus nug no zoo tshaj. Piv txwv li, tos rau "cell smart table scan" sab nraum Exadata tuaj yeem tig mus rau hauv lub rooj hnyav hnyav li no uas I / O siv sijhawm tag nrho cov lus teb thiab kev ua haujlwm poob qis heev. Tias yog vim li cas nws tsis ncaj ncees lawm, thaum txheeb xyuas AWR, los txiav txim siab tag nrho feem pua ββββntawm Exadata kev cia siab raws li kev koom tes ntawm nws cov khawv koob rau kev ua tau zoo, thiab ntau dua yog li siv qhov feem pua ββββntawm kev twv ua haujlwm sab nraud ntawm Exadata. Txhawm rau kom nkag siab tias "yuav ua li cas" kev ua haujlwm ntawm cov ntaub ntawv yog li cas, koj yuav tsum kawm AWR cov txheeb cais ntawm ntu "Instance Activity Stats" (muaj ntau cov txheeb cais nrog cov npe piav qhia tus kheej) thiab sib piv rau ib leeg.
Thiab kom nkag siab tias cov ntaub ntawv sab nraud ntawm Exadata yuav xav li cas, nws yog qhov zoo tshaj plaws los ua cov ntaub ntawv clone los ntawm kev thaub qab ntawm lub hom phiaj architecture thiab txheeb xyuas qhov ua tau zoo ntawm cov clone no hauv qab load. Exadata cov tswv, raws li txoj cai, muaj lub sijhawm no.
Author: Alexey Struchenko, tus thawj coj ntawm Jet Infosystems database department
Tau qhov twg los: www.hab.com