Oracle Database transactions and locking revealed : building high performance through concurrency / Darl Kuhn, Thomas Kyte.
2020
QA76.9.D3
Linked e-resources
Linked Resource
Online Access
Concurrent users
Unlimited
Authorized users
Authorized users
Document Delivery Supplied
Can lend chapters, not whole ebooks
Details
Title
Oracle Database transactions and locking revealed : building high performance through concurrency / Darl Kuhn, Thomas Kyte.
Author
Kuhn, Darl.
Edition
2nd ed.
ISBN
9781484264256 (electronic bk.)
1484264258 (electronic bk.)
148426424X
9781484264249
1484264258 (electronic bk.)
148426424X
9781484264249
Publication Details
Berkeley, CA : Apress, 2020.
Language
English
Description
1 online resource (289 pages)
Item Number
10.1007/978-1-4842-6425-6 doi
Call Number
QA76.9.D3
Dewey Decimal Classification
005.74
Summary
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.
Note
Includes index.
Access Note
Access limited to authorized users.
Digital File Characteristics
text file
PDF
Source of Description
Description based on print version record.
Added Author
Kyte, Thomas.
Available in Other Form
Oracle Database Transactions and Locking Revealed : Building High Performance Through Concurrency.
Linked Resources
Online Access
Record Appears in
Online Resources > Ebooks
All Resources
All Resources
Table of Contents
1. Getting Started
2. Locking and Blocking
3. Locks, Latches, and Mutexes
4. Concurrency and Multiversioning
5. Transactions
6. Redo and Undo
7. Investigating Redo
8. Investigating Undo
9. Troubleshooting.
2. Locking and Blocking
3. Locks, Latches, and Mutexes
4. Concurrency and Multiversioning
5. Transactions
6. Redo and Undo
7. Investigating Redo
8. Investigating Undo
9. Troubleshooting.