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 3RD_EDITION
SUMMARY
-
Items Found: 564
- 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
- Multiversioning
- 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
- Pluggable Databases
- Reduced Resource Utilization
- Reduced Maintenance
- How Is a Pluggable Database Different?
- 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
- Fast 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
- SGA 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 Multiversioning
- What Are Concurrency Controls?
- Transaction Isolation Levels
- READ UNCOMMITTED
- READ COMMITTED
- REPEATABLE READ
- SERIALIZABLE
- READ ONLY
- Implications of Multiversion 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 Nondistributed 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-COMMIT 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
- Statistics Prior to 12c
- Statistics Starting with 12c
- 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
- 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
- Invisible Indexes
- Multiple Indexes on the Same Column Combinations
- Indexing Extended Columns
- Virtual Column Solution
- Function-Based Index Solution
- 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
- Extended Datatypes
- 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
- Reduced Contention in an OLTP System
- Table Partitioning Schemes
- Range Partitioning
- Hash Partitioning
- List Partitioning
- Interval Partitioning
- Reference Partitioning
- Interval Reference Partitioning
- Virtual Column Partitioning
- Composite Partitioning
- Row Movement
- Table Partitioning Schemes Wrap-up
- Partitioning Indexes
- Local Indexes vs. Global Indexes
- Local Indexes
- Global Indexes
- Partial Indexes
- Partitioning and Performance,Revisited
- Ease of Maintenance Features
- Multiple Partition Maintenance Operations
- Cascade Truncate
- Cascade Exchange
- 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
- Procedural Parallelism
- Parallel Pipelined Functions
- Do-It-Yourself Parallelism
- Old School Do-It-Yourself Parallelism
- Chapter 15: Data Loading and Unloading
- External Tables
- Setting Up External Tables
- Dealing with Errors
- Using an External Table to Load Different Files
- Multiuser Issues
- Preprocessing
- Data Pump Unload
- SQLLDR
- Loading Data with SQLLDR FAQs
- SQLLDR Caveats
- Flat File Unload
- 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
- Multiversioning
- 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
- Pluggable Databases
- Reduced Resource Utilization
- Reduced Maintenance
- How Is a Pluggable Database Different?
- 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
- Fast 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
- SGA 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 Multiversioning
- What Are Concurrency Controls?
- Transaction Isolation Levels
- READ UNCOMMITTED
- READ COMMITTED
- REPEATABLE READ
- SERIALIZABLE
- READ ONLY
- Implications of Multiversion 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 Nondistributed 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-COMMIT 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
- Statistics Prior to 12c
- Statistics Starting with 12c
- 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
- 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
- Invisible Indexes
- Multiple Indexes on the Same Column Combinations
- Indexing Extended Columns
- Virtual Column Solution
- Function-Based Index Solution
- 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
- Extended Datatypes
- 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
- Reduced Contention in an OLTP System
- Table Partitioning Schemes
- Range Partitioning
- Hash Partitioning
- List Partitioning
- Interval Partitioning
- Reference Partitioning
- Interval Reference Partitioning
- Virtual Column Partitioning
- Composite Partitioning
- Row Movement
- Table Partitioning Schemes Wrap-up
- Partitioning Indexes
- Local Indexes vs. Global Indexes
- Local Indexes
- Global Indexes
- Partial Indexes
- Partitioning and Performance,Revisited
- Ease of Maintenance Features
- Multiple Partition Maintenance Operations
- Cascade Truncate
- Cascade Exchange
- 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
- Procedural Parallelism
- Parallel Pipelined Functions
- Do-It-Yourself Parallelism
- Old School Do-It-Yourself Parallelism
- Chapter 15: Data Loading and Unloading
- External Tables
- Setting Up External Tables
- Dealing with Errors
- Using an External Table to Load Different Files
- Multiuser Issues
- Preprocessing
- Data Pump Unload
- SQLLDR
- Loading Data with SQLLDR FAQs
- SQLLDR Caveats
- Flat File Unload
