Oracle Database Transactions and Locking Revealed offers a lot-wanted info for constructing scalable, high-concurrency purposes and deploy them towards the Oracle Database. Learn this short, one hundred fifty-web page book that’s tailored from Skilled Oracle Database Structure to realize a strong and correct understanding of how locking and concurrency are handled by Oracle Database. Additionally find out how the Oracle Database structure accommodates consumer transactions, and how one can write code to mesh with how Oracle Database is designed to function.
Good transaction design is a vital side of extremely-concurrent purposes which are run by lots of, even hundreds of customers who’re all executing transactions on the similar time. Transaction design in flip depends upon an excellent understanding of how the underlying database platform manages of the locking of assets in order to stop entry conflicts and data loss which may in any other case end result from concurrent entry to data within the database.
Oracle Database Transactions and Locking Revealed covers intimately the varied lock varieties, and additionally totally different locking schemes corresponding to pessimistic and optimistic locking. Then you definitely’ll study transaction isolation and multiversion concurrency, and how the varied lock varieties help Oracle Database’s transactional options. You’ll study some good ideas for transaction design, in addition to some dangerous practices and habits to keep away from. Protection can also be given to redo and undo, and their position in concurrency. This is a vital book that anybody creating extremely-concurrent purposes will need to have useful on their shelf.
What youll learnUnderstand locks and their implication for concurrent purposes
Handle transaction isolation to satisfy enterprise wants whereas not impeding concurrency
Design efficient transactions and select the right atomicity degree on your wants
Reap the benefits of options comparable to deferrable constraints and autonomous transactions
Construct multi-database purposes with wanted atomicity via distributed transactions
Examine and troubleshoot redo and undo issues that may impede concurrency
Who this book is forOracle Database Transactions and Locking Revealed is the definitive book on transactions and locking for Oracle Database builders and architects who’re creating extremely-concurrent purposes. Readers ought to have already got good understanding of SQL and PL/SQL. Expertise in software improvement can also be useful.