oracle?????
???????????? ???????[ 2016/6/6 13:47:30 ] ????????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???Ч?????а?????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11