您好,欢迎访问三七文档
当前位置:首页 > IT计算机/网络 > 数据库 > 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上述版权协议的前提下用于个人学习和交流,请勿自行分发、印刷及其它未经授权的行为及商业用途。因译者水平及时间有限,难免有错误或不妥之处,欢迎来信指正与交流。如有侵权,请联系译者删除。联系方式:qhwdw@163.com2017年9月IV目录前言...........................................................................................................................1第一部分入门.................................................................................................................61、介绍.....................................................................................................................71.1关于本指南................................................................................................71.2OracleDBA的日常工作..............................................................................71.3数据库调优工具........................................................................................81.4访问数据库主页面....................................................................................92、Oracle数据库性能调整方法...........................................................................112.1使用自动负载信息库收集数据库统计数据..........................................112.2Oracle数据库性能调整方法...................................................................152.3数据库中常见的性能问题......................................................................18第二部分主动数据库性能调优...................................................................................213、自动数据库性能监视.......................................................................................223.1自动数据库诊断监视概述..
本文标题:Oracle数据库2天+性能调优指南
链接地址:https://www.777doc.com/doc-4942133 .html