| 查看: 350 | 回复: 1 | ||
| 【奖励】 本帖被评价1次，作者conanwj增加金币 1 个 | ||
| 当前主题已经存档。 | ||
[资源]
【分享】[PDF]Secrets of the Oracle Database.Norbert Debes.Apress.2009[New]
|
||
|
Secrets of the Oracle Database 本资源来自于互联网，仅供学习研究之用，不可涉及任何商业用途，请在下载后24小时内删除。 著作权归原作者或出版社所有。未经发贴人conanwj许可，严禁任何人以任何形式转贴本文，违者必究！ Authors(Editors): Norbert Debes Publisher: Apress Pub Date: 2009 Pages: 554 ISBN-13 (pbk): 978-1-4302-1952-1 ISBN-13 (electronic): 978-1-4302-1953-8 Introduction Secrets of the ORACLE Database brings together a wealth of information on undocumented as well as incompletely documented features of the ORACLE database management system (DBMS). It has been my goal to combine many of the hidden features of the ORACLE database server into a single source. You will be hard-pressed to find the same density of material on advanced, undocumented topics in another book. Certain topics addressed may also be found in articles on the Internet, but I have striven to provide more background information and indepth examples than are usually available on the Internet. The book also contains a significant amount of original material, such as the inclusion of think time in resource profiles for performance diagnosis, an emergency procedure for the conversion of a RAC installation to a single instance installation, as well as the integration of Statspack, Active Workload Repository, and Active Session History with SQL trace. The book is intended to complement the vast documentation from Oracle Corporation as well as articles found on Oracle’s Metalink support platform. Arguably, the omission of some features from Oracle’s documentation might be considered a documentation bug. Many features, especially among those for troubleshooting (e.g., events) and tracing, remain undocumented on purpose and for good reason, since Oracle Corporation rightfully suspects that they might backfire when used in the wrong situation or without fully understanding the implications of their use. Such features are not the subject of this book either. Instead, this text is centered on those undocumented features that provide significant benefit without compromising the integrity or availability of databases. In this book, a certain feature is said to be undocumented if the full text search of the documentation provided on the Oracle Technology Network2 web site does not yield any hint of the feature’s existence. A feature is said to be partially documented if the full text search does reveal that the feature exists, but significant aspects of the feature are undocumented, thus limiting the usefulness of the feature. Incomplete documentation often causes the need to investigate a feature, which constitutes a significant investment in time and thus money, to reveal the undocumented aspects through trial and error, searching the Internet, or Oracle’s Metalink support platform. A significant number of undocumented aspects unveiled in this text are not addressed by Metalink articles. This book is a highly technical book. I have spared no effort in making the material as easily accessible as possible by not assuming too much previous knowledge by the reader, adopting a clear writing style, and presenting many examples. An occasional humorous remark serves to intermittently stimulate the right brain and perhaps even trigger a grin, allowing the left analytical brain to rest for a moment before tackling more technicalities. Although this book is not expressly an ORACLE DBMS performance optimization book, it has been my intention to offer a solid performance diagnostic method based on the analysis of extended SQL trace data. To the best of my knowledge, this is the first book that covers the Oracle10g and Oracle11g extended SQL trace file formats, which differ in several important aspects from the format used by Oracle9i. I sincerely hope that the free extended SQL trace profiler ESQLTRCPROF provided with the book will help to quickly diagnose and solve difficult performance problems you might face. As far as I know, ESQLTRCPROF is the only profiler that classifies the wait event SQL*Net message from client into unavoidable latency due to client/ server communication and think time due to non-database–related processing by the client. This configurable feature of the profiler alone is immensely valuable in situations where proof is needed that the ORACLE DBMS is not the cause of a performance problem. Since think time cannot be optimized, except by recoding the application or other applications waited for, proper identification of think time will also aid in estimating the maximum speedup attainable by tuning interactions between client and DBMS instance. In situations where it’s appropriate for an ORACLE database administrator to see past the end of his or her nose, I include background information on operating systems, networking, and programming. I have also devoted some sections to operating system tools that are useful for troubleshooting or investigation. I hope you will agree that this leads to a broader understanding of the features discussed than could be attained by exclusively focusing on ORACLE DBMS software and leaving interactions with the operating system on which it runs aside. Given the vast amount of hidden parameters, undocumented events, and X$ fixed tables, it is impossible to cover all of these. It would keep me busy for the rest of my lifetime and I could never share the insights with my readers. It has been my goal to explain how these undocumented features integrate into the ORACLE DBMS and most of all to present a structured approach for dealing with them. Thus, after assimilating the knowledge conferred, you will be able to make your own discoveries of valuable undocumented features. 本资源共7个可选网络硬盘链接，16.08 MB。 -------------------------------------------------------------------------------------------------------- Secrets of the Oracle Database.Norbert Debes.Apress.2009.pdf Secrets of the Oracle Database.Norbert Debes.Apress.2009.pdf Secrets of the Oracle Database.Norbert Debes.Apress.2009.pdf Secrets of the Oracle Database.Norbert Debes.Apress.2009.pdf Secrets of the Oracle Database.Norbert Debes.Apress.2009.pdf Secrets of the Oracle Database.Norbert Debes.Apress.2009.pdf Secrets of the Oracle Database.Norbert Debes.Apress.2009.pdf -------------------------------------------------------------------------------------------------------- |
回复此楼» 猜你喜欢
国自然评审意见
已经有12人回复
-
国自然面上复盘~欢迎讨论
已经有14人回复
-
系统查不到
已经有11人回复
-
有多少人是今天查系统知道结果的？
已经有18人回复
-
为什么资助数各大高校都创新高，自己申请怎么就这么难
已经有12人回复
-
有没有仍没收到信息的
已经有3人回复
-
导师吐槽：我怎么摊上了这么个极品研究生！
已经有8人回复
-
基金不中，共勉
已经有11人回复
-
麻烦专家们看看评委们的意见（F口面上）
已经有9人回复
-
2026年叶企孙基金
已经有6人回复
2楼2009-11-23 13:10:06
投票:
10