LEADER 06973nam 22007815 450 001 9910300467003321 005 20200705113241.0 010 $a1-4842-0760-2 024 7 $a10.1007/978-1-4842-0760-4 035 $a(CKB)3710000000277333 035 $a(EBL)1964907 035 $a(SSID)ssj0001539508 035 $a(PQKBManifestationID)11909724 035 $a(PQKBTitleCode)TC0001539508 035 $a(PQKBWorkID)11531289 035 $a(PQKB)10755009 035 $a(SSID)ssj0001386443 035 $a(PQKBManifestationID)11830274 035 $a(PQKBTitleCode)TC0001386443 035 $a(PQKBWorkID)11374075 035 $a(PQKB)11464842 035 $a(MiAaPQ)EBC1964907 035 $a(DE-He213)978-1-4842-0760-4 035 $a(CaSebORM)9781484207604 035 $a(PPN)183090268 035 $a(EXLCZ)993710000000277333 100 $a20141105d2014 u| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOracle Database Transactions and Locking Revealed$b[electronic resource] /$fby Thomas Kyte, Darl Kuhn 205 $a1st ed. 2014. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2014. 215 $a1 online resource (179 p.) 225 1 $aExpert's Voice in Oracle 300 $a"Independent Oracle Users Group"--Cover. 300 $a"Building Successful Concurrency"--Cover. 300 $aIncludes index. 311 $a1-4842-0761-0 327 $aContents at a Glance; Introduction; Chapter 1: Getting Started; Background; Locking; Concurrency Control; Multiversioning; Transactions; Redo and Undo; Summary; Chapter 2: Locking and Issues; What Are Locks?; Lost Updates; Pessimistic Locking; Optimistic Locking; Optimistic Locking Using a Version Column; Optimistic Locking Using a Checksum; Optimistic or Pessimistic Locking?; Blocking; Blocked Inserts; Blocked Merges, Updates, and Deletes; Deadlocks; Lock Escalation; Summary; Chapter 3: Lock Types; DML Locks; TX (Transaction) Locks; TM (DML Enqueue) Locks; DDL Locks; Latches 327 $aLatch " Spinning "Measuring the Cost of Latching a Shared Resource; Setting Up for the Test; Without Bind Variables; With Bind Variables; Performance/Scalability Comparison; Mutexes; Manual Locking and User-Defined Locks; Manual Locking; Creating Your Own Locks; Summary; Chapter 4: Concurrency and Multiversioning; What Are Concurrency Controls?; Transaction Isolation Levels; READ UNCOMMITTED; READ COMMITTED; REPEATABLE READ; Getting a Consistent Answer; Lost Updates: Another Portability Issue; SERIALIZABLE; READ ONLY; Implications of Multiversion Read Consistency 327 $aA Common Data Warehousing Technique That FailsAn Explanation for Higher Than Expected I/O on Hot Tables; Write Consistency; Consistent Reads and Current Reads; Seeing a Restart; Why Is a Restart Important to Us?; Summary; Chapter 5: Transactions; Transaction Control Statements; Atomicity; Statement-Level Atomicity; Procedure-Level Atomicity; Transaction-Level Atomicity; DDL and Atomicity; Durability; WRITE Extensions to COMMIT; COMMITS in a Nondistributed PL/SQL Block; Integrity Constraints and Transactions; IMMEDIATE Constraints; DEFERRABLE Constraints and Cascading Updates 327 $aBad Transaction HabitsCommitting in a Loop; Performance Implications; Snapshot Too Old Error; Restartable Processes Require Complex Logic; Using Autocommit; Distributed Transactions; Autonomous Transactions; How Autonomous Transactions Work; When to Use Autonomous Transactions; Summary; Chapter 6: Redo and Undo; What Is Redo?; What Is Undo?; How Redo and Undo Work Together; Example INSERT-UPDATE-DELETE-COMMIT Scenario; The INSERT; Hypothetical Scenario: The System Crashes Right Now; Hypothetical Scenario: The Buffer Cache Fills Up Right Now; The UPDATE 327 $aHypothetical Scenario: The System Crashes Right NowHypothetical Scenario: The Application Rolls Back the Transaction; The DELETE; The COMMIT; Commit and Rollback Processing; What Does a COMMIT Do?; What Does a ROLLBACK Do?; Summary; Chapter 7: Investigating Redo; Measuring Redo; Can I Turn Off Redo Log Generation?; Setting NOLOGGING in SQL; Setting NOLOGGING on an Index; NOLOGGING Wrap-up; Why Can't I Allocate a New Log ?; Block Cleanout; Log Contention; Temporary Tables and Redo/Undo; Prior to 12c; Starting with 12c; Summary; Chapter 8: Investigating Undo 327 $aWhat Generates the Most and Least Undo? 330 $aOracle Database Transactions and Locking Revealed provides much-needed information for building scalable, high-concurrency applications and deploy them against the Oracle Database. Read this short, 150-page book that is adapted from Expert Oracle Database Architecture to gain a solid and accurate understanding of how locking and concurrency are dealt with by Oracle Database. Also learn how the Oracle Database architecture accommodates user transactions, and how you can write code to mesh with how Oracle Database is designed to operate. Good transaction design is an important facet of highly-concurrent applications that are run by hundreds, even thousands of users who are all executing transactions at the same time. Transaction design in turn relies upon a good understanding of how the underlying database platform manages of the locking of resources so as to prevent access conflicts and data loss that might otherwise result from concurrent access to data in the database. 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?ll learn about transaction isolation and multiversion concurrency, and how the various lock types support Oracle Database?s transactional features. You?ll learn some good 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. This is an important book that anyone developing highly-concurrent applications will want to have handy on their shelf. 410 0$aExpert's voice in Oracle. 606 $aDatabase management 606 $aComputer programming 606 $aDatabase Management$3https://scigraph.springernature.com/ontologies/product-market-codes/I18024 606 $aProgramming Techniques$3https://scigraph.springernature.com/ontologies/product-market-codes/I14010 615 0$aDatabase management. 615 0$aComputer programming. 615 14$aDatabase Management. 615 24$aProgramming Techniques. 676 $a004 676 $a005.11 676 $a005.74 700 $aKyte$b Thomas$4aut$4http://id.loc.gov/vocabulary/relators/aut$0630611 702 $aKuhn$b Darl$4aut$4http://id.loc.gov/vocabulary/relators/aut 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910300467003321 996 $aOracle Database Transactions and Locking Revealed$92208303 997 $aUNINA