This is a collection of Oracle \/ Unix books which are highly recommended.<\/p>\n
\n\n\n\n<\/a><\/td>\n\nHOWTO Secure and Audit Oracle 10g and 11g<\/a><\/h3>\nRon Ben Natan<\/h4>\nI can really recommend this book to anybody who is interested in making Oracle database systems more secure and to get an overview of all the security features and possibilities of current Oracle database releases. It covers versions 10g and 11g and contains not only excellent explanations of the different features but also practical examples of how to implement them. A highlight of the book is the focus on consequences of different features on database performance. The reader can really profit from the authors expertise in this area of technology.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nExpert Oracle JDBC Programming<\/a><\/h3>\nR.M. Menon<\/h4>\nFor me personally, the book served its purpose of giving me a very good picture of how the Oracle database can be used by Java Applications using JDBC connectivity. When discussing with Java developers about Oracle, it is important to be familiar with the concepts of JDBC and how they can be implemented in Java. The book has helped me changing the perspective from the database administrators point of view to the java developers angle.<\/p>\nThe author explains the 4 different types of JDBC Drivers, why it is a good idea to turn Autocommit off, etc. but perhaps the most basic but essential information given in the book is the distinction between the Statement and the PreparedStatement Interface and a clear recommendation to NOT use Statement class in production code. Moreover, the standard update batching as well as Oracle update batching is introduced with the recommendation to prefer the oracle implementation for performance reasons.<\/p>\nApart from that, the more advanced features Statement Caching as well as Connection Pooling and Caching were of most interest to me. Although it did not make a java developer out of me, I could use the sample code to get familiar with the concepts. Other than that, the book is great as a reference to come back to different topics if need arises.<\/p>\nI can recommend this book to any Oracle database administrator, who wants to understand, how Java Applications use JDBC to interact with the database. On the other hand, it is a must-read for any Java Developer working with Oracle JDBC. Beware that this is not a book to learn Java, but specifically for understanding Oracle database interaction with JDBC.<\/td>\n<\/tr>\n\n\n<\/a><\/td>\n\nTroubleshooting Oracle Performance<\/a><\/h3>\nChristian Antognini<\/h4>\nThis book is exremely useful for Oracle Administrators and Developers alike. It is easy to understand and contains valuable information for everybody interested in understanding Oracle performance issues. The author demonstrates an excellent method to identify wrong Optimizer estimates that lead to suboptimal execution plans.<\/p>\nThe author shares dozens of “best-practices” and advices from his personal consulting experience as well es detailed information which is not available in Oracle documentation.<\/p>\nMy personal highlight was the introduction to a sophisticated, yet easy-to-use SQL Trace Analyzer TVD$XTAT which overcomes the limits of tkprof for SQL Response Time Analysis.<\/p>\nThis book is a must-have for every Oracle professional.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nOracle Automatic Storage Management<\/a><\/h3>\nVengurlekar, Vallath, Long<\/h4>\nAt the time of the release of this book, it was the only book available on the topic of ASM. I contains all the necessary information in order understand and implement ASM setups.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nPro Oracle Database 10g RAC on Linux<\/a><\/h3>\nJulian Dyke, Steve Shaw<\/h4>\nThe book does an excellent job of presenting detailed information on how to configure Linux in order to run Oracle Real Application Cluster Databases. Additionally, it contains very interesting information about Benchmarking (TPC) Concepts as well as Storage Fundamentals.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nOracle Database 10g – RMAN Backup & Recovery<\/a><\/h3>\nHart, Freeman<\/h4>\nBackup & Recovery is one of the most important topics when working with production databases. This book is in my opinion the best book in order to understand RMAN Backup and Recovery concepts as well as practical examples.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nCost Based Oracle Fundamentals<\/a><\/h3>\nJonathan Lewis<\/h4>\nCost Based Fundamentals is currently the most detailed printed information about how the Oracle core component, the query optimizer, works. Although sometimes scientifc, the author explains basic concepts of how the query optimizer costs different access operations and join methods. I am looking forward to reading the next book of Jonathan Lewis.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nEffective Oracle by Design<\/a><\/h3>\nTom Kyte<\/h4>\nEffective Oracle by Design written by Tom Kyte is a collection of techniques in order to design databases for scalability. It not only explains different features, e.g. Shared Servers, but also gives recommendations of when and when not to use it. I would recommend it to any DBA.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nExpert Oracle Database Architecture<\/a><\/h3>\nTom Kyte<\/h4>\nExpert Database Architecture covers in very detailed manner the key concepts of Oracle databases: concurrency (e.g. read consistency), transaction management, undo, redo.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nOptimizing Oracle Performance<\/a><\/h3>\nCary Millsap, Jeff Holt<\/h4>\nThis book marks a new era in Oracle Performance Management. The authors explain the concept of Method-R, a method of focusing only on response time of the most problematic business process. By collecting properly scoped 10046 trace data, performance analysts can dramatically improve performance with the maximum effect for the business.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nOracle Replication<\/a><\/h3>\nKaram, Garmany, Burleson<\/h4>\nI found this book while researching “Advanced Replication”. Although the technology is likely to be replaced by Oracle Streams, it was interesting to see some basic example setups for all kinds of replication needs.<\/p>\nPlease note:<\/strong> It seems that although I have the second edition version (Dec 2006), there is only first edition available on Amazon.<\/small><\/td>\n<\/tr>\n\n<\/a><\/td>\n\nOracle Security in der Praxis<\/a><\/h3>\nHaas<\/h4>\nSecurity ist ein oftmals vernachl\u00e4ssigter Bereich von Oracle Datenbanken. Dabei w\u00e4ren die M\u00f6glichkeiten extrem vielf\u00e4ltig. Das Buch illustriert die verschiedenen M\u00f6glichkeiten, die Datenbanken mit verschiedenen Features zu sichern.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nhp-ux internals<\/a><\/h3>\ncooper, moore<\/h4>\nThe book explains in a very deep technical way how the hp-ux operating system works. What was especially interesting for me was the section about memory management.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nPractical Oracle 8i<\/a><\/h3>\nJonathan Lewis<\/h4>\nAlthough the book does not cover any recent release, most of the information is still valuable in order to build efficient databases. It covers physical data structures (tables, indexes, IOTs, partitioning, views) as well as parallel query.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nOracle Insights – Tales of the Oak Table<\/a><\/h3>\nThe book is in my opinion more entertaining than informative. It contains multiple chapters each written by a different Oracle expert. This alone should be reason enough to get it.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nSystem Performance Tuning<\/a><\/h3>\nThe book focuses mainly on Sun Solaris (up to 8 ) and Linux and contains chapters for every part of the Performance Tuning areas: CPU, RAM, IO (Storage, Disks), Network, etc.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nOracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning<\/a><\/h3>\nThe Oracle Wait Interface is one most important features. The book explains the most important wait events, shows SQL statement for further diagnosing the reasons of the wait events and provides recommendations for reducing the occurrance of wait events.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nOracle Database 10g – Real Application Clusters Handbook<\/a><\/h3>\nThe book is in my opinion currently the best book about the internals of RAC.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/blockquote>\n
I can really recommend this book to anybody who is interested in making Oracle database systems more secure and to get an overview of all the security features and possibilities of current Oracle database releases. It covers versions 10g and 11g and contains not only excellent explanations of the different features but also practical examples of how to implement them. A highlight of the book is the focus on consequences of different features on database performance. The reader can really profit from the authors expertise in this area of technology.<\/td>\n<\/tr>\n
For me personally, the book served its purpose of giving me a very good picture of how the Oracle database can be used by Java Applications using JDBC connectivity. When discussing with Java developers about Oracle, it is important to be familiar with the concepts of JDBC and how they can be implemented in Java. The book has helped me changing the perspective from the database administrators point of view to the java developers angle.<\/p>\n
The author explains the 4 different types of JDBC Drivers, why it is a good idea to turn Autocommit off, etc. but perhaps the most basic but essential information given in the book is the distinction between the Statement and the PreparedStatement Interface and a clear recommendation to NOT use Statement class in production code. Moreover, the standard update batching as well as Oracle update batching is introduced with the recommendation to prefer the oracle implementation for performance reasons.<\/p>\n
Apart from that, the more advanced features Statement Caching as well as Connection Pooling and Caching were of most interest to me. Although it did not make a java developer out of me, I could use the sample code to get familiar with the concepts. Other than that, the book is great as a reference to come back to different topics if need arises.<\/p>\n
I can recommend this book to any Oracle database administrator, who wants to understand, how Java Applications use JDBC to interact with the database. On the other hand, it is a must-read for any Java Developer working with Oracle JDBC. Beware that this is not a book to learn Java, but specifically for understanding Oracle database interaction with JDBC.<\/td>\n<\/tr>\n
This book is exremely useful for Oracle Administrators and Developers alike. It is easy to understand and contains valuable information for everybody interested in understanding Oracle performance issues. The author demonstrates an excellent method to identify wrong Optimizer estimates that lead to suboptimal execution plans.<\/p>\n
The author shares dozens of “best-practices” and advices from his personal consulting experience as well es detailed information which is not available in Oracle documentation.<\/p>\n
My personal highlight was the introduction to a sophisticated, yet easy-to-use SQL Trace Analyzer TVD$XTAT which overcomes the limits of tkprof for SQL Response Time Analysis.<\/p>\n
This book is a must-have for every Oracle professional.<\/td>\n<\/tr>\n
At the time of the release of this book, it was the only book available on the topic of ASM. I contains all the necessary information in order understand and implement ASM setups.<\/td>\n<\/tr>\n
The book does an excellent job of presenting detailed information on how to configure Linux in order to run Oracle Real Application Cluster Databases. Additionally, it contains very interesting information about Benchmarking (TPC) Concepts as well as Storage Fundamentals.<\/td>\n<\/tr>\n
Backup & Recovery is one of the most important topics when working with production databases. This book is in my opinion the best book in order to understand RMAN Backup and Recovery concepts as well as practical examples.<\/td>\n<\/tr>\n
Cost Based Fundamentals is currently the most detailed printed information about how the Oracle core component, the query optimizer, works. Although sometimes scientifc, the author explains basic concepts of how the query optimizer costs different access operations and join methods. I am looking forward to reading the next book of Jonathan Lewis.<\/td>\n<\/tr>\n
Effective Oracle by Design written by Tom Kyte is a collection of techniques in order to design databases for scalability. It not only explains different features, e.g. Shared Servers, but also gives recommendations of when and when not to use it. I would recommend it to any DBA.<\/td>\n<\/tr>\n
Expert Database Architecture covers in very detailed manner the key concepts of Oracle databases: concurrency (e.g. read consistency), transaction management, undo, redo.<\/td>\n<\/tr>\n
This book marks a new era in Oracle Performance Management. The authors explain the concept of Method-R, a method of focusing only on response time of the most problematic business process. By collecting properly scoped 10046 trace data, performance analysts can dramatically improve performance with the maximum effect for the business.<\/td>\n<\/tr>\n
I found this book while researching “Advanced Replication”. Although the technology is likely to be replaced by Oracle Streams, it was interesting to see some basic example setups for all kinds of replication needs.<\/p>\n
Please note:<\/strong> It seems that although I have the second edition version (Dec 2006), there is only first edition available on Amazon.<\/small><\/td>\n<\/tr>\n\n<\/a><\/td>\n\nOracle Security in der Praxis<\/a><\/h3>\nHaas<\/h4>\nSecurity ist ein oftmals vernachl\u00e4ssigter Bereich von Oracle Datenbanken. Dabei w\u00e4ren die M\u00f6glichkeiten extrem vielf\u00e4ltig. Das Buch illustriert die verschiedenen M\u00f6glichkeiten, die Datenbanken mit verschiedenen Features zu sichern.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nhp-ux internals<\/a><\/h3>\ncooper, moore<\/h4>\nThe book explains in a very deep technical way how the hp-ux operating system works. What was especially interesting for me was the section about memory management.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nPractical Oracle 8i<\/a><\/h3>\nJonathan Lewis<\/h4>\nAlthough the book does not cover any recent release, most of the information is still valuable in order to build efficient databases. It covers physical data structures (tables, indexes, IOTs, partitioning, views) as well as parallel query.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nOracle Insights – Tales of the Oak Table<\/a><\/h3>\nThe book is in my opinion more entertaining than informative. It contains multiple chapters each written by a different Oracle expert. This alone should be reason enough to get it.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nSystem Performance Tuning<\/a><\/h3>\nThe book focuses mainly on Sun Solaris (up to 8 ) and Linux and contains chapters for every part of the Performance Tuning areas: CPU, RAM, IO (Storage, Disks), Network, etc.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nOracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning<\/a><\/h3>\nThe Oracle Wait Interface is one most important features. The book explains the most important wait events, shows SQL statement for further diagnosing the reasons of the wait events and provides recommendations for reducing the occurrance of wait events.<\/td>\n<\/tr>\n\n<\/a><\/td>\n\nOracle Database 10g – Real Application Clusters Handbook<\/a><\/h3>\nThe book is in my opinion currently the best book about the internals of RAC.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/blockquote>\n
Security ist ein oftmals vernachl\u00e4ssigter Bereich von Oracle Datenbanken. Dabei w\u00e4ren die M\u00f6glichkeiten extrem vielf\u00e4ltig. Das Buch illustriert die verschiedenen M\u00f6glichkeiten, die Datenbanken mit verschiedenen Features zu sichern.<\/td>\n<\/tr>\n
The book explains in a very deep technical way how the hp-ux operating system works. What was especially interesting for me was the section about memory management.<\/td>\n<\/tr>\n
Although the book does not cover any recent release, most of the information is still valuable in order to build efficient databases. It covers physical data structures (tables, indexes, IOTs, partitioning, views) as well as parallel query.<\/td>\n<\/tr>\n
The book is in my opinion more entertaining than informative. It contains multiple chapters each written by a different Oracle expert. This alone should be reason enough to get it.<\/td>\n<\/tr>\n
The book focuses mainly on Sun Solaris (up to 8 ) and Linux and contains chapters for every part of the Performance Tuning areas: CPU, RAM, IO (Storage, Disks), Network, etc.<\/td>\n<\/tr>\n
The Oracle Wait Interface is one most important features. The book explains the most important wait events, shows SQL statement for further diagnosing the reasons of the wait events and provides recommendations for reducing the occurrance of wait events.<\/td>\n<\/tr>\n
The book is in my opinion currently the best book about the internals of RAC.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/blockquote>\n
![\"\"](\"http:\/\/www.assoc-amazon.de\/e\/ir?t=osn-21&l=as2&o=3&a=159059407X\")
![\"howto_secure_and_audit_oracle_10g_and_11g\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2009\/06\/howto_secure_and_audit_oracle_10g_and_11g.jpg\" "\\"howto_secure_and_audit_oracle_10g_and_11g\\"")
<\/a><\/td>\n![\"expert_jdbc\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2009\/06\/expert_jdbc.gif\" "\\"expert_jdbc\\"")
<\/a>![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/troublshooting_oracle_performance.jpg\" "\\"troublshooting_oracle_performance\\"")
<\/a>![\"\"](\"http:\/\/www.assoc-amazon.de\/e\/ir?t=osn-21&l=as2&o=3&a=1590599179\")
<\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/oracle_automatic_storage_ma.jpg\" "\\"oracle_automatic_storage_ma\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/pro_oracle_database_10g_rac.jpg\" "\\"pro_oracle_database_10g_rac\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/rman_backup_recovery.jpg\" "\\"rman_backup_recovery\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/cost_based_fundamentals.jpg\" "\\"cost_based_fundamentals\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/effective_oracle_by_design.jpg\" "\\"effective_oracle_by_design\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/expert_oracle_database_arch.jpg\" "\\"expert_oracle_database_arch\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/optimizing_oracle_performance.jpg\" "\\"optimizing_oracle_performance\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/oracle_replication.jpg\" "\\"oracle_replication\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/oracle_security.jpg\" "\\"oracle_security\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/hp-ux_11i_internals.jpg\" "\\"hp-ux_11i_internals\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/practical_oracle_8i.jpg\" "\\"practical_oracle_8i\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/oracle_insights.jpg\" "\\"oracle_insights\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/system_performance_tuning.jpg\" "\\"system_performance_tuning\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/oracle_wait_interface.jpg\" "\\"oracle_wait_interface\\"")
<\/a><\/td>\n![\"\"](\"http:\/\/www.ora-solutions.net\/web\/wp-content\/uploads\/2008\/10\/rac_handbook.jpg\" "\\"rac_handbook\\"")
<\/a><\/td>\n