Jetzt eintauschen
und EUR 6,48 Gutschein erhalten
Möchten Sie verkaufen? Hier verkaufen
Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Keine Abbildung vorhanden

Den Verlag informieren!
Ich möchte dieses Buch auf dem Kindle lesen.

Sie haben keinen Kindle? Hier kaufen oder eine gratis Kindle Lese-App herunterladen.

Expert Oracle Database 11g Administration (Expert's Voice in Oracle) [Englisch] [Taschenbuch]

Sam Alapati

Erhältlich bei diesen Anbietern.


14. November 2008 143021015X 978-1430210153 2009

Sam Alapati's Expert Oracle Database 11g Administration is a comprehensive handbook for Oracle database administrators (DBAs) using the 11g release of the Oracle Database. All key aspects of database administration are covered, including backup and recovery, day–to–day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It'll help you get the job done.

  • Comprehensive handbook for Oracle Database administrators. Covers all major aspects of database administration.
  • Tests and explains in detail key DBA commands.
  • Offers primers on Linux/Unix, data modeling, SQL, and PL/SQL.

Hinweise und Aktionen

  • Studienbücher: Ob neu oder gebraucht, alle wichtigen Bücher für Ihr Studium finden Sie im großen Studium Special. Natürlich portofrei.


Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr



Sam Alapati s Expert Oracle Database 11g Administration is a comprehensive handbook for Oracle database administrators (DBAs) using the latest release of the Oracle Database (Oracle Database 11g). All key aspects of database administration are covered, including backup and recovery, day to day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It ll help you get the job done. * Comprehensive handbook for Oracle DBAs. Covers all major aspects of database administration. * Tests and explains in detail key DBA commands. * Offers primers on Linux/Unix, data modeling, SQL, and PL/SQL.

Über den Autor und weitere Mitwirkende

Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle Certified Professional designation and the Hewlett-Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of America's national headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid-1980s. He is also well-versed in the Microsoft SQL Server, Sybase, and IBM DB2 database management systems.

In diesem Buch (Mehr dazu)
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis
Hier reinlesen und suchen:

Eine digitale Version dieses Buchs im Kindle-Shop verkaufen

Wenn Sie ein Verleger oder Autor sind und die digitalen Rechte an einem Buch haben, können Sie die digitale Version des Buchs in unserem Kindle-Shop verkaufen. Weitere Informationen


Es gibt noch keine Kundenrezensionen auf
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Sterne
Die hilfreichsten Kundenrezensionen auf (beta) 4.7 von 5 Sternen  3 Rezensionen
34 von 34 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Great Reference, Even with a Couple Accuracy Problems 6. September 2009
Von Charles Hooper - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
This is a huge book, which could possibly best be described as the condensed encyclopedia of Oracle databases. The book covers everything from administration to performance tuning to using SQL*Plus to installing Oracle on Linux to using RMAN. While I did not read this book cover to cover, I did page through the book looking for interesting topics to read. I did read the author's "Expert Oracle Database 10g Administration" book cover to cover a couple years ago and was at the time very impressed with that book. There were a couple small errors in the 10g book, repeated a couple times, but I commented to a couple people that the 10g book is by far the best and most thorough Oracle reference book that I had run across. The appendix at the back of the 10g book was very effective in helping me find exactly the right topic, and usually the right syntax for just about any task. The appendix in the 11g version of the book is just about as good. It appears that the author may have rushed the job of updating the 10g book for 11g R1 as quite a few screen captures still show Oracle versions such as and a couple other sections of the book also seem to be more specific to 10g R1 than 11g R1 (or 11g R2).

This book contains a lot of great and/or very helpful information, but while paging through the book I found a couple problems. Overlooking the problems, I would still recommend this book as a reference for Oracle 11g R1. The section on performance tuning is not my first choice for performance tuning information.

Problems found when paging through the book (I know that I probably missed several issues):
Page 90 mentions RAID 0+1 but not the more robust RAID 10.

Page 92 states "RAID 5 offers many advantages over the other levels of RAID. The traditional complaint about the `write penalty' should be discounted because of sophisticated advances in write caches and other strategies that make RAID 5 more efficient than in the past." Visit [...] to see the opinions of other DBAs.

Page 166 states "if you use an Oracle block size of 64KB (65,536 bytes)..." The maximum supported block size is 32KB, not 64KB, and some platforms support a maximum of a 16KB block size.

Page 171 states when suggesting the use of multiple block sizes in a single database "if you have large indexes in your database, you will need a large block size for their tablespaces." "Oracle provides separate pools for the various block sizes, and this leads to better use of Oracle memory." For those who have followed the multiple block size discussions over the years, it should be fairly clear that it is not a good idea to use multiple block sizes in a single database. Oracle's documentation states that multiple block sizes are intended to be used only to support transportable tablespaces.

Page 181 states "The database writer process writes dirty blocks to disk under the following conditions... Every 3 seconds." A check of the Oracle documentation will quickly confirm that this is not the case.

Page 182 states "Oracle further recommends that you first ensure that your system is using asynchronous I/O before deploying additional database writer processes beyond the default number - you might not need multiple database writer processes if so." I think that I misread this several times as saying "do not enable multiple database writers unless you also plan to enable asynchronous I/O," which would be an incorrect statement.

Page 190 states "this is why the buffer cache hit ratio, which measures the percentage of time users accessed the data they needed from the buffer cache (rather than requiring a disk read), is such an important indicator of performance of the Oracle instance." The author provides a link on page 1161 to an article authored by Cary Millsap which discusses why a higher buffer cache hit ratio may not be ideal. This is definitely a step in the right direction regarding the buffer cache hit ratio, but it might be better to simply ignore the statistic.

Page 190 when describing the buffer cache hit ratio states that the formula for calculating the hit ratio is "hit rate = (1 - (physical reads)/(logical reads))*100". The Oracle Database Performance Tuning Guide 11g Release 1 manual states that the correct formula is "1 - (('physical reads cache')/('consistent gets from cache'+'db block gets from cache'))"

Page 395 states "11.1.0 is an alternative name for Oracle Database 11g Release 2." Oracle 11g R2 was just released on September 1, 2009 and its version is

Page 402 correctly (according to the documentation) states that Oracle Enterprise Linux 4 and 5, as well as Red Hat Enterprise Linux are supported platforms for Oracle Database 11g, and correctly (according to the documentation) does not list Red Hat Enterprise Linux 3. Page 403 lists the required RPM packages for Red Hat Enterprise Linux 3, but ignores the supported Linux platforms.

Page 405 shows parameters that need to be set on Linux. This appears to be a direct copy of the parameters in the Oracle documentation, but the author did not include the net.core.wmem-max parameter. Note that Oracle will require different parameters than those specified in this book, but that is not the fault of the author.

Page 452 states that the COMPATIBLE parameter may be set to "10.2 so the untested features of the new Oracle version won't hurt your application." I think that this is misleading at best.

Page 466 states "If you're supporting data warehouse applications, it makes sense to have a very large DB_BLOCK_SIZE - something between 8KB and 32KB. This will improve database performance when reading huge chunks from disk." This is not quite a correct statement, especially if the DB_FILE_MULTIBLOCK_READ_COUNT is set correctly, or not set in the case Oracle or above is in use. 8KB is the standard block size, so I am not sure why the author groups it with the other block sizes in the very large block size group.

Page 477 states "the default value for the STATISTICS_LEVEL initialization parameter is TYPICAL. You need to use this setting if you want to use several of Oracle's features, including Automatic Shared Memory Management." This is an incomplete statement as a setting of ALL will also work.

Page 1055 shows the use of both CASCADE>=YES and CASCADE=>'TRUE' with DBMS_STATS. I believe that TRUE is the correct syntax, but it should not be specified in single quotes.

Page 1067 states "subqueries perform better when you use IN rather than EXISTS." The reality is that Oracle may very well automatically transform queries using IN syntax into queries using EXISTS syntax (or vice-versa), and may even transform both IN syntax queries and EXISTS syntax queries into standard join syntax.

Page 1074 stated that "inline stored functions can help improve the performance of your SQL statement." The author then demonstrated this concept by converting a SQL statement with a three table equijoin accessing apparent primary and foreign keys of the tables into a SQL statement which accessed a single table and called two PL/SQL functions (per row), each of which queried one of the other two tables which were included in the original equijoin SQL statement. This approach does not seem to be a good idea given the number of additional context switches which will result, as well as the additional number of parse calls. In short, do not solve something in PL/SQL when it may be easily solved in SQL alone.

Page 1075 states "you should avoid the use of inequality and the greater than or equal to predicates, as they may also bypass indexes." Something does not look right about that statement.

Page 1089 states "the indexes could become unbalanced in a database with a great deal of DML. It is important to rebuild such indexes regularly so queries can run faster." Interesting suggestion - I believe that standard SELECT statements are classified as DML as they are definitely not DDL. An index cannot become unbalanced, and indexes rarely need to be rebuilt - see Richard Foote's blog for the more details.

Page 1089 states "when you rebuild the indexes, include the COMPUTE STATISTICS statement so you don't have to gather statistics after the rebuild." Oracle 10g and above automatically collect statistics when building indexes, and I would assume that the same is true when rebuilding indexes.

Page 1108 states that "cpu_time is the total parse and execute time" when describing the columns found in V$SQL. It is actually the time measure in centiseconds (100th of a second) of the CPU utilization when executing the SQL statement, and probably also includes the CPU time for parsing the SQL statement, but I have not verified this.

Page 1154 provides a demonstration of finding sessions consuming a lot of CPU time. The example used the `CPU used by this session' statistic rather than drilling through V$SYS_TIME_MODEL into V$SESS_TIME_MODEL. The example used the `CPU used by this session' as a reason for examining parse CPU usage and recursive CPU usage. While it is good to check CPU usage of sessions, there are a couple problems with this approach. First, the `CPU used by this session' statistic is not updated until the first fetch from a SQL statement is returned to the client. If the client was waiting for the last hour for the first row to be returned, the CPU utilization will show close to 0 seconds difference between the start of the SQL statement and the check of the `CPU used by this session' statistic in V$SESSTAT - this is not the case for the statistics in V$SESS_TIME_MODEL, which are updated in near real-time. Second, the change (delta) in the statistic for the sessions was not determined - if one session had been connected for 120 days, it probably should have consumed more CPU time than a session connected for 30 minutes, and probably should not be investigated.

Even with the above issues, I would still recommend this book as a reference. For specific information on performance tuning, using RMAN, or installing on Linux, it might be a good idea to use a second book for deeper understanding of the process.
13 von 14 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Awesome book on Oracle Administration 30. März 2009
Von F. Stepanski - Veröffentlicht auf
Lets me honest, as I have said in other reviews of Oracle 11g, Oracle 11g is a beast. There are so many new features that have been added to it in this new version that it sometimes feels that you are learning a whole new database.

Yes, Oracle 11g is pretty much the defacto standard when it comes to DBMS but it can take years to fully master all its complexities. I've only been using Oracle for a few years and sometimes I still consider myself a newbie at time.

So even though this book seems like a monster too (1300+ pages), it is something that no Oracle DBA or even casual user should be without. The author, Sam Alapati really covers everything there is to know to fully administer Oracle 11g and some things I didnt even know existed until I went through the book. You dont have to read this book cover to cover to fully appreciate this book's wealth of knowledge.

The book is very well organized and makes it really easy to find exactly what you are looking for. Since a book this size really has to be well organized otherwise you will spend hours trying to find something. Not only is this book very well organized but is written in a way in that you don't have to be a genius to understand it. I've read so many other Oracle books that assume you have a Phd in engineering or something to understand what the author is talking about.

This book explains all the topics in an easy to read and digest manner with plenty of "real-life" examples that you probably already have encountered at work using Oracle.

The book is divided into 7 sections: Data Modeling, Achitecture, Installation and Upgrading, User Management, Backup and Recovery, Managing, and Performance Tuning.

The author explains so much excellent information in this book than its really like getting 2 or 3 books in one. The Performance section alone is worth the price alone since many other Oracle books barely talk about this topic unless its a separate book. And the Architecture and Installation sections really explain how the new version (11g) really differs from previous versions and quickly makes you understand how much has changed from older versions.

This book can also be used as reference book for getting your Oracle certifications as well: Oracle Database SQL Certified Expert exam.

So I highly recommend this book to anyone who really wants to learn Oracle the right way and save money in the process since you really do not need another book! A great buy!
5 von 5 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Using for reference 8. März 2011
Von Sudheer R. Mallepally - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
Purchased this book based on my good experience with this author's writing style(easy to read and follow) with 10g books. What I have read so far is very well explained. I am not planning to read to whole book right away, will be using this book as a reference. I have noticed few errors in the book and went to the publishers website to see corrections for the same and could not find any. I could not find the author's email contact anywhere in the book to give him a feedback and clarify few things. Sam, if you read this review please contact me at


The author contacted me and clarified what I was looking for, at this point I do not have any further questions.
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Erster Beitrag:
Eingabe des Log-ins

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen

Ähnliche Artikel finden

Ihr Kommentar