Oracle Core: Essential Internals for DBAs and Developers

Table of Contents

1. Title
2. Contents at a Glance
3. Contents
4. About the Author
5. About the Technical Reviewer
6. Acknowledgments
7. Introduction
   1. Targets
   2. Where Next
8. Chapter 1: Getting Started . . .
   1. Oracle in Processes
   2. Oracle in Action
   3. Summary
9. Chapter 2: Redo and Undo
   1. Basic Data Change
   2. ACID
   3. Redo Simplicity
   4. Undo Complexity
   5. Summary
10. Chapter 3: Transactions and Consistency
    1. Conflict Resolution
    2. Transactions and Undo
    3. Data Block Visits and Undo
    4. Commit SCN
    5. LOBs
    6. Summary
11. Chapter 4: Locks and Latches
    1. First Things, First . . .
    2. Latches
    3. Locks
    4. Summary
12. Chapter 5: Caches and Copies
    1. Memory Management
    2. Multiple Data Caches
    3. Working Data Sets
    4. The LRU/TCH Algorithm
    5. REPL_AUX
    6. Finding Data
    7. Summary
13. Chapter 6: Writing and Recovery
    1. Targets
    2. Log Writer
    3. Database Writer
    4. Database Writer Interactions
    5. Recovery
    6. Summary
14. Chapter 7: Parsing and Optimizing
    1. Understanding SQL
    2. The Dictionary Cache
    3. What Is a Parse Call?
    4. The Library Cache
    5. Parsing and Optimizing
    6. Summary
15. Chapter 8: RAC and Ruin
    1. The Big Picture
    2. What’s the Point?
    3. How Can It Work?
    4. Recovery
    5. Sequences
    6. Summary
16. Appendix: Dumping and Debugging
    1. oradebug
    2. Dumps from SQL
    3. Guesswork
17. Glossary
18. Index