????14??10g?е????SGA????
????i?????SGA???????ASMM??Automatic Shared Memory Management????SGA???????????С?????????????9i???????????SGA?е???????????С??
????ii???????ó????????statistics_level?typical??all??????????ASMM???????????10g????????μ?????????sga_target????????????SGA???С??
????iii??????10g??????μ???????MMAN????memory manager????????????SGA?????
????iiii?????????????????MMON????memory monitor????????????????????
????15??11g?е??????????
????i1??????????????AMM??Automatic Memory Management????Oracle??????????????????????С?????????????10g???????????SGA??PGA???С??
????i2???????????statistics_level?typical??all??????????AMM??
????show parameter statistics_level; --??AMM
????show parameter memory; --??????oracle??????????
????alter system set memory_max_target=900m;--???????????????
????i3???μ?????????memory_target?????????????????С????SGA????PGA??????С??
????alter system set memory_target=500m; --memory_target?????????????memory_max_target
????i4???μ?????????memory_max_target????????memory_target???????????
????alter system set memory_max_target=900m scope=spfile; --?′??????Ч??scope=spfile????????????
????i5???????????AMM????sga_target??pga_aggregate_target?????????ó?0??
????show parameter sga_target;
????show parameter page_aggregate_target;
????alter system set sga_target=0m;
????alter system set pag_aggregate_target=0;
????i6??11g?е???????MMAN???????????????????
????16??oracle??????
????i??Oracle?????????????????????Щ?????????????????????洢????
????ii??Oracle ??????????????????????
???????????????????е??????????????
?????????????????????γ?????????????????
????17???????
?????????????Oracle??????????????????????????????????D:devoracleproduct10.2.0oradataorcl??????в??????????????в???????????????????????????????????????????????
????1)????????????????????
????i??????????????????????洢????????????????????????
????ii????????????????????????????????????????????
????iii????????????????????????????????????????????????
????????????Щ????????????????????У???????н???????
????2)????????????????????
???????????????????????澯???????????鵵?????????????????
??????????????pfile?????spfile?????λ??ORACLE_HOMEDATABASE???￡?9i??????????sfile???????spfileorcl.ora?????
?????????????sys???????λ??ORACLE_HOMEDATABASE???￡???pwdorcl.ora?????
??????????й鵵?????archive log list??
????ORACLE_HOME: D:devoracleproduct10.2.0db_1
????????????Щ???????????????????????У?????????н???????
????18???????
????????????????????????????????????ɡ?
????Oracle ???????????????????->????->??->??->?????->????
????19??????
????i1??????????????д???????λ????? Oracle ????????????????????????SYSTEM????????
????i2?????????????????????????????????????????????????????????????
????i3????????С?????????????????????????С????
????i4????????????????
????CREATE TABLESPACE tablespacename
????DATAFILE 'filename' [SIZE integer [K|M]]
????[AUTOEXTEND [OFF|ON]];
????i5????????
????1)???????????±???(??v$tablespace?в?)??SYSTEM??SYSAUX??TEMP??UNDOTBS1??USERS??EXAMPLE??
????2)??SYSTEM????????????????????????????SYSTEM???仵???Oracle??????????
????3)??SYSAUX??10g?????????SYSTEM????????????????SYSTEM???????? ??????????????е??Щ???????????SYSAUX????????????磬???SYSTEM??????LogMiner?????SYSTEM??????Logical Standby??Spatial?????DRSYS??????Oracle Text???
????i6??TEMP??????????????????????????????????????????????????????Oracle????е?????????н??С?
????UNDOTBS1???????????UNDO???????????????????DML?????У????????????
????USERS??????????????
????EXAMPLE?????????????????漰???????????
????i7??select * from dba_data_files;--?????????????
????select * from v$tablespace;--??????
????20???Ρ????????????
????i???Σ?ASSM ????δ洢????
????1)?????????????????洢???????????????ɡ?
????2)??????????洢??????????????η?????????????????????Ρ??????Ρ?????κ?????Ρ?
????ii????
????1)??????η??????????????????????ɡ?
????2)???????е????п?????????????????????η????????????
????3)????????????????????????????????????????С?
????iii???????
????1)?????????Oracle??????????????????д???С?洢?????
????2)??Oracle????????????????λ?????????????洢???
????3)??show  parameter db_block_size; --????????С
????iiii??????????????
????1)???????????????????????????????
????2)?????????????????????????????????С????????????