|
|
|
Secret ORACLE is the
definitive guide to undocumented and partially documented features of
the ORACLE database server. This book will improve your efficiency as
an ORACLE database administrator and enable you to master more
difficult administrative, tuning and troubleshooting tasks than you
ever thought possible. Many undocumented features are very stable, even
more stable than numerous documented features. The very useful SQL*Plus
command ORADEBUG, which has been around since Oracle7, is a prime
example. Hence the material presented in the book will not become
obsolete as the next major release appears, but most of it will remain
useful for many years to come.
The book covers many undocumented
features and aspects of the ORACLE
DBMS releases 9i, 10g, and 11g including but not limited to:
- how pga_aggregate_target is implemented with hidden
parameters
- hidden parameters in general
- IND$, V$OBJECT_USAGE and index usage monitoring
- events (trace, optimizer)
- Extended SQL trace file format reference (9i, 10g, 11g)
- how to leverage the sqlid emitted to Oracle11g SQL trace files with
Statspack, AWR and ASH
- how to generate a resource profile from extended
SQL trace files
using Perl (the book includes the Perl program ESQLTRCPROF which is
better than TKPROF in
many respects) to diagnose performance problems
- Statspack (undocumented parameters, how to link the
hash value in
SQL trace to Statspack)
- using the undocumented ORADEBUG command for
tracing, hang
analysis, and performance diagnostics
- application instrumentation for leveraging tracing
and statistics collection with DBMS_MONITOR with a special look at JDBC
instrumentation
- the MERITS performance optimization method, which
extends the state of the art wait event tuning paradigm
- undocumented aspects of V$ views
- X$ fixed tables
- undocumented packages (DBMS_SYSTEM, DBMS_SUPPORT,
DBMS_IJOB,
DBMS_BACKUP_RESTORE) and partially documented packages (DBMS_SCHEDULER
and external jobs, DBMS_UTILITY)
- writing applications for monitoring, performance
optimization, benchmarking and data extraction using the undocumented
Perl DBI distribution inside each Oracle10g/11g installation
- undocumented aspects of Real Application Clusters
(removing the RAC
option in case of emergency, manual load rebalancing after node failure
with services and
TAF)
Available online at Lulu.com, Amazon.com,
Amazon.de
(for customers within the EU), Barnes
& Noble, and Borders
Secret ORACLE
is featured in the book review section of the Northern California Oracle Users Group
Journal (November 2008). The review was
written by Brian Hitchcock, a Senior Oracle DBA at Sun Microsystems and
a frequent speaker at Oracle OpenWorld. Brian recommends Secret ORACLE to other readers with
DBA experience and is convinced "that a junior DBA could benefit as
well". He is impressed by the amount of new information he learned and
by the overall quality: "I just finished reading a book from Oracle
Press that had many errors, both typos and factual errors. I was
surprised that a self-published book would have many fewer errors than
a book from a major publisher."
While he cautions the reader against actually using undocumented
features, he acknowledges that the book does a great job at explaining
the undocumented aspects and inner workings of certain documented
features, e.g. PGA_AGGREGATE_TARGET, V$SESSION_WAIT, V$OBJECT_USAGE,
and Advanced Queuing: "Learning about undocumented features can help
you use the normal features better."
This quote from Brian's review says it all: "How much did I like this
book? In the first 30 pages I found so many things that I didn’t know
but that I think are worth knowing that I can’t describe them all to
you in this review. That’s how good this book is."
Read the full review here.
Secret ORACLE
received an enthusiastic review
by DOAG News, a
publication of the German Oracle Users
Group DOAG (volume 2/2008, ISSN 09 36-0360). The reviewer was
impressed by the amount and depth of information on ORACLE database
performance optimization and praises the large collection of highly
useful scripts provided to the readers. The chapter on Statspack was
well received due to a procedure for finding the most resource
intensive Statspack snapshots in a repository of hundreds or even
thousands of Statspack snapshots. The reviewer also liked the chapter
on the MERITS Oracle database performance optimization method. The
MERITS method is a six-step approach (Measure, assEss, Reproduce,
Improve, forecasT, inStall) to performance optimization that emphasizes
accurately measuring and diagnosing performance problems thus
eliminating trial and error. Click here to read the review.
To encourage sales directly from the publisher Lulu.com , readers who
present a valid Lulu order number and date to ORADBPRO Publishing will
receive a revised edition of the extended SQL trace profiler
ESQLTRCPROF. ESQLTRCPROF is a valuable performance diagnosis tool
which goes beyond the capabilities of TKPROF. The enhanced version has
the following new features:
- accounting of elapsed time, cpu time, and wait time
per dependency level
- calculation of percentage of total response time
for each SQL or PL/SQL statement
- input file name and trace file header included in
output
- extraction of missing SQL statement texts from
cursor dumps (if present in trace file due to an ORADEBUG dump command)
- support for trace files without database calls
(PARSE, EXEC, FETCH), e.g. from background processes when analyzing a
slow roll forward with extended SQL trace
- millisecond precision for additional metrics
Please send valid Lulu order number and date by e-mail to ORADBPRO
Publishing to receive the enhanced profiler (see tab Contact for e-mail address).
|
|
|
|
|
|
|
|
|
|
|
|