0%

Book Description

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 feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data.

  • Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book.

  • Provides proven content from a world-renowned performance and troubleshooting expert

  • Emphasizes the significance of internals knowledge to rapid identification of database performance problems

Covers the core essentials and does not waste your time with esoterica

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
18.227.228.95