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
Expert Oracle Database Architecture, Third Edition
" Now in its third edition, this best-selling book continues to bring you some of the …
book
Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition, Second Edition
Learn through this practical guide to SQL tuning how Oracle's own experts do it, using a …
book
Oracle RMAN Database Duplication
RMAN is Oracle’s flagship backup and recovery tool, but did you know it’s also an effective …
book
Oracle Database 12c Oracle RMAN Backup & Recovery
This authoritative Oracle Press resource on RMAN has been thoroughly revised to cover every new feature, …