Dab tsi yog PGA hauv Oracle?
Dab tsi yog PGA hauv Oracle?

Video: Dab tsi yog PGA hauv Oracle?

Video: Dab tsi yog PGA hauv Oracle?
Video: Mathematics with Python! Sequences 2024, Kaum ib hlis
Anonim

Qhov Kev Pabcuam Ntiaj Teb Thaj Chaw ( PGA ) yog thaj chaw nco ntiag tug uas muaj cov ntaub ntawv thiab tswj cov ntaub ntawv rau cov txheej txheem server. Oracle Database nyeem thiab sau cov ntaub ntawv hauv lub PGA sawv cev ntawm tus txheej txheem server. Ib qho piv txwv ntawm cov ntaub ntawv zoo li no yog thaj tsam khiav ntawm tus cursor.

Piv txwv li, PGA siv rau hauv Oracle li cas?

Ib Qhov Kev Pabcuam Ntiaj Teb No ( PGA ) yog thaj chaw nco uas muaj cov ntaub ntawv thiab tswj cov ntaub ntawv rau cov txheej txheem server. Nws yog ib cheeb tsam uas tsis muaj kev nco uas tsim los ntawm Oracle thaum pib txheej txheem server. Nkag mus rau lub PGA yog tshwj xeeb rau cov txheej txheem server thiab nws tsuas yog nyeem thiab sau los ntawm Oracle code ua rau nws sawv cev.

Tsis tas li ntawd, SGA hauv Oracle yog dab tsi? Nyob rau hauv lub database tswj systems tsim los ntawm lub Oracle Corporation, System ntiaj teb no cheeb tsam ( SGA ) ua ib feem ntawm qhov system nco (RAM) sib koom los ntawm tag nrho cov txheej txheem teej tug mus rau ib leeg Oracle database piv txwv. Cov SGA muaj tag nrho cov ntaub ntawv tsim nyog rau kev ua haujlwm piv txwv.

Tsis tas li ntawd, PGA thiab SGA yog dab tsi hauv Oracle?

Basic Memory Structures Lub SGA yog ib pawg ntawm kev sib koom ua ke nco, hu ua SGA Cheebtsam, uas muaj cov ntaub ntawv thiab tswj cov ntaub ntawv rau ib qho Oracle Database piv txwv. A PGA yog ib cheeb tsam nonshared nco uas muaj cov ntaub ntawv thiab tswj cov ntaub ntawv tsuas yog siv los ntawm ib qho Oracle txheej txheem.

Pga_aggregate_target yog dab tsi?

PGA_AGGREGATE_TARGET yog ib qho kev pib pib qhov ntsuas thiab tswj tag nrho cov txiaj ntsig ntawm kev ua tiav lub cim xeeb uas tuaj yeem faib los ntawm Oracle rau Cov Txheej Txheem Ntiaj Teb (PGA) PGA_AGGREGATE_TARGET = (TOTAL_MEM * 80%) * 50% Tag Nrho Memory ntawm no yog hais txog tag nrho cov cim xeeb muaj nyob hauv lub kaw lus.

Pom zoo: