Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Expert Oracle Database Architecture / / by Thomas Kyte, Darl Kuhn
| Expert Oracle Database Architecture / / by Thomas Kyte, Darl Kuhn |
| Autore | Kyte Thomas |
| Edizione | [3rd ed. 2014.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 |
| Descrizione fisica | 1 online resource (823 p.) |
| Disciplina | 005.7585 |
| Collana | Expert's Voice in Oracle |
| Soggetto topico |
Database management
Software engineering Database Management Software Engineering/Programming and Operating Systems |
| ISBN |
9781430262992
1430262990 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910300475103321 |
Kyte Thomas
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle Database Transactions and Locking Revealed / / by Thomas Kyte, Darl Kuhn
| Oracle Database Transactions and Locking Revealed / / by Thomas Kyte, Darl Kuhn |
| Autore | Kyte Thomas |
| Edizione | [1st ed. 2014.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 |
| Descrizione fisica | 1 online resource (179 p.) |
| Disciplina |
004
005.11 005.74 |
| Collana | Expert's Voice in Oracle |
| Soggetto topico |
Database management
Computer programming Database Management Programming Techniques |
| ISBN |
9781484207604
1484207602 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents 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
Latch " 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 A 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 Bad 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 Hypothetical 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 What Generates the Most and Least Undo? |
| Record Nr. | UNINA-9910300467003321 |
|
Kyte Thomas
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||