????2)???????????????????仺????ɡ?
????3)?????????С?????????????????
????i3???????????
????1)??????洢?????????????ж?????????????????????
????2)?????????????????????????????????????У??????????????????Щ???????????????????????????????????????????????
????3)??????????????С??????????????????????
????4)????????????????е????????η??????????
????i????????????????????????????????????Ч???????
????ii????????????????????????????????????????а???????????????′ζ?????????????????????????????л???????????????????
????i4???????????
????1)????????????????????????????????????????????????????
????2)?????????????????????????????????????????????????д?????????С?
????3)???????????????????????????????????С??
????eg??UPDATE emp SET empno=7935 WHERE empno=7934;???????????????б????????????(??????????????????????е?????1M ???????3?? ??????????????????????????????????????????????)????????????е???Щ???д??????????????
????i5??Large??
?????????д???????????????????????????????????????IO?????????в?????
????i6??Stream??
???????stream??????????????????????????????
????i7??JAVA??
???????java??????????????
????7??PGA(Process Global Area): ?????????
????i0???????????(PGA)???????????????????????????????????????????session?????SQL??????????????session???п?????????????????session???????????hash???????????????PGA?е???檔
????i1??PGA?????????????????????????????????????????????????Oracle?????????????????????????
????i2?????????????????????????PGA????????????
???????????£??????????????????????????????????????????潲??
????8??oracle???????????????????????(????????????????????)?????????
????i???????????????????oracle?????????н??????????????????????ó????????????????????????????????????????????????????λ?????????????????????????λ??????????
????ii??????????????????????????????????????????????????????oracle??????????????????????????????????
????iii???????????Oracle???????????????????Э???????????????????Oracle????????????????к???????
????10???????????????????
????i???????????????????????????????????ó???????sql*plus??????????????????????????oracle??????????????????????????????????????????????÷?????????????????????????????????????и??????????????????????9i??10g??11g?????????????
????ii????????????????????????????????????
????iii??SGA??????????????PGA???????
????11????
????i0??????????? Oracle ???????????????
????i1?????????????????????????????
????i2??????????????????????????
????i3????v$session?в?????????SELECT * FROM v$session;
????12?????????
????i0??PMON ?????????????????????????????
????1)?????????????????
????2)????????е?????????????
????3)????????????????????
????i1??SMON ??????????????????oracle?????
????1)????????????????′??????????????????
????2)???????????????????????????????????????
????3)????????????????Ρ?
????i2??DBWR ????д?????
????1)???????????????????????ù???鱣????????С?
????2)??????????????????д??????????С?
????i3??LGWR ???д?????
????1)????????????????е????????д??????????
????2)?????ж???????????y??????????????????д???????
????i4??CKPT???????
????1)?????????????????????????????????????
????2)?????????????????????????????
????3)????????????????????????±???????
????1?????????alter system checkpoint??
????2??????shutdown abort????????????????????????
????3)?????????????????
????1?????????
????2??????????л???
????DBWR??LGWR??CKPT??????Э?????????
????i5???????????
????1)????v$process?в????????????????
????2)????????????DBWR????
????select * from v$process where program like '%DBW%';
??????DBWR???????: show parameter db_wr??DBWR?????????????????????????????
???????DBWR???????:
????alter system set db_writer_processes=3 scope=memory; --??"???????????????????"????
????alter system set db_writer_processes=3 scope=spfile;--????????′?????????Ч
????3)????????????ARC????
????select * from v$process where program like '%ARC%';
????13??9i?е????PGA????
????i???????????????ó????????workarea_size_policy?AUTO??
????ii?????PGA?????DBA?????????????????????????е?session???????????PGA??????С???????????ó?????????pga_aggregate_target??Oracle????????????session??PGA???С??