Maitiro ekutarisa ndangariro kushandiswa muOracle Dhijitari yeExpress yeDatabase?
Mune dhatabhesi reOracle, kushandiswa kwakanaka kwendangariro kwakakosha kuti uve nechokwadi chekushanda kwehurongwa. Memory muOracle inoshandiswa kuchengetedza data mu cache, kumhanya mivhunzo, nekuchengetedza kuvimbika kwe database. Naizvozvo, zvakakosha kuti kunyatso tarisisa mashandisirwo endangariro kuti uone zvingangoita mabhodhoro kana nyaya dzekuita. Muchikamu chino, tichaongorora akasiyana matekiniki uye maturusi ekutarisa uye kuongorora mashandisiro endangariro. muOracle Database Express Edition.
1. Kushandisa Oracle Memory Manager: Oracle Database Express Edition inosanganisira chishandiso chinonzi "Oracle Memory Manager" chinokutendera kuti utore uye utarise mashandisirwo endangariro. Tichishandisa Oracle Memory Maneja, tinogona kuona kuti ndeapi matunhu endangariro ari kushandisa zvakanyanya zviwanikwa uye kutora matanho ekugadzirisa mashandisiro azvo.
2. Kugadzirisa Oracle Activity Monitor: Chinoongorora Chiitiko Oracle ndeye yakavakirwa-mukati dhatabhesi chishandiso chinopa tarisiro yekuita uye kushandiswa kwezviwanikwa. munguva chaiyo. Ichi chishandiso chinokutendera kuti utarise kushandiswa kwendangariro, pamwe nezvimwe zviwanikwa zvakaita seCPU, I/O, uye network. Nekugadzirisa Oracle Activity Monitor kuratidza mametric ane chekuita nendangariro, tinogona kuwana tarisiro yakadzama yemashandisirwo ari kuitwa ndangariro mukati mebhodhi. nguva chaiyo uye kuona chero matambudziko kana kusashanda.
3. Kushandisa Mibvunzo yeSQL: Oracle inopa nhevedzano yemaonero uye matafura epivot anopa ruzivo rwakadzama nezvekushandiswa kwendangariro uye zvimwe zviwanikwa zvehurongwa. Semuenzaniso, iyo "V$SGASTAT" maonero anopa nhamba dzepasi rose yakagovaniswa kushandiswa kwendangariro, nepo "V$BUFFER_POOL_STATISTICS" tafura inoratidza ruzivo nezve data cache performance. Kuburikidza neSQL queries tichishandisa maonero aya uye matafura epivot, tinogona kuwana mishumo yakadzama nezve memory mashandisirwo uye nekuiongorora kuti tione chero nyaya kana matambudziko.
Muchidimbu, kutarisa kushandiswa kwendangariro muOracle Database Express Edition kwakakosha kuti uve nechokwadi chekushanda kwakakwana uye kudzivirira zvipingaidzo. Kushandisa zvishandiso seOracle Memory Manager, iyo Chinoongorora Zviitiko Kubva kuOracle uye SQL mibvunzo kune maonero uye pivot matafura, tinogona kuwana yakadzama yekuona mashandisiro endangariro munguva chaiyo uye kutora matanho akakodzera kukwirisa kuita kwayo.
-Kusuma kune Oracle Database Express Edition
Nhanganyaya kuOracle Database Chinyorwa cheExpress
Oracle Database Express Edition (Oracle XE) ndeyemahara, yekupinda-chikamu edition yevagadziri uye vashandisi ve madhatabhesi, ichipa ine simba uye scalable chikuva chekushandisa. Kunyangwe Oracle XE idiki edition maererano nehukuru hwedatabase uye kushanda kwayo, ichiri sarudzo yakanaka kune avo vari kutsvaga kudzidza uye kuyedza neOracle Database.
Mune ino post, isu tichatarisa pane yakakosha chikamu che database server performance: kutarisa kushandiswa kwendangariro. Memory chinhu chakakosha sosi mune chero dhatabhesi system, uye kuve nechokwadi chekushandisa kwayo kwakanaka uye kunoshanda kunogona kubatsira kuvandudza mashandiro uye kugadzikana kweOracle XE.
Pane nzira dzinoverengeka dzekutarisa uye kubata ndangariro kushandiswa muOracle XE. Imwe yezvishandiso zvakanyanya kushandiswa ndeye Oracle Memory Manager., iyo inopa ruzivo rwakadzama nezvehukuru uye kugoverwa kwendangariro muhurongwa. Iyo zvakare inobvumidza iwe kuti uite zvigadziriso uye zvigadziriso kuti ukwidzise Oracle's XE ndangariro kushandiswa.
Pamusoro peOracle's Memory Manager, Zvakakosha kufunga nezvekushandiswa kwekutarisa uye kuongorora mabasa, akadai sekuita tracking uye SQL kuongorora.. Zvishandiso izvi zvinopa mamwe ruzivo nezve mashandisirwo endangariro nemibvunzo chaiyo uye maitiro, ayo anogona kubatsira kuona matambudziko nekugadzirisa Oracle XE kuita.
Muchidimbu, kutarisa kushandiswa kwendangariro kwakakosha pakuona kuita uye kugadzikana kweOracle Database Express Edition. Uchishandisa maturusi akaita seOracle Memory Maneja uye yekutarisa uye yekuongorora mabasa, vashandisi vanogona kukwirisa ndangariro uye kuvandudza kushanda kwese kweOracle XE-yakavakirwa maapplication usatore pasi simba rekurangarira ndangariro mune yako Oracle XE dhatabhesi.
-Kukosha kwekutarisa kushandiswa kwendangariro muOracle
Zvakakosha kunzwisisa kukosha kwekutarisa kushandiswa kwendangariro muOracle Database Express Edition. Memory inoita basa rakakosha mukuita kwedatabase uye kugadzikana. Kusashandisa zvakanaka kwendangariro kunogona kukonzera yakawedzera nguva yekupindura, yakaderera system performance, uye mune zvakanyanyisa zviitiko kunyangwe server kuparara. Naizvozvo, zvakakosha kuve nematanho ekutarisa akakodzera munzvimbo kuti ive nechokwadi chekushandiswa kwendangariro kwakanaka uye kudzivirira matambudziko anogona kuitika.
Al tarisa kushandiswa kwendangariro muOracle, inotibvumira kuona maitiro anomalies uye kugadzirisa matambudziko asati akanganisa vashandisi vekupedzisira. Tinogona kuona mabhodhoro, senge, semuenzaniso, zvivharo zvendangariro izvo zvinogona kunge zvichikonzera kunonoka kuita kana kuzara system kubondera. Pamusoro pezvo, kugara tichitarisisa kunotitendera kugadzirisa ndangariro marongero sezvinodiwa, optimize Oracle database performance.
Pamusoro pekutarisa nguva dzose kwekushandiswa kwendangariro, isu tinofanirawo kufunga nezve ndangariro kukura kuronga. Izvi zvinosanganisira kufungidzira kukura kweramangwana redhatabhesi uye kuve nechokwadi chekuti pane ndangariro yakakwana iripo yekuzadzisa zvinodiwa mune ramangwana. Constantmonitoring inotibvumira kufanotaura zvakanaka uye kuronga zvidikanwi zvekuyeuka, nokudaro tichidzivisa matambudziko ekushanda anokonzerwa nekusakwana kwendangariro.
- Zvishandiso zviripo zvekutarisa ndangariro muOracle Database Express Edition
Oracle Database Express Edition isimba rekushandisa dhatabhesi uye zvakakosha kuti vatariri ve database vakanyatso tarisisa mashandisirwo endangariro kuti vaone kuti system inoshanda zvakakwana. Kufambisa basa iri, Oracle inopa akati wandei maturusi anobvumira maneja kuteedzera uye kuongorora mashandisirwo endangariro muOracle Database Express Edition.
Chimwe chishandiso chakadaro Oracle Enterprise Manager, iyo inopa intuitive uye nyore-kushandisa-graphical interface yekutarisa ndangariro. Kuburikidza nechishandiso ichi, vatariri vanogona kuona metrics akadai seyakagovaniswa buffer saizi, saizi yebhafa yedatabase, uye saizi yekugovana yekurangarira dziva. Vanogonawo kuona magirafu anoratidza kuti kushandiswa kwendangariro kwakachinja sei nekufamba kwenguva, zvichivabvumira kukurumidza kuona chero matambudziko angangoitika.
Chimwe chishandiso chinobatsira Oracle's Dynamic Views package, iyo inobvumira vatariri kuwana chaiyo-nguva ruzivo nezve mashandisiro endangariro mudhatabhesi. Aya maonero ane simba anopa maonero akadzama enzvimbo dzekurangarira dzinoshandiswa nedatabase, senge yakagovaniswa buffer, dhatabhesi buffer, uye nzvimbo yePGA. Neruzivo urwu rwenguva-chaiyo, vatariri vanogona kuita sarudzo dzine ruzivo nezve maitiro ekugadzirisa ndangariro kumisikidza kuti ikwidze mashandiro ehurongwa.
Muchidimbu, Oracle Database Express Edition inopa vatariri ve database vane akati wandei maturusi ane simba ekutarisa mashandisirwo endangariro. Oracle System Maneja inogonesa intuitive yekutarisa yekutarisa, nepo Oracle ane simba maonero anopa chaiyo-nguva ruzivo rwekuita sarudzo dzine ruzivo. Nezvishandiso izvi zvavanazvo, vatariri ve database vanogona kuona kuti kushandiswa kwendangariro muOracle Database Express Edition kunoshanda uye kwakagadziridzwa.
-Kushandisa iyo TOP kuraira kuwana ruzivo munguva chaiyo
Iyo TOP yekuraira chishandiso chinobatsira kwazvo kuwana chaiyo-nguva ruzivo nezve mashandisiro endangariro muOracle Database Express Edition Kuburikidza nemurairo uyu, vatariri ve database vanogona kutarisa Zvinonyatsoita uye kukwidziridza zviwanikwa zviripo.
Imwe yezvakakosha zvakanakira kushandisa TOP command kugona kwayo kuratidza maitiro ari kushandisa yakanyanya ndangariro chero nguva. Izvi zvinonyanya kubatsira kana iwe uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchingerwa nyaya, nekuti zvinokutendera iwe kukurumidza kuona maitiro ari kudya huwandu hwakakosha hwezviwanikwa. Kuburikidza neruzivo rwunopihwa neTOP rairo, maneja anogona kutora nhanho dzekukurumidza kugadzirisa kushandiswa kwendangariro nekuvandudza mashandiro ehurongwa hwese.
Nekushandisa iyo TOP kuraira, vatariri vanogona zvakare kuwana ruzivo rwakadzama nezve mashandisirwo endangariro nemaitiro akasiyana munguva chaiyo. Izvi zvinovabvumira kuona kuti ndeapi maitiro ari kushandisa "yakawandisa" huwandu hwendangariro uye kutora matanho ekugadzirisa. Pamusoro pezvo, iyo TOP yekuraira inopa ruzivo nezve huwandu hwese hwekuita maitiro, huwandu hwekurangarira hwakagoverwa kune yega yega maitiro, uye huwandu hwekurangarira huripo pane system. Izvi zvinobatsira vatariri kuwana tarisiro yemamiriro azvino ekurangarira mudhatabhesi uye kuita sarudzo dzine ruzivo nezve kutonga zviripo.
Muchidimbu, iyo TOP yekuraira chishandiso chine simba chekutarisa kushandiswa kwendangariro muOracle Database Express Edition munguva chaiyo. Iyo inobvumira maneja kuti aone zviri nyore kuti ndeapi maitiro ari kushandisa yakanyanya ndangariro uye kutora nhanho yekururamisa kukwirisa mashandiro ehurongwa. Nekupa ruzivo rwakadzama nezve mashandisirwo endangariro nemaitiro, iyo TOP murairo unobatsira vatariri kuwana tarisiro yeyazvino mamiriro endangariro muhurongwa uye kuita sarudzo dzine ruzivo nezve manejimendi ezviwanikwa.
-Kududzira mhedzisiro yeiyo TOP yekuraira muOracle Database Express Edition
Iyo TOP yekuraira muOracle Database Express Edition chishandiso chine simba chekutarisa mashandisirwo endangariro mudhatabhesi. Kududzira mhedzisiro yemurairo uyu kunogona kupa nzwisiso yakadzama mukuita uye kubatsira kuona zvinogona kuitika mundangariro matambudziko.
Chekutanga chekutariswa pakududzira mhinduro yeTOP ikoramu yePID inoratidza chinozivisa maitiro ekumhanya. Izvi zvinogona kubatsira kuona kuti ndeapi maitiro ari kushandisa zvakanyanya ndangariro uye kuti anoshanda sei.
Iyo "MEM" column inoratidza huwandu hwendangariro hunoshandiswa nemaitiro ega ega, zvichikutendera kuti uone nekukurumidza maitiro ari kushandisa yakanyanya ndangariro. Izvi zvinonyanya kubatsira kana uchitsvaga ndangariro dzinogona kudonha kana mabhodhoro anogona kukanganisa mashandiro.
Pamusoro pezvo, iyo "TIME" column inoratidza nguva yakazara yekuuraya yega yega. Ruzivo urwu runobatsira pakuona kuti ndeapi maitiro ari kupedza zvakanyanya CPU nguva uye kana paine ari kukonzera yakakwira ndangariro kushandiswa nekuda kwekuita kwenguva refu.
Muchidimbu, kududzira mhedzisiro yeTOP yekuraira muOracle Database Express Edition inopa nzwisiso yakakosha mukushandiswa kwememory database. Nekuongorora iyo "PID", "MEM" uye "NGUVA" makoramu, unogona kuona maitiro ari kushandisa zvakanyanya ndangariro uye system zviwanikwa. Izvi zvinobvumira matanho akakodzera kutorwa kugadzirisa kushanda uye kugadzirisa matambudziko anogona kuitika.
-Ongororo yeSGA uye PGA paramita kukwirisa ndangariro kushandiswa
Paunenge uchiongorora mashandisirwo endangariro muOracle Database Express Edition, zvakakosha kuti utarise iyo SGA (System Global Area) uye PGA (Program Global Area) paramita kuti ikwidze kuita kwayo. SGA inoreva ndangariro yakagovaniswa inoshandiswa neiyo inoshanda sisitimu yekuchengeta data uye kutonga ruzivo, nepo PGA iri yemunhu ndangariro inoshandiswa nechero Oracle maitiro kana sesheni kuita mashandiro ekugadzirisa.
Kuongorora kushandiswa kwendangariro, Zvinokurudzirwa kushandisa maonero eOracle ane simba seV$SGA, V$PAGETABLE, V$PROCESS, pakati pevamwe. Aya maonero anopa ruzivo rwakadzama nezve yazvino uye yakakura saizi yeSGA nePGA, pamwe nehuwandu hwekurangarira hunoshandiswa neakasiyana masisitimu zvikamu. Kuburikidza neaya maonero, vatariri ve database vanogona tsvaga chero nyaya dzakawandisa kana kusaenzana mukushandiswa kwendangariro uye tora matanho ekugadzirisa nekukasika.
Kana data rekuita rekuyeuka rawanikwa, SGA nePGA paramita inogona kugadziriswa kuti iwedzere kushanda zvakanaka. . Nekuwedzera saizi yeSGA, inobvumira kuwanda kuchengetwa kwedata uye inoderedza kuda kwekuwana dhisiki, inonatsiridza kushanda kwedatabase rese. pane rimwe divi, gadzirisa saizi yePGA Zvinogona kubatsira kana uchigovera ndangariro dzakawanda kumabasa anoda kugadziridzwa kwakanyanya, senge kuronga mashandiro kana kushandiswa kwechinguvana ndangariro mumibvunzo yakaoma. Izvo zvakakosha kuti uzive kuti zvigadziriso izvi zvinofanirwa kuitwa nemazvo uye kutarisa maitiro azvo pakuita kuti zvidzivise zvingangove zvakanyanyisa nyaya dzekushandisa ndangariro.
-Kurudziro yekubata zvakanaka ndangariro muOracle Database Express Edition
Zve nyatso gadzirisa ndangariro muOracle Database Express Edition, zvakakosha kuziva uye kutarisa kushandiswa kwendangariro mudura re database. Imwe nzira yekuita izvi ndeye kushandisa maonero ane simba anopihwa neOracle. Aya maonero ane simba anotendera iwe kuti uwane ruzivo rwenguva-chaiyo nezve mashandisiro endangariro, senge yakagovaniswa chikamu saizi, buffer cache saizi, uye PGA saizi.
Imwe kurudziro yakakosha ndeye gadzirisa ndangariro parameters maererano nezvinodiwa uye maitiro ehurongwa. Oracle inopa ma paramita akaita se SHARED_POOL_SIZE, DB_CACHE_SIZE, uye PGA_AGGREGATE_TARGET, ayo anodzora kugoverwa kwendangariro kune zvakasiyana dhatabhesi zvikamu. Kugadzirisa ma paramita aya nenzira kwayo kunogona kuvandudza mashandiro ehurongwa uye kudzivirira kubuda mumatambudziko ekurangarira.
Uye zvakare, zvinokurudzirwa kushandisa monitoring tools kuongorora kushandiswa kwendangariro munguva chaiyo uye track zvingangoitika matambudziko. Oracle inopa zvishandiso senge Enterprise Manager uye Mugadziri weSQL, iyo inopa yepamberi yekutarisisa uye diagnostic functionalities. Zvishandiso izvi zvinokutendera kuti uone matambudziko ekunyanya kushandisa ndangariro, gadzirisa munguva chaiyo uye gadzira yambiro yekudzivirira kutadza kutadza.
-Kuona uye kugadzirisa matambudziko ane chekuita nekushandiswa kwendangariro muOracle
Kuziva nekugadzirisa matambudziko ane chekuita ne ndangariro kushandiswa muOracle
Imwe yezvakakosha mu kutungamirirwa kwe dhatabhesi Iko kushandiswa kwakanaka kwendangariro. MuOracle Database Express Edition, zvakakosha kuti utarise nemazvo uye kugadzirisa chero nyaya dzine chekuita nekushandiswa kwendangariro. Pano tichapa mamwe mazano nemaitiro ekuona nekugadzirisa matambudziko aya.
Chimwe chezvishandiso zvikuru zvaunogona kushandisa kutarisa kushandiswa kwendangariro muOracle ndiyo SGA (System Global Area) memory manager. Iyo SGA idunhu rekugovaniswa ndangariro umo Oracle inochengeta data uye zvimiro zvakagovaniswa nemaitiro ese ari muhurongwa. Zvakakosha kuyeuka kuti SGA yakakamurwa kuita subareas, senge buffer cache uye dziva rakagovaniswa, izvo zvinopesvedzera kuita kwese kwedatabase. Nekutarisa uye kugadzirisa aya ma subareas, unogona kukwidziridza kushandiswa kwendangariro pane yako Oracle system.
Chimwe chinhu chekufunga nezvacho kukura kwePGA (Program Global Area). Iyo PGA inzvimbo yendangariro inoshandiswa nesevha process yakatsaurirwa kune chaiyo mushandisi kana maitiro ekushandisa. Kana saizi yePGA isina kurongeka nenzira kwayo, panogona kunge paine nyaya dzine chekuita nendangariro. Izvo zvakakosha kuti uongorore uye kugadzirisa saizi ye PGA kuidzivirira kubva pakushandisa yakawandisa zviwanikwa uye kukanganisa mashandiro eyose system.
- Kushandisa zviziviso uye maaramu kutarisa ndangariro munguva chaiyo
Zviziviso uye maaramu akakosha maturusi ekutarisa ndangariro kushandiswa muOracle Database Express Edition munguva chaiyo. Aya maficha anobvumira vatariri vehurongwa kuti vagamuchire zviziviso zvepakarepo kana mashandisirwo endangariro asvika pamazinga akakosha. Izvi zvinonyanya kubatsira munzvimbo dzekugadzira uko kusaita zvakanaka kunogona kuve nemhedzisiro yakakura pakuwanikwa kwehurongwa uye kuita. .
Nezviyeuchidzo zvakagadzirirwa uye maaramu, vatariri vanogona:
-Gara uchitarisa mashandisirwo endangariro kuti uone zvingangoita mabhodhoro uye nyaya dzekuita.
-Kurumidza kuona mibvunzo kana maitiro ari kushandisa yakawandisa ndangariro uye tora nekukurumidza kugadzirisa.
-Seta zvikumbaridzo kuti ugamuchire chenjedzo kana kushandiswa kwendangariro kuchipfuura kusarudzika kukosha.
Kugadzirisa zviziviso uye maaramu muOracle Database Express Edition iri nyore uye inogona kuitwa kuburikidza nemirairo mutsara interface kana kushandisa Oracle Enterprise Manager Express. . Kugadzirisa real-time memory chenjedzo, tevera matanho anotevera:
1. Pinda kuOracle Database Express Edition semutongi wehurongwa.
2. Mhanya iyo ALTER SYSTEM SET MEMORY_MAX_TARGET kuraira kuti uise iyo yakanyanya kukosha yendangariro inogona kushandiswa.
3. Shandisa iyo ALTER SYSTEM SET MEMORY_TARGET kuraira kuseta kukosha kwekushandisa ndangariro.
4. Shandisa chirevo cheCREATE ALARM kugadzira alarm inotangwa kana kushandiswa kwendangariro kuchipfuura imwe chikumbaridzo.
5. Tarisa zvigadziriso uchishandisa murairo we SHOW PARAMETER MEMORY kuti uone kuti chenjedzo uye maalarm ari kushanda uye akagadzirirwa zvakanaka.
Kushandisa chenjedzo uye maaramu kutarisa ndangariro munguva chaiyo inzira yakanakisa yekuve nechokwadi chekushanda kwakakwana kweOracle Database Express Edition Nezvishandiso izvi, vatariri vanogona kuona uye kugadzirisa matambudziko ekurangarira, vachidzivirira kuvhiringika mukushanda kwehurongwa.
- Mhedziso uye matanho ekutevera kuvandudza ndangariro yekutarisa muOracle Database Express Edition
Mhedziso
Mukupedzisa, kutarisisa ndangariro muOracle Database Express Edition ibasa rakakosha kuve nechokwadi chekuita kwakaringana system. Mupositi iyi yese, takaongorora nzira dzakasiyana uye nzira dzekuita basa iri. zvinobudirira.
Matanho ekutevera kuvandudza ndangariro
Kuvandudza ndangariro yekutarisa muOracle Database Express Edition, isu tinokurudzira kutora anotevera matanho:
1. Ongorora ndangariro configuration: Usati waita chero zvigadziriso, zvakakosha kuti unzwisise kuti ndangariro inogadziriswa sei mune yako database. Izvi zvinosanganisira kuziva kiyi yekurangarira paramita, senge saizi yebuffer cache uye yakagovaniswa dziva. Shandisa mubvunzo weduramazwi reOracle kuwana ruzivo urwu.
2. Seta zvikumbaridzo zvechenjedzo: Gadzirisa mikumbiro yeyambiro yezvikamu zvakasiyana zvendangariro, senge buffer cache uye dziva rakagovaniswa. Izvi zvinokutendera kuti ugamuchire zviziviso kana miganho yakatemerwa yasvika kana kudarika, izvo zvinokuyambira nezvematambudziko angangove endangariro.
3. Ramba uchitarisa: Gadzirisa memory yekutarisa inoenderera mberi kuziva nemazvo nekugadzirisa nyaya. Shandisa maturusi ekutarisisa akadai seOracle Enterprise Maneja kana tsika zvinyorwa kuti uwane akakosha metrics, akadai sekushandiswa kwendangariro uye nguva yekubuda, uye kuaronda nguva nenguva.
Muchidimbu, kuvandudza ndangariro yekutarisa muOracle Database Express Edition inoda yakarongeka uye inoshanda maitiro. Nekutevera matanho ataurwa pamusoro apa, iwe uchakwanisa kukwidziridza mashandiro edhatabhesi yako uye kudzivirira matambudziko anodhura mune ramangwana. Rangarira kugadzirisa nguva nenguva uye optimizations kuti system yako irambe ichishanda zvinobudirira.
Ini ndiri Sebastián Vidal, injiniya wekombuta anofarira nezve tekinoroji uye DIY. Uyezve, ndini musiki we tecnobits.com, kwandinogovera zvidzidzo kuti tekinoroji iwanikwe uye inonzwisisika kumunhu wese.