Oracle数据库2天+性能调优指南

Oracle®数据库2天+性能调优指南12cRelease2(12.2)E49959-112017年5月IOracleDatabase2Day+PerformanceTuningGuide,12cRelease2(12.2)E49959-11Copyright©2007,2017,Oracleand/oritsaffiliates.Allrightsreserved.PrimaryAuthors:RajeshBhatiya,DavidMcDermid,LanceAshdown,ImmanuelChanContributors:DebadityaChatterjee,MariaColgan,DineshDas,KakaliDas,KarlDias,MikeFeng,YongFeng,AndrewHoldsworth,KevinJernigan,CarolineJohnston,AneeshKahndelwal,SushilKumar,SueK.Lee,HerveLejeune,AnaMcCollum,ColinMcGregor,MugheesMinhas,ValarieMoore,DeborahOwens,MarkRamacher,UriShaft,SusanShepard,JanetStern,StephenWexler,GrahamWood,KhaledYagoub,HailingYu,MichaelZampiceniThissoftwareandrelateddocumentationareprovidedunderalicenseagreementcontainingrestrictionsonuseanddisclosureandareprotectedbyintellectualpropertylaws.Exceptasexpresslypermittedinyourlicenseagreementorallowedbylaw,youmaynotuse,copy,reproduce,translate,broadcast,modify,license,transmit,distribute,exhibit,perform,publish,ordisplayanypart,inanyform,orbyanymeans.Reverseengineering,disassembly,ordecompilationofthissoftware,unlessrequiredbylawforinteroperability,isprohibited.Theinformationcontainedhereinissubjecttochangewithoutnoticeandisnotwarrantedtobeerror-free.Ifyoufindanyerrors,pleasereportthemtousinwriting.IfthisissoftwareorrelateddocumentationthatisdeliveredtotheU.S.GovernmentoranyonelicensingitonbehalfoftheU.S.Government,thenthefollowingnoticeisapplicable:U.S.GOVERNMENTENDUSERS:Oracleprograms,includinganyoperatingsystem,integratedsoftware,anyprogramsinstalledonthehardware,and/ordocumentation,deliveredtoU.S.GovernmentendusersarecommercialcomputersoftwarepursuanttotheapplicableFederalAcquisitionRegulationandagencyspecificsupplementalregulations.Assuch,use,duplication,disclosure,modification,andadaptationoftheprograms,includinganyoperatingsystem,integratedsoftware,anyprogramsinstalledonthehardware,and/ordocumentation,shallbesubjecttolicensetermsandlicenserestrictionsapplicabletotheprograms.NootherrightsaregrantedtotheU.S.Government.Thissoftwareorhardwareisdevelopedforgeneraluseinavarietyofinformationmanagementapplications.Itisnotdevelopedorintendedforuseinanyinherentlydangerousapplications,includingapplicationsthatmaycreateariskofpersonalinjury.Ifyouusethissoftwareorhardwareindangerousapplications,thenyoushallberesponsibletotakeallappropriatefail-safe,backup,redundancy,andothermeasurestoensureitssafeuse.OracleCorporationanditsaffiliatesdisclaimanyliabilityforanydamagescausedbyuseofthissoftwareorhardwareindangerousapplications.OracleandJavaareregisteredtrademarksofOracleand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.IntelandIntelXeonaretrademarksorregisteredtrademarksofIntelCorporation.AllSPARCIItrademarksareusedunderlicenseandaretrademarksorregisteredtrademarksofSPARCInternational,Inc.AMD,Opteron,theAMDlogo,andtheAMDOpteronlogoaretrademarksorregisteredtrademarksofAdvancedMicroDevices.UNIXisaregisteredtrademarkofTheOpenGroup.Thissoftwareorhardwareanddocumentationmayprovideaccesstoorinformationaboutcontent,products,andservicesfromthirdparties.OracleCorporationanditsaffiliatesarenotresponsibleforandexpresslydisclaimallwarrantiesofanykindwithrespecttothird-partycontent,products,andservicesunlessotherwisesetforthinanapplicableagreementbetweenyouandOracle.OracleCorporationanditsaffiliateswillnotberesponsibleforanyloss,costs,ordamagesincurredduetoyouraccesstooruseofthird-partycontent,products,orservices,exceptassetforthinanapplicableagreementbetweenyouandOracle.III译者声明本文是Oracle公司官网上《OracleDatabase2day+PerformanceTuningGuide12cRelease2(12.2)》的中文翻译版。是译者为方便自己参考学习相关知识，利用业务时间翻译而成，仅在同意Oracle上述版权协议的前提下用于个人学习和交流，请勿自行分发、印刷及其它未经授权的行为及商业用途。因译者水平及时间有限，难免有错误或不妥之处，欢迎来信指正与交流。如有侵权，请联系译者删除。联系方式：[e-mail]2017年9月IV目录前言...........................................................................................................................1第一部分入门.................................................................................................................61、介绍.....................................................................................................................71.1关于本指南................................................................................................71.2OracleDBA的日常工作..............................................................................71.3数据库调优工具........................................................................................81.4访问数据库主页面....................................................................................92、Oracle数据库性能调整方法...........................................................................112.1使用自动负载信息库收集数据库统计数据..........................................112.2Oracle数据库性能调整方法...................................................................152.3数据库中常见的性能问题......................................................................18第二部分主动数据库性能调优...................................................................................213、自动数据库性能监视.......................................................................................223.1自动数据库诊断监视概述..