oracle?????

????1??oracle?????SGA+PGA??????
????2??oracle??????????
??????????????????????????ɡ??????????????????????????????е?????????????

????oracle????????
????1)???????????????????Oracle?????
????2)????ó??????????????????????У?????Oracle?????????????????????????????
????3)????????????Oracle???????????????????????????????????????????
????4)?????????????
????5)??????????????sql?????鹲???????????????sql???????У???????????????????????????????????μ?sql???????????????sql???
????6)???????????????????????SGA??????????????
????7)??????????????SGA?и????????????DBWN???????????????1????????д??????????LGWR?????????????м??????
????8)?????????????????????????????????ó????С?
????3??oracle??????
????i??oracle????????oracle??????oracle?????ɡ?
????ii??oracle??????????????????????????????????ü??????????????????
????iii??oracle??????????????????????????????ɡ?
????4??oracle???
????i??Oracle?????????????????????
????ii?????Oracle???????????????????楨??????????
????iii??Oracle???????????SGA??PGA??
????????????????????SGA??
????????????????????????PGA??
???????????￡?SGA:PGA=8:1??????檔
????iiii??Oracle??????????????SMON??PMON??DBWR??LGWR??ARC??CKPT???
????5??SGA(System Global Area): ???????
????i0???????????洢??SGA??????????????????
????i1??SGA??????????????????????????????????Large???Java???Stream???
????i2???????
????1)??????????SQL??PL/SQL?????????????????????е????????
???????????SELECT * FROM emp?????????sql????????????->????->??????м??->??????м???????Щ???????????????????????????SELECT * FROM emp???????????????в?????????????sql???????????????????????м??????????????????????м????????????????????????????oracle???Ч?????а?????