Qhov chaw Oracle yog dab tsi?
Qhov chaw Oracle yog dab tsi?

Video: Qhov chaw Oracle yog dab tsi?

Video: Qhov chaw Oracle yog dab tsi?
Video: Yog hmoov dab tsi - Gao Nou Kue ft. Mang Vang (Official Music Video) New song 2020 2024, Kaum ib hlis
Anonim

Tablespaces yog tus choj ntawm qee yam ntawm lub cev thiab cov laj thawj ntawm cov Oracle database. Tablespaces yog qhov chaw koj khaws Oracle database khoom xws li rooj , indexes thiab rollback ntu. Koj tuaj yeem xav txog ib rooj zoo li ib qho kev sib koom disk drive hauv Windows.

Hais txog qhov no, dab tsi yog tablespace hauv Oracle nrog piv txwv?

Ib Oracle database yog suav nrog ib lossis ntau qhov chaw cia khoom hu ua cov rooj zaum . Ib tug database cov ntaub ntawv yog collectively khaws cia rau hauv datafiles uas tsim txhua rooj ntawm lub database. Rau piv txwv , qhov yooj yim tshaj plaws Oracle database yuav muaj ib tug rooj thiab ib datafile.

Qhov thib ob, qhov chaw nyob hauv SQL yog dab tsi? A qhov chaw rooj yog ib tug cia qauv, nws muaj rooj , indexes, cov khoom loj, thiab cov ntaub ntawv ntev. Nws tuaj yeem siv los teeb tsa cov ntaub ntawv hauv cov ntaub ntawv mus rau hauv cov ntaub ntawv khaws cia uas cuam tshuam nrog qhov twg cov ntaub ntawv khaws cia rau hauv qhov system.

Ntxiv mus, koj yuav nrhiav tau qhov chaw hauv lub rooj li cas?

Txhawm rau kom tau txais cov rooj zaum rau tag nrho Oracle rooj hauv ib lub tsev qiv ntawv tshwj xeeb: SQL> xaiv table_name, tablespace_name los ntawm all_tables qhov twg tus tswv = 'USR00'; Kom tau txais cov rooj rau ib qho Oracle Performance index: SQL> xaiv tablespace_name los ntawm all_indexes qhov twg tus tswv = 'USR00' thiab index_name = 'Z303_ID';

Oracle cov rooj khaws cia nyob qhov twg?

Yog li Oracle rooj (lawv txhais thiab lawv cov ntaub ntawv) yog khaws cia hauv cov rooj zaum. Tablespaces, nyob rau hauv lem, yog khaws cia hauv cov ntaub ntawv. Feem ntau cov ntaub ntawv muaj "DBF" txuas ntxiv thiab nyob rau hauv cov chaw xaiv (feem ntau yog "ORADATA" folder). Kuv qhia koj kom mus saib lub Oracle database references kom paub meej ntxiv.

Pom zoo: