<html xmlns="http://www.w3.org/1999/xhtml"><head><meta charset="utf-8"><meta name="generator" content="pdf2htmlEX"><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/base.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/9817392/raw.css"><script src="https://csdnimg.cn/release/download_crawler_static/js/compatibility.min.js"></script><script src="https://csdnimg.cn/release/download_crawler_static/js/pdf2htmlEX.min.js"></script><script>try{pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({});}catch(e){}</script><title></title></head><body><div id="sidebar" style="display: none"><div id="outline"></div></div><div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/9817392/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">EnmoTech</div><div class="t m0 x2 h4 y3 ff2 fs0 fc0 sc1 ls0 ws0">云和恩墨</div><div class="t m0 x3 h5 y4 ff1 fs1 fc1 sc0 ls0 ws0">Oracle<span class="_ _0"> </span><span class="ff2 sc2">应用优化</span></div></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div></body></html>
<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/9817392/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">EnmoTech</div><div class="t m0 x2 h4 y3 ff2 fs0 fc0 sc1 ls0 ws0">云和恩墨</div><div class="t m0 x4 h5 y5 ff2 fs1 fc1 sc2 ls0 ws0">优化思路</div><div class="t m0 x5 h6 y6 ff3 fs2 fc2 sc0 ls0 ws0">•</div><div class="t m0 x6 h7 y7 ff2 fs2 fc1 sc0 ls0 ws0">优化应该怎么<span class="_ _1"></span>做？</div><div class="t m0 x5 h6 y8 ff3 fs2 fc2 sc0 ls0 ws0">•</div><div class="t m0 x6 h7 y9 ff2 fs2 fc1 sc0 ls0 ws0">我们到底要调<span class="_ _1"></span>优什么？</div><div class="t m0 x5 h6 ya ff3 fs2 fc2 sc0 ls0 ws0">•</div><div class="t m0 x6 h7 yb ff2 fs2 fc1 sc0 ls0 ws0">谁参与调优<span class="_ _2"> </span><span class="ff3">?</span></div><div class="t m0 x5 h6 yc ff3 fs2 fc2 sc0 ls0 ws0">•</div><div class="t m0 x6 h7 yd ff2 fs2 fc1 sc0 ls0 ws0">什么样的系统<span class="_ _1"></span>需要优化？</div><div class="t m0 x5 h6 ye ff3 fs2 fc2 sc0 ls0 ws0">•</div><div class="t m0 x6 h7 yf ff2 fs2 fc1 sc0 ls0 ws0">项目生命期中<span class="_ _1"></span>的优化三部曲</div><div class="t m0 x7 h8 y10 ff3 fs3 fc2 sc0 ls0 ws0">•</div><div class="t m0 x8 h9 y11 ff2 fs3 fc1 sc0 ls0 ws0">初期</div><div class="t m0 x7 h8 y12 ff3 fs3 fc2 sc0 ls0 ws0">•</div><div class="t m0 x8 h9 y13 ff2 fs3 fc1 sc0 ls0 ws0">运行时</div><div class="t m0 x7 h8 y14 ff3 fs3 fc2 sc0 ls0 ws0">•</div><div class="t m0 x8 h9 y15 ff2 fs3 fc1 sc0 ls0 ws0">故障时</div><div class="t m0 x5 h6 y16 ff3 fs2 fc2 sc0 ls0 ws0">•</div><div class="t m0 x6 h7 y17 ff2 fs2 fc1 sc0 ls0 ws0">调优到什么时<span class="_ _1"></span>候结束？</div><div class="t m0 x5 h6 y18 ff3 fs2 fc2 sc0 ls0 ws0">•</div><div class="t m0 x6 h7 y19 ff2 fs2 fc1 sc0 ls0 ws0">调优一个反复<span class="_ _1"></span>的过程，需要随时<span class="_ _1"></span>监控，随时调整</div></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div>
<div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/9817392/bg3.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">EnmoTech</div><div class="t m0 x2 h4 y3 ff2 fs0 fc0 sc1 ls0 ws0">云和恩墨</div><div class="t m0 x9 h5 y1a ff2 fs1 fc1 sc2 ls0 ws0">调优的阶段</div><div class="t m0 xa ha y1b ff2 fs4 fc1 sc0 ls0 ws0">调优被分成不同的阶段<span class="_ _3"> </span><span class="ff3">:</span></div><div class="t m0 xa hb y1c ff3 fs5 fc2 sc0 ls0 ws0">•</div><div class="t m0 xb hc y1d ff2 fs5 fc1 sc0 ls0 ws0">需求分析和架构设计</div><div class="t m0 x5 hd y1e ff3 fs6 fc2 sc0 ls0 ws0">•</div><div class="t m0 xc he y1f ff2 fs6 fc1 sc0 ls0 ws0">需求实现（业务与技术）与数据存<span class="_ _4"></span>储</div><div class="t m0 x5 hd y20 ff3 fs6 fc2 sc0 ls0 ws0">•</div><div class="t m0 xc he y21 ff2 fs6 fc1 sc0 ls0 ws0">应用架构与数据库架构</div><div class="t m0 xa hb y22 ff3 fs5 fc2 sc0 ls0 ws0">•</div><div class="t m0 xb hc y23 ff2 fs5 fc1 sc0 ls0 ws0">应用设计和开发</div><div class="t m0 x5 hd y24 ff3 fs6 fc2 sc0 ls0 ws0">•</div><div class="t m0 xc he y25 ff2 fs6 fc1 sc0 ls0 ws0">应用模块设计与<span class="_ _5"> </span><span class="ff3">E-R<span class="_ _5"> </span></span>模型设计</div><div class="t m0 x5 hd y26 ff3 fs6 fc2 sc0 ls0 ws0">•</div><div class="t m0 xc he y27 ff2 fs6 fc1 sc0 ls0 ws0">代码规范与数据规范</div><div class="t m0 x5 hd y28 ff3 fs6 fc2 sc0 ls0 ws0">•</div><div class="t m0 xc he y29 ff2 fs6 fc1 sc0 ls0 ws0">高效<span class="_ _5"> </span><span class="ff3">SQL<span class="_ _5"> </span></span>的书写</div><div class="t m0 xa hb y2a ff3 fs5 fc2 sc0 ls0 ws0">•</div><div class="t m0 xb hc y2b ff2 fs5 fc1 sc0 ls0 ws0">数据库配置</div><div class="t m0 x5 hd y2c ff3 fs6 fc2 sc0 ls0 ws0">•</div><div class="t m0 xc he y2d ff2 fs6 fc1 sc0 ls0 ws0">参数文件</div><div class="t m0 x5 hd y2e ff3 fs6 fc2 sc0 ls0 ws0">•</div><div class="t m0 xc he y2f ff2 fs6 fc1 sc0 ls0 ws0">表空间<span class="_ _5"> </span><span class="ff3">/<span class="_ _5"> </span></span>数据文件</div><div class="t m0 xa hb y30 ff3 fs5 fc2 sc0 ls0 ws0">•</div><div class="t m0 xb hc y31 ff2 fs5 fc1 sc0 ls0 ws0">部属应用</div><div class="t m0 x5 hd y32 ff3 fs6 fc2 sc0 ls0 ws0">•</div><div class="t m0 xc he y33 ff2 fs6 fc1 sc0 ls0 ws0">表、索引、<span class="_ _5"> </span><span class="ff3">PLSQL<span class="_ _5"> </span></span>程序</div><div class="t m0 xa hb y34 ff3 fs5 fc2 sc0 ls0 ws0">•</div><div class="t m0 xb hc y35 ff2 fs5 fc1 sc0 ls0 ws0">周期性调整</div><div class="t m0 x5 hd y36 ff3 fs6 fc2 sc0 ls0 ws0">•</div><div class="t m0 xc he y37 ff2 fs6 fc1 sc0 ls0 ws0">全面检查</div><div class="t m0 xa hb y38 ff3 fs5 fc2 sc0 ls0 ws0">•</div><div class="t m0 xb hc y39 ff2 fs5 fc1 sc0 ls0 ws0">低效时调整</div><div class="t m0 x5 hd y3a ff3 fs6 fc2 sc0 ls0 ws0">•</div><div class="t m0 xc he y3b ff2 fs6 fc1 sc0 ls0 ws0">针对性调整</div></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div>
<div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/9817392/bg4.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">EnmoTech</div><div class="t m0 x2 h4 y3 ff2 fs0 fc0 sc1 ls0 ws0">云和恩墨</div><div class="t m0 x4 h5 y3c ff3 fs1 fc1 sc0 ls0 ws0">Oracle <span class="_ _0"> </span><span class="ff2">性能因素</span></div></div><div class="c xd y3d w3 hf"><div class="t m0 xe h10 y3e ff4 fs7 fc1 sc0 ls0 ws0">Des<span class="_ _1"></span>i<span class="_ _4"></span>gn</div><div class="t m0 xf h10 y3f ff4 fs7 fc1 sc0 ls0 ws0">20%</div></div><div class="c x10 y40 w4 h11"><div class="t m0 x11 h12 y41 ff1 fs7 fc1 sc0 ls0 ws0">Da<span class="_ _1"></span>tabas<span class="_ _1"></span>e</div><div class="t m0 x12 h12 y42 ff1 fs7 fc1 sc0 ls0 ws0">17<span class="_ _1"></span>.5%</div></div><div class="c x13 y43 w5 h11"><div class="t m0 x11 h12 y44 ff1 fs7 fc1 sc0 ls0 ws0">Appl<span class="_ _4"></span>i<span class="_ _4"></span>ca<span class="_ _1"></span>ti<span class="_ _4"></span>on</div><div class="t m0 x14 h12 y45 ff1 fs7 fc1 sc0 ls0 ws0">60<span class="_ _1"></span>%</div></div><div class="c x15 y46 w6 h11"><div class="t m0 x11 h12 y47 ff1 fs7 fc1 sc0 ls0 ws0">Sys<span class="_ _1"></span>te<span class="_ _1"></span>m</div><div class="t m0 x16 h12 y48 ff1 fs7 fc1 sc0 ls0 ws0">2.5%</div></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div>
<div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/9817392/bg5.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">EnmoTech</div><div class="t m0 x2 h4 y3 ff2 fs0 fc0 sc1 ls0 ws0">云和恩墨</div><div class="t m0 x9 h5 y1a ff2 fs1 fc1 sc2 ls0 ws0">优化的方向</div><div class="t m0 x17 h13 y49 ff3 fs8 fc2 sc0 ls0 ws0">•</div><div class="t m0 x18 h14 y4a ff2 fs8 fc1 sc0 ls0 ws0">调优设计<span class="_ _6"> </span><span class="ff3">.</span></div><div class="t m0 x13 h15 y4b ff3 fs0 fc2 sc0 ls0 ws0">•</div><div class="t m0 x19 h4 y4c ff2 fs0 fc1 sc0 ls0 ws0">架构设计（<span class="_ _7"> </span><span class="ff3">Rac/<span class="_ _7"> </span></span>单机）、应用设计（模块<span class="_ _1"></span>设计、<span class="_ _7"> </span><span class="ff3">E-R<span class="_ _8"> </span></span>模型设计）</div><div class="t m0 x17 h13 y4d ff3 fs8 fc2 sc0 ls0 ws0">•</div><div class="t m0 x18 h14 y4e ff2 fs8 fc1 sc0 ls0 ws0">调优应用<span class="_ _6"> </span><span class="ff3">.</span></div><div class="t m0 x13 h15 y4f ff3 fs0 fc2 sc0 ls0 ws0">•</div><div class="t m0 x19 h4 y50 ff2 fs0 fc1 sc0 ls0 ws0">代码调优、应<span class="_ _1"></span>用存储对象调优</div><div class="t m0 x17 h13 y51 ff3 fs8 fc2 sc0 ls0 ws0">•</div><div class="t m0 x18 h14 y52 ff2 fs8 fc1 sc0 ls0 ws0">调优内存<span class="_ _6"> </span><span class="ff3">.</span></div><div class="t m0 x13 h15 y53 ff3 fs0 fc2 sc0 ls0 ws0">•</div><div class="t m0 x19 h4 y54 ff2 fs0 fc1 sc0 ls0 ws0">数据高速缓存<span class="_ _1"></span>区、共享池、重<span class="_ _1"></span>做日志缓存区、大<span class="_ _1"></span>池</div><div class="t m0 x17 h13 y55 ff3 fs8 fc2 sc0 ls0 ws0">•</div><div class="t m0 x18 h14 y56 ff2 fs8 fc1 sc0 ls0 ws0">调优<span class="_ _6"> </span><span class="ff3">I/O.</span></div><div class="t m0 x13 h15 y57 ff3 fs0 fc2 sc0 ls0 ws0">•</div><div class="t m0 x19 h4 y58 ff2 fs0 fc1 sc0 ls0 ws0">异步<span class="_ _7"> </span><span class="ff3">I/O<span class="_ _7"> </span></span>、表空间数据文件划分、<span class="_ _1"></span>存储对象分布等</div><div class="t m0 x17 h13 y59 ff3 fs8 fc2 sc0 ls0 ws0">•</div><div class="t m0 x18 h14 y5a ff2 fs8 fc1 sc0 ls0 ws0">调优竞争<span class="_ _6"> </span><span class="ff3">.</span></div><div class="t m0 x13 h15 y5b ff3 fs0 fc2 sc0 ls0 ws0">•</div><div class="t m0 x19 h4 y5c ff2 fs0 fc1 sc0 ls0 ws0">回滚段、<span class="_ _7"> </span><span class="ff3">Lock<span class="_ _7"> </span></span>、<span class="_ _8"> </span><span class="ff3">latch</span></div><div class="t m0 x17 h13 y5d ff3 fs8 fc2 sc0 ls0 ws0">•</div><div class="t m0 x18 h14 y5e ff2 fs8 fc1 sc0 ls0 ws0">调优操作系统<span class="_ _6"> </span><span class="ff3">.</span></div><div class="t m0 x13 h15 y5f ff3 fs0 fc2 sc0 ls0 ws0">•</div><div class="t m0 x19 h4 y60 ff2 fs0 fc1 sc0 ls0 ws0">共享内存段大<span class="_ _1"></span>小、 <span class="_ _8"> </span><span class="ff3">Raid<span class="_ _7"> </span></span>模式、文件系统与裸<span class="_ _1"></span>设备、文件缓存大小等</div></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div>
