没有合适的资源?快使用搜索试试~ 我知道了~
首页Oracle性能调优宝典:从入门到高级应用
Oracle性能调优宝典:从入门到高级应用
4星 · 超过85%的资源 需积分: 9 7 下载量 83 浏览量
更新于2024-08-01
收藏 8.29MB PDF 举报
《Expert One-on-one Oracle》是一本专注于Oracle数据库性能调优的专业书籍,旨在帮助读者深入了解Oracle系统的各个方面,提升应用程序开发效率并优化数据库性能。本书适合所有对Oracle技术感兴趣的开发者和DBA,特别是那些希望提高应用程序运行速度和数据库管理能力的人士。
书中首先在引言部分介绍了作者的理念和本书的目的,强调了它不仅提供深入的技术讲解,还关注于实践应用中的问题解决策略。作者提倡一种理解Oracle架构的方法,区分了开发者的黑盒与DBA的白盒视角,鼓励读者采用合适的开发方式来实现高效数据库应用程序。
第一章"Developing Successful Oracle Applications"涵盖了关键概念和实践技巧。这部分着重于如何开发出能够快速响应的Oracle应用程序,包括理解Oracle架构、并发控制机制以及如何确保数据库独立性。此外,作者强调了开发者与DBA之间的合作关系,认为理解这两者之间的互动对于优化性能至关重要。
第二章"Architecture"详细解析了Oracle服务器的工作原理,包括服务器组件(如服务器端进程)、数据存储结构(如参数文件、数据文件、临时文件、控制文件和重做日志文件)及其功能。读者将在这里学习到如何配置这些元素以适应不同的性能需求。
此外,书中还涉及高级SQL特性,以及如何利用Oracle的可扩展性和安全性进行应用程序设计。书末的附录通常包含实用工具、编码规范、环境设置指南等补充信息,便于读者获取最新的源代码和更新内容。
《Expert One-on-one Oracle》是一本极具价值的参考书籍,无论是对于初学者还是经验丰富的Oracle专业人员,都能从中收获性能调优和最佳实践的知识,从而提升Oracle系统的整体效能。通过深入浅出的方式,作者帮助读者跨越理论与实践的鸿沟,成为真正的Oracle性能优化专家。
Expert one-on-one Oracle
16
Overview..............................................................................................................................1341
Step1:CreatingtheDataDictionary ................................... 1341
Step2:UsingLogMiner.............................................. 1345
OptionsandUsage.............................................................................................................1352
UsingLogMinertoFindOutWhen...............................................................................1355
PGAUsage...........................................................................................................................1357
LogMinerLimits................................................................................................................1359
OracleObjectTypes ................................................. 1359
ChainedorMigratedRows ........................................... 1363
Otherlimits ........................................................ 1366
V$LOGMNR_CONTENTS ..............................................................................................1367
Summary..............................................................................................................................1370
AppendixAI:DBMS_OBFUSCATION_TOOLKIT............................................................1372
Overview..............................................................................................................................1372
TheWrapper .......................................................................................................................1374
Caveats .................................................................................................................................1392
KeyManagement ...............................................................................................................1394
TheClientApplicationManagesandStoresKeys ........................ 1394
StoretheKeysintheSameDatabase ................................... 1395
StoretheKeysintheFileSystemwiththeDatabase...................... 1396
Summary..............................................................................................................................1397
AppendixAJ:DBMS_OUTPUT..............................................................................................1398
Overview..............................................................................................................................1398
HowDBMS_OUTPUTWorks.........................................................................................1399
DBMS_OUTPUTandOtherEnvironments..................................................................1404
GettingAroundtheLimits...............................................................................................1409
UsingASmallWrapperFunctionorAnotherPackage ................... 1409
CreatingDBMS_OUTPUTFunctionality................................ 1411
Summary..............................................................................................................................1418
AppendixAK:DBMS_PROFILER..........................................................................................1419
Overview..............................................................................................................................1419
Caveats .................................................................................................................................1431
Summary..............................................................................................................................1432
AppendixAL:DBMS_UTILITY..............................................................................................1433
Overview..............................................................................................................................1433
COMPILE_SCHEMA ........................................................................................................1433
ANALYZE_SCHEMA........................................................................................................1438
ANALYZE_SCHEMAwithaChangingSchema ......................... 1440
ANALYZE_SCHEMAdoesnotAnalyzeEverything ..................... 1440
ANALYZE_DATABASE ...................................................................................................1442
FORMAT_ERROR_STACK.............................................................................................1442
FORMAT_CALL_STACK ................................................................................................1444
GET_TIME...........................................................................................................................1448
Expert one-on-one Oracle
17
GET_PARAMETER_VALUE ...........................................................................................1449
NAME_RESOLVE..............................................................................................................1450
NAME_TOKENIZE ...........................................................................................................1453
COMMA_TO_TABLE,TABLE_TO_COMMA ............................................................1457
DB_VERSIONandPORT_STRING ..............................................................................1459
GET_HASH_VALUE.........................................................................................................1460
Summary..............................................................................................................................1466
AppendixAM:UTL_FILE ........................................................................................................1467
Overview..............................................................................................................................1467
TheUTL_FILE_DIRinit.oraparameter .........................................................................1467
AccessingMappedWindowsDrives .............................................................................1469
HandlingExceptions .........................................................................................................1471
DumpingaWebPagetoDisk .........................................................................................1472
1023ByteLimit ...................................................................................................................1473
ReadingADirectory..........................................................................................................1474
Summary..............................................................................................................................1476
AppendixAN:UTL_HTTP.......................................................................................................1477
Overview..............................................................................................................................1477
UTL_HTTPFunctionality.................................................................................................1477
AddingSSLtoUTL_HTTP ..............................................................................................1480
ReallyUsingUTL_HTTP..................................................................................................1487
ABetterUTL_HTTP ..........................................................................................................1490
Summary..............................................................................................................................1501
AppendixAO:UTL_RAW........................................................................................................1503
Overview..............................................................................................................................1503
AppendixAP:UTL_SMTPandSendingMail .....................................................................1506
Overview..............................................................................................................................1506
UTL_SMTP‐alargerexample.........................................................................................1506
LoadingandusingtheJavaMailAPI .............................................................................1512
Summary..............................................................................................................................1521
AppendixAQ:UTL_TCP..........................................................................................................1522
Overview..............................................................................................................................1522
TheSocketType..................................................................................................................1523
Summary..............................................................................................................................1537
AppendixB:Support,Errataandp2p.wrox.com..................................................................1539
Overview..............................................................................................................................1539
TheOnlineForumsatp2p.wrox.com.............................................................................1539
HowToEnrollForSupport........................................... 1539
WhyThisSystemOffersTheBestSupport .............................. 1540
CheckingtheErrataOnlineathttp://www.wrox.com/ ...............................................1541
FindinganErratumontheWebSite ................................... 1541
AddanErratum .................................................... 1541
HowtoTellUsExactlyWhatYouThink ......................................................................1543
Expert one-on-one Oracle
18
Introduction
Theinspirationforthematerialcontainedinthisbookcomesfrommyexperiences
developingOraclesoftwareandworkingwithfellowOracledevelopers,helpingthem
buildreliableandrobustapplicationsbasedontheOracledatabase.Thebookisbasicallya
reflectionofwhatIdoeverydayandoftheissuesIseepeopleencounteringeachand
everyday.
IcoveredwhatIfeltwasmostrelevant‐namelytheOracledatabaseanditsarchitecture.I
couldhavewrittenasimilarly‐titledbookexplaininghowtodevelopanapplicationusing
aspecificlanguageandarchitecture‐forexample,oneusingJavaServerPagesthatspeak
toEnterpriseJavaBeans,thatuseJDBCtocommunicatewithOracle.However,attheend
oftheday,youreallydoneedtounderstandthetopicscoveredhereinordertobuildsuch
anapplicationsuccessfully.ThisbookdealswithwhatIbelieveneedstobeuniversally
knowntodevelopsuccessfullywithOracle,whetheryouareaVisualBasicprogrammer
usingODBC,aJavaprogrammerusingEJBsandJDBC,oraPerlprogrammerusingDBI
Perl.Thisbookdoesnotpromoteanyspecificapplicationarchitecture;itdoesnotcompare
3‐tiertoclient‐server.Rather,itcoverswhatthedatabasecandoandwhatyoumust
understandaboutthewayitworks.Sincethedatabaseisattheheartofanyapplication
architecture,thebookshouldhaveabroadaudience.
WhatthisBookisAbout
Oneoftheproblemswithhavingplentyofdevelopmentoptionsisintryingtofigureout
whichonemightbethebestchoiceforyourparticularneeds.Everyonewantsasmuch
flexibilityaspossible(asmanychoicesastheycanpossiblyhave)buttheyalsowant
thingstobeverycutanddry;inotherwords,easy.Oraclepresentsthedeveloperwith
almostunlimitedchoice.NooneeversaysʹyoucanʹtdothatinOra cleʹ‐theysayʹhow
manydifferentwayswouldyouliketodothatinOracle?ʹIhopethatthisbookwillhelp
youmakethecorrect
choice.
Itisabookforthosepeoplewhoappreciatethechoicebutwouldalsolikesomeguidelines
andpracticalimplementationdetailsonOraclefeaturesandfunctions.Forexample,
Oraclehasareallyneatfeaturecalledthevirtualprivatedatabase.Oracledocumentation
tellsyouhowtousethisfeatureand
whatitdoes.Oracledocumentationdoesnot,
however,tellyouwhenyoushouldusethisfeatureand,perhapsevenmoreimportantly,
whenyoushouldnotusethisfeature.Itdoesnotalwaystellyoutheimplementationdetails
ofthisfeature,andifyouʹrenotawareofthem,thiscanreallycomebacktohauntyou(Iʹm
notreferringtobugs,butreallythewayitissupposedtoworkandwhatthefeaturewas
reallydesignedtodo).
Expert one-on-one Oracle
19
WhoShouldUsethisBook?
ThetargetaudienceforthisbookisanyonewhodevelopsapplicationswithOracleasthe
databasebackend.ItisabookforprofessionalOracledeveloperswhoneedtoknowhow
togetthingsdoneinthedatabase.Thepracticalnatureofthebookmeansthatmany
sectionsshouldalsobeveryinterestingtotheDBA.Mostoftheexamplesinthebookuse
SQL*PLUStodemonstratethekeyfeatures,soyouwonʹtfindouthowtodevelopareally
coolGUI‐butyouwillfindouthowtheOracledatabaseworks,whatitskeyfeaturescan
doandwhenthey
should(andshouldnot)beused.
ItisabookforanyonewhowantstogetmoreoutofOraclewithlesswork.Itisforanyone
whowantstoseenewwaystouseexistingfeatures.Itisforanyonewhowantstoseehow
thesefeaturescanbeapplied
intherealworld(notjustexamplesofhowtousethefeature
butwhythefeatureisrelevantinthefirstplace).Anothercategoryofpeoplethatwould
findthisbookofinterestwouldbethetechnicalmanagerinchargeofthedeveloperswho
workonOracleprojects.Insomerespects,itisjustasimportantthattheyunderstandwhy
knowingthedatabaseiscrucialtosuccess.Thisbookcanprovideammunitionforthe
managerwhowouldliketogettheirpersonneltrainedinthecorrecttechnologies,orin
ensuringthattheyalreadyknowwhattheyneedtoknow.
Inordertogetthemostoutofthisbook,thereadershouldhave:
• KnowledgeofSQL.YoudonʹthavetobethebestSQLcoderever,butagood
workingknowledgewouldhelp.
• AnunderstandingofPL/SQL.Thisisnotapre‐requisitebutwillhelpyouto
ʹabsorbʹtheexamples.Thisbookwillnot,forexample,teachyouhowtoprograma
FORloopordeclarearecordtype‐theOracledocumentationandnumerousbooks
coverthiswell.However,thatʹsnottosaythatyouwonʹtlearnalotaboutPL/SQL
byreadingthisbook.Youwill.Youʹllbecomeveryintimatewithmanyfeaturesof
PL/SQLandyouʹllseenewwaystodothings,becomeawareofpackages/features
thatperhapsyoudidnotknowexisted.
• Exposuretosome3GLlanguagesuchasCorJava.Ibelievethatanyonewhocan
readandwritecodeina3GLlanguagewillbeabletosuccessfullyreadand
understandtheexamplesinthisbook.
• FamiliaritywiththeOracleServerConceptsManual.
Afewwordsonthatlastpoint:duetoitsvastsize,manypeoplefindtheOracle
documentationsettobesomewhatintimidating.Ifyouarejuststartingoutorhavenʹtread
anyofitasyet,IcantellyouthattheOracle8iConceptsmanualisexactlytherightplaceto
start.Itisabout800pageslongandtouchesonmanyofthemajorOracleconceptsthat
youneedtoknowabout.Itmaynotgiveyoueach,andeverytechnicaldetail(thisiswhat
theother10,000to20,000pagesofdocumentationarefor)butitwilleducateyouonallof
theimportantconcepts.Thismanualtouchesthefollowingtopics(tonameafew):
Expert one-on-one Oracle
20
• Thestructuresinthedatabase,howdataisorganizedandstored.
• Distributedprocessing.
• Oracleʹsmemoryarchitecture.
• Oracleʹsprocessarchitecture.
• Schemaobjectsyouwillbeusing(tables,indexes,clusters,andsoon).
• Built‐indatatypesanduser‐defineddatatypes.
• SQL‐storedprocedures.
• Howtransactionswork.
• Theoptimizer.
• Dataintegrity.
• Concurrencycontrol.
Iwillcomebacktothesetopicsmyselftimeandtimeagain.Thesearethefundamentals‐
withoutknowledgeofthem,yourOracleapplicationswillbepronetofailure.Iencourage
youtoreadthroughthemanualandgetanunderstandingofsomeofthesetopics.
HowThisBookisStructured
Tohelpyouusethisbook,itisorganizedintosixdiscretesections(describedbelow).
Thesearenotrigiddivisions,buttheywillhelpyounavigatequicklytotheare ayouneed
most.Thisbookhas23chaptersandeachislikeaʹmini‐bookʹ‐avirtuallystandalone
component.Occasionally,Irefertoexamplesorfeaturesinotherchapters(theSecurity
section,inparticular,reliesalittlemoreonexamplesandconceptsthatarebuiltupover
severalchapters)butyoucouldprettymuchpickachapteroutofthebookandreadit
standalone.YouwillnothavetoreadChapter10tounderstandormakeuseofChapter14,
forexample.
Theformatandstyleofeachchapterisvirtuallyidentical:
• Anintroductiontothefeatureorcapability.
• Whyyoumightwanttouseit(ornot).Ioutlinethetimesyouwouldconsiderusing
thisfeatureandwhenyouwouldnotwanttouseit.
• Howtousethisfeature.NotjustacopyoftheSQLreferenceherebutratherstepby
step‐hereiswhatyouneed,hereiswhatyouhavetodo,thesearetheswitches
youneedtogothroughtogetstarted.Thingscoveredinthissectionwillbe:
Howtoimplementit
Examples,examples,andexamples
Debuggingthisfeature
Caveatsofusingthisfeature
剩余1543页未读,继续阅读
2013-10-22 上传
2008-12-18 上传
2009-01-21 上传
2008-02-28 上传
jzhStudy
- 粉丝: 0
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 新型智能电加热器:触摸感应与自动温控技术
- 社区物流信息管理系统的毕业设计实现
- VB门诊管理系统设计与实现(附论文与源代码)
- 剪叉式高空作业平台稳定性研究与创新设计
- DAMA CDGA考试必备:真题模拟及章节重点解析
- TaskExplorer:全新升级的系统监控与任务管理工具
- 新型碎纸机进纸间隙调整技术解析
- 有腿移动机器人动作教学与技术存储介质的研究
- 基于遗传算法优化的RBF神经网络分析工具
- Visual Basic入门教程完整版PDF下载
- 海洋岸滩保洁与垃圾清运服务招标文件公示
- 触摸屏测量仪器与粘度测定方法
- PSO多目标优化问题求解代码详解
- 有机硅组合物及差异剥离纸或膜技术分析
- Win10快速关机技巧:去除关机阻止功能
- 创新打印机设计:速释打印头与压纸辊安装拆卸便捷性
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功