» » Secrets of the Oracle Database (Expert's Voice in Oracle)

Download Secrets of the Oracle Database (Expert's Voice in Oracle) fb2

by Norbert Debes
Download Secrets of the Oracle Database (Expert's Voice in Oracle) fb2
Databases & Big Data
  • Author:
    Norbert Debes
  • ISBN:
    1430219521
  • ISBN13:
    978-1430219521
  • Genre:
  • Publisher:
    Apress; 1st ed. edition (June 2, 2009)
  • Pages:
    450 pages
  • Subcategory:
    Databases & Big Data
  • Language:
  • FB2 format
    1352 kb
  • ePUB format
    1988 kb
  • DJVU format
    1501 kb
  • Rating:
    4.5
  • Votes:
    224
  • Formats:
    txt docx azw rtf


Series: Expert's Voice in Oracle.

Norbert Debes has more than 13 years experience as an Oracle database administrator. He holds a master's degree in computer science from the University of Erlangen, Germany, and is an Oracle8, Oracle8i, and Oracle9i certified professional Oracle database administrator. For over 6 years, he held different positions and technical roles at Oracle Germany. In his last role at Oracle, Norbert was responsible for promoting Real Application Clusters on a technical level. Series: Expert's Voice in Oracle.

Start by marking Secrets of the Oracle Database (Expert's Voice in Oracle) as Want to Read .

Start by marking Secrets of the Oracle Database (Expert's Voice in Oracle) as Want to Read: Want to Read savin. ant to Read. Norbert Debes shines the light of day on features that help you master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible. Finally, in one place, you have at your fingertips knowledge that previously had to be acquired through years of experience and word of mouth through knowing the right people. What Norbert writes is accurate, well–tested, well–illustrated by clear examples, and sure to improve your ability to make an impact in your day–to–day work with Oracle.

Expert's Voice in Oracle. Norbert Debes has more than 13 years experience as an Oracle database administrator

Expert's Voice in Oracle. Covering useful but little-known features from Oracle Database 9 through Oracle Database 11, this book will improve your efficiency as an Oracle database administrator or developer. Norbert Debes has more than 13 years experience as an Oracle database administrator.

Norbert Debes has more than 13 years experience as an Oracle database administrator Right from the beginning of his quest in the Oracle database management system, Norbert always wanted to know exactly how things worked. Right from the beginning of his quest in the Oracle database management system, Norbert always wanted to know exactly how things worked. He would not be satisfied with superficial explanations, but demanded evidence.

Norbert Debes shines the light of day on features that help y. .展开全部) Covering useful but little-known features from Oracle Database 9 through Oracle Database 11, this book will.Secrets of the Oracle Database is the definitive guide to undocumented and features of the Oracle database server.

Covering useful but little-known features from Oracle Database 9 through Oracle Database 11, this book will improve your efficiency as an Oracle database administrator or developer.

Authoritative – written by an expert-level Oracle professional who spent . About this book Norbert Debes has more than 13 years experience as an Oracle database administrator.

Authoritative – written by an expert-level Oracle professional who spent several years working as an insider for Oracle Corporation. Helpful – Illuminates features that truly can be applied in production environments to help solve tough problems that Oracle administrators and developers face on a routine basis. Proven – The author’s work is accurate, well-tested, and proven by clear examples.

Covering useful but little–known features from Oracle9i Database through Oracle Database 11g, this book will .

Covering useful but little–known features from Oracle9i Database through Oracle Database 11g, this book will improve your efficiency as an Oracle database administrator or developer.

Series: Expert's Voice in Oracle. Other readers will always be interested in your opinion of the books you've read. Whether you've loved the book or not, if you give your honest and detailed thoughts then people will find new books that are right for them. File: PDF, 1. 3 MB. Читать онлайн.

Want to be notified of new releases in acle-db? . Release v. corresponds to the code in the published book, without corrections or updates.

Release v. See the file Contributing. md for more information on how you can contribute to this repository.

Secrets of the Oracle Database is the definitive guide to undocumented and partially-documented features of the Oracle Database server. Covering useful but little-known features from Oracle Database 9 through Oracle Database 11, this book will improve your efficiency as an Oracle database administrator or developer. Norbert Debes shines the light of day on features that help you master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible.

Finally, in one place, you have at your fingertips knowledge that previously had to be acquired through years of experience and word of mouth through knowing the right people. What Norbert writes is accurate, well-tested, well-illustrated by clear examples, and sure to improve your ability to make an impact on your day-to-day work with Oracle.


doesnt Do You
The "Secrets of the Oracle Database" book with the subtitle of "Advanced administration, tuning, and troubleshooting using undocumented features" follows the same pattern as most of the other Apress books, with very well researched and verified information with careful references to well regarded books and external resources. Many code samples and demonstrations are provided throughout the book in the format of: tell me about something, and then show me/prove to me that it actually works. The topics in this book reminded me a bit of the topics discussed in the book "Oracle 10g Insider Solutions," except for the fact that the "Secrets of the Oracle Database" book actually makes an effort (a very thorough effort) at indicating which features are available with each version of Oracle (through 11.1.0.7), which features require additional cost licenses (such as the use of AWR), and provides a good enough example of the features so that the feature may be utilized with an understanding of why the feature should be used. The "Secrets of the Oracle Database" book even does a thorough job indicating the permissions and/or roles needed to leverage the various features. Specific items that I found to be helpful:
* In most cases, commands are provided for Linux/Unix and the equivalents for Windows.
* Good description of SYS.AUX_STATS and the various functions to view and populate the CPU stats are described in the book.
* Very detailed description of raw 10046 trace files.
* Detailed listing of the purpose of the various database tables related to Statspack.
* Good summary of ORADEBUG functionality.
* Provides a warning not to adjust the hidden (underscore) parameters unless under the supervision of Oracle support.

With the above in mind, why not give the book a 5 out of 5 rating?
* Several Oracle features/behavior which are described as undocumented are in fact fairly well documented and/or discussed in Metalink notes, on various Oracle related blogs, and various Internet forums: Page 143 describes ALTER USER IDENTIFIED BY VALUES as being undocumented while it is documented in Metalink (279355.1 last modified 27-OCT-2008 and 1051962.101 last modified 16-OCT-2008) and on several websites. Page 136 states that the TRACE=TRUE parameter for the exp/imp and expdp/impdp utilities is undocumented while it is documented in a couple Metalink notes (271782.1 last modified 17-JAN-2005 and 286496.1 last modified 21-APR-2009) . Page 337 states that DBMS_SYSTEM is undocumented while it is documented in a couple Metalink notes (286496.1 last modified 21-APR-2009 and 103267.1 last modified 20-NOV-2002 and 436036.1 last modified 09-MAR-2009 and DBMS_SUPPORT is described in 62294.1 last modified 25-OCT-2002), several books, and several websites. Pages 271 and 371 state that the 10046 trace file format is undocumented while it is documented in a couple Metalink notes (39817.1 last modified 09-DEC-2008 and 376442.1 last modified 25-JUN-2009), two books referenced by this book ("Optimizing Oracle Performance" and "Troubleshooting Oracle Performance"), and several websites. Page 299 states that "it is undocumented which parameter changes force the optimizer to consider a new plan," after showing how changing OPTIMIZER_INDEX_COST_ADJ forced a change in the execution plan - but the book never went on to suggest checking V$SES_OPTIMIZER_ENV, V$SQL. OPTIMIZER_ENV_HASH_VALUE/V$SQL. OPTIMIZER_ENV, or a 10053 trace file.

There also appear to be a couple errors, or at least exceptions to some of the broad rules discussed in the book:
* Page 29 states that "V$PARAMETER is built in such a way that it lists documented (non-hidden) parameters only," with documented parameters being those which do not begin with one or two underscore characters. This is a correct statement, until one of the hidden parameters is modified, with a command such as the following: ALTER SYSTEM SET "_OPTIMIZER_UNDO_COST_CHANGE"='10.1.0.4'; (_OPTIMIZER_UNDO_COST_CHANGE is one of those parameters which are adjusted automatically when OPTIMIZER_FEATURES_ENABLE is set to a different value). Once the _OPTIMIZER_UNDO_COST_CHANGE parameter (or likely any _ parameter) is modified, it will then be listed along with the documented parameters in V$PARAMETER (tested on Oracle 10.2.0.2 and 11.1.0.7).
* Page 45 states "Since SELECT statements don't benefit from unused indexes... it may be worthwhile to drop unused indexes." Richard Foote's blog provides evidence that those indexes which appear to be unused indexes may actually provide the cost based optimizer statistical information that it would not otherwise have. Also, not every use of an index is recorded as a use of that index.

Given the title and subtitle of the book, I expected much more insight into the internals of Oracle databases. For instance on page 277 when describing the content of a 10046 trace file, the book stated that cr is defined simply as "consistent reads", while cu is defined simply as "current blocks processed". Page 357 gives a little more detail on the cu statistic "call parameter cu (current read) corresponds to the statistic db block gets." This limited description is disappointing as a book described as providing advanced administration, tuning, and troubleshooting techniques should be able to tell much more about the cr and cu statistics. The same might also be stated about the coverage of V$SYS_TIME_MODEL, V$LOCK, V$SQL_SHARED_CURSOR and several other features discussed in the book.

Several of the chapters (5, 6, 8, 13, 14, 15, etc.) are very short, ranging from two to five pages in length. It might have been a better idea to combine several of these small chapters and/or provide more knowledge of Oracle's internal behavior in those chapters. The author seems to favor the word "contrary" as it appears many times throughout the book. The back cover of the book indicates that this book should be read after "Troubleshooting Oracle Performance" and/or "Expert Oracle Database 11g Administration". Reading either of these two books before reading the book "Secrets of the Oracle Database" might make some of the secrets disclosed in the book seem quite ordinary.

In summary, this book's contents would likely seem as "secrets" for those DBA who have worked with Oracle for only a couple years and for those DBAs whose last book read was an Oracle 8.0.5 administrator's guide. This book contains a great collection of disconnected information about Oracle (no building process from one item to the next), but it sometimes stops short of providing undocumented secrets to those DBAs who have read a couple good books recently, read a couple good blogs, and followed along on the discussions of a couple Oracle related forums. Much of the information may be obtained from other sources, but it is helpful that so much of the information is contained in a single book.
Very Old Chap
I was sceptical to the book from the beginning. Being an Oracle DBA and published author, I bought this book without much illusions of secrets that will be revealed. It's not well written, it's hard to read and not much information is revealed. If the reader wants Oracle secrets, I recommend the latest book by Jonathan Lewis. I planned on re-reading it and posting a detailed review, but unfortunately I didn't have much time for that. This is not a book that I would recommend to an average DBA or developer.
ladushka
I am so surprised that a book like this has not already been written. In a nutshell, the book contains dozens of snippets of information that you mostly knew about but never had time to understand or learn properly.

As a DBA you're always on the lookout for those little snippets of info that just allow you to make it through one more project while keeping your sanity. You know those little things like the undocumented dbms_system parameter that allows you to write direct to the alert log, those sort of things. Well this book is jammed packed with a mish-mash of those little tricks you have been collecting for the last X number of years.

The book doesn't really have any solid structure and the author is pains to state that you simply dip into the book when you have time and pick up another titbit of info, which might come in useful one day.

The book is not for beginners, so if you are a casual user of Oracle don't bother, you will not not find it useful at all and will waste your money, it is aimed squarely at slightly more experienced DBA and a developer with serious interest in the internals of Oracle, may find it useful. Once again the author is clear at the start, the subjects are glanced over, the book gives you just about enough to get you started and leaves the rest to you to work out. Things like reading raw SQL trace files, one thing the masochist in me has always enjoyed! This book expects you to understand how to read a raw SQL trace to a basic standard before moving on to more advanced aspects of the interpreting them.

There is a great section on using the inbuilt Perl distro that comes with the RDBMS installation, nothing spectacular but extremely useful, saves you having to convince the SA to load this module and that to Oracle connectivity, so you will less of a pain to you Sys Admin when you need to script stuff up!

All sorts of stuff is covered, things like how to use DBMS_PIPE against RMAN to run your RMAN backups from within the DB using schedules, the author is big fan of STATSPACK, proving that it still has some very valid uses when working with performance issues. Lots and lots of stuff about undocumented parameters, lots of info on the more obscure DBMS packages and their uses. Info about the various and little used trace event 10027, 10053 and 10079. The books covers mainly 10g but there are lots of references to the changes in 11g and how things behaved in 9i, so quite broad in scope.

Very please with this book, I read it cover to cover, I simply couldn't put it down. I would stress again, this is not a tutorial book, most likely you will nothing if you have only a passing interest in Oracle or are just getting started as a DBA, the author expects you to be familiar with a lot of the concepts and ideas and very little introduction is given to each subject.

Another great quality release from Apress, I have yet to find an Oracle book from Apress that I have not thoroughly enjoyed and have not got my money's worth from!