<p>Now in its second edition, this best-selling book by<strong> Tom Kyte</strong> of "Ask Tom" fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly.</p> <p>This fully revised second edition covers the developments up to Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.</p> <p>Don’t treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career.</p> <ul>
<li>Fully revised to cover Oracle Database 11g </li> <li>Proof-by-example approach: Let the evidence be your guide </li> <li>Dives deeply into Oracle Database’s most powerful features </li> </ul>

Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions

Computers & Technology

Kyte, Thomas

Programming

Apress

<p>Now in its third edition, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom Kyte and Darl Kuhn share a simple philosophy: "you can treat Oracle as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment." If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly. </p>
<p>This fully revised third edition covers the developments up to Oracle Database 12c. Significant new content is included surrounding Oracle's new cloud feature set, and especially the use of pluggable databases. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.</p>
<p>Don’t treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career. </p>
<ul>
<li>Revised to cover Oracle Database 12c </li>
<li>Proof-by-example approach: Let the evidence be your guide </li>
<li>Dives deeply into Oracle Database’s most powerful features </li>
</ul>

Expert Oracle Database Architecture

Operating Systems

<p>Oracle Database Transactions and Locking Revealed provides much-needed information for building scalable, high-concurrency applications and deploy them against the Oracle Database. Read this short, 150-page book that is adapted from Expert Oracle Database Architecture to gain a solid and accurate understanding of how locking and concurrency are dealt with by Oracle Database. Also learn how the Oracle Database architecture accommodates user transactions, and how you can write code to mesh with how Oracle Database is designed to operate.</p>
<p>Good transaction design is an important facet of highly-concurrent applications that are run by hundreds, even thousands of users who are all executing transactions at the same time. Transaction design in turn relies upon a good understanding of how the underlying database platform manages of the locking of resources so as to prevent access conflicts and data loss that might otherwise result from concurrent access to data in the database.</p>
<p>Oracle Database Transactions and Locking Revealed covers in detail the various lock types, and also different locking schemes such as pessimistic and optimistic locking. Then you’ll learn about transaction isolation and multiversion concurrency, and how the various lock types support Oracle Database’s transactional features. You’ll learn some good tips for transaction design, as well as some bad practices and habits to avoid. Coverage is also given to redo and undo, and their role in concurrency. This is an important book that anyone developing highly-concurrent applications will want to have handy on their shelf.</p>

Oracle Database Transactions and Locking Revealed

<p><div> <div>Access much-needed information for building scalable, high-concurrency applications and deploying them against the Oracle Database. This new edition is updated to be current with Oracle Database 19. It includes a new chapter with troubleshooting recipes to help you quickly diagnose and resolve locking problems that are urgent and block production.</div> <div><br /></div> <div>Good transaction design is an important facet of highly-concurrent applications that are run by hundreds, even thousands, of users who are executing transactions at the same time. Transaction design, in turn, relies on a good understanding of how the database engine manages the locking of resources to prevent access conflicts and data loss that might otherwise result from concurrent access to data in the database. This book provides a solid and accurate explanation of how locking and concurrency are dealt with by Oracle Database. You will learn how the Oracle Database architecture accommodates user transactions, and how you can write code to mesh with the way in which Oracle Database is designed to operate.</div> <div><br /></div> <div><b><i>Oracle Database Transactions and Locking Revealed</i></b> covers in detail the various lock types, and also different locking schemes such as pessimistic and optimistic locking. Then you will learn about transaction isolation and multi-version concurrency, and how the various lock types support Oracle Database's transactional features. You will learn tips for transaction design, as well as some bad practices and habits to avoid. Coverage is also given to redo and undo, and their role in concurrency. The book is loaded with insightful code examples that drive home each concept. This is an important book that anyone developing highly-concurrent applications will want to have handy on their shelf.</div> </div> <div><br /></div> <div><br /></div> <div><br /></div> <div><b>What You Will Learn</b></div> <div> <div> <ul> <li>Avoid application lockups due to conflicts over accessing the same resource</li> <li>Understand how Oracle prevents one application from overwriting another's modifications</li> <li>Create transaction designs that mesh with how Oracle Database is designed</li> <li>Build high-throughput applications supporting thousands of concurrent users</li> <li>Design applications to take full advantage of Oracle's powerful database engine</li> <li>Gain a fundamental knowledge of Oracle's transaction and locking architecture</li> <li>Develop techniques to quickly diagnose and resolve common locking issues</li> </ul> </div> </div> <div><br /></div> <div><br /></div> <div><b>Who This Book Is For</b></div> <div><br /></div> Oracle developers and database administrators faced with troubleshooting and solving deadlocks, locking contention, and similar problems that are encountered in high-concurrency environments; and application developers wanting to design their applications to excel at multi-user concurrency by taking full advantage of Oracle Database's multi-versioning and concurrency support<br /></p>

Oracle Database Transactions and Locking Revealed: Building High Performance Through Concurrency

Kuhn, Darl

Databases & Big Data

<p><div>Now in its fourth edition and covering Oracle Database 21c, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom Kyte and Darl Kuhn share a simple philosophy: "you can treat Oracle as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment." If you choose the latter, then you'll find that there are few information management problems that you cannot solve quickly and elegantly.</div> <div><br /></div> <div>This fully revised fourth edition covers the developments and new features up to Oracle Database 21c.&nbsp;Up-to-date features are covered for tables, indexes, data types, sequences, partitioning, data loading, temporary tables, and more.&nbsp;All the examples are demonstrated using modern techniques and are executed in container and pluggable databases. The book's proof-by-example approach encourages you to let evidence be your guide. Try something. See the result. Understand why the result is what it is. Apply your newfound knowledge with confidence. The book covers features by explaining how each one works, how to implement software using it, and the common pitfalls associated with it.&nbsp;</div> <div><br /></div> <div>Don't treat Oracle Database as a black box. Get this book. Dive deeply into Oracle Database's most powerful features that many do not invest the time to learn about. Set yourself apart from your competition and turbo-charge your career.</div> <div><br /></div> <div><b>What You Will Learn</b></div> <div><br /></div> <div> <div> <ul> <li>Identify and effectively resolve application performance issues and bottlenecks</li> <li>Architect systems to leverage the full power and feature set of Oracle's database engine</li> <li>Configure a database to maximize the use of memory structures and background processes</li> <li>Understand internal locking and latching technology and how it impacts your system</li> <li>Proactively recommend best practices around performance for table and index structures</li> <li>Take advantage of advanced features such as table partitioning and parallel execution</li> </ul> </div> </div> <div><br /></div> <div><b>Who This Book Is For</b></div> <div><br /></div> <div>Oracle developers and Oracle DBAs. If you're a developer and want a stronger understanding of Oracle features and architecture that will enable your applications to scale regardless of the workload, this book is for you. If you're a DBA and want to intelligently work with developers to design applications that effectively leverage Oracle technology, then look no further.<br /></div></p>

Expert Oracle Database Architecture: Techniques and Solutions for High Performance and Productivity

<p>* A proven best-seller by the most recognized Oracle expert in the world. </p>
<p>* The best Oracle book ever written. It defines what Oracle really is, and why it is so powerful. </p> <p>* Inspired by the thousands of questions Tom has answered on his http://asktom.oracle.com site. It tackles the problems that developers and DBAs struggle with every day. </p> <p>* Provides everything you need to know to program correctly with the database and exploit its feature-set effectively. </p>

Expert One-on-One Oracle

Computer Science

<p>This is a defining book on the Oracle database for any developer or database administrator who works with Oracle-driven database applications. <strong>Tom Kyte</strong> has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly.</p> <p>Expert Oracle Database Architecture is the first of a three-book series that completely explores and defines the Oracle database. It covers all of the most important Oracle architecture features, including:</p> <ul>
<li>Files, memory structures and processes </li> <li>Locking and latching </li> <li>Transactions, concurrency and multi-versioning </li> <li>Tables and Indexes </li> <li>Datatypes </li> <li>Partitioning and parallelism </li> </ul>
<p>Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.</p> <p>This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book.</p> <p>Tom has fully revised and expanded the architecture-related sections from Expert One-on-One Oracle (a searchable PDF of which is included on the CD accompanying this book), and added substantial new material. He focuses solely on 9i and 10g architecture in this book and refers to the CD for 8i-specific details. The number of changes will surprise you.</p> <p>In summary, this book provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world's foremost Oracle experts, Thomas Kyte.</p>

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions

<p>Tom Kyte has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter course, then you will find that there are few information management problems that you cannot solve quickly and elegantly. </p>
<p>Tom has selected the most important features and techniques and he teaches them in a proof-by-example manner, not only discussing the features available, but also how to implement software using them and indicating the potential pitfalls. </p>
<p>This book covers:<br> Core database structures and utilities<br> Performance tuning<br> Advanced SQL features<br> Extensibility using C, Java and OR features<br> Security<br> Important supplied packages<br></p>

Expert One on One Oracle

Programming Languages

Wrox Press

<p>Oracle is the world's leading relational database. It provides a rich environment to store, handle, and extract data. When used properly, Oracle provides a solid foundation upon which to build enterprise scale applications. </p>
<p> Mastering the Oracle database is not an overnight job. It takes time, practice, and a lot of real world experience. This book teaches you the core concepts behind using the database, shows you the tools and techniques you need to master, and gives you practical examples of programming Oracle. By the time you have completed this book, you will have all the knowledge you need to use Oracle databases with confidence. </p>
<p> You are setting out on the same journey we travelled some years ago. We know the things you are going to run into time and time again. We understand the challenges you are going to meet when you have to develop an application or administer your database. We can guarantee you that the techniques you'll learn in this book are proven and have led us through many successful implementations. </p>
<p> What does this book cover: </p>
<p> * Oracle terminology, tools, concepts, and architecture<br> * The functionality of the different versions and editions of Oracle (8, 8i, and 9i)<br> * Basic and advanced Oracle SQL<br> * Mastering SQL<br> * Plus as an Oracle development tool<br> * Understanding tables, indexes, transactions and concurrency, views, triggers, and objects<br> * Using PL/SQL to write and package procedural code in the database<br> * Securing your Oracle applications<br> * Evaluating performance and tuning your Oracle application<br> * A SQL Toolkit of useful scripts that you can use in your database<br> * Case studies that apply this knowledge to create two practical Oracle applications</p>

Beginning Oracle Programming

Dillon, Sean

Beck, Christopher

See the best price to sell, buy, or rent books by Kyte, Thomas. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Kyte, Thomas