SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK EXPERT ORACLE DATABASE ARCHITECTURE, 2ND EDITION
SUMMARY
-
Items Found: 576
- Chapter 1: Developing Successful Oracle Applications
- My Approach
- The Black Box Approach.
- How (and How Not) to Develop Database Applications
- Understanding Oracle Architecture
- Understanding Concurrency Control
- Multi-Versioning
- Database Independence?
- How Do I Make It Run Faster?
- The DBA-Developer Relationship.
- Chapter 2: Architecture Overview.
- Defining Database and Instance.
- The SGA and Background Processes.
- Connecting to Oracle
- Dedicated Server
- Shared Server
- Mechanics of Connecting over TCP/IP
- Chapter 3: Files
- Parameter Files
- What Are Parameters?.
- Legacy init.ora Parameter Files
- Server Parameter Files (SPFILEs)
- Converting to SPFILEs
- Trace Files
- Requested Trace Files
- Trace Files Generated in Response to Internal Errors
- Trace File Wrap-up
- Alert File
- Data Files.
- A Brief Review of File System Mechanisms
- The Storage Hierarchy in an Oracle Database
- Dictionary-Managed and Locally-Managed Tablespaces.
- Temp Files
- Control Files
- Redo Log Files
- Online Redo Log
- Archived Redo Log
- Password Files.
- Change Tracking File
- Flashback Logs.
- Flashback Database
- Flash Recovery Area
- DMP Files (EXP/IMP Files)
- Data Pump Files
- Flat Files
- Chapter 4: Memory Structures.
- The Process Global Area and User Global Area
- Manual PGA Memory Management
- Automatic PGA Memory Management
- Choosing Between Manual and Auto Memory Management.
- PGA and UGA Wrap-up
- The System Global Area.
- Fixed SGA
- Redo Buffer
- Block Buffer Cache
- Shared Pool
- Large Pool.
- Java Pool
- Streams Pool
- Automatic SGA Memory Management
- Automatic Memory Management
- Chapter 5: Oracle Processes
- Server Processes.
- Dedicated Server Connections
- Shared Server Connections
- Database Resident Connection Pooling (DRCP)
- Connections vs. Sessions
- Dedicated Server vs. Shared Server vs. DRCP
- Dedicated/Shared Server Wrap-up
- Background Processes
- Focused Background Processes.
- Utility Background Processes.
- Slave Processes
- I/O Slaves.
- Pnnn: Parallel Query Execution Servers
- Chapter 6: Locking and Latching
- What Are Locks?
- Locking Issues
- Lost Updates.
- Pessimistic Locking
- Optimistic Locking
- Optimistic or Pessimistic Locking?.
- Blocking.
- Deadlocks
- Lock Escalation
- Lock Types.
- DML Locks
- DDL Locks
- Latches
- Mutexes
- Manual Locking and User-Defined Locks
- Chapter 7: Concurrency and Multi-versioning
- What Are Concurrency Controls?.
- Transaction Isolation Levels
- READ UNCOMMITTED.
- READ COMMITTED
- REPEATABLE READ
- SERIALIZABLE
- READ ONLY
- Implications of Multi-version Read Consistency.
- A Common Data Warehousing Technique That Fails.
- An Explanation for Higher Than Expected I/O on Hot Tables
- Write Consistency
- Consistent Reads and Current Reads
- Seeing a Restart
- Why Is a Restart Important to Us?
- Chapter 8: Transactions
- Transaction Control Statements
- Atomicity
- Statement-Level Atomicity
- Procedure-Level Atomicity
- Transaction-Level Atomicity
- DDL and Atomicity
- Durability
- WRITE Extensions to COMMIT.
- COMMITS in a Non-Distributed PL/SQL Block
- Integrity Constraints and Transactions.
- IMMEDIATE Constraints
- DEFERRABLE Constraints and Cascading Updates.
- Bad Transaction Habits.
- Committing in a Loop
- Using Autocommit
- Distributed Transactions.
- Autonomous Transactions
- How Autonomous Transactions Work.
- When to Use Autonomous Transactions
- Chapter 9: Redo and Undo.
- What Is Redo?
- What Is Undo?
- How Redo and Undo Work Together
- Example INSERT-UPDATE-DELETE Scenario
- Commit and Rollback Processing
- What Does a COMMIT Do?
- What Does a ROLLBACK Do?
- Investigating Redo
- Measuring Redo.
- Can I Turn Off Redo Log Generation?
- Why Can’t I Allocate a New Log?
- Block Cleanout.
- Log Contention.
- Temporary Tables and Redo/Undo
- Investigating Undo
- What Generates the Most and Least Undo?
- ORA-01555: snapshot too old Error
- Chapter 10: Database Tables
- Types of Tables
- Terminology
- Segment
- Segment Space Management
- High-water Mark
- FREELISTS
- PCTFREE and PCTUSED
- LOGGING and NOLOGGING
- INITRANS and MAXTRANS
- Heap Organized Tables
- Index Organized Tables
- Index Organized Tables Wrap-up
- Index Clustered Tables Wrap-up
- Hash Clustered Tables
- Hash Clustered Tables Wrap-up
- Sorted Hash Clustered Tables
- Nested Tables
- Nested Tables Syntax
- Nested Table Storage
- Nested Tables Wrap-up
- Temporary Tables
- Temporary Tables Wrap-up
- Object Tables
- Object Tables Wrap-up
- Chapter 11: Indexes
- An Overview of Oracle Indexes
- B*Tree Indexes
- Index Key Compression
- Reverse Key Indexes
- Descending Indexes
- When Should You Use a B*Tree Index?
- B*Trees Wrap-up
- Bitmap Indexes
- When Should You Use a Bitmap Index?
- Bitmap Join Indexes
- Bitmap Indexes Wrap-up
- Function-Based Indexes
- Important Implementation Details
- A Simple Function-Based Index Example
- Indexing Only Some of the Rows.
- Implementing Selective Uniqueness
- Caveat Regarding ORA-01743
- Function-Based Indexes Wrap-up
- Application Domain Indexes
- Frequently Asked Questions and Myths About Indexes.
- Do Indexes Work on Views?
- Do Nulls and Indexes Work Together?
- Should Foreign Keys Be Indexed?
- Why Isn’t My Index Getting Used?
- Myth: Space Is Never Reused in an Index
- Myth: Most Discriminating Elements Should Be First
- Chapter 12: Datatypes
- An Overview of Oracle Datatypes
- Character and Binary String Types
- NLS Overview
- Character Strings
- Binary Strings: RAW Types
- Number Types.
- NUMBER Type Syntax and Usage
- BINARY_FLOAT/BINARY_DOUBLE Type Syntax and Usage.
- Non-native Number Types
- Performance Considerations
- Long Types
- Restrictions on LONG and LONG RAW Types
- Coping with Legacy LONG Types
- Dates,Timestamps,and Interval Types
- Formats
- DATE Type
- TIMESTAMP Type.
- INTERVAL Type
- LOB Types
- Internal LOBs
- BFILEs.
- ROWID/UROWID Types
- Chapter 13: Partitioning.
- Partitioning Overview
- Increased Availability
- Reduced Administrative Burden
- Enhanced Statement Performance.
- Table Partitioning Schemes.
- Range Partitioning
- Hash Partitioning
- List Partitioning
- Interval Partitioning
- Reference Partitioning.
- Composite Partitioning
- Row Movement.
- Table Partitioning Schemes Wrap-up.
- Partitioning Indexes
- Local Indexes vs. Global Indexes.
- Local Indexes
- Global Indexes
- Partitioning and Performance,Revisited
- Auditing and Segment Space Compression.
- Chapter 14: Parallel Execution.
- When to Use Parallel Execution
- A Parallel Processing Analogy
- Oracle Exadata.
- Parallel Query
- Parallel DML.
- Parallel DDL
- Parallel DDL and Data Loading Using External Tables
- Parallel DDL and Extent Trimming.
- Parallel Recovery
- Procedural Parallelism.
- Parallel Pipelined Functions
- Do-It-Yourself Parallelism
- Old School Do-It-Yourself Parallelism
- Chapter 15: Data Loading and Unloading.
- SQL*Loader.
- Loading Data with SQLLDR FAQs
- SQLLDR Caveats
- External Tables
- Setting Up External Tables
- Dealing with Errors
- Using an External Table to Load Different Files
- Multiuser Issues
- Flat File Unload
- Data Pump Unload
- Chapter 16: Data Encryption
- Types of Encryption
- Data in Motion
- Data at Rest
- Manual Application Encryption
- The Oracle Wallet
- Transparent Column Level Encryption
- Transparent Tablespace Encryption
- What Encryption Is Not About
- Implementing Manual Application Encryption
- Reasons to Avoid the Manual Approach
- Performance Implications of the Manual Approach
- When to Use the Manual Approach
- Implementing Column Level Encryption
- How to Use Column Encryption
- Data Storage with Column Encryption
- Measuring the Performance Impact of Column Encryption
- Influences on the Magnitude
- Limitations of Column Encryption.
- Implementing Tablespace Encryption.
- How to Use Tablespace Encryption
- Data Storage with Tablespace Encryption
- Measuring the Performance Impact of Tablespace Encryption
- Deciding on an Encryption Technique
- Chapter 1: Developing Successful Oracle Applications
- My Approach
- The Black Box Approach.
- How (and How Not) to Develop Database Applications
- Understanding Oracle Architecture
- Understanding Concurrency Control
- Multi-Versioning
- Database Independence?
- How Do I Make It Run Faster?
- The DBA-Developer Relationship.
- Chapter 2: Architecture Overview.
- Defining Database and Instance.
- The SGA and Background Processes.
- Connecting to Oracle
- Dedicated Server
- Shared Server
- Mechanics of Connecting over TCP/IP
- Chapter 3: Files
- Parameter Files
- What Are Parameters?.
- Legacy init.ora Parameter Files
- Server Parameter Files (SPFILEs)
- Converting to SPFILEs
- Trace Files
- Requested Trace Files
- Trace Files Generated in Response to Internal Errors
- Trace File Wrap-up
- Alert File
- Data Files.
- A Brief Review of File System Mechanisms
- The Storage Hierarchy in an Oracle Database
- Dictionary-Managed and Locally-Managed Tablespaces.
- Temp Files
- Control Files
- Redo Log Files
- Online Redo Log
- Archived Redo Log
- Password Files.
- Change Tracking File
- Flashback Logs.
- Flashback Database
- Flash Recovery Area
- DMP Files (EXP/IMP Files)
- Data Pump Files
- Flat Files
- Chapter 4: Memory Structures.
- The Process Global Area and User Global Area
- Manual PGA Memory Management
- Automatic PGA Memory Management
- Choosing Between Manual and Auto Memory Management.
- PGA and UGA Wrap-up
- The System Global Area.
- Fixed SGA
- Redo Buffer
- Block Buffer Cache
- Shared Pool
- Large Pool.
- Java Pool
- Streams Pool
- Automatic SGA Memory Management
- Automatic Memory Management
- Chapter 5: Oracle Processes
- Server Processes.
- Dedicated Server Connections
- Shared Server Connections
- Database Resident Connection Pooling (DRCP)
- Connections vs. Sessions
- Dedicated Server vs. Shared Server vs. DRCP
- Dedicated/Shared Server Wrap-up
- Background Processes
- Focused Background Processes.
- Utility Background Processes.
- Slave Processes
- I/O Slaves.
- Pnnn: Parallel Query Execution Servers
- Chapter 6: Locking and Latching
- What Are Locks?
- Locking Issues
- Lost Updates.
- Pessimistic Locking
- Optimistic Locking
- Optimistic or Pessimistic Locking?.
- Blocking.
- Deadlocks
- Lock Escalation
- Lock Types.
- DML Locks
- DDL Locks
- Latches
- Mutexes
- Manual Locking and User-Defined Locks
- Chapter 7: Concurrency and Multi-versioning
- What Are Concurrency Controls?.
- Transaction Isolation Levels
- READ UNCOMMITTED.
- READ COMMITTED
- REPEATABLE READ
- SERIALIZABLE
- READ ONLY
- Implications of Multi-version Read Consistency.
- A Common Data Warehousing Technique That Fails.
- An Explanation for Higher Than Expected I/O on Hot Tables
- Write Consistency
- Consistent Reads and Current Reads
- Seeing a Restart
- Why Is a Restart Important to Us?
- Chapter 8: Transactions
- Transaction Control Statements
- Atomicity
- Statement-Level Atomicity
- Procedure-Level Atomicity
- Transaction-Level Atomicity
- DDL and Atomicity
- Durability
- WRITE Extensions to COMMIT.
- COMMITS in a Non-Distributed PL/SQL Block
- Integrity Constraints and Transactions.
- IMMEDIATE Constraints
- DEFERRABLE Constraints and Cascading Updates.
- Bad Transaction Habits.
- Committing in a Loop
- Using Autocommit
- Distributed Transactions.
- Autonomous Transactions
- How Autonomous Transactions Work.
- When to Use Autonomous Transactions
- Chapter 9: Redo and Undo.
- What Is Redo?
- What Is Undo?
- How Redo and Undo Work Together
- Example INSERT-UPDATE-DELETE Scenario
- Commit and Rollback Processing
- What Does a COMMIT Do?
- What Does a ROLLBACK Do?
- Investigating Redo
- Measuring Redo.
- Can I Turn Off Redo Log Generation?
- Why Can’t I Allocate a New Log?
- Block Cleanout.
- Log Contention.
- Temporary Tables and Redo/Undo
- Investigating Undo
- What Generates the Most and Least Undo?
- ORA-01555: snapshot too old Error
- Chapter 10: Database Tables
- Types of Tables
- Terminology
- Segment
- Segment Space Management
- High-water Mark
- FREELISTS
- PCTFREE and PCTUSED
- LOGGING and NOLOGGING
- INITRANS and MAXTRANS
- Heap Organized Tables
- Index Organized Tables
- Index Organized Tables Wrap-up
- Index Clustered Tables Wrap-up
- Hash Clustered Tables
- Hash Clustered Tables Wrap-up
- Sorted Hash Clustered Tables
- Nested Tables
- Nested Tables Syntax
- Nested Table Storage
- Nested Tables Wrap-up
- Temporary Tables
- Temporary Tables Wrap-up
- Object Tables
- Object Tables Wrap-up
- Chapter 11: Indexes
- An Overview of Oracle Indexes
- B*Tree Indexes
- Index Key Compression
- Reverse Key Indexes
- Descending Indexes
- When Should You Use a B*Tree Index?
- B*Trees Wrap-up
- Bitmap Indexes
- When Should You Use a Bitmap Index?
- Bitmap Join Indexes
- Bitmap Indexes Wrap-up
- Function-Based Indexes
- Important Implementation Details
- A Simple Function-Based Index Example
- Indexing Only Some of the Rows.
- Implementing Selective Uniqueness
- Caveat Regarding ORA-01743
- Function-Based Indexes Wrap-up
- Application Domain Indexes
- Frequently Asked Questions and Myths About Indexes.
- Do Indexes Work on Views?
- Do Nulls and Indexes Work Together?
- Should Foreign Keys Be Indexed?
- Why Isn’t My Index Getting Used?
- Myth: Space Is Never Reused in an Index
- Myth: Most Discriminating Elements Should Be First
- Chapter 12: Datatypes
- An Overview of Oracle Datatypes
- Character and Binary String Types
- NLS Overview
- Character Strings
- Binary Strings: RAW Types
- Number Types.
- NUMBER Type Syntax and Usage
- BINARY_FLOAT/BINARY_DOUBLE Type Syntax and Usage.
- Non-native Number Types
- Performance Considerations
- Long Types
- Restrictions on LONG and LONG RAW Types
- Coping with Legacy LONG Types
- Dates,Timestamps,and Interval Types
- Formats
- DATE Type
- TIMESTAMP Type.
- INTERVAL Type
- LOB Types
- Internal LOBs
- BFILEs.
- ROWID/UROWID Types
- Chapter 13: Partitioning.
- Partitioning Overview
- Increased Availability
- Reduced Administrative Burden
- Enhanced Statement Performance.
- Table Partitioning Schemes.
- Range Partitioning
- Hash Partitioning
- List Partitioning
- Interval Partitioning
- Reference Partitioning.
- Composite Partitioning
- Row Movement.
- Table Partitioning Schemes Wrap-up.
- Partitioning Indexes
- Local Indexes vs. Global Indexes.
- Local Indexes
- Global Indexes
- Partitioning and Performance,Revisited
- Auditing and Segment Space Compression.
- Chapter 14: Parallel Execution.
- When to Use Parallel Execution
- A Parallel Processing Analogy
- Oracle Exadata.
- Parallel Query
- Parallel DML.
- Parallel DDL
- Parallel DDL and Data Loading Using External Tables
- Parallel DDL and Extent Trimming.
- Parallel Recovery
- Procedural Parallelism.
- Parallel Pipelined Functions
- Do-It-Yourself Parallelism
- Old School Do-It-Yourself Parallelism
- Chapter 15: Data Loading and Unloading.
- SQL*Loader.
- Loading Data with SQLLDR FAQs
- SQLLDR Caveats
- External Tables
- Setting Up External Tables
- Dealing with Errors
- Using an External Table to Load Different Files
- Multiuser Issues
- Flat File Unload
- Data Pump Unload
- Chapter 16: Data Encryption
- Types of Encryption
- Data in Motion
- Data at Rest
- Manual Application Encryption
- The Oracle Wallet
- Transparent Column Level Encryption
- Transparent Tablespace Encryption
- What Encryption Is Not About
- Implementing Manual Application Encryption
- Reasons to Avoid the Manual Approach
- Performance Implications of the Manual Approach
- When to Use the Manual Approach
- Implementing Column Level Encryption
- How to Use Column Encryption
- Data Storage with Column Encryption
- Measuring the Performance Impact of Column Encryption
- Influences on the Magnitude
- Limitations of Column Encryption.
- Implementing Tablespace Encryption.
- How to Use Tablespace Encryption
- Data Storage with Tablespace Encryption
- Measuring the Performance Impact of Tablespace Encryption
- Deciding on an Encryption Technique
