Qhov system tablespace muaj dab tsi hauv Oracle?
Qhov system tablespace muaj dab tsi hauv Oracle?

Video: Qhov system tablespace muaj dab tsi hauv Oracle?

Video: Qhov system tablespace muaj dab tsi hauv Oracle?
Video: HEALTHMATTERS: THAM TXOG QHOV SYSTEM UA KOM YUAG THIAB NOJ QAB NYOB ZOO NROG MAIV VAJ. 2024, Hlis ntuj nqeg
Anonim

Ib Oracle database muaj ib lossis ntau qhov chaw cia khoom hu ua cov rooj zaum , uas collectively khaws tag nrho cov database cov cov ntaub ntawv. Txhua rooj hauv ib Oracle database muaj ib lossis ntau cov ntaub ntawv hu ua datafiles, uas yog cov qauv ntawm lub cev uas ua raws li kev khiav haujlwm qhov system hauv qhov twg Oracle yog khiav.

Ib yam li ntawd, kev siv qhov system tablespace hauv Oracle yog dab tsi?

System tablespace yog a rooj uas khaws tag nrho cov ntaub ntawv phau ntawv txhais lus nyob rau hauv database thiab nws yog tsim thaum lub sij hawm tsim database. Qhov no rooj yog ib txwm thiab yuav tsum nyob online rau database qhib.

Ib yam li ntawd, tablespace yog dab tsi hauv Oracle nrog piv txwv? Ib Oracle database yog suav nrog ib lossis ntau qhov chaw cia khoom hu ua cov rooj zaum . Cov ntaub ntawv database yog khaws cia rau hauv cov ntaub ntawv cov ntaub ntawv uas ua rau txhua tus rooj ntawm lub database. Rau piv txwv , qhov yooj yim tshaj plaws Oracle database yuav muaj ib tug rooj thiab ib tug datafile.

Ib yam li ntawd, koj tuaj yeem nug, System thiab Sysaux tablespace hauv Oracle yog dab tsi?

SYSTEM thiab SYSAUX Tablespaces . Cov SYSTEM tablespace yog siv rau kev ua haujlwm tseem ceeb (piv txwv li, cov ntaub ntawv phau ntawv txhais lus). Tus pab SYSAUX tablespace yog siv rau cov khoom siv database ntxiv (xws li Enterprise Manager Repository). Txhua Oracle database muaj a SYSTEM tablespace thiab a SYSAUX tablespace.

Sysaux tablespace muaj dab tsi?

SYSAUX tablespace . Cov SYSAUX tablespace muab kev khaws cia ntawm cov rooj sib tham tsis yog sys thiab indexes uas ib txwm muab tso rau hauv SYSTEM rooj . Piv txwv li, cov ntxhuav thiab indexes uas yav tas los muaj los ntawm cov neeg siv system tam sim no tau teev tseg rau a SYSAUX tablespace.

Pom zoo: