{\rtf1\adeflang1025\ansi\ansicpg1252\uc1\adeff0\deff0\stshfdbch0\stshfloch0\stshfhich0\stshfbi0\deflang1033\deflangfe1042{\fonttbl{\f0\froman\fcharset0\fprq2{\*\panose 02020603050405020304}Times New Roman;}{\f1\fswiss\fcharset0\fprq2{\*\panose 020b0604020202020204}Arial;} {\f2\fmodern\fcharset0\fprq1{\*\panose 02070309020205020404}Courier New;}{\f3\froman\fcharset2\fprq2{\*\panose 05050102010706020507}Symbol;}{\f10\fnil\fcharset2\fprq2{\*\panose 05000000000000000000}Wingdings;} {\f36\fswiss\fcharset0\fprq2{\*\panose 020b0604030504040204}Tahoma;}{\f37\fswiss\fcharset0\fprq2{\*\panose 020b0506020202030204}Arial Narrow;}{\f38\froman\fcharset0\fprq2{\*\panose 00000000000000000000}TheSansMonoConNormal;} {\f39\fswiss\fcharset0\fprq2{\*\panose 020b0603020202020204}Trebuchet MS;}{\f40\fswiss\fcharset0\fprq2{\*\panose 00000000000000000000}CommonBullets;}{\f56\froman\fcharset238\fprq2 Times New Roman CE;}{\f57\froman\fcharset204\fprq2 Times New Roman Cyr;} {\f59\froman\fcharset161\fprq2 Times New Roman Greek;}{\f60\froman\fcharset162\fprq2 Times New Roman Tur;}{\f61\fbidi \froman\fcharset177\fprq2 Times New Roman (Hebrew);}{\f62\fbidi \froman\fcharset178\fprq2 Times New Roman (Arabic);} {\f63\froman\fcharset186\fprq2 Times New Roman Baltic;}{\f64\froman\fcharset163\fprq2 Times New Roman (Vietnamese);}{\f66\fswiss\fcharset238\fprq2 Arial CE;}{\f67\fswiss\fcharset204\fprq2 Arial Cyr;}{\f69\fswiss\fcharset161\fprq2 Arial Greek;} {\f70\fswiss\fcharset162\fprq2 Arial Tur;}{\f71\fbidi \fswiss\fcharset177\fprq2 Arial (Hebrew);}{\f72\fbidi \fswiss\fcharset178\fprq2 Arial (Arabic);}{\f73\fswiss\fcharset186\fprq2 Arial Baltic;}{\f74\fswiss\fcharset163\fprq2 Arial (Vietnamese);} {\f76\fmodern\fcharset238\fprq1 Courier New CE;}{\f77\fmodern\fcharset204\fprq1 Courier New Cyr;}{\f79\fmodern\fcharset161\fprq1 Courier New Greek;}{\f80\fmodern\fcharset162\fprq1 Courier New Tur;} {\f81\fbidi \fmodern\fcharset177\fprq1 Courier New (Hebrew);}{\f82\fbidi \fmodern\fcharset178\fprq1 Courier New (Arabic);}{\f83\fmodern\fcharset186\fprq1 Courier New Baltic;}{\f84\fmodern\fcharset163\fprq1 Courier New (Vietnamese);} {\f416\fswiss\fcharset238\fprq2 Tahoma CE;}{\f417\fswiss\fcharset204\fprq2 Tahoma Cyr;}{\f419\fswiss\fcharset161\fprq2 Tahoma Greek;}{\f420\fswiss\fcharset162\fprq2 Tahoma Tur;}{\f421\fbidi \fswiss\fcharset177\fprq2 Tahoma (Hebrew);} {\f422\fbidi \fswiss\fcharset178\fprq2 Tahoma (Arabic);}{\f423\fswiss\fcharset186\fprq2 Tahoma Baltic;}{\f424\fswiss\fcharset163\fprq2 Tahoma (Vietnamese);}{\f425\fswiss\fcharset222\fprq2 Tahoma (Thai);}{\f426\fswiss\fcharset238\fprq2 Arial Narrow CE;} {\f427\fswiss\fcharset204\fprq2 Arial Narrow Cyr;}{\f429\fswiss\fcharset161\fprq2 Arial Narrow Greek;}{\f430\fswiss\fcharset162\fprq2 Arial Narrow Tur;}{\f433\fswiss\fcharset186\fprq2 Arial Narrow Baltic;} {\f439\froman\fcharset161\fprq2 TheSansMonoConNormal Greek;}{\f446\fswiss\fcharset238\fprq2 Trebuchet MS CE;}{\f447\fswiss\fcharset204\fprq2 Trebuchet MS Cyr;}{\f449\fswiss\fcharset161\fprq2 Trebuchet MS Greek;} {\f450\fswiss\fcharset162\fprq2 Trebuchet MS Tur;}{\f453\fswiss\fcharset186\fprq2 Trebuchet MS Baltic;}}{\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0; \red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;\red128\green0\blue128;\red128\green0\blue0;\red128\green128\blue0;\red128\green128\blue128;\red192\green192\blue192;}{\stylesheet{ \ql \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs24\alang1025 \ltrch\fcs0 \fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext0 Normal;}{ \s1\ql \li0\ri0\sb360\sa120\keepn\widctlpar\wrapdefault\faauto\outlinelevel0\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af1\afs36\alang1025 \ltrch\fcs0 \b\f1\fs36\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext0 heading 1;}{ \s2\ql \li0\ri0\sb360\sa120\keepn\widctlpar\wrapdefault\faauto\outlinelevel1\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af0\afs29\alang1025 \ltrch\fcs0 \b\fs29\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext0 heading 2;}{ \s3\ql \li0\ri0\sb360\sa120\keepn\widctlpar\wrapdefault\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af37\afs25\alang1025 \ltrch\fcs0 \b\f37\fs25\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext0 heading 3;}{ \s4\ql \li0\ri0\sb360\sa120\keepn\widctlpar\wrapdefault\faauto\outlinelevel3\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af0\afs24\alang1025 \ltrch\fcs0 \b\fs24\expnd-1\expndtw-6\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext0 heading 4;}{\s5\ql \li0\ri0\sb240\sa60\widctlpar\wrapdefault\faauto\outlinelevel4\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af37\afs22\alang1025 \ltrch\fcs0 \b\f37\fs22\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext0 heading 5;}{\* \cs10 \additive Default Paragraph Font;}{\* \ts11\tsrowd\trftsWidthB3\trpaddl108\trpaddr108\trpaddfl3\trpaddft3\trpaddfb3\trpaddfr3\trcbpat1\trcfpat1\tblind0\tblindtype3\tscellwidthfts0\tsvertalt\tsbrdrt\tsbrdrl\tsbrdrb\tsbrdrr\tsbrdrdgl\tsbrdrdgr\tsbrdrh\tsbrdrv \ql \li0\ri0\widctlpar\wrapdefault\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs20 \ltrch\fcs0 \fs20\lang1024\langfe1024\cgrid\langnp1024\langfenp1024 \snext11 \ssemihidden Normal Table;}{ \s15\ql \fi567\li0\ri0\sb60\sa60\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af1\afs20\alang1025 \ltrch\fcs0 \f1\fs20\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \snext15 \sautoupd Story Text;}{ \s16\qr \li0\ri0\sa120\keepn\pagebb\widctlpar\wrapdefault\faauto\outlinelevel0\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af1\afs48\alang1025 \ltrch\fcs0 \shad\f1\fs48\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon15 \snext16 \sautoupd Story Chapter;}{\s17\ql \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af2\afs24\alang1025 \ltrch\fcs0 \f2\fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext17 Plain Text;}{ \s18\ql \li0\ri0\sb60\sa60\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af1\afs20\alang1025 \ltrch\fcs0 \f1\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext18 \sautoupd base text;}{\s19\ql \li0\ri0\sb60\sa60\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af1\afs20\alang1025 \ltrch\fcs0 \f1\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext19 \sautoupd aw base text;}{\s20\ql \li567\ri0\sb60\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0 \rtlch\fcs1 \af2\afs18\alang1025 \ltrch\fcs0 \f2\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon21 \snext20 \sautoupd aw code start;}{\s21\ql \li567\ri0\widctlpar \tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0 \rtlch\fcs1 \af2\afs18\alang1025 \ltrch\fcs0 \f2\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon19 \snext21 \sautoupd aw code body;}{ \s22\ql \li567\ri0\sa60\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0 \rtlch\fcs1 \af2\afs18\alang1025 \ltrch\fcs0 \f2\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon21 \snext22 \sautoupd aw code end;}{\*\cs23 \additive \b\i aw emphasis;}{\s24\qr \li0\ri0\sa480\pagebb\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\outlinelevel0\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af1\afs48\alang1025 \ltrch\fcs0 \shad\f1\fs48\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon19 \snext24 \sautoupd aw chapter;}{\s25\ql \li0\ri0\sb120\sa120\widctlpar \tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\outlinelevel1\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af1\afs36\alang1025 \ltrch\fcs0 \b\f1\fs36\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon19 \snext25 \sautoupd aw heading 1;}{\s26\ql \li0\ri0\sb120\sa120\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ai\af1\afs28\alang1025 \ltrch\fcs0 \i\f1\fs28\ul\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon19 \snext26 \sautoupd aw heading 2;}{\s27\qr \li0\ri0\sa480\widctlpar \tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\outlinelevel0\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af1\afs48\alang1025 \ltrch\fcs0 \shad\caps\f1\fs48\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon24 \snext27 \sautoupd aw chapter title;}{\s28\ql \fi-360\li360\ri0\sb60\sa60\widctlpar\jclisttab\tx360\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault{\*\pn \pnlvlbody\ilvl0\ls11\pnrnot0\pndec } \faauto\ls11\adjustright\rin0\lin360\itap0 \rtlch\fcs1 \af1\afs20\alang1025 \ltrch\fcs0 \f1\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon19 \snext28 \sautoupd aw list body;}{\s29\ql \fi-357\li357\ri0\sb120\sa60\widctlpar \jclisttab\tx360\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault{\*\pn \pnlvlbody\ilvl0\ls11\pnrnot0\pndec }\faauto\ls11\adjustright\rin0\lin357\itap0 \rtlch\fcs1 \af1\afs20\alang1025 \ltrch\fcs0 \f1\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon28 \snext29 \sautoupd aw list start;}{\s30\ql \fi-357\li357\ri0\sb60\sa120\widctlpar\jclisttab\tx360\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault{\*\pn \pnlvlbody\ilvl0\ls11\pnrnot0\pndec }\faauto\ls11\adjustright\rin0\lin357\itap0 \rtlch\fcs1 \af1\afs20\alang1025 \ltrch\fcs0 \f1\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon28 \snext30 \sautoupd aw list end;}{ \s31\ql \li0\ri0\sb60\sa60\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af1\afs20\alang1025 \ltrch\fcs0 \f1\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon19 \snext31 \sautoupd aw table body;}{\s32\qc \li0\ri0\sb480\sa480\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\outlinelevel0\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ai\af1\afs48\alang1025 \ltrch\fcs0 \i\shad\f1\fs48\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon24 \snext32 aw figure holder;}{\*\cs33 \additive \rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i \sbasedon10 aw quoted;}{\s34\ql \li567\ri567\sb60\sa60\widctlpar \tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin567\lin567\itap0 \rtlch\fcs1 \ai\af1\afs20\alang1025 \ltrch\fcs0 \i\f1\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon19 \snext34 aw sidebar;}{ \s35\ql \li0\ri0\sb120\sa120\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ai\af1\afs24\alang1025 \ltrch\fcs0 \i\f1\fs24\ul\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon26 \snext35 aw heading 3;}{\s36\ql \li567\ri0\sb60\sa60\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0 \rtlch\fcs1 \af2\afs18\alang1025 \ltrch\fcs0 \f2\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon21 \snext36 aw code one-line;}{\s37\ql \li0\ri0\sa120\widctlpar\tqc\tx4153\tqr\tx8306\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs24\alang1025 \ltrch\fcs0 \fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext37 header;}{\s38\ql \li0\ri0\sa120\widctlpar\tqc\tx4153\tqr\tx8306\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs24\alang1025 \ltrch\fcs0 \fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext38 footer;}{\*\cs39 \additive \rtlch\fcs1 \af0 \ltrch\fcs0 \sbasedon10 page number;}{\*\cs40 \additive \rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i \sbasedon10 Emphasis;}{ \s41\ql \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \cbpat9 \rtlch\fcs1 \af36\afs24\alang1025 \ltrch\fcs0 \f36\fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext41 Document Map;}{ \s42\ql \fi360\li0\ri0\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext42 Body Text;}{ \s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon42 \snext43 Body Text First;}{ \s44\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext42 Body Text Cont;}{ \s45\ql \fi-576\li576\ri0\sb120\sa120\sl-260\slmult0\keep\widctlpar\tx216\tx576\wrapdefault\faauto\adjustright\rin0\lin576\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext45 Bullet;}{\s46\ql \fi-576\li576\ri0\sb240\sa120\sl-260\slmult0\keep\widctlpar\tx216\tx576\wrapdefault\faauto\adjustright\rin0\lin576\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon45 \snext45 Bullet First;}{\s47\ql \fi-576\li576\ri0\sb120\sa240\sl-260\slmult0\keep\widctlpar\tx216\tx576\wrapdefault\faauto\adjustright\rin0\lin576\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon45 \snext42 Bullet Last;}{\s48\ql \li0\ri0\sb360\sa360\sl-280\slmult0\nowidctlpar\brdrt\brdrs\brdrw10\brsp200 \brdrb\brdrs\brdrw10\brsp200 \wrapdefault\faauto\adjustright\rin0\lin0\rtlgutter\itap0 \rtlch\fcs1 \af37\afs21\alang1025 \ltrch\fcs0 \f37\fs21\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext42 Note/Tip/Caution;}{\s49\ql \li0\ri144\sl-240\slmult0 \widctlpar\wrapdefault\faauto\adjustright\rin144\lin0\itap0 \rtlch\fcs1 \ab\af38\afs20\alang1025 \ltrch\fcs0 \b\f38\fs20\cf13\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon0 \snext49 Code Bold;}{ \s50\ql \li0\ri0\sa240\keepn\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af1\afs28\alang1025 \ltrch\fcs0 \b\caps\f1\fs28\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext51 Chapter Number;}{ \s51\ql \li0\ri0\sb480\sa480\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af1\afs60\alang1025 \ltrch\fcs0 \b\f1\fs60\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext0 Chapter Title;}{ \s52\ql \li0\ri0\sb240\sa240\sl-280\slmult0\widctlpar\tx576\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ai\af0\afs22\alang1025 \ltrch\fcs0 \i\fs22\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \snext42 Figure Caption;}{ \s53\ql \li0\ri0\sb240\sa120\sl-280\slmult0\widctlpar\tx576\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ai\af0\afs22\alang1025 \ltrch\fcs0 \i\fs22\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon52 \snext54 Code Caption;}{\s54\ql \li0\ri144\sb160\sl-240\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin144\lin0\itap0 \rtlch\fcs1 \af38\afs20\alang1025 \ltrch\fcs0 \f38\fs20\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon0 \snext0 Code First;}{\s55\ql \li0\ri144\sb160\sl-240\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin144\lin0\itap0 \rtlch\fcs1 \ab\af38\afs20\alang1025 \ltrch\fcs0 \b\f38\fs20\cf13\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon54 \snext55 Code First Bold;}{\s56\ql \li0\ri144\sa160\sl-240\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin144\lin0\itap0 \rtlch\fcs1 \af38\afs20\alang1025 \ltrch\fcs0 \f38\fs20\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon0 \snext42 Code Last;}{\s57\ql \li0\ri144\sa160\sl-240\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin144\lin0\itap0 \rtlch\fcs1 \ab\af38\afs20\alang1025 \ltrch\fcs0 \b\f38\fs20\cf13\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon56 \snext57 Code Last Bold;}{\s58\ql \fi-1152\li1152\ri0\sb120\sa120\widctlpar\tx792\tx1080\wrapdefault\faauto\adjustright\rin0\lin1152\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon59 \snext0 Num Sub List;}{\s59\ql \fi-1152\li1152\ri0\sb120\sa120\widctlpar\tx792\tx1080\wrapdefault\faauto\adjustright\rin0\lin1152\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext59 Bullet Sub List;}{\s60\ql \fi-576\li576\ri0\sb120\sa240\sl-260\slmult0\keep\widctlpar\tx216\tx576\wrapdefault\faauto\adjustright\rin0\lin576\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext0 Num List;}{\s61\ql \li0\ri144\sl-240\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin144\lin0\itap0 \rtlch\fcs1 \af38\afs20\alang1025 \ltrch\fcs0 \f38\fs20\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon49 \snext61 Code;}{\s62\ql \fi-360\li360\ri0\sb120\sl-260\slmult0\keep\widctlpar\tx216\tx576\wrapdefault\faauto\adjustright\rin0\lin360\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon46 \snext62 Bibliography;}{\s63\ql \fi-720\li720\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin720\itap0 \rtlch\fcs1 \af0\afs24\alang1025 \ltrch\fcs0 \fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext0 \sautoupd index 1;}{\s64\ql \fi-432\li720\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin720\itap0 \rtlch\fcs1 \af0\afs24\alang1025 \ltrch\fcs0 \fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext0 \sautoupd index 2;}{\s65\ql \fi-144\li720\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin720\itap0 \rtlch\fcs1 \af0\afs24\alang1025 \ltrch\fcs0 \fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext0 \sautoupd index 3;}{\s66\ql \li0\ri0\sb240\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af1\afs28\alang1025 \ltrch\fcs0 \b\f1\fs28\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext63 Index Letter;}{\s67\ql \li0\ri0\sb120\sl360\slmult1\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af39\afs22\alang1025 \ltrch\fcs0 \b\f39\fs22\expnd-1\expndtw-6\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext42 Part Opener Text;}{\s68\ql \li288\ri288\sb240\widctlpar\wrapdefault\faauto\adjustright\rin288\lin288\itap0 \rtlch\fcs1 \af38\afs20\alang1025 \ltrch\fcs0 \f38\fs20\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \snext68 SB Code First;}{\s69\ql \fi-576\li576\ri0\sb120\sa240\sl-260\slmult0\keep\widctlpar\tx216\tx576\wrapdefault\faauto\adjustright\rin0\lin576\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext69 Num List Last;}{\s70\ql \fi-576\li576\ri0\sb240\sa120\sl-260\slmult0\keep\widctlpar\tx216\tx576\wrapdefault\faauto\adjustright\rin0\lin576\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext69 Num List First;}{\s71\ql \li0\ri0\sa240\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af1\afs28\alang1025 \ltrch\fcs0 \b\caps\f1\fs28\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon50 \snext72 Part Number;}{\s72\ql \li0\ri0\sa480\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af1\afs60\alang1025 \ltrch\fcs0 \b\f1\fs60\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon51 \snext0 Part Title;}{\s73\ql \li0\ri0\sb240\sa240\keep\keepn\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\ai\af0\afs24\alang1025 \ltrch\fcs0 \b\i\fs24\cf2\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext42 \sautoupd Production;}{\s74\qj \li432\ri432\sb320\sa240\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin432\lin432\itap0 \rtlch\fcs1 \ai\af0\afs24\alang1025 \ltrch\fcs0 \i\fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon42 \snext42 Quote;}{\s75\ql \li0\ri144\sl-240\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin144\lin0\itap0 \rtlch\fcs1 \af38\afs20\alang1025 \ltrch\fcs0 \f38\fs20\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon0 \snext75 Results;}{\s76\ql \li0\ri144\sb240\sl-240\slmult0\widctlpar\brdrt\brdrs\brdrw45\brsp100\brdrcf15 \wrapdefault\faauto\adjustright\rin144\lin0\rtlgutter\itap0 \rtlch\fcs1 \af38\afs20\alang1025 \ltrch\fcs0 \f38\fs20\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon54 \snext76 Results First;}{\s77\ql \li0\ri144\sa160\sl-240\slmult0\widctlpar\brdrb\brdrs\brdrw45\brsp100\brdrcf15 \wrapdefault\faauto\adjustright\rin144\lin0\itap0 \rtlch\fcs1 \af38\afs20\alang1025 \ltrch\fcs0 \f38\fs20\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon56 \snext77 Results Last;}{\s78\ql \li0\ri144\sb240\sa240\widctlpar\brdrt \brdrs\brdrw45\brsp100\brdrcf15 \brdrb\brdrs\brdrw45\brsp100\brdrcf15 \wrapdefault\faauto\adjustright\rin144\lin0\rtlgutter\itap0 \rtlch\fcs1 \af38\afs20\alang1025 \ltrch\fcs0 \f38\fs20\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon0 \snext78 Results Single;}{\s79\ql \li288\ri288\sb120\sa120\widctlpar\wrapdefault\faauto\adjustright\rin288\lin288\itap0 \rtlch\fcs1 \af37\afs20\alang1025 \ltrch\fcs0 \f37\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext79 SB Body First;}{\s80\ql \fi-432\li763\ri0\sb240\sa120\widctlpar\tx216\tx475\wrapdefault\faauto\adjustright\rin0\lin763\itap0 \rtlch\fcs1 \af37\afs20\alang1025 \ltrch\fcs0 \f37\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon81 \snext83 SB Bullet First;}{\s81\ql \fi-475\li763\ri288\sb240\sa240\widctlpar\tx216\tx475\wrapdefault\faauto\adjustright\rin288\lin763\itap0 \rtlch\fcs1 \af37\afs20\alang1025 \ltrch\fcs0 \f37\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon82 \snext82 SB Num List First;}{\s82\ql \fi-475\li763\ri288\sb240\sa240\widctlpar\tx216\tx475\wrapdefault\faauto\adjustright\rin288\lin763\itap0 \rtlch\fcs1 \af37\afs20\alang1025 \ltrch\fcs0 \f37\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext82 SB Num List;}{\s83\ql \fi-432\li720\ri288\sb120\sa120\widctlpar\tx216\tx475\wrapdefault\faauto\adjustright\rin288\lin720\itap0 \rtlch\fcs1 \af37\afs20\alang1025 \ltrch\fcs0 \f37\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon80 \snext83 SB Bullet;}{\s84\ql \fi-432\li720\ri288\sb120\sa240\widctlpar\tx216\tx475\wrapdefault\faauto\adjustright\rin288\lin720\itap0 \rtlch\fcs1 \af37\afs20\alang1025 \ltrch\fcs0 \f37\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon83 \snext79 SB Bullet Last;}{\s85\qc \li288\ri288\sb360\sa240\widctlpar\brdrt\brdrs\brdrw45\brsp20\brdrcf16 \brdrl\brdrs\brdrw45\brsp80\brdrcf16 \brdrb\brdrs\brdrw45\brsp20\brdrcf16 \brdrr\brdrs\brdrw45\brsp80\brdrcf16 \wrapdefault\faauto\adjustright\rin288\lin288\rtlgutter\itap0 \cbpat16 \rtlch\fcs1 \ab\af1\afs22\alang1025 \ltrch\fcs0 \b\caps\f1\fs22\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext79 SB Head;}{ \s86\ql \fi504\li288\ri288\sb120\sa120\widctlpar\wrapdefault\faauto\adjustright\rin288\lin288\itap0 \rtlch\fcs1 \af37\afs20\alang1025 \ltrch\fcs0 \f37\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon79 \snext86 SB Body;}{ \s87\ql \fi-475\li763\ri288\sb240\sa240\widctlpar\tx216\tx475\wrapdefault\faauto\adjustright\rin288\lin763\itap0 \rtlch\fcs1 \af37\afs20\alang1025 \ltrch\fcs0 \f37\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon82 \snext79 SB Num List Last;}{\s88\qc \li288\ri288\sb120\sa240\widctlpar\wrapdefault\faauto\adjustright\rin288\lin288\itap0 \rtlch\fcs1 \ab\af1\afs21\alang1025 \ltrch\fcs0 \b\f1\fs21\ul\cf15\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext88 SB Subhead;}{ \s89\ql \li288\ri288\sb240\sa240\widctlpar\wrapdefault\faauto\adjustright\rin288\lin288\itap0 \rtlch\fcs1 \af38\afs20\alang1025 \ltrch\fcs0 \f38\fs20\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon90 \snext89 SB Code Single;}{ \s90\ql \li288\ri288\widctlpar\wrapdefault\faauto\adjustright\rin288\lin288\itap0 \rtlch\fcs1 \af38\afs20\alang1025 \ltrch\fcs0 \f38\fs20\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \snext90 SB Code;}{ \s91\ql \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs21\alang1025 \ltrch\fcs0 \fs21\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext91 Table Text;}{\s92\ql \li0\ri0\sb240\sa120\sl-280\slmult0 \widctlpar\tx576\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ai\af0\afs22\alang1025 \ltrch\fcs0 \i\fs22\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon52 \snext93 Table Caption;}{ \s93\ql \fi-720\li720\ri0\sb120\sa120\sl-240\slmult0\keepn\widctlpar\brdrt\brdrdot\brdrw10\brsp60 \wrapdefault\faauto\adjustright\rin0\lin720\rtlgutter\itap0 \rtlch\fcs1 \ab\af37\afs21\alang1025 \ltrch\fcs0 \b\f37\fs21\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext91 Table Head;}{\s94\ql \li0\ri0\sb60\sa240\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ai\af0\afs18\alang1025 \ltrch\fcs0 \i\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon91 \snext42 Table Footnote;}{\s95\ql \li0\ri0\sb120\sa120\sl-240\slmult0\keep\keepn\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af0\afs20\alang1025 \ltrch\fcs0 \b\fs20\ul\cf15\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext91 Table Subhead;}{\s96\ql \li0\ri0\sa240\widctlpar\brdrb\brdrdot\brdrw10\brsp60 \wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs21\alang1025 \ltrch\fcs0 \fs21\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon91 \snext42 Table Text Last;}{\s97\ql \li360\ri0\sb240\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin360\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon98 \snext98 Unnumbered First;}{\s98\ql \li360\ri0\sb120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin360\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext98 Unnumbered;}{\s99\ql \li360\ri0\sb120\sa240\widctlpar\wrapdefault\faauto\adjustright\rin0\lin360\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon98 \snext42 Unnumbered Last;}{\s100\qr \li0\ri0\sa240\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs24\alang1025 \ltrch\fcs0 \fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon74 \snext42 \sautoupd Quote Source;}{\s101\ql \fi-576\li1152\ri288\sb120\sa120\widctlpar\tx475\tx763\wrapdefault\faauto\adjustright\rin288\lin1152\itap0 \rtlch\fcs1 \af37\afs20\alang1025 \ltrch\fcs0 \f37\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon83 \snext101 SB Sub List;}{\s102\ql \li288\ri288\sa240\widctlpar\wrapdefault\faauto\adjustright\rin288\lin288\itap0 \rtlch\fcs1 \af38\afs20\alang1025 \ltrch\fcs0 \f38\fs20\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon90 \snext102 SB Code Last;}{\s103\qc \li0\ri0\sb360\sa240\widctlpar\brdrt\brdrs\brdrw45\brsp20\brdrcf1 \brdrl\brdrs\brdrw45\brsp80\brdrcf1 \brdrb\brdrs\brdrw45\brsp20\brdrcf1 \brdrr\brdrs\brdrw45\brsp80\brdrcf1 \wrapdefault\faauto\adjustright\rin0\lin0\rtlgutter\itap0 \cbpat1 \rtlch\fcs1 \ab\af1\afs22\alang1025 \ltrch\fcs0 \b\f1\fs22\cf8\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon85 \snext0 Exercise Head;}{ \s104\ql \li0\ri0\sb120\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af37\afs20\alang1025 \ltrch\fcs0 \f37\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext104 \sautoupd Exercise Body;}{ \s105\ql \li0\ri0\sb120\sa240\widctlpar\brdrb\brdrs\brdrw45\brsp240 \wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af37\afs20\alang1025 \ltrch\fcs0 \f37\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon79 \snext105 Exercise Body Last;}{\s106\ql \li0\ri0\sb120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af1\afs24\alang1025 \ltrch\fcs0 \b\f1\fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext106 Glossary Head;}{ \s107\ql \li360\ri0\sb60\sa240\widctlpar\wrapdefault\faauto\adjustright\rin0\lin360\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext107 Glossary Text;}{ \s108\qc \li0\ri0\sa120\widctlpar\wrapdefault\faauto\outlinelevel0\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af39\afs48\alang1025 \ltrch\fcs0 \f39\fs48\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext108 FM Title;}{ \s109\qc \li0\ri0\sa120\widctlpar\wrapdefault\faauto\outlinelevel0\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af39\afs24\alang1025 \ltrch\fcs0 \b\f39\fs24\cf15\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon108 \snext109 FM Subtitle;}{ \s110\qc \li0\ri0\sb360\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af1\afs22\alang1025 \ltrch\fcs0 \b\caps\f1\fs22\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext110 FM Author;}{ \s111\ql \li0\ri0\sb120\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs21\alang1025 \ltrch\fcs0 \fs21\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext111 FM Copyright;}{ \s112\ql \fi-288\li648\ri0\sb240\widctlpar\wrapdefault\faauto\adjustright\rin0\lin648\itap0 \rtlch\fcs1 \af0\afs21\alang1025 \ltrch\fcs0 \fs21\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext112 FM Copyright Credits;}{ \s113\qc \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ai\af0\afs24\alang1025 \ltrch\fcs0 \i\fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext113 FM Dedication;}{ \s114\ql \li0\ri0\sb480\sa480\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af39\afs60\alang1025 \ltrch\fcs0 \b\f39\fs60\expnd-4\expndtw-20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon51 \snext114 FM Head;}{ \s115\ql \fi-288\li648\ri0\sa240\widctlpar\wrapdefault\faauto\adjustright\rin0\lin648\itap0 \rtlch\fcs1 \af0\afs21\alang1025 \ltrch\fcs0 \fs21\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon112 \snext111 FM Copyright Credits Last;}{\*\cs116 \additive \rtlch\fcs1 \af38\afs20 \ltrch\fcs0 \f38\fs20\cf11 \sbasedon10 Code Inline;}{\s117\ql \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs19\alang1025 \ltrch\fcs0 \fs19\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext117 Footnote;}{\s118\ql \li0\ri144\sb120\sa120\sl-240\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin144\lin0\itap0 \rtlch\fcs1 \af38\afs20\alang1025 \ltrch\fcs0 \f38\fs20\lang1024\langfe1024\cgrid\noproof\langnp1033\langfenp1042 \sbasedon0 \snext118 Code Single;}{\s119\ql \li0\ri0\sb240\sa240\keep\keepn\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\ai\af0\afs24\alang1025 \ltrch\fcs0 \b\i\fs24\cf6\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon73 \snext119 Query;}{\s120\qc \li0\ri0\sb120\sa20\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af1\afs18\alang1025 \ltrch\fcs0 \f1\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \snext0 \sautoupd Figure;}{\s121\ql \fi360\li0\ri0\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon42 \snext121 EndOfChapter;}{\s122\ql \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs20\alang1025 \ltrch\fcs0 \fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext122 footnote text;}{\*\cs123 \additive \rtlch\fcs1 \af0 \ltrch\fcs0 \super \sbasedon10 footnote reference;}{\*\cs124 \additive \rtlch\fcs1 \af0\afs16 \ltrch\fcs0 \fs16 \sbasedon10 annotation reference;}{\s125\ql \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs20\alang1025 \ltrch\fcs0 \fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext125 annotation text;}{ \s126\ql \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af0\afs20\alang1025 \ltrch\fcs0 \b\fs20\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon125 \snext125 annotation subject;}{ \s127\ql \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af36\afs16\alang1025 \ltrch\fcs0 \f36\fs16\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon0 \snext127 Balloon Text;}{ \s128\ql \fi360\li0\ri0\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af0\afs23\alang1025 \ltrch\fcs0 \b\fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 \sbasedon42 \snext128 code i;}{ \s129\ql \fi-720\li720\ri0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin720\itap0 \rtlch\fcs1 \af1\afs24\alang1025 \ltrch\fcs0 \f1\fs24\lang2057\langfe1042\cgrid\langnp2057\langfenp1042 \sbasedon0 \snext129 Normal Indent;}{ \s130\ql \li0\ri0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ai\af1\afs24\alang1025 \ltrch\fcs0 \i\f1\fs24\lang2057\langfe1042\cgrid\langnp2057\langfenp1042 \sbasedon0 \snext130 Body Text 2;}{\*\cs131 \additive \rtlch\fcs1 \af0 \ltrch\fcs0 \ul\cf2 \sbasedon10 \styrsid664403 Hyperlink;}}{\*\latentstyles\lsdstimax156\lsdlockeddef0}{\*\listtable{\list\listtemplateid-2035101444\listsimple{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0 \levelindent0{\leveltext\'02\'00.;}{\levelnumbers\'01;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-360\li1800\jclisttab\tx1800\lin1800 }{\listname ;}\listid-132}{\list\listtemplateid190355802\listsimple{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0 \levelstartat1\levelspace0\levelindent0{\leveltext\'02\'00.;}{\levelnumbers\'01;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-360\li1440\jclisttab\tx1440\lin1440 }{\listname ;}\listid-131}{\list\listtemplateid-577575992\listsimple{\listlevel\levelnfc0\levelnfcn0 \leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'02\'00.;}{\levelnumbers\'01;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-360\li1080\jclisttab\tx1080\lin1080 }{\listname ;}\listid-130}{\list\listtemplateid1992066010\listsimple {\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'02\'00.;}{\levelnumbers\'01;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-360\li720\jclisttab\tx720\lin720 }{\listname ;}\listid-129} {\list\listtemplateid767297994\listsimple{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li1800\jclisttab\tx1800\lin1800 }{\listname ;}\listid-128}{\list\listtemplateid2062070138\listsimple{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li1440\jclisttab\tx1440\lin1440 } {\listname ;}\listid-127}{\list\listtemplateid440723874\listsimple{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li1080 \jclisttab\tx1080\lin1080 }{\listname ;}\listid-126}{\list\listtemplateid-1855161760\listsimple{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li720\jclisttab\tx720\lin720 }{\listname ;}\listid-125}{\list\listtemplateid-358715930\listsimple{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'02\'00.;}{\levelnumbers\'01;} \rtlch\fcs1 \af0 \ltrch\fcs0 \fi-360\li360\jclisttab\tx360\lin360 }{\listname ;}\listid-120}{\list\listtemplateid170315252\listsimple{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li360\jclisttab\tx360\lin360 }{\listname ;}\listid-119}{\list\listtemplateid-1\listsimple{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat0\levelspace0\levelindent0{\leveltext \'01*;}{\levelnumbers;}\rtlch\fcs1 \af0 \ltrch\fcs0 }{\listname ;}\listid-2}{\list\listtemplateid-166693384{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3906 ?;}{\levelnumbers;} \f3\fbias0 \fi-360\li720\jclisttab\tx720\lin720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li1440\jclisttab\tx1440\lin1440 }{\listlevel \levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li2160\jclisttab\tx2160\lin2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0 \levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li2880\jclisttab\tx2880\lin2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li3600\jclisttab\tx3600\lin3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li4320 \jclisttab\tx4320\lin4320 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li5040\jclisttab\tx5040\lin5040 }{\listlevel\levelnfc23 \levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li5760\jclisttab\tx5760\lin5760 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1 \levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li6480\jclisttab\tx6480\lin6480 }{\listname ;}\listid91172161}{\list\listtemplateid67698719{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0 \levelstartat1\levelspace0\levelindent0{\leveltext\'02\'00.;}{\levelnumbers\'01;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-360\li360\jclisttab\tx360\lin360 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0 {\leveltext\'04\'00.\'01.;}{\levelnumbers\'01\'03;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-432\li792\jclisttab\tx792\lin792 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'06\'00.\'01.\'02.;}{\levelnumbers\'01\'03\'05;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-504\li1224\jclisttab\tx1224\lin1224 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'08\'00.\'01.\'02.\'03.;}{\levelnumbers\'01\'03\'05\'07;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-648\li1728\jclisttab\tx1728\lin1728 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'0a\'00.\'01.\'02.\'03.\'04.;}{\levelnumbers\'01\'03\'05\'07\'09;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-792\li2232\jclisttab\tx2232\lin2232 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'0c\'00.\'01.\'02.\'03.\'04.\'05.;}{\levelnumbers\'01\'03\'05\'07\'09\'0b;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-936\li2736\jclisttab\tx2736\lin2736 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0 {\leveltext\'0e\'00.\'01.\'02.\'03.\'04.\'05.\'06.;}{\levelnumbers\'01\'03\'05\'07\'09\'0b\'0d;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-1080\li3240\jclisttab\tx3240\lin3240 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1 \levelspace0\levelindent0{\leveltext\'10\'00.\'01.\'02.\'03.\'04.\'05.\'06.\'07.;}{\levelnumbers\'01\'03\'05\'07\'09\'0b\'0d\'0f;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-1224\li3744\jclisttab\tx3744\lin3744 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0 \levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'12\'00.\'01.\'02.\'03.\'04.\'05.\'06.\'07.\'08.;}{\levelnumbers\'01\'03\'05\'07\'09\'0b\'0d\'0f\'11;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-1440\li4320\jclisttab\tx4320\lin4320 }{\listname ;}\listid322468441}{\list\listtemplateid-1048289994{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat0\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\fbias0 \fi-360\li960\jclisttab\tx960\lin960 }{\listlevel \levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li1680\jclisttab\tx1680\lin1680 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0 \levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li2400\jclisttab\tx2400\lin2400 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li3120\jclisttab\tx3120\lin3120 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li3840 \jclisttab\tx3840\lin3840 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li4560\jclisttab\tx4560\lin4560 }{\listlevel\levelnfc23 \levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li5280\jclisttab\tx5280\lin5280 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0 \levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li6000\jclisttab\tx6000\lin6000 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li6720\jclisttab\tx6720\lin6720 }{\listname ;}\listid750197609}{\list\listtemplateid-1850941578{\listlevel\levelnfc255\levelnfcn255\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0 {\leveltext\'01\'97;}{\levelnumbers;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fbias0 \fi-360\li720\jclisttab\tx720\lin720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3880 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li1080\jclisttab\tx1080\lin1080 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li1440\jclisttab\tx1440\lin1440 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li1800\jclisttab\tx1800\lin1800 }{\listlevel \levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3928 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li2160\jclisttab\tx2160\lin2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0 \levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3880 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li2520\jclisttab\tx2520\lin2520 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li2880\jclisttab\tx2880\lin2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li3240\jclisttab\tx3240\lin3240 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3928 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li3600\jclisttab\tx3600\lin3600 }{\listname ;}\listid798111781}{\list\listtemplateid1405273894\listsimple{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \s28\fi-360\li360 \jclisttab\tx360\lin360 }{\listname ;}\listid1076169485}{\list\listtemplateid67698719{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'02\'00.;}{\levelnumbers\'01;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-360\li360\jclisttab\tx360\lin360 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'04\'00.\'01.;}{\levelnumbers\'01\'03;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-432\li792 \jclisttab\tx792\lin792 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'06\'00.\'01.\'02.;}{\levelnumbers\'01\'03\'05;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-504\li1224 \jclisttab\tx1224\lin1224 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'08\'00.\'01.\'02.\'03.;}{\levelnumbers\'01\'03\'05\'07;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-648\li1728 \jclisttab\tx1728\lin1728 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'0a\'00.\'01.\'02.\'03.\'04.;}{\levelnumbers\'01\'03\'05\'07\'09;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-792\li2232 \jclisttab\tx2232\lin2232 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'0c\'00.\'01.\'02.\'03.\'04.\'05.;}{\levelnumbers\'01\'03\'05\'07\'09\'0b;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-936\li2736\jclisttab\tx2736\lin2736 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'0e\'00.\'01.\'02.\'03.\'04.\'05.\'06.;}{\levelnumbers\'01\'03\'05\'07\'09\'0b\'0d;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-1080\li3240\jclisttab\tx3240\lin3240 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'10\'00.\'01.\'02.\'03.\'04.\'05.\'06.\'07.;}{\levelnumbers \'01\'03\'05\'07\'09\'0b\'0d\'0f;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-1224\li3744\jclisttab\tx3744\lin3744 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'12\'00.\'01.\'02.\'03.\'04.\'05.\'06.\'07.\'08.;}{\levelnumbers\'01\'03\'05\'07\'09\'0b\'0d\'0f\'11;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-1440\li4320\jclisttab\tx4320\lin4320 }{\listname ;}\listid1211266713}{\list\listtemplateid89443496{\listlevel \levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\leveltext\'01\u-3983 ?;}{\levelnumbers;}\f10\fs16\fbias0 \fi-360\li1350\jclisttab\tx1350\lin1350 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0 \levelfollow0\levelstartat1\levelspace360\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li2070\jclisttab\tx2070\lin2070 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0 {\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li2790\jclisttab\tx2790\lin2790 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li3510\jclisttab\tx3510\lin3510 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li4230\jclisttab\tx4230\lin4230 }{\listlevel \levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li4950\jclisttab\tx4950\lin4950 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0 \levelfollow0\levelstartat1\levelspace360\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li5670\jclisttab\tx5670\lin5670 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0 {\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li6390\jclisttab\tx6390\lin6390 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li7110\jclisttab\tx7110\lin7110 }{\listname ;}\listid1319655055}{\list\listtemplateid-2085829406{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat0\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;} \fbias0 \fi-360\li960\jclisttab\tx960\lin960 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li1680\jclisttab\tx1680\lin1680 }{\listlevel \levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li2400\jclisttab\tx2400\lin2400 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0 \levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li3120\jclisttab\tx3120\lin3120 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li3840\jclisttab\tx3840\lin3840 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li4560 \jclisttab\tx4560\lin4560 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li5280\jclisttab\tx5280\lin5280 }{\listlevel\levelnfc23 \levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li6000\jclisttab\tx6000\lin6000 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1 \levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li6720\jclisttab\tx6720\lin6720 }{\listname ;}\listid1362127849}{\list\listtemplateid-1338742674{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0 \levelstartat0\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\fbias0 \fi-360\li960\jclisttab\tx960\lin960 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li1680\jclisttab\tx1680\lin1680 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li2400 \jclisttab\tx2400\lin2400 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li3120\jclisttab\tx3120\lin3120 }{\listlevel\levelnfc23 \levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li3840\jclisttab\tx3840\lin3840 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1 \levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li4560\jclisttab\tx4560\lin4560 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li5280\jclisttab\tx5280\lin5280 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li6000 \jclisttab\tx6000\lin6000 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li6720\jclisttab\tx6720\lin6720 }{\listname ;}\listid1392464355}{\list\listtemplateid2085804688{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat0\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\fbias0 \fi-360\li960\jclisttab\tx960\lin960 }{\listlevel \levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li1680\jclisttab\tx1680\lin1680 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0 \levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li2400\jclisttab\tx2400\lin2400 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li3120\jclisttab\tx3120\lin3120 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li3840 \jclisttab\tx3840\lin3840 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li4560\jclisttab\tx4560\lin4560 }{\listlevel\levelnfc23 \levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li5280\jclisttab\tx5280\lin5280 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0 \levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fbias0 \fi-360\li6000\jclisttab\tx6000\lin6000 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li6720\jclisttab\tx6720\lin6720 }{\listname ;}\listid1429888245}{\list\listtemplateid67698719{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0 {\leveltext\'02\'00.;}{\levelnumbers\'01;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-360\li360\jclisttab\tx360\lin360 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'04\'00.\'01.;}{\levelnumbers \'01\'03;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-432\li792\jclisttab\tx792\lin792 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'06\'00.\'01.\'02.;}{\levelnumbers\'01\'03\'05;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-504\li1224\jclisttab\tx1224\lin1224 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'08\'00.\'01.\'02.\'03.;}{\levelnumbers\'01\'03\'05\'07;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-648\li1728\jclisttab\tx1728\lin1728 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'0a\'00.\'01.\'02.\'03.\'04.;}{\levelnumbers\'01\'03\'05\'07\'09;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-792\li2232\jclisttab\tx2232\lin2232 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'0c\'00.\'01.\'02.\'03.\'04.\'05.;}{\levelnumbers\'01\'03\'05\'07\'09\'0b;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-936\li2736\jclisttab\tx2736\lin2736 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'0e\'00.\'01.\'02.\'03.\'04.\'05.\'06.;}{\levelnumbers \'01\'03\'05\'07\'09\'0b\'0d;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-1080\li3240\jclisttab\tx3240\lin3240 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'10\'00.\'01.\'02.\'03.\'04.\'05.\'06.\'07.;}{\levelnumbers\'01\'03\'05\'07\'09\'0b\'0d\'0f;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-1224\li3744\jclisttab\tx3744\lin3744 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0 \levelindent0{\leveltext\'12\'00.\'01.\'02.\'03.\'04.\'05.\'06.\'07.\'08.;}{\levelnumbers\'01\'03\'05\'07\'09\'0b\'0d\'0f\'11;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fi-1440\li4320\jclisttab\tx4320\lin4320 }{\listname ;}\listid1676181409} {\list\listtemplateid-1850941578{\listlevel\levelnfc255\levelnfcn255\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\'97;}{\levelnumbers;}\rtlch\fcs1 \af0 \ltrch\fcs0 \fbias0 \fi-360\li720\jclisttab\tx720\lin720 } {\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3880 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li1080\jclisttab\tx1080\lin1080 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0 \levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li1440\jclisttab\tx1440\lin1440 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0 {\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li1800\jclisttab\tx1800\lin1800 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3928 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li2160\jclisttab\tx2160\lin2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3880 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li2520\jclisttab\tx2520\lin2520 }{\listlevel \levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fbias0 \fi-360\li2880\jclisttab\tx2880\lin2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0 \levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li3240\jclisttab\tx3240\lin3240 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3928 ?;}{\levelnumbers;}\f3\fbias0 \fi-360\li3600\jclisttab\tx3600\lin3600 }{\listname ;}\listid1781607339}}{\*\listoverridetable{\listoverride\listid-119\listoverridecount0\ls1}{\listoverride\listid-125\listoverridecount0\ls2} {\listoverride\listid-126\listoverridecount0\ls3}{\listoverride\listid-127\listoverridecount0\ls4}{\listoverride\listid-128\listoverridecount0\ls5}{\listoverride\listid-120\listoverridecount0\ls6}{\listoverride\listid-129\listoverridecount0\ls7} {\listoverride\listid-130\listoverridecount0\ls8}{\listoverride\listid-131\listoverridecount0\ls9}{\listoverride\listid-132\listoverridecount0\ls10}{\listoverride\listid1076169485\listoverridecount0\ls11}{\listoverride\listid-2 \listoverridecount1{\lfolevel\listoverrideformat{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelold\levelspace0\levelindent360{\leveltext\'01?;}{\levelnumbers;}\fi-360\li360\lin360 }}\ls12}{\listoverride\listid-2 \listoverridecount1{\lfolevel\listoverrideformat{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat3\levelold\levelspace0\levelindent958{\leveltext\'01?;}{\levelnumbers;}\f40\fs20\fbias0 \fi-958\li1052\lin1052 }}\ls13} {\listoverride\listid-2\listoverridecount1{\lfolevel\listoverrideformat{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelold\levelspace0\levelindent360{\leveltext\'01?;}{\levelnumbers;}\f10\fs16\fbias0 \fi-360\li540\lin540 }}\ls14}{\listoverride\listid-2\listoverridecount1{\lfolevel\listoverrideformat{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat3\levelold\levelspace0\levelindent958{\leveltext\'01?;}{\levelnumbers;} \f40\fs20\fbias0 \fi-958\li1556\lin1556 }}\ls15}{\listoverride\listid-2\listoverridecount1{\lfolevel\listoverrideformat{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelold\levelspace0\levelindent360{\leveltext \'01?;}{\levelnumbers;}\f10\fs16\fbias0 \fi-360\li540\lin540 }}\ls16}{\listoverride\listid-2\listoverridecount1{\lfolevel\listoverrideformat{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelold\levelspace0 \levelindent360{\leveltext\'01?;}{\levelnumbers;}\f10\fs16\fbias0 \fi-360\li540\lin540 }}\ls17}{\listoverride\listid1392464355\listoverridecount0\ls18}{\listoverride\listid1362127849\listoverridecount0\ls19}{\listoverride\listid1429888245 \listoverridecount0\ls20}{\listoverride\listid750197609\listoverridecount0\ls21}{\listoverride\listid1319655055\listoverridecount0\ls22}{\listoverride\listid1319655055\listoverridecount9{\lfolevel}{\lfolevel\listoverridestartat\levelstartat1}{\lfolevel \listoverridestartat\levelstartat1}{\lfolevel\listoverridestartat\levelstartat1}{\lfolevel\listoverridestartat\levelstartat1}{\lfolevel\listoverridestartat\levelstartat1}{\lfolevel\listoverridestartat\levelstartat1}{\lfolevel\listoverridestartat \levelstartat1}{\lfolevel\listoverridestartat\levelstartat1}\ls23}{\listoverride\listid1211266713\listoverridecount0\ls24}{\listoverride\listid322468441\listoverridecount0\ls25}{\listoverride\listid1676181409\listoverridecount0\ls26} {\listoverride\listid1781607339\listoverridecount0\ls27}{\listoverride\listid91172161\listoverridecount0\ls28}{\listoverride\listid798111781\listoverridecount0\ls29}}{\*\rsidtbl \rsid84178\rsid97088\rsid131169\rsid147166\rsid401822\rsid525086\rsid664403 \rsid866590\rsid922984\rsid931725\rsid945118\rsid1013011\rsid1056014\rsid1069319\rsid1070257\rsid1119599\rsid1120180\rsid1189481\rsid1474008\rsid1644937\rsid1733957\rsid1842144\rsid2035930\rsid2060546\rsid2233422\rsid2574168\rsid2700783\rsid3108637 \rsid3148767\rsid3357743\rsid3421601\rsid3433404\rsid3480789\rsid3627984\rsid3755248\rsid3962583\rsid4010394\rsid4064805\rsid4531965\rsid4741659\rsid5072721\rsid5244563\rsid5337381\rsid5571031\rsid5588447\rsid5594950\rsid5600774\rsid5727577\rsid6042117 \rsid6043316\rsid6097071\rsid6245454\rsid6448993\rsid6491363\rsid6562805\rsid6692173\rsid6752243\rsid6758956\rsid6773670\rsid7013215\rsid7153045\rsid7277130\rsid7477107\rsid7482445\rsid7602594\rsid7603297\rsid7626272\rsid7627156\rsid7746449\rsid8080532 \rsid8093225\rsid8223694\rsid8352475\rsid8405271\rsid8525051\rsid8539919\rsid8989966\rsid9058438\rsid9061526\rsid9141563\rsid9323701\rsid9400531\rsid9504832\rsid9595830\rsid9651683\rsid9730504\rsid9896418\rsid10427064\rsid10432658\rsid10493321 \rsid10553513\rsid10956523\rsid11225147\rsid11283847\rsid11303203\rsid11434014\rsid11609795\rsid11695481\rsid11893026\rsid11935415\rsid11942891\rsid12005508\rsid12072667\rsid12148293\rsid12200310\rsid12335408\rsid12403629\rsid12531999\rsid12607399 \rsid12862200\rsid12867643\rsid12871508\rsid12993602\rsid13197533\rsid13375564\rsid13507205\rsid13646515\rsid13909770\rsid13919535\rsid13973988\rsid14044965\rsid14098149\rsid14222503\rsid14489511\rsid14555296\rsid14631506\rsid14898492\rsid14970506 \rsid15021586\rsid15027770\rsid15148977\rsid15213031\rsid15236131\rsid15362431\rsid15431696\rsid16146621\rsid16278078\rsid16400063\rsid16530870\rsid16531382\rsid16605593\rsid16669906}{\*\generator Microsoft Word 11.0.8106;}{\info {\title Trouble-shooting (JL Compt)}{\author Jonathan Lewis} {\keywords Orace trouble-shooting tuning dynamic performance views v$ x$ v$session_wait v$session_wait_history v$active_session_histoy dba_hist_active_sess_history tkprof statspack AWR v$mystat v$session_event v$sess_time_model v$sesstat v$lock} {\doccomm Oracle trouble-shooting tuning dynamic performance views v$ x$}{\operator Jonathan Lewis}{\creatim\yr2005\mo9\dy10\hr11\min29}{\revtim\yr2008\mo9\dy4\hr9\min51}{\printim\yr2005\mo3\dy20\hr11\min46}{\version570}{\edmins593}{\nofpages5} {\nofwords2331}{\nofchars13293}{\*\company }{\*\category Oracle trouble-shooting tuning}{\nofcharsws15593}{\vern24611}{\*\password 00000000}}{\*\xmlnstbl {\xmlns1 http://schemas.microsoft.com/office/word/2003/wordml}} \paperw11906\paperh16838\margl1152\margr1152\margt1440\margb1440\gutter0\ltrsect \widowctrl\ftnbj\aenddoc\donotembedsysfont0\donotembedlingdata1\grfdocevents0\validatexml0\showplaceholdtext0\ignoremixedcontent0\saveinvalidxml0\showxmlerrors0\noxlattoyen\expshrtn\noultrlspc\dntblnsbdb \nospaceforul\hyphcaps0\formshade\horzdoc\dghspace120\dgvspace120\dghorigin1701\dgvorigin1984\dghshow0\dgvshow3\jcompress\viewkind1\viewscale100\pgbrdrhead\pgbrdrfoot\rsidroot11225147 \fet0{\*\wgrffmtfilter 013f}\ilfomacatclnup0{\*\ftnsep \ltrpar \pard\plain \ltrpar\ql \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs24\alang1025 \ltrch\fcs0 \fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5727577 \chftnsep \par }}{\*\ftnsepc \ltrpar \pard\plain \ltrpar\ql \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs24\alang1025 \ltrch\fcs0 \fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5727577 \chftnsepc \par }}{\*\aftnsep \ltrpar \pard\plain \ltrpar\ql \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs24\alang1025 \ltrch\fcs0 \fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5727577 \chftnsep \par }}{\*\aftnsepc \ltrpar \pard\plain \ltrpar\ql \li0\ri0\sa120\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs24\alang1025 \ltrch\fcs0 \fs24\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5727577 \chftnsepc \par }}\ltrpar \sectd \ltrsect\linex0\headery709\footery709\colsx709\endnhere\sectdefaultcl\sftnbj {\*\pnseclvl1\pnucrm\pnqc\pnstart1\pnindent720\pnhang {\pntxta .}}{\*\pnseclvl2\pnucltr\pnqc\pnstart1\pnindent720\pnhang {\pntxta .}}{\*\pnseclvl3 \pndec\pnqc\pnstart1\pnindent720\pnhang {\pntxta .}}{\*\pnseclvl4\pnlcltr\pnqc\pnstart1\pnindent720\pnhang {\pntxta )}}{\*\pnseclvl5\pndec\pnqc\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}{\*\pnseclvl6\pnlcltr\pnqc\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}{\*\pnseclvl7\pnlcrm\pnqc\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}{\*\pnseclvl8\pnlcltr\pnqc\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}{\*\pnseclvl9\pnlcrm\pnqc\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}} \pard\plain \ltrpar\s51\ql \li0\ri0\sb480\sa480\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af1\afs60\alang1025 \ltrch\fcs0 \b\f1\fs60\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid11225147 How to do Trouble-Shooting}{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5727577 \par }\pard\plain \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid10956523 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11225147 A search of the internet will find all sorts of tools and }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10956523 tips }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11225147 on trouble-shooting an Oracle database, }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10956523 but }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11225147 it\rquote s very easy to be drawn into a chase that wastes a huge amount of time and effort if you don\rquote t start with a clear image of what you are trying to achieve and why. }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8539919 \par Focusing only on performance trouble-shooting, }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11225147 I\rquote }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16530870 ve g}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11225147 one back to basi}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16530870 c}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11225147 s to }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10956523 produce a short}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16530870 list of targets, }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10956523 to remind you of }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16530870 the only }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5600774 source of }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16530870 information that\rquote s available to help you.}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5727577 \par }\pard\plain \ltrpar\s1\ql \li0\ri0\sb360\sa120\keepn\widctlpar\wrapdefault\faauto\outlinelevel0\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \ab\af1\afs36\alang1025 \ltrch\fcs0 \b\f1\fs36\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5600774 Where\rquote s the problem}{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5727577 . \par }\pard\plain \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid1733957 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8539919 If you\rquote re lo}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1733957 oking for a performance problem}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8539919 you\rquote re probably facing one of three scenarios}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1733957 \endash which }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8539919 can be typified by the questions: \par }\pard \ltrpar\s43\ql \li720\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin720\itap0\pararsid8539919 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8539919 Why is this screen / report always so slow ? \par Why did the batch over-run by three hours last night ? \par }\pard \ltrpar\s43\ql \li720\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin720\itap0\pararsid3148767 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8539919 What}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3148767 \rquote s}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8539919 going on right now ? \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid6245454 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8539919 The third question can, of course, be split into two forms \endash why is }{ \rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid8539919\charrsid6042117 \'93the system\'94}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8539919 always slow, and why is }{\rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid8539919\charrsid6042117 \'93the system\'94}{ \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8539919 sometimes slow \endash but}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6245454 the critical feature is that there is (}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6042117 apparently) no specific issue, }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6245454 just a general malaise.}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8539919 \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid12531999 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7603297 It\rquote s important to remember which of these three scenarios you are addressing, because the most fruitful approach to problem solving }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid14222503 should be guided by }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12531999 the class of problem you are addressing. Regardless of the type of problem, however, Oracle has only one source of information that can help you \endash the dynamic performance views.}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6245454 \par }\pard\plain \ltrpar\s1\ql \li0\ri0\sb360\sa120\keepn\widctlpar\wrapdefault\faauto\outlinelevel0\adjustright\rin0\lin0\itap0\pararsid12531999 \rtlch\fcs1 \ab\af1\afs36\alang1025 \ltrch\fcs0 \b\f1\fs36\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 { \rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid12531999 The dynamic performance views. \par }\pard\plain \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid9141563 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12531999 Internally, Oracle captures a huge amount of information about }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid14898492 what\rquote s }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9141563 going on from moment to moment and summarises it in a variety of different ways. Broadly speaking you could divide these summaries across three dimensions: people}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6042117 (sessions)}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9141563 , resources, and statements; for example:}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12531999 \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid12871508 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9141563 People: \tab v$sesstat, v$session_event, v$sess_time_model \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid9141563 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9141563 Resources:\tab v$filestat, v$}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12871508 segstat, v$latch}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11303203 , v$event_histogram}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9141563 \par }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12871508 Statements:\tab v$sql, v$sqlstats \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid12871508 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12871508 Summaries can be very helpful, of course, but sometimes what we really need are answers to questions like \'93 how many times did I hit child 43 of the cache buffers chains latch the third time I ran statement X using execution plan Y, and how much CPU time did I spend spinning on that latch and how much time sleeping\'94. \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid84178 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12871508 That kind of detail, of course, is far too voluminous for any realisti}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3962583 c capture process, but with 10g}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12871508 we do get some }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6562805 extra }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12871508 sampling across the three dimensions }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6562805 that can be very helpful}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12871508 . Extending from }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid12871508\charrsid84178 v$session_wait}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12871508 we get }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid12871508\charrsid84178 v$session_wait_history}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12871508 (a 100% sample of the last 10 wait events} {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6562805 for each session}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12871508 ), }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid12871508\charrsid84178 v$active_session_history}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12871508 (a sample once per second}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid525086 for th}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8525051 e last hour or so}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6562805 of every session}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8525051 ) and }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid8525051\charrsid84178 dba_hist_active_sess_history}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8525051 (a sample}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid84178 from }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid84178\charrsid84178 v$active_session_history}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid84178 that is kept}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3755248 , by default,}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8525051 }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid84178 for }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3755248 the last seven days)}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3962583 . The }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid3962583\charrsid866590 v$active_session_history}{ \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3962583 and }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid866590 d}{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid3962583\charrsid866590 b}{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid866590 a}{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid3962583\charrsid866590 _hist_active_sess_history}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3962583 , however, are only available to users with the appropriate licences.}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9141563 \par }\pard\plain \ltrpar\s1\ql \li0\ri0\sb360\sa120\keepn\widctlpar\wrapdefault\faauto\outlinelevel0\adjustright\rin0\lin0\itap0\pararsid13973988 \rtlch\fcs1 \ab\af1\afs36\alang1025 \ltrch\fcs0 \b\f1\fs36\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 { \rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid13973988 Improving performance \par }\pard\plain \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid13973988 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13973988 So when you go trouble-shooting, what does it mean to }{\rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid13973988\charrsid7626272 \'93improve performance\'94}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13973988 . In simple terms you want something to happen faster, whether it\rquote s a screen re}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7626272 sponse, report run, batch run, }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13973988 time is probably the single visible measure of success. \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid10553513 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13973988 The formula: }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid13973988\charrsid5244563 response time = wait time + service time}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13973988 is probably very well known to the Oracle community (largely due to the efforts of Anjo Kolk and Cary Millsap); but I\rquote d also like to throw another }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13375564 equation}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10553513 , or pair of equations, }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13973988 in}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10553513 to the pot:}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13973988 \par }\pard \ltrpar\s43\ql \li720\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin720\itap0\pararsid10427064 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10553513 Wait time = competitive wait time + }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10427064 resource }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10553513 wait time \par Service time = competitive service time + }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10427064 resource }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10553513 service time \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid3357743 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10427064 I\rquote m not entirely happy with the wording I have used in these expressions, but the idea I want to get across is that there is a very fluid boundary between how you decide what }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3357743 you call }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10427064 \lquote wait\rquote time and what }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3357743 you call }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10427064 \lquote service\rquote time. }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1474008 }{ \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3627984 \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid16146621 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10427064 Consider, for example, }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1474008 a simple disk I/O }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16146621 which}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1013011 , }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1474008 on an idle system}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1013011 ,}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1474008 }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16146621 should take}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1474008 }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3627984 6 milliseconds. From Oracle\rquote s perspective, that would probably be considered virtually 100% wait time. }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16146621 F}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3627984 rom the viewpoint of \lquote response time = wait time + service time\rquote , most of that time is waiting for the heads to settle}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15021586 and }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3627984 waiting for the disk to rotate to the right position}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16146621 \endash so, at a difference level, how much of that 6 seconds is wait time, and how much is service time ?}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3627984 . }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16146621 But wh}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3627984 en two users try to access the same disc at the same time one of them will see a 12 m/s }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16146621 response }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3627984 time, of which 6 m/s is }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3433404 definitely }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3627984 waiting }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15021586 (}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3433404 on what I call }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15021586 competition time) }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3627984 for the other user to get out of the way. \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid15021586 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3627984 At the opposite extreme, consider a simple latch acqu isition. It takes a few microsecond}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15021586 s}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3627984 (service time) to run through the code to acquire a latch; but if someone else is holding a latch }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15021586 that I want, }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3627984 I start to spin on that latch, working to avoid sleeping. Is the spin}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15021586 time \'93wait time\'94 or \'93service time\'94 } {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3627984 ? I\rquote d like to think of it as service time \endash I am still working, not waiting \endash but identify it as competitive service time rather than resource service time. }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3357743 (For a simple example of this type of competition resulting in a massive CPU overhead, see }{\field{\*\fldinst {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3357743 HYPERLINK "}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3357743\charrsid3357743 http://jonathanlewis.wordpress.com/2008/05/10/cpu-usage/}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3357743 " }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5072721 {\*\datafield 00d0c9ea79f9bace118c8200aa004ba90b02000000170000003900000068007400740070003a002f002f006a006f006e0061007400680061006e006c0065007700690073002e0077006f0072006400700072006500730073002e0063006f006d002f0032003000300038002f00300035002f00310030002f00630070007500 2d00750073006100670065002f000000e0c9ea79f9bace118c8200aa004ba90b7200000068007400740070003a002f002f006a006f006e0061007400680061006e006c0065007700690073002e0077006f0072006400700072006500730073002e0063006f006d002f0032003000300038002f00300035002f00310030002f 006300700075002d00750073006100670065002f00000000000000}}}{\fldrslt {\rtlch\fcs1 \af0 \ltrch\fcs0 \cs131\ul\cf2\insrsid3357743\charrsid8989966 http://jonathanlewis.wordpress.com/2008/05/10/cpu-usage/}}}\sectd \ltrsect \linex0\headery709\footery709\colsx709\endnhere\sectdefaultcl\sftnbj {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3357743 ). \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid13197533 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13197533 One guideline to consider when it comes to competition time is that higher frequency tends to lead to more competition. That\rquote s part of the thinking behind strategies which say: \'93if you\rquote re going to update 1,000 rows do it in one statement, not in 1,000 statements\'94 \endash the more steps you take, the more times you compete, and the higher the probability of wasting time in competition. \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid3433404 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15021586 The rea son I am struggling to make a distinction between competition and usage is simple. }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11893026 After the \'93time-based tuning\'94 revolution, too many people spent too much time focusing on the \lquote service time + wait time\rquote }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3433404 viewpoint, }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11893026 translating this into: \lquote you\rquote ve got to use the 10046 trace to see the time\'94. That\rquote s an important }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13197533 aspect of trouble-shooting}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11893026 and the best strategy for some circumstances \endash but you still have to reduce the time, and you can spend too much effort trying to reduce your }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid11893026\charrsid3433404 usage}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11893026 time when you could do better to reduce the }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid11893026\charrsid3433404 competition}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11893026 time by reducing }{\rtlch\fcs1 \af0 \ltrch\fcs0 \ul\insrsid11893026\charrsid3433404 other people\rquote s}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11893026 usage.}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3357743 \par }\pard\plain \ltrpar\s1\ql \li0\ri0\sb360\sa120\keepn\widctlpar\wrapdefault\faauto\outlinelevel0\adjustright\rin0\lin0\itap0\pararsid7602594 \rtlch\fcs1 \ab\af1\afs36\alang1025 \ltrch\fcs0 \b\f1\fs36\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 { \rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid7602594 Strategies \par }\pard\plain \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid7602594 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7602594 So let\rquote s put the pieces together and address the three basic questions. \par }\pard \ltrpar\s43\ql \li720\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin720\itap0\pararsid12867643 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12867643 Why is this screen / report always so slow ? \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid3433404 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9651683 There\rquote s an obvious }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3433404 best strategy }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9651683 on this one; if you can identify the task so precisely then the 10046 trace gives you the maximum detail available for every operation \endash except it doesn\rquote t show you much indication of where you spent the CPU and how much of i}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3433404 t was used in competition}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10493321 and y ou may need to do some work, and make some intelligent guesses, about how reasonable your wait times are. }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9651683 \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid10493321 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10493321 Obviously the summarized (}{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid10493321\charrsid3433404 tkprof}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10493321 ) output from the trace will allow you to identify the statements that were responsible for most of the time, and le t you guess that some of the statements may have been badly affected by competition time \endash but you still need to know if the statement that took 1,000 sequential reads and 10 seconds is behaving reasonably because (a) that\rquote s a reasonable number of disk reads to expect and (b) the average of 0.01 seconds per read is meaningful or did 90% of the I/Os come from cache with 10% coming from an overloaded disk system. \par }\pard \ltrpar\s43\ql \li720\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin720\itap0\pararsid12867643 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12867643 Why did the batch over-run by three hours last night ? \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid3433404 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13919535 Until the advent of 10g and the licences for the diagnostic pack and performance pack, }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12005508 you couldn\rquote t get any fine detail about a single session }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3433404 in the past}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12005508 . }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1119599 You could only get the system-wi}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid4064805 de }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid4064805\charrsid3433404 statspack}{ \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid4064805 reports, which could give you }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1189481 some clues about resource hogs (}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid4064805 which mi ght be heavy users, but might also be sources of intense competition}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1189481 )}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid4064805 .}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12867643 \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid1189481 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13646515 So the ideal has always been to do the smallest amount of extra work to get the maximum viable instrumentation into the batch jobs. }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11283847 In the simplest case, all it takes is two }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9061526 basic SQL statements e}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15431696 ach time you disconnect \endash with }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9730504 a third, possibly, for 10g. The queries simply report the work done (}{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid9730504\charrsid1189481 v$mystat}{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid1189481 }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1189481\charrsid1189481 \endash the slice of}{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid1189481 v$sesstat}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1189481\charrsid1189481 for the session}{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid1189481 )}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9730504 ) time waited (}{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid9730504\charrsid1189481 v$session_event}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9730504 ) and, optionally, database time distribution (}{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid9730504\charrsid1189481 v$sess_time_model}{ \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9730504 ) for the session. }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15236131 \par }\pard\plain \ltrpar\s20\ql \li567\ri0\sb60\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0\pararsid12607399 \rtlch\fcs1 \af2\afs18\alang1025 \ltrch\fcs0 \f2\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid1056014 S}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid12607399 elect}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid1056014 \par \tab }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid12607399 stn.name, mst.value \par }\pard\plain \ltrpar\s21\ql \li567\ri0\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0\pararsid12607399 \rtlch\fcs1 \af2\afs18\alang1025 \ltrch\fcs0 \f2\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid1056014 from \par }\pard \ltrpar\s21\ql \li567\ri0\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0\pararsid1056014 {\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid1056014 \tab }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid12607399 v$mystat mst, v$statname stn \par where}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid1056014 \par \tab }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid12607399 mst.value != 0 \par }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid1056014 and\tab }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid12607399 mst.statistic# = stn.statistic# \par }\pard \ltrpar\s21\ql \li567\ri0\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0\pararsid12607399 {\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid12607399 ; \par \par select\tab \par \tab /*+ leading(mys) no_merge(mys) */ \par \tab event, total_waits, total_timeouts, \par \tab round(time_waited/100,2) time_waited, \par \tab round(max_wait/100,2) max_wait \par from \par \tab (select sid from v$mystat where rownum = 1)\tab mys, \par \tab v$session_event \tab \tab \tab \tab }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid1056014 \tab \tab }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid12607399 sev \par where}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid1056014 \par }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid12607399 \tab sev.sid = mys.sid \par ; \par \par select\tab \par \tab /*+ leading(mys) no_merge(mys) */ \par \tab stat_name, value \par from \par \tab (select sid from v$mystat where rownum = 1)\tab mys, \par \tab v$sess_time_model\tab \tab \tab \tab }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid1056014 \tab \tab }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid12607399 stm \par where}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid1056014 \par }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid12607399 \tab stm.sid = mys.sid \par and\tab stm.value != 0 \par }\pard\plain \ltrpar\s22\ql \li567\ri0\sa60\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0\pararsid12607399 \rtlch\fcs1 \af2\afs18\alang1025 \ltrch\fcs0 \f2\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid12607399 ;}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid15236131 \par }\pard\plain \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid12607399 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15236131 With a relatively short report you get a head start on trouble-shooting because you can compare the report for a bad day with the report for the previous day and ask q}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12607399 uestions like: }{\rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid12607399\charrsid16531382 \'93did I do far more single block reads today than yesterday \endash or was the averag}{\rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid16531382\charrsid16531382 e read time longer\'94}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16531382 , }{\rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid16531382\charrsid16531382 \'93did more Workarea e}{\rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid12607399\charrsid16531382 xecutions spill to disk today\'94}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12607399 , }{\rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid7277130\charrsid16531382 \'93why has the number of }{\rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid14555296\charrsid16531382 SQL}{ \rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid7277130\charrsid16531382 *Net roundtrips gone up by a factor of 10\'94}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7277130 .}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15431696 \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid16278078 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16531382 The three queries}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7277130 can\rquote t give you the }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16531382 complete }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7277130 answers because the detail isn\rquote t there, but }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid16278078 they }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7277130 will direct you to the right places to look for the answers. \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid5727577 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7277130 Of course, with 10g, you could start with this report, }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12200310 to find out which jobs did most work, or suffered from the worst competition, and then }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5727577 go into the }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid5727577\charrsid1070257 dba_hist_active_sess_history}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5727577 to see if it gives you a good sample of the critical work this session was doing when it had a problem.}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13646515 \par }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid131169 \par }\pard \ltrpar\s43\ql \li720\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin720\itap0\pararsid11935415 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12867643 What}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11935415 \rquote s}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12867643 going on right now ? \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid13909770 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5727577 Finally the ge}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13909770 neric \lquote system is bad\rquote question. This may be the }{\rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid13909770\charrsid11942891 \lquote instant response\rquote }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13909770 question, or may be the longer term view of a badly performing system. Either way, your best bet is taking snapshots.}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11935415 \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid2700783 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13909770 For the longer term viewpoint, of course, }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid13909770\charrsid3108637 Statspack}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13909770 (or }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid13909770\charrsid3108637 AWR}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13909770 ) give you a defaul t way of collecting all sorts of interesting data in snapshots, and their mechanisms tell you all you need to know about snapshots \endash copy the data from a dynamic performance view, wait a bit, make another copy, }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid2700783 report }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13909770 the difference. \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid12072667 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid2700783 In the case of }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12403629 the lon ger term view, you\rquote re probably going to look }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3108637 for }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7013215 competition \endash what resources are under most pressure, can }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3108637 you see what SQL is (probably) }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7013215 causing that pressure. }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12072667 In many cases this means looking at the }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid12072667\charrsid3108637 \'93Load Profile\'94}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12072667 and the }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid12072667\charrsid3108637 \'93Top 5 Timed events\'94}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12072667 to get an idea of work done and time lost, then jumping to the most appropriate section of }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid12072667\charrsid3108637 \lquote SQL ordered by \'85\rquote }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12072667 .}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid2700783 \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid3108637 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12072667 When you look at the SQL \endash there are two things to remember: usage and competition. A statement which uses a lot of CPU is denying CPU to other statements. A statement that does a lot of physical reads is slowing down the physical reads }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3108637 by }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid12072667 other statements. A statement that executes a large number of times is interrupting other statements and competing for latches. }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3108637 \par }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid97088 When you look at }{\rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid97088\charrsid7477107 \lquote greedy\rquote }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid97088 statements, don\rquote t forget to check how greedy they are \endash what impact are they having on the total resource available. Several of the }{\rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid97088\charrsid7477107 \lquote SQL ordered by \'85\rquote }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid97088 reports have some text to help, such as: \par }\pard\plain \ltrpar\s20\ql \li567\ri0\sb60\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0\pararsid16605593 \rtlch\fcs1 \af2\afs18\alang1025 \ltrch\fcs0 \f2\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid97088\charrsid97088 SQL ordered by Gets DB/Inst: }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid16605593 XXXXXX/XXXXXX}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid97088\charrsid97088 Snaps: 8277-8278}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid2035930 \par }\pard\plain \ltrpar\s21\ql \li567\ri0\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0\pararsid8093225 \rtlch\fcs1 \af2\afs18\alang1025 \ltrch\fcs0 \f2\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid97088 -> Resources reported for PL/SQL code includes the resources used by all SQL}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid2035930 \par }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid97088 statements called by the code. \par -> Total Buffer Gets: 263,043,933 \par }\pard\plain \ltrpar\s22\ql \li567\ri0\sa60\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0\pararsid8093225 \rtlch\fcs1 \af2\afs18\alang1025 \ltrch\fcs0 \f2\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid97088 -> Captured SQL account for }{\rtlch\fcs1 \ab\af2 \ltrch\fcs0 \b\ul\insrsid97088\charrsid12862200 49.8%}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid97088 of Total }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid12072667 \par }\pard\plain \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid4741659 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11695481 This rep}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid401822 ort would be fairly useful as it}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid11695481 has captured rou}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid14970506 ghly half the buffer gets accounted for in the period. But if this turns }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid4741659 out to be 30 statements each responsible for about 1.6% of the total then you might move rapidly on to check the SQL ordered by CPU, o }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9896418 r the SQL ordered by executions to see if there are any single SQL statements with a larger potential payback.}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13909770 \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid8223694 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid14489511 In the case of the short-term view, you need some quick, lightweight, code to take similar snapshots of several of the dynamic performance views. I have various packages to }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid2060546 look at }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid2060546\charrsid8223694 v$sess_io}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid2060546 , }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid2060546\charrsid8223694 v$}{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid6097071\charrsid8223694 sysstat}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6097071 , }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid7746449\charrsid8223694 v$session_event}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7746449 }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6097071 and so on, but one of the best examples I\rquote ve come across of such code is on Tanel Poder\rquote s }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid13507205 \'93Session Level S}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3421601 tatspack\'94 at }{\field{\*\fldinst { \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3421601 HYPERLINK "}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3421601\charrsid3421601 http://blog.tanelpoder.com/2007/06/24/session-level-statspack/}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3421601 " }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5072721 {\*\datafield 00d0c9ea79f9bace118c8200aa004ba90b02000000170000003f00000068007400740070003a002f002f0062006c006f0067002e00740061006e0065006c0070006f006400650072002e0063006f006d002f0032003000300037002f00300036002f00320034002f00730065007300730069006f006e002d006c0065007600 65006c002d00730074006100740073007000610063006b002f000000e0c9ea79f9bace118c8200aa004ba90b7e00000068007400740070003a002f002f0062006c006f0067002e00740061006e0065006c0070006f006400650072002e0063006f006d002f0032003000300037002f00300036002f00320034002f00730065 007300730069006f006e002d006c006500760065006c002d00730074006100740073007000610063006b002f000000000000}}}{\fldrslt {\rtlch\fcs1 \af0 \ltrch\fcs0 \cs131\ul\cf2\insrsid3421601\charrsid931725 http://blog.tanelpoder.com/2007/06/24/session-level-statspack/}}} \sectd \ltrsect\linex0\headery709\footery709\colsx709\endnhere\sectdefaultcl\sftnbj {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7602594 \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid7482445 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7746449 The idea is simple \endash if the system is busy, someone, somewhere, is doing something inefficient \endash in this case you w}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5337381 ant to find the culprit quickly}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1069319 \endash who\rquote s doing the work that is causing a problem. (Notice how the time scale changes the direction of search \endash although the snapshot principle is the same as the }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid9504832\charrsid9504832 S}{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid1069319\charrsid9504832 tatspack}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1069319 report, we can search for }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7482445 a }{\rtlch\fcs1 \af0 \ltrch\fcs0 \ul\insrsid1069319\charrsid5571031 person}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1069319 in }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10432658 real-time, but only search for the }{\rtlch\fcs1 \af0 \ltrch\fcs0 \ul\insrsid10432658\charrsid5571031 SQL}{ \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10432658 in Statspack).}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3421601 \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid1069319 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid2574168 The output from a simple snapshot of }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid2574168\charrsid5571031 v$sess_io}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid2574168 might look like this:}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid10432658 \par }\pard\plain \ltrpar\s20\ql \li567\ri0\sb60\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0\pararsid2574168 \rtlch\fcs1 \af2\afs18\alang1025 \ltrch\fcs0 \f2\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid2574168 SQL> execute snap_sess_io.start_snap \par }\pard\plain \ltrpar\s21\ql \li567\ri0\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0\pararsid2574168 \rtlch\fcs1 \af2\afs18\alang1025 \ltrch\fcs0 \f2\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid2574168 PL/SQL procedure successfully completed. \par }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid5571031 \par }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid2574168 -- wait 5 seconds \par }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid5571031 \par }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid2574168 SQL> execute snap_sess_io.end_snap \par ----------------------------------- \par Session I/O:- 17-Jun 14:28:40 \par Interval:- 5 seconds \par ----------------------------------- \par SID CU Gets CR Gets Reads Blk Change Con Change \par ------ ---------- ---------- ---------- ---------- ---------- \par 9 3654 }{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid9323701 4}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid2574168 45,630 13,925 7,}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid9058438 1}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid2574168 94 8}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid9058438 ,5}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid2574168 39 \par }\pard\plain \ltrpar\s22\ql \li567\ri0\sa60\widctlpar\tx567\tx1134\tx1701\tx2268\tx2835\tx3402\tx3969\tx4536\wrapdefault\faauto\adjustright\rin0\lin567\itap0\pararsid2574168 \rtlch\fcs1 \af2\afs18\alang1025 \ltrch\fcs0 \f2\fs18\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid2574168 13 0 50,157 0 0 0}{\rtlch\fcs1 \af2 \ltrch\fcs0 \insrsid2574168\charrsid3421601 \par }\pard\plain \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid6043316 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9323701 With a suitable filter to bring out only the larger numbers, you can get a short report that points you }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6043316 to }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9323701 just one or two sessions}{ \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid945118 that might be worth following}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9323701 . (The }{\rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid9323701\charrsid6043316 \lquote Reads\rquote }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9323701 in the above report are probably coming from a file-system cache, by the way, so not only is session 9 threatening the discs, it\rquote s always }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9058438 burning extra CPU).}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid945118 \par }\pard\plain \ltrpar\s1\ql \li0\ri0\sb360\sa120\keepn\widctlpar\wrapdefault\faauto\outlinelevel0\adjustright\rin0\lin0\itap0\pararsid9323701 \rtlch\fcs1 \ab\af1\afs36\alang1025 \ltrch\fcs0 \b\f1\fs36\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 { \rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid9058438 Conclusion}{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid9323701 \par }\pard\plain \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid8080532 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9058438 There are cases where you can identify}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid2233422 }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9058438 a business operation that is believed to be inefficient}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8080532 . I}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9058438 f you have this luxury, then the 10046 trace is an enormous help t}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8080532 o pinning down exactly where you}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9058438 }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid8080532 should }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9058438 spend your efforts in fixing the problem. But there are cases where this direct approach is not possible.}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9323701 \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid9058438 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9058438 If you have to find problems in the past, or problems that are non-localised, then Oracle offers you summaries of the work and time attributed to users, statements, and resources. You can used snapshots (at various timescales) on these summaries to }{ \rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid4010394 help you }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9058438 identify }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid4010394 the best place to spend your efforts.}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid9058438 \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid4010394 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid4010394 Remember that competition for resources can be as great a threat to performance as use of a resource. If you stop me from working too hard, you are also reducing the competition for resources being suffered by other users. So, in the absence of precise targets, identifying the most significant resource threats may be the most cost-effective use of your time. \par }\pard \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid7627156 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15362431 Footnote: in this article I\rquote ve avoided the question of locking. When a user says \endash }{\rtlch\fcs1 \ai\af0 \ltrch\fcs0 \i\insrsid15362431\charrsid147166 \'93The system is hung\'94}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15362431 , one of the first quick checks is }{\rtlch\fcs1 \ab\ai\af0 \ltrch\fcs0 \b\i\insrsid15362431\charrsid11434014 v$lock}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid15362431 to see if there are some blocking locks causing a problem. }{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid7627156 Because the view falls outside the normal range of performance issues due to inefficiency, I\rquote ve left the topic aside to be pursued at a later date.}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid3962583 \par }\pard\plain \ltrpar\s42\ql \fi360\li0\ri0\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5727577 \par }\pard\plain \ltrpar\s129\ql \li0\ri0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af1\afs24\alang1025 \ltrch\fcs0 \f1\fs24\lang2057\langfe1042\cgrid\langnp2057\langfenp1042 {\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5727577 \par }\pard\plain \ltrpar\s130\ql \li0\ri0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid7153045 \rtlch\fcs1 \ai\af1\afs24\alang1025 \ltrch\fcs0 \i\f1\fs24\lang2057\langfe1042\cgrid\langnp2057\langfenp1042 {\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5727577 Jonathan Lewis is a freelance consultant whose experience with Oracle goes back }{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid664403 just over 20 years to version 5.1a (}{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5727577 though he does try to forget that when dealing with modern systems}{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid664403 )}{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5727577 . He speciali}{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid15148977 ses in physical database design, }{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5727577 the strategic use}{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid15148977 of the Oracle database engine and solving performance }{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid7153045 issues}{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid15148977 .}{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5727577 \par }\pard \ltrpar\s130\ql \li0\ri0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 {\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5727577 \par Jonathan is the author of \lquote Cost Based Oracle \endash Fundamentals\rquote published by Apress, and 'Practical Oracle 8i \endash Designing Efficient Databases' published by Addison-Wesley, and is one of the best- known speakers on the UK Oracle circuit, as well as being very popular on the international scene. \par \par }\pard \ltrpar\s130\ql \li0\ri0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0\pararsid5588447 {\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5727577 Further details of his published papers, presentations, tutorials and seminars can be found a}{ \rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid664403 t }{\field{\*\fldinst {\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid664403 HYPERLINK "http://www.jlcomp.demon.co.uk" }{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5072721 {\*\datafield 00d0c9ea79f9bace118c8200aa004ba90b02000000170000001e00000068007400740070003a002f002f007700770077002e006a006c0063006f006d0070002e00640065006d006f006e002e0063006f002e0075006b000000e0c9ea79f9bace118c8200aa004ba90b3e00000068007400740070003a002f002f0077007700 77002e006a006c0063006f006d0070002e00640065006d006f006e002e0063006f002e0075006b002f00000000000000}}}{\fldrslt {\rtlch\fcs1 \af1 \ltrch\fcs0 \cs131\ul\cf2\insrsid664403\charrsid8989966 http://www.jlcomp.demon.co.uk}}}\sectd \ltrsect \linex0\headery709\footery709\colsx709\endnhere\sectdefaultcl\sftnbj {\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid664403 and }{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5588447 on }{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid12335408 hi}{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid664403 s blog at }{\field{\*\fldinst {\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid664403 HYPERLINK "http://jonathanlewis.wordpress.com" }{\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid5072721 {\*\datafield 00d0c9ea79f9bace118c8200aa004ba90b02000000170000002300000068007400740070003a002f002f006a006f006e0061007400680061006e006c0065007700690073002e0077006f0072006400700072006500730073002e0063006f006d000000e0c9ea79f9bace118c8200aa004ba90b480000006800740074007000 3a002f002f006a006f006e0061007400680061006e006c0065007700690073002e0077006f0072006400700072006500730073002e0063006f006d002f00000000000000}}}{\fldrslt {\rtlch\fcs1 \af1 \ltrch\fcs0 \cs131\ul\cf2\insrsid664403\charrsid8989966 http://jonathanlewis.wordpress.com}}}\sectd \ltrsect\linex0\headery709\footery709\colsx709\endnhere\sectdefaultcl\sftnbj {\rtlch\fcs1 \af1 \ltrch\fcs0 \insrsid664403 . \par }\pard\plain \ltrpar\s43\ql \li0\ri0\sb120\sl-260\slmult0\widctlpar\wrapdefault\faauto\adjustright\rin0\lin0\itap0 \rtlch\fcs1 \af0\afs23\alang1025 \ltrch\fcs0 \fs23\lang1033\langfe1042\cgrid\langnp1033\langfenp1042 {\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid6758956 Publish Aug 2008.}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid1842144 \'a9 Jonathan Lewis}{\rtlch\fcs1 \af0 \ltrch\fcs0 \insrsid5727577 \par }}