{"product_id":"oracle-database-transactions-and-locking-revealed-building-high-performance-through-concurrency-paperback","title":"Oracle Database Transactions and Locking Revealed: Building High Performance Through Concurrency - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eDarl Kuhn\u003c\/b\u003e (Author), \u003cb\u003eThomas Kyte\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003eAccess 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.\u003cbr\u003eGood 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.\u003cbr\u003e\u003cb\u003e\u003ci\u003eOracle Database Transactions and Locking Revealed\u003c\/i\u003e\u003c\/b\u003e 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. \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cb\u003eWhat You Will Learn\u003c\/b\u003e\u003cul\u003e\n\u003cli\u003eAvoid application lockups due to conflicts over accessing the same resource\u003c\/li\u003e\n\u003cli\u003eUnderstand how Oracle prevents one application from overwriting another's modifications\u003c\/li\u003e\n\u003cli\u003eCreate transaction designs that mesh with how Oracle Database is designed\u003c\/li\u003e\n\u003cli\u003eBuild high-throughput applications supporting thousands of concurrent users\u003c\/li\u003e\n\u003cli\u003eDesign applications to take full advantage of Oracle's powerful database engine\u003c\/li\u003e\n\u003cli\u003eGain a fundamental knowledge of Oracle's transaction and locking architecture\u003c\/li\u003e\n\u003cli\u003eDevelop techniques to quickly diagnose and resolve common locking issues\u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003e\u003c\/p\u003e\u003cb\u003eWho This Book Is For\u003c\/b\u003e\u003cbr\u003eOracle 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\u003cbr\u003e\u003ch3\u003eBack Jacket\u003c\/h3\u003e\u003cp\u003eAccess 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.\u003cbr\u003eGood 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.\u003cbr\u003e\u003ci\u003eOracle Database Transactions and Locking Revealed\u003c\/i\u003e 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.\u003cbr\u003eYou will: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAvoid application lockups due to conflicts over accessing the same resource\u003c\/li\u003e\n\u003cli\u003eUnderstand how Oracle prevents one application from overwriting another's modifications\u003c\/li\u003e\n\u003cli\u003eCreate transaction designs that mesh with how Oracle Database is designed\u003c\/li\u003e\n\u003cli\u003eBuild high-throughput applications supporting thousands of concurrent users\u003c\/li\u003e\n\u003cli\u003eDesign applications to take full advantage of Oracle's powerful database engine\u003c\/li\u003e\n\u003cli\u003eGain a fundamental knowledge of Oracle's transaction and locking architecture\u003c\/li\u003e\n\u003cli\u003eDevelop techniques to quickly diagnose and resolve common locking issues\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003cb\u003eDarl Kuhn\u003c\/b\u003e is a senior-level database administrator with decades of experience. He handles all facets of database administration from design and development to production support. He enjoys documenting and sharing knowledge and has authored several books on Oracle technology. \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cb\u003eThomas Kyte \u003c\/b\u003eis a former vice president of the Core Technologies Group at Oracle Corporation. He is the same Tom who created the \"Ask Tom\" website and the Oracle Magazine column of the same name. He has a long history of answering questions about the Oracle database and tools that developers and database administrators struggle with every day.\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 265\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.62 x 10 x 7 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eIllustrated:\u003c\/strong\u003e Yes\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e October 15, 2020\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":47212838879481,"sku":"9781484264249","price":70.18,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0789\/2782\/3097\/files\/Z0NDZGZKTkVJQWR5eWpjUmNiNm9pUT09.webp?v=1768098629","url":"https:\/\/bookscloud.io\/products\/oracle-database-transactions-and-locking-revealed-building-high-performance-through-concurrency-paperback","provider":"BooksCloud Book Dropshipping","version":"1.0","type":"link"}