Oracle Database Transactions and Locking Revealed (eBook)
XXVIII, 265 Seiten
Apress (Verlag)
978-1-4842-6425-6 (ISBN)
- Avoid application lockups due to conflicts over accessing the same resource
- Understand how Oracle prevents one application from overwriting another's modifications
- Create transaction designs that mesh with how Oracle Database is designed
- Build high-throughput applications supporting thousands of concurrent users
- Design applications to take full advantage of Oracle's powerful database engine
- Gain a fundamental knowledge of Oracle's transaction and locking architecture
- Develop techniques to quickly diagnose and resolve common locking issues
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.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.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 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.What You Will LearnAvoid application lockups due to conflicts over accessing the same resourceUnderstand how Oracle prevents one application from overwriting another's modificationsCreate transaction designs that mesh with how Oracle Database is designedBuild high-throughput applications supporting thousands of concurrent usersDesign applications to take full advantage of Oracle's powerful database engineGain a fundamental knowledge of Oracle's transaction and locking architectureDevelop techniques to quickly diagnose and resolve common locking issuesWho This Book Is ForOracle 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
Erscheint lt. Verlag | 14.10.2020 |
---|---|
Zusatzinfo | XXVIII, 265 p. 12 illus. |
Sprache | englisch |
Themenwelt | Informatik ► Datenbanken ► Oracle |
Schlagworte | Ask Tom • Concurrency • deadlocks • Locking • Multiversioning • Oracle Database • Oracle Transactions • Redo and Undo • Transaction Design |
ISBN-10 | 1-4842-6425-8 / 1484264258 |
ISBN-13 | 978-1-4842-6425-6 / 9781484264256 |
Informationen gemäß Produktsicherheitsverordnung (GPSR) | |
Haben Sie eine Frage zum Produkt? |
Größe: 2,8 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich