Oracle Core essential internals for DBAs and developers
Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting—no more, no less. Oracle Database seems complex on the surface. However, its extensive featur...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York :
Apress
2011.
|
| Edición: | 1st ed. 2011. |
| Colección: | The expert's voice in databases Oracle Core
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629062506719 |
Tabla de Contenidos:
- Title Page; Copyright Page; Contents at a Glance; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Targets; Where Next; CHAPTER 1 Getting Started ...; Where to Begin; Oracle in Processes; Oracle in Action; Summary; CHAPTER 2 Redo and Undo; The Answer to Recovery, Read Consistency, and Nearly Everything-Really!; Basic Data Change; The Approach; An Example; Debriefing; Summary of Observations; ACID; Redo Simplicity; Undo Complexity; Read Consistency; Rollback; Summary; CHAPTER 3 Transactions and Consistency; Now You See Me, Now You Don't
- Conflict ResolutionTransactions and Undo; Start and End of Transaction; The Transaction Table; Reviewing the Undo Block; Data Block Visits and Undo; Setting the Scene; The Interested Transaction List; Concurrent Action; Creating Consistency; Consistent Doesn't Mean Historic; Work Done; Commit SCN; Commit Cleanout; Delayed Block Cleanout; Transaction Table Rollback; Transaction Control (TRN CTL::); First Change; Transaction Table Consistent Read; LOBs; Summary; CHAPTER 4 Locks and Latches; First Things, First ...; Arrays; Pointers; Linked Lists; Hash Tables; Latches; Logic Behind Latches
- Latch Activity StatisticsLatch Misses; Latch Scalability; Locks; Infrastructure; A Graphic Image of vlock; Deadlock; Lock Modes; Latches for Locks; KGL Locks (and Pins); Locks and Pins; Summary; CHAPTER 5 Caches and Copies; Memory Management; Granules; Granules and Buffers; Multiple Data Caches; Granules and Buffer Pools; Buffer Pools; Working Data Sets; The LRU/TCH Algorithm; LRU/TCH in action; Relinking a Buffer; REPL_AUX; Finding Data; Pinning Buffers; Logical I/O; Updates; Loading a Hash Chain; Read-Consistent Copies; Physical I/O; Tablescans; Summary; CHAPTER 6 Writing and Recovery
- The Moving Finger Writes and Having Writ, Moves On; Targets; Log Writer; Log Writer Writes; PL/SQL Optimization; ACID Anomaly; Commit Enhancements; Mechanics; Redo Wastage; Private Redo; Database Writer; Buffer Headers; Checkpoint Queues; Incremental Checkpointing; Database Writer Interactions; Database Writer Meets Log Writer; Database Writer and LRU; Checkpoints and Queues; Buffer Header Queues; Checkpoints and Log Files; Recovery; Media Recovery; Standby Databases; Flashback Database; Side Effects; Summary; CHAPTER 7 Parsing and Optimizing; Do You Come Here Often?; Understanding SQL
- ParsingOptimizing; Interpreting the tkprof Summaries; The Dictionary Cache; The Structure; Dictionary Cache Activity; What Is a Parse Call?; Cursor Caching; Holding Cursors; The Library Cache; Shared Pool Structures; The Fine Structure of the Shared Pool; Extent Listing; The Free Lists; The LRU List(s); ... and Action!; Scenario 1: A Lucky Case; Scenario 2: Running Out of Luck; Scenario 3: Allocating a Large Chunk; ORA-04031: Unable to Allocate %n Bytes; Parsing and Optimizing; Executing, Locking, and Pinning; Mutexes; Summary; CHAPTER 8 RAC and Ruin; Everything's Negotiable!; The Big Picture
- Staying Alive
