24小时热门版块排行榜

返回列表

【奖励】本帖被评价1次，作者conanwj增加金币 1 个

当前主题已经存档。

conanwj

版主 (著名写手)

[资源] 【分享】[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
--------------------------------------------------------------------------------------------------------

回复此楼