- 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
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.