Book description
Now in its second edition, this best-selling book by Tom Kyte of Ask Tom fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you'll find that there are few information management problems that you cannot solve quickly and elegantly.
This fully revised second edition covers the latest developments in Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.
Don't treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career.
Fully-revised to cover Oracle Database 11g
Proof-by-example approach: Let the evidence be your guide
Dives deeply into Oracle Databases's most powerful features
Table of contents
- Copyright
- Foreword
- Foreword from the First Edition
- About the Author
- About the Technical Reviewers
- Acknowledgments
-
Introduction
- What This Book Is About
- Who Should Read This Book
-
How This Book Is Structured
- Chapter 1: Developing Successful Oracle Applications
- Chapter 2: Architecture Overview
- Chapter 3: Files
- Chapter 4: Memory Structures
- Chapter 5: Oracle Processes
- Chapter 6: Locking and Latching
- Chapter 7: Concurrency and Multi-versioning
- Chapter 8: Transactions
- Chapter 9: Redo and Undo
- Chapter 10: Database Tables
- Chapter 11: Indexes
- Chapter 12: Datatypes
- Chapter 13: Partitioning
- Chapter 14: Parallel Execution
- Chapter 15: Data Loading and Unloading
- Chapter 16: Data Encryption
- Source Code and Updates
- Errata
- Setting Up Your Environment
-
1. Developing Successful Oracle Applications
- 1.1. My Approach
- 1.2. The Black Box Approach
- 1.3. How (and How Not) to Develop Database Applications
- 1.4. Summary
- 2. Architecture Overview
-
3. Files
- 3.1. Parameter Files
- 3.2. Server Parameter Files (SPFILEs)
- 3.3. Trace Files
- 3.4. Alert File
- 3.5. Data Files
- 3.6. Temp Files
- 3.7. Control Files
- 3.8. Redo Log Files
- 3.9. Password Files
- 3.10. Change Tracking File
- 3.11. Flashback Logs
- 3.12. DMP Files (EXP/IMP Files)
- 3.13. Data Pump Files
- 3.14. Flat Files
- 3.15. Summary
- 4. Memory Structures
-
5. Oracle Processes
-
5.1. Server Processes
- 5.1.1. Dedicated Server Connections
- 5.1.2. Shared Server Connections
- 5.1.3. Database Resident Connection Pooling (DRCP)
- 5.1.4. Connections vs. Sessions
- 5.1.5. Dedicated Server vs. Shared Server vs. DRCP
- 5.1.6. Dedicated/Shared Server Wrap-up
-
5.2. Background Processes
-
5.2.1. Focused Background Processes
- 5.2.1.1. PMON: The Process Monitor
- 5.2.1.2. SMON: The System Monitor
- 5.2.1.3. RECO: Distributed Database Recovery
- 5.2.1.4. CKPT: Checkpoint Process
- 5.2.1.5. DBWn: Database Block Writer
- 5.2.1.6. LGWR: Log Writer
- 5.2.1.7. ARCn: Archive Process
- 5.2.1.8. DIAG: Diagnosability Process
- 5.2.1.9. FBDA: Flashback Data Archiver Process
- 5.2.1.10. DBRM: Database ResourceManager Process
- 5.2.1.11. GEN0: General Task Execution Process
- 5.2.1.12. Remaining Common Focused Processes
-
5.2.2. Utility Background Processes
- 5.2.2.1. CJQ0 and Jnnn Processes: Job Queues
- 5.2.2.2. QMNC and Qnnn: Advanced Queues
- 5.2.2.3. EMNC: Event Monitor Processes
- 5.2.2.4. MMAN: Memory Manager
- 5.2.2.5. MMON, MMNL, and Mnnn: Manageability Monitors
- 5.2.2.6. CTWR: Change Tracking Processes
- 5.2.2.7. RVWR: Recovery Writer
- 5.2.2.8. DMnn/DWnn: Data Pump Master/Worker Processes
- 5.2.2.9. Remaining Utility Background Processes
-
5.2.1. Focused Background Processes
- 5.3. Slave Processes
- 5.4. Summary
-
5.1. Server Processes
-
6. Locking and Latching
- 6.1. What Are Locks?
- 6.2. Locking Issues
- 6.3. Lock Types
- 6.4. Summary
- 7. Concurrency and Multi-versioning
- 8. Transactions
- 9. Redo and Undo
- 10. Database Tables
-
11. Indexes
- 11.1. An Overview of Oracle Indexes
- 11.2. B*Tree Indexes
- 11.3. Bitmap Indexes
- 11.4. Function-Based Indexes
- 11.5. Application Domain Indexes
- 11.6. Frequently Asked Questions and Myths About Indexes
- 11.7. Summary
-
12. Datatypes
- 12.1. An Overview of Oracle Datatypes
- 12.2. Character and Binary String Types
- 12.3. Binary Strings: RAW Types
- 12.4. Number Types
- 12.5. Long Types
- 12.6. Dates, Timestamps, and Interval Types
- 12.7. LOB Types
- 12.8. ROWID/UROWID Types
- 12.9. Summary
-
13. Partitioning
- 13.1. Partitioning Overview
- 13.2. Table Partitioning Schemes
- 13.3. Partitioning Indexes
- 13.4. Partitioning and Performance, Revisited
- 13.5. Auditing and Segment Space Compression
- 13.6. Summary
- 14. Parallel Execution
-
15. Data Loading and Unloading
-
15.1. SQL*Loader
-
15.1.1. Loading Data with SQLLDR FAQs
- 15.1.1.1. Why do I receive "exceeds maximum length" in my log file?
- 15.1.1.2. How Do I Load Delimited Data?
- 15.1.1.3. How Do I Load Fixed Format Data?
- 15.1.1.4. How Do I Load Dates?
- 15.1.1.5. How Do I Load Data Using Functions?
- 15.1.1.6. How Do I Load Data with Embedded Newlines?
- 15.1.1.7. How Do I Load LOBs?
- 15.1.1.8. How Do I Call SQLLDR from a Stored Procedure?
- 15.1.2. SQLLDR Caveats
- 15.1.3. SQLLDR Summary
-
15.1.1. Loading Data with SQLLDR FAQs
- 15.2. External Tables
- 15.3. Flat File Unload
- 15.4. Data Pump Unload
- 15.5. Summary
-
15.1. SQL*Loader
-
16. Data Encryption
- 16.1. Types of Encryption
- 16.2. What Encryption Is Not About
- 16.3. Implementing Manual Application Encryption
- 16.4. Implementing Column Level Encryption
- 16.5. Implementing Tablespace Encryption
- 16.6. Deciding on an Encryption Technique
- 16.7. Summary
Product information
- Title: Expert Oracle Database Architecture: Oracle Database 9
- Author(s):
- Release date: July 2010
- Publisher(s): Apress
- ISBN: 9781430229469
You might also like
book
Modern Java in Action
Modern Java in Action connects new features of the Java language with their practical applications. Using …
book
Java Cookbook, 4th Edition
Java continues to grow and evolve, and this cookbook continues to evolve in tandem. With this …
book
Software Engineering at Google
Today, software engineers need to know not only how to program effectively but also how to …
book
Java: The Complete Reference, Eleventh Edition, 11th Edition
The Definitive Java Programming Guide Fully updated for Java SE 11, Java: The Complete Reference, Eleventh …