SQL优化及系统性能诊断_何为.DOCVIP

Doc Ref: REF DocRefNumber \* MERGEFORMAT Document Reference Number REF LastDate \* MERGEFORMAT September 6, 2009 STYLEREF HD2 \* MERGEFORMAT Document Control If Section 1 1 “PAGE 19 of = NUMPAGES 21 - Sec1 21” “ PAGE iii” iii File Ref: FILENAME \* FirstCap 中国外运LINUX环境SVN安装手册.doc (v. REF DocVersion \* MERGEFORMAT DRAFT 1A ) Company Confidential - For internal use only SQL优化及系统性能诊断 Author: Octavius.He Creation Date: createdate \@ MMMM d, yyyyMay 28, 2013 Last Updated: savedate \@ MMMM d, yyyyJune 20, 2013 Document Ref: Document Reference Number Version: DRAFT 1A Approvals: Approver 1 Approver 2 autotext PIC Oracle Logo \* Mergeformat Copy Number _____ Document Control Change Record SECTIONPAGES \* MERGEFORMAT 3 Date Author Version Change Reference CREATEDATE \@ d-MMM-yy 28-May-13 Octavius.He Draft 1a No Previous Document Reviewers Name Position Distribution Copy No. Name Location Library Master Project Library Project Manager Note To Holders: If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes. If you receive a hard copy of this document, please write your name on the front cover, for document control purposes. Contents TOC \o 2-3 Document Control PAGEREF _Toc377398282 \h ii 1. 开场白 PAGEREF _Toc377398283 \h 2 1.1. 三个简单问题 PAGEREF _Toc377398284 \h 2 1.2. 简单的实验 PAGEREF _Toc377398285 \h 2 2. SQL优化ABC PAGEREF _Toc377398286 \h 4 2.1. 最简单的优化准则 PAGEREF _Toc377398287 \h 4 2.2. ORACLE直方图 PAGEREF _Toc377398288 \h 4 2.3. FND_STATS PAGEREF _Toc377398289 \h 5 3. EBS性能调优 PAGEREF _Toc377398290 \h 6 3.1. SQL代码很慢或突然变慢（展开） PAGEREF _Toc377398291 \h 6 3.2. EBS整体性能调优（展开） PAGEREF _Toc377398292 \h 6 4. AWR PAGEREF _Toc377398293 \h 9 4.1. 什么是AWR PAGEREF _Toc377398294 \h 9 4.2. 启用AWR PAGEREF _Toc377398295 \h 9 4.3. 生成AWR快照 PAGEREF _Toc377398296 \h 10 4.4. 生成AWR报告 PAGEREF _Toc377398297 \h 10 4.5. AWR的作用 PAGEREF _Toc377398298 \h 12 1. RAC模式下的调优