001432364 000__ 04004cam\a2200553\a\4500 001432364 001__ 1432364 001432364 003__ OCoLC 001432364 005__ 20230309003439.0 001432364 006__ m\\\\\o\\d\\\\\\\\ 001432364 007__ cr\un\nnnunnun 001432364 008__ 201107s2020\\\\cau\\\\\o\\\\\001\0\eng\d 001432364 019__ $$a1200651364$$a1204151389$$a1224942021$$a1228842501$$a1233050164 001432364 020__ $$a9781484264256$$q(electronic bk.) 001432364 020__ $$a1484264258$$q(electronic bk.) 001432364 020__ $$z148426424X 001432364 020__ $$z9781484264249 001432364 0247_ $$a10.1007/978-1-4842-6425-6$$2doi 001432364 035__ $$aSP(OCoLC)1204138390 001432364 040__ $$aEBLCP$$beng$$epn$$cEBLCP$$dYDX$$dTOH$$dOCLCO$$dGW5XE$$dVT2$$dSFB$$dERF$$dOCLCF$$dOCLCO$$dEBLCP$$dLDP$$dUPM$$dOCLCQ$$dUKAHL$$dOCL$$dOCLCQ$$dOCLCO$$dOCLCQ 001432364 049__ $$aISEA 001432364 050_4 $$aQA76.9.D3 001432364 08204 $$a005.74$$223 001432364 1001_ $$aKuhn, Darl. 001432364 24510 $$aOracle Database transactions and locking revealed :$$bbuilding high performance through concurrency /$$cDarl Kuhn, Thomas Kyte. 001432364 250__ $$a2nd ed. 001432364 260__ $$aBerkeley, CA :$$bApress,$$c2020. 001432364 300__ $$a1 online resource (289 pages) 001432364 336__ $$atext$$btxt$$2rdacontent 001432364 337__ $$acomputer$$bc$$2rdamedia 001432364 338__ $$aonline resource$$bcr$$2rdacarrier 001432364 347__ $$atext file 001432364 347__ $$bPDF 001432364 500__ $$aIncludes index. 001432364 5050_ $$a1. 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. 001432364 506__ $$aAccess limited to authorized users. 001432364 520__ $$aAccess 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. 001432364 588__ $$aDescription based on print version record. 001432364 63000 $$aOracle (Computer file) 001432364 650_0 $$aDatabase management. 001432364 650_6 $$aBases de données$$xGestion. 001432364 655_0 $$aElectronic books. 001432364 7001_ $$aKyte, Thomas. 001432364 77608 $$iPrint version:$$aKuhn, Darl.$$tOracle Database Transactions and Locking Revealed : Building High Performance Through Concurrency.$$dBerkeley, CA : Apress L.P., ©2020$$z9781484264249 001432364 852__ $$bebk 001432364 85640 $$3Springer Nature$$uhttps://univsouthin.idm.oclc.org/login?url=https://link.springer.com/10.1007/978-1-4842-6425-6$$zOnline Access$$91397441.1 001432364 909CO $$ooai:library.usi.edu:1432364$$pGLOBAL_SET 001432364 980__ $$aBIB 001432364 980__ $$aEBOOK 001432364 982__ $$aEbook 001432364 983__ $$aOnline 001432364 994__ $$a92$$bISE