oracle一事务的完整流程分析.docVIP

oracleò???ê???μ?íê??á÷3ì·??? ?úoracle?í?§??ó?·t?????¨á￠á??óμ?￡?2￠°????óìá????oracle·t????ò??°·???1y￡? 2???è???￡o/wyzxg/archive/2010/08/16/5815335.aspx ??ìì?÷òa·?????oracle·t????3ìè?o?′|àíó??§??3ìμ????ó oracle·t????3ìè?o?′|àíó??§??3ìμ????ó ·t???÷??3ì?úíê3éó??§??3ìμ????ó1y3ì?D￡??÷òaíê3éè???7??è???￡o 0.sqló???μ??a?? êy?Y?éμ??áè?db buffer ??è??? ?aê????¨á￠??1??? ±?ê???DT??êy?Y?é ·?è?dirty list ó??§commit?òrollback 0.sqló???μ??a?? ????òa?2oracle·t???÷??3ìè??é′|àíó??§??3ìμ????ó￡?μ±ò?ó??§??3ììá??ò???sqlê±￡oupdate temp set a=a*2￡?ê×?èoracle·t???÷??3ì′óó??§??3ì°?D??￠?óê?μ?oó￡??úPGA?D?íòa′???3ì·????ùDè?ú′?￡?′?′￠?à1?μ?D??￠￡?è??ú?á?°?ú′?′?′￠?à1?μ?μ???D??￠μè￡?·t???÷??3ì°??a??sqló???μ?×?·?×a?ˉ?aASCIIμèD§êy×???￡??ó×??a??ASCII??±?′?μY??ò???HASHoˉêy￡?2￠·μ??ò???hash?μ￡?è?oó·t???÷??3ì??μ?shared pool?Dμ?library cache?Dè￥2é?òê?·?′??ú?àí?μ?hash?μ￡?è?1?′??ú￡?·t???÷??3ì??ê1ó??aì?ó???ò????ù?o′??úSHARED POOLμ?library cache?Dμ?ò?·???1yμ?°?±?à′?′DD￡?è?1?2?′??ú￡?·t???÷??3ì???úCGA?D￡???o?UGA?úèY??sql￡???DDó?·¨·???￡?ê×?è?ì2éó?·¨μ??yè·D?￡??ó×???ó????Dé??°μ?±í￡??÷òy￡?êóí?μè???ó??DD?a??￡?2￠????êy?Y×?μ??ì2é?aD????óμ???3?ò??°?à1??á11￡?2￠?ù?YORACLE??ó?μ?ó??ˉ?￡ê?ò??°êy?Y×?μ??Dê?·?′??ú?àó|???óμ?í3??êy?Yoíê?·?ê1ó?á?′?′￠′ó?ùà′éú3éò????′DD?????ò′ó′?′￠′ó?ù?D??ó?ò????′DD????￡?è?oó?ùó?êy?Y×?μ?o???′?ó??§???àó|???óμ??′DDè¨?T￡?×?oóéú3éò???±àò?′ú???￡ORACLE???aì?sqló???μ?±?éíêμ?ê??±??￠HASH?μ?￠±àò?′ú???￠ó?′?ó????à1?áaμ?è?o?í3??êy?Yoí??ó???μ??′DD?????o′??úSHARED POOLμ?library cache?D?￡·t???÷??3ìí¨1ySHARED POOL ??′??÷￡¨shared pool latch￡?à′éê???éò??ò??D?12?íPL/SQL???D?o′??a′??úèY￡?ò2?íê??μ±?SHARED POOL??′??÷???¨μ?PL/SQL???Dμ??é2??é±??2??￡?òò?a?aD??é?é?ü±????ü??3ì?ùê1ó??￡?úSQL·????×????ó?μ?LIBRARY CACHE￡?′óêy?Y×?μ??Do???±í?￠êóí?μè?á11μ?ê±oò￡?Dèòa??êy?Y×?μ?′ó′??ì?áè?LIBRARY CACHE￡?òò′?￡??ú?áè????°ò2òaê1ó?LIBRARY CACHE??′??÷￡¨library cache pin￡?library cache lock￡?à′éê??ó?óú?o′?êy?Y×?μ??￡ μ????ú?a?1￡??a??sqló???ò??-±?±àò?3é?é?′DDμ?′ú??á?￡?μ??12??aμàòa2ù×÷??D?êy?Y￡??ùò?·t???÷??3ì?1òa?a?a??sql×?±??¤′|àíê