SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK EXPERT ORACLE EXADATA
SUMMARY
-
Items Found: 1204
- Acknowledgments
- Chapter 1: Introduction
- Distributed Processing and Replication
- Oracle Basic Replication
- Oracle Advanced Replication
- Oracle Streams Replication
- Evolution and Oracle GoldenGate
- Chapter 2: Installation
- Downloading the Software
- Downloading from Oracle E-Delivery
- Downloading from OTN
- Understanding Your Environment
- Reviewing the Install Instructions
- Installing Goldengate
- General System Requirements
- Memory Requirements
- Disk Space Requirements
- Network Requirements
- Operating System Requirements
- Requirements for Microsoft Windows Clustered Environments
- Installing Goldengate on Windows
- Installing GoldenGate 11g on Linux and UNIX
- Environment Settings for Oracle and Goldengate on Linux and UNIX
- GoldenGate and Oracle RAC Considerations
- Installing Goldengate for Microsoft SQL Server on Windows
- Installing Goldengate for Teradata on Windows and UNIX
- Installing Goldengate for Sybase on Windows and UNIX
- Installing GoldenGate for IBM DB2 UDB on Windows and UNIX
- Installing Oracle GoldenGate Director 11g
- System Requirements
- Installing Oracle GoldenGate Director Server
- Grant Database Privileges and Credentials to Oracle GoldenGate Director Server Schema
- Install Oracle GoldenGate Director
- Installing Oracle GoldenGate Veridata
- GoldenGate Veridata Agent System Requirements
- GoldenGate Veridata Agent Disk Requirements
- GoldenGate Veridata Agent Memory Requirements
- GoldenGate Veridata Agent Database Privileges
- GoldenGate Veridata Server System Requirements
- Install Oracle Goldengate Veridata
- Chapter 3: Architecture
- Typical GoldenGate Flow
- GoldenGate Components
- Source Database
- Capture (Local Extract) Process
- Source Trail
- Data Pump
- Network
- Collector
- Remote Trail
- Delivery (Replicat).
- Target Database
- Manager
- Topologies and Use Cases
- One-Way Replication
- Bidirectional Replication
- Broadcast Replication
- Integration Replication
- Tools and Utilities
- GGSCI
- DEFGEN
- Logdump.
- Reverse
- Veridata
- Director
- Chapter 4: Basic Replication
- Overview
- Prerequisites for Setting Up Replication
- Requirements
- One-Way Replication Topology
- Basic Replication Steps
- Starting the Extract
- Verifying Database-Level Supplemental Logging
- Enabling Database-Level Supplemental Logging
- Enabling Table-Level Supplemental Logging
- Disabling Triggers and Cascade-Delete Constraints
- Verifying the Manager Status
- Configuring the Local Extract
- Adding the Extract
- Starting and Stopping the Extract
- Verifying the Extract
- Starting the Data Pump
- Configuring the Data Pump
- Adding the Data Pump
- Starting and Stopping the Data Pump
- Verifying the Data Pump
- Loading with GoldenGate
- Prerequisites for the GoldenGate Initial Load
- Configuring the Initial-Load Extract
- Adding the Initial-Load Extract
- Configuring the Initial-Load Replicat
- Adding the Initial-Load Replicat
- Starting the GoldenGate Initial Load
- Verifying the Initial Load
- Loading with DBMS Utilities
- Prerequisites for Loading with DBMS Utilities
- Steps for Loading with DBMS Utilities
- Starting the Replicat
- Configuring the Replicat
- Adding the Replicat
- Starting and Stopping the Replicat
- Verifying the Replicat
- Chapter 5: Advanced Features
- Enhancing the Replication Configuration
- Enhancing Extract and Replicat Reporting
- Reporting Discarded Records
- Purging Old Trail Files
- Adding Automatic Process Startup and Restart
- Adding a Checkpoint Table
- Making the Replication More Secure
- Encrypting Passwords
- Encrypting the Trail Files
- Adding Data Filtering and Mapping
- Filtering Tables
- Filtering Columns.
- Filtering Rows
- Mapping Columns
- Transforming Columns
- Oracle-Specific DBMS Configuration Options
- Configuring for Oracle RAC
- Configuring for Oracle ASM
- Adding Oracle DDL Replication
- Adding Bidirectional Replication
- Excluding Transactions for Bidirectional Replication
- Handling Conflict Resolution for Bidirectional Replication
- Chapter 6: Heterogeneous Replication
- Microsoft SQL Server to Oracle Replication
- Preparing the Oracle GoldenGate Environments
- Initial Data Load Completion for Oracle GoldenGate Environments
- Source Oracle Database Configuration
- Target Microsoft SQL Server Database Configuration
- Creating Sample Microsoft SQL Server Database
- Configure Change Data Capture on Source
- Verifying Operational Readiness
- Chapter 7: Tuning
- Tuning Methodology
- Defining the Performance Requirements.
- Creating a Performance Baseline
- Evaluating the Current Performance
- Determining the Problem
- Designing and Implementing a Solution
- Using Parallel Extracts and Replicats
- Implementing Parallel Extracts and Replicats with Table Filtering
- Implementing Parallel Extracts and Replicats Using Key Ranges
- Using BATCHSQL
- Using GROUPTRANSOPS
- Tuning Disk Storage
- Tuning the Network
- Tuning the RMTHOST Parameter
- Tuning the Database
- Chapter 8: Monitoring Oracle GoldenGate
- Designing a Monitoring Strategy
- Why Monitoring the Extract Is Important
- Getting the Maximum Threshold
- Which Processes to Monitor in the GoldenGate Environment
- Monitoring All Running Processes
- Monitoring the Detail Extract
- Checking the Current Oracle Online Redo Log
- Checking the Archived Log
- Monitoring the GoldenGate Rate and Redo Log Consumption Rate
- Monitoring Lags for Each Group
- Viewing Event and Error Logs
- Automating Monitoring
- Checking GoldenGate Process Scripts
- Monitoring Lag Scripts
- Checking Memory and CPU Scripts
- Checking Disk Space
- Chapter 9: Oracle GoldenGate Veridata
- Veridata Components
- GoldenGate Veridata Server
- GoldenGate Veridata Web
- GoldenGate Veridata Repository
- GoldenGate Veridata Agent,Java,and C-Code
- GoldenGate Veridata CLI (Vericom)
- How Veridata Comparison Works
- How Veridata Can Help You
- Setting Up the Veridata Compares
- Creating Database Connections
- Setting Up Tables and Data Scripts.
- Creating a Group
- Creating Compare Pairs
- Creating a Job
- Creating a Profile
- Running the Veridata Job
- Improving Performance and Reducing Overhead
- Excluding Columns
- Tuning Profiles Settings
- Disabling the Confirm Out of Sync Step
- Increasing the Number of Threads
- Compares Methods
- Right Trim on Character Fields
- Comparing Incremental Data for Large Tables
- Comparing GoldenGate Real-Time Replication Data
- Comparing Different Column Types and Compare Formats
- Using Performance Statistics
- Using Vericom Command Line
- Setting Up Role-Based Security
- Chapter 10: GoldenGate Director
- Director Components
- GoldenGate GGSCI Instances
- Director Administrator
- Director Server and Database
- Director Web
- Director Client
- Setting Up the Data Source
- Modifying the Manager Parameter file
- Modifying the Parameter File Using the Built-in Editor
- Modifying the Parameter File Using the GUI
- Setting Up the Initial Load
- Adding an Initial Load Task
- Creating a One-Way Replication
- Adding a Data Pump Process
- Additional Director Features and Tricks
- Alter Extract or Replicat RUN Options
- Changing the Trail-File Size
- Extracting Tranlogoptions
- Generating Definition Files
- Finding Parameters or Attributes in Director
- Advanced Mapping
- Alerts
- Chapter 11: Troubleshooting Oracle GoldenGate
- Common Problems and Solutions
- Oracle GoldenGate Process Failures
- Oracle GoldenGate Extract Process Failures
- Oracle GoldenGate Process Failures Without Report Diagnostics
- Oracle GoldenGate Trail File Problems
- Trail Files that Don’t Empty
- Trail Files that Don’t Roll Over
- Trail File Purging Issues
- Trail Files that Purge Too Soon
- Oracle GoldenGate Error Log Analysis
- Understanding the Oracle GoldenGate Discard File
- Discard File Not Created
- Discard File Is Too Big
- Can’t Open the Discard File
- Using Trace Commands with Oracle GoldenGate
- Oracle GoldenGate Process Tracing with TLTRACE
- Using TRACE Parameters with Oracle GoldenGate
- Troubleshooting Case Study with Oracle GoldenGate
- Oracle GoldenGate Configuration Issues
- Incorrect Software Versions with Oracle GoldenGate
- Database Availability Issues
- Missing Oracle GoldenGate Process Groups
- Missing Oracle GoldenGate Trail Files
- Oracle GoldenGate Parameter File Configuration Issues
- Operating System Configuration Issues with Oracle GoldenGate
- Network Configuration Issues with Oracle GoldenGate
- Network Data-Transfer Issues
- Oracle Database Issues with GoldenGate
- Extract Can’t Access Oracle Database Archive and Redo Logs
- Extract Failure Conditions Due to Oracle Source Database Issues
- Data-Pump Errors
- Replicat Errors on the Oracle Database Target System
- Replicat Hangs on the Target System
- Replicat Experiences an Abend Failure on the Target System
- Replicat Fails on Large Transactions
- Incompatible Record Errors with a Replicat
- Data-Synchronization Issues
- Tables Missing Key Constraints
- Character Set Configuration Issues
- Missing-Column Errors
- Fetch Failures
- Chapter 12: Disaster Recovery Replication
- Prerequisites
- Requirements
- Disaster Recovery Replication Topology
- Setup
- Configuring the Local Extract for Disaster Recovery
- Configuring the Data Pump for Disaster Recovery
- Configuring the Replicat for Disaster Recovery
- Configuring the Standby Extract
- Configuring the Standby Data Pump
- Configuring the Standby Replicat
- Performing a Planned Switchover
- Performing an Unplanned Failover
- Chapter 13: Zero-Downtime Migration Replication
- Prerequisites
- Requirements
- Zero-Downtime Migration Topology
- Setup
- Configuring the Local Extract for Zero-Downtime Migration
- Configuring the Data Pump for Zero-Downtime Migration
- Configuring the Replicat for Zero-Downtime Migration
- Configuring the Fallback Local Extract for Zero-Downtime Migration
- Configuring the Fallback Data-Pump for Zero-Downtime Migration
- Configuring the Fallback Replicat for Zero-Downtime Migration
- Performing the Migration Cutover
- Performing the Migration Fallback
- Chapter 14: Tips and Tricks
- Requirements and Planning
- Knowing the Business Objectives.
- Understanding the Requirements
- Determining the Topology
- Installation and Setup
- Creating Dedicated Users
- Encrypting Passwords
- Creating a Dedicated Installation Directory
- Using a Checkpoint Table
- Verifying the Character Sets
- Developing Naming Standards
- Using a Data Pump
- Management and Monitoring
- Using GGSCI Command Shortcuts
- Using OBEY Files
- Generating Interim Statistics
- Using a Discard File
- Reporting Regularly on Process Health
- Purging Old Trail Files Regularly
- Automatically Starting Processes
- Performance
- Running Performance Tests
- Limiting the Number of Extracts
- Using Passthru Mode for Data Pumps
- Using Parallel Replicats
- Using the Fastest Available Storage
- Tuning the Database
- Appendix: Additional Technical Resources for the
- Oracle GoldenGate Administrator
- References for Further Reading
- Quick Guide to Oracle GoldenGate Commands
- ADD
- GGSCI
- HELP
- INFO
- SEND
- STATUS
- Logdump Commands and Syntax for Troubleshooting
- Accessing the Logdump Utility
- Getting Help with Logdump Syntax
- HISTORY.
- Opening GoldenGate Trail Files with Logdump
- Chapter 1: What Is Exadata?.
- An Overview of Exadata
- History of Exadata
- Alternative Views of What Exadata Is
- Data Warehouse Appliance
- OLTP Machine
- Consolidation Platform
- Configuration Options
- Exadata Database Machine X2-2.
- Exadata Database Machine X2-8.
- Hardware Components
- Operating Systems
- Database Servers
- Storage Servers.
- InfiniBand
- Flash Cache
- Disks.
- Bits and Pieces
- Software Components
- Database Server Software
- Storage Server Software
- Software Architecture.
- Chapter 2: Offloading / Smart Scan
- Why Offloading Is Important
- What Offloading Includes
- Column Projection
- Predicate Filtering
- Storage Indexes.
- Simple Joins (Bloom Filters)
- Function Offloading
- Compression/Decompression.
- Encryption/Decryption
- Virtual Columns
- Data Mining Model Scoring
- Non-Smart Scan Offloading.
- Smart Scan Prerequisites
- Full Scans
- Direct Path Reads
- Exadata Storage
- Smart Scan Disablers
- Simply Unavailable
- Reverting to Block Shipping
- Skipping Some Offloading
- How to Verify That Smart Scan is Happening
- 10046 Trace.
- Performance Statistics (v$sessstat)
- Offload Eligible Bytes
- SQL Monitoring
- Parameters
- Chapter 3: Hybrid Columnar Compression
- Oracle Storage Review
- Oracle Compression Mechanisms
- BASIC.
- OLTP
- HCC.
- HCC Mechanics.
- HCC Performance.
- Load Performance
- Query Performance.
- DML Performance.
- Expected Compression Ratios
- Compression Advisor.
- Real World Examples.
- Restrictions/Challenges.
- Moving Data to a non-Exadata Platform.
- Disabling Serial Direct Path Reads
- Locking Issues
- Single Row Access
- Common Usage Scenarios
- Chapter 4: Storage Indexes
- Structure.
- Monitoring Storage Indexes
- Database Statistics.
- Tracing.
- Monitoring Wrap Up
- Controlling Storage Indexes.
- _kcfis_storageidx_disabled
- _kcfis_storageidx_diag_mode.
- _cell_storidx_mode
- Storage Software Parameters
- Behavior
- Performance
- Special Optimization for Nulls
- Physical Distribution of Values
- Potential Issues
- Incorrect Results
- Moving Target.
- Partition Size
- Incompatible Coding Techniques
- Chapter 5: Exadata Smart Flash Cache
- Hardware
- Cache vs. Flash Disk
- Using Flash Memory as Cache
- How ESFC is Created
- Controlling ESFC Usage
- Monitoring
- At the Storage Layer
- At the Database Layer
- Performance
- Chapter 6: Exadata Parallel Operations
- Parameters
- Parallelization at the Storage Tier
- Auto DOP
- Operation and Configuration.
- I/O Calibration.
- Auto DOP Wrap Up
- Parallel Statement Queuing
- The Old Way.
- The New Way.
- Controlling Parallel Queuing
- Parallel Statement Queuing Wrap Up
- In-Memory Parallel Execution
- Chapter 7: Resource Management
- Database Resource Manager.
- Consumer Groups
- Plan Directives.
- Resource Plan.
- Resource Manager Views
- The Wait Event: resmgr: cpu quantum
- DBRM Example
- Testing a Resource Plan.
- Instance Caging
- Configuring and Testing Instance Caging.
- Over-Provisioning
- I/O Resource Manager
- How IORM Works
- Methods for Managing I/O on Exadata
- Bringing It All Together
- IORM Monitoring and Metrics
- Chapter 8: Configuring Exadata
- Exadata Network Components
- The Management Network
- The Client Access Network.
- The Private Network
- About the Configuration Process
- Configuring Exadata.
- Step 1: The Configuration Worksheet.
- Step 2: The DBM Configurator
- Step 3: Upload Parameter and Deployment Files
- Step 4: CheckIP (checkip.sh)
- Step 5: Firstboot
- Step 6: Staging the Installation Media
- Step 7: Running OneCommand
- Upgrading Exadata.
- Creating a New RAC Cluster
- Upgrading the Existing Cluster
- Chapter 9: Recovering Exadata.
- Exadata Diagnostic Tools
- Sun Diagnostics: sundiag.sh
- HealthCheck
- CellCLI.
- Backing Up Exadata
- Backing Up the Database Servers
- Backing Up the Storage Cell
- Backing Up the Database.
- Disk-Based Backups.
- Tape-Based Backups.
- Backup from Standby Database
- Exadata Optimizations for RMAN.
- Recovering Exadata
- Restoring the Database Server.
- Recovering the Storage Cell
- Chapter 10: Exadata Wait Events.
- Events Specific to Exadata
- The “cell” Events.
- Plan Steps That Trigger Events
- Exadata Wait Events in the User I/O Class.
- cell smart table scan
- cell smart index scan
- cell single block physical read
- cell multiblock physical read.
- cell list of blocks physical read
- cell smart file creation
- cell statistics gather
- Exadata Wait Events in the System I/O Class
- cell smart incremental backup.
- cell smart restore from backup
- Exadata Wait Events in the Other and Idle Classes
- cell smart flash unkeep
- Old Events
- direct path read
- enq: KO—fast object checkpoint
- reliable message
- Resource Manager Events.
- resmgr:cpu quantum
- resmgr:pq queued
- Chapter 11: Understanding Exadata Performance Metrics.
- Measuring Exadata’s Performance Metrics.
- Revisiting the Prerequisites for Exadata Smart Scans
- Exadata Smart Scan Performance
- Understanding Exadata Smart Scan Metrics and Performance Counters
- Exadata Dynamic Performance Counters
- When and How to Use Performance Counters
- The Meaning and Explanation of Exadata Performance Counters.
- Exadata Performance Counter Reference
- Understanding SQL Statement Performance
- Chapter 12: Monitoring Exadata Performance
- A Systematic Approach.
- Monitoring SQL Statement Response Time
- Monitoring SQL Statements with Real-Time SQL Monitoring Reports.
- Monitoring SQL Statements using V$SQL and V$SQLSTATS
- Monitoring the Storage Cell Layer
- Accessing Cell Metrics in the Cell Layer Using CellCLI
- Accessing Cell Metrics Using the Grid Control Exadata Storage Server Plug-In
- Which Cell Metrics to Use?
- Monitoring Exadata Storage Cell OS-level Metrics
- Chapter 13: Migrating to Exadata
- Migration Strategies
- Logical Migration
- Extract and Load
- Copying Data over a Database Link.
- Replication-Based Migration
- Logical Migration Wrap Up
- Physical Migration
- Backup and Restore
- Full Backup and Restore.
- Incremental Backup
- Transportable Tablespaces (and XTTS)
- Physical Standby
- ASM Rebalance
- Post-Migration Tasks
- Wrap Up Physical Migration Section
- Chapter 14: Storage Layout
- Exadata Disk Architecture
- Failure Groups
- Grid Disks
- Storage Allocation
- Creating Grid Disks
- Creating Grid Disks.
- Grid Disk Sizing
- Creating FlashDisk-Based Grid Disks
- Storage Strategies
- Configuration Options
- Isolating Storage Cell Access
- Cell Security.
- Cell Security Terminology.
- Cell Security Best Practices
- Configuring ASM-Scoped Security
- Configuring Database-Scoped Security
- Removing Cell Security
- Chapter 15: Compute Node Layout
- Provisioning Considerations
- Non-RAC Configuration.
- RAC Clusters
- Typical Exadata Configuration
- Exadata Clusters
- Chapter 16: Unlearning Some Things We Thought We Knew.
- A Tale of Two Systems
- OLTP-Oriented Workloads.
- Exadata Smart Flash Cache (ESFC)
- Scalability
- Write-Intensive OLTP Workloads
- DW-Oriented Workloads
- Enabling Smart Scans
- Things that Can Cripple Smart Scans.
- Other Things to Keep in Mind
- Mixed Workloads
- To Index or Not to Index?.
- The Optimizer Doesn’t Know
- Using Resource Manager
- Appendix A: CellCLI and dcli
- CellCLI Command Syntax
- Getting Familiar with CellCLI
- Sending Commands from the Operating System
- Configuring and Managing the Storage Cell.
- dcli Command Syntax.
- Appendix B: Online Exadata Resources
- Exadata MOS Support Notes.
- Helpful Exadata MOS Support Notes
- Exadata Bulletins and Blogs
- Appendix C: Diagnostic Scripts
- Acknowledgments
- Chapter 1: Introduction
- Distributed Processing and Replication
- Oracle Basic Replication
- Oracle Advanced Replication
- Oracle Streams Replication
- Evolution and Oracle GoldenGate
- Chapter 2: Installation
- Downloading the Software
- Downloading from Oracle E-Delivery
- Downloading from OTN
- Understanding Your Environment
- Reviewing the Install Instructions
- Installing Goldengate
- General System Requirements
- Memory Requirements
- Disk Space Requirements
- Network Requirements
- Operating System Requirements
- Requirements for Microsoft Windows Clustered Environments
- Installing Goldengate on Windows
- Installing GoldenGate 11g on Linux and UNIX
- Environment Settings for Oracle and Goldengate on Linux and UNIX
- GoldenGate and Oracle RAC Considerations
- Installing Goldengate for Microsoft SQL Server on Windows
- Installing Goldengate for Teradata on Windows and UNIX
- Installing Goldengate for Sybase on Windows and UNIX
- Installing GoldenGate for IBM DB2 UDB on Windows and UNIX
- Installing Oracle GoldenGate Director 11g
- System Requirements
- Installing Oracle GoldenGate Director Server
- Grant Database Privileges and Credentials to Oracle GoldenGate Director Server Schema
- Install Oracle GoldenGate Director
- Installing Oracle GoldenGate Veridata
- GoldenGate Veridata Agent System Requirements
- GoldenGate Veridata Agent Disk Requirements
- GoldenGate Veridata Agent Memory Requirements
- GoldenGate Veridata Agent Database Privileges
- GoldenGate Veridata Server System Requirements
- Install Oracle Goldengate Veridata
- Chapter 3: Architecture
- Typical GoldenGate Flow
- GoldenGate Components
- Source Database
- Capture (Local Extract) Process
- Source Trail
- Data Pump
- Network
- Collector
- Remote Trail
- Delivery (Replicat).
- Target Database
- Manager
- Topologies and Use Cases
- One-Way Replication
- Bidirectional Replication
- Broadcast Replication
- Integration Replication
- Tools and Utilities
- GGSCI
- DEFGEN
- Logdump.
- Reverse
- Veridata
- Director
- Chapter 4: Basic Replication
- Overview
- Prerequisites for Setting Up Replication
- Requirements
- One-Way Replication Topology
- Basic Replication Steps
- Starting the Extract
- Verifying Database-Level Supplemental Logging
- Enabling Database-Level Supplemental Logging
- Enabling Table-Level Supplemental Logging
- Disabling Triggers and Cascade-Delete Constraints
- Verifying the Manager Status
- Configuring the Local Extract
- Adding the Extract
- Starting and Stopping the Extract
- Verifying the Extract
- Starting the Data Pump
- Configuring the Data Pump
- Adding the Data Pump
- Starting and Stopping the Data Pump
- Verifying the Data Pump
- Loading with GoldenGate
- Prerequisites for the GoldenGate Initial Load
- Configuring the Initial-Load Extract
- Adding the Initial-Load Extract
- Configuring the Initial-Load Replicat
- Adding the Initial-Load Replicat
- Starting the GoldenGate Initial Load
- Verifying the Initial Load
- Loading with DBMS Utilities
- Prerequisites for Loading with DBMS Utilities
- Steps for Loading with DBMS Utilities
- Starting the Replicat
- Configuring the Replicat
- Adding the Replicat
- Starting and Stopping the Replicat
- Verifying the Replicat
- Chapter 5: Advanced Features
- Enhancing the Replication Configuration
- Enhancing Extract and Replicat Reporting
- Reporting Discarded Records
- Purging Old Trail Files
- Adding Automatic Process Startup and Restart
- Adding a Checkpoint Table
- Making the Replication More Secure
- Encrypting Passwords
- Encrypting the Trail Files
- Adding Data Filtering and Mapping
- Filtering Tables
- Filtering Columns.
- Filtering Rows
- Mapping Columns
- Transforming Columns
- Oracle-Specific DBMS Configuration Options
- Configuring for Oracle RAC
- Configuring for Oracle ASM
- Adding Oracle DDL Replication
- Adding Bidirectional Replication
- Excluding Transactions for Bidirectional Replication
- Handling Conflict Resolution for Bidirectional Replication
- Chapter 6: Heterogeneous Replication
- Microsoft SQL Server to Oracle Replication
- Preparing the Oracle GoldenGate Environments
- Initial Data Load Completion for Oracle GoldenGate Environments
- Source Oracle Database Configuration
- Target Microsoft SQL Server Database Configuration
- Creating Sample Microsoft SQL Server Database
- Configure Change Data Capture on Source
- Verifying Operational Readiness
- Chapter 7: Tuning
- Tuning Methodology
- Defining the Performance Requirements.
- Creating a Performance Baseline
- Evaluating the Current Performance
- Determining the Problem
- Designing and Implementing a Solution
- Using Parallel Extracts and Replicats
- Implementing Parallel Extracts and Replicats with Table Filtering
- Implementing Parallel Extracts and Replicats Using Key Ranges
- Using BATCHSQL
- Using GROUPTRANSOPS
- Tuning Disk Storage
- Tuning the Network
- Tuning the RMTHOST Parameter
- Tuning the Database
- Chapter 8: Monitoring Oracle GoldenGate
- Designing a Monitoring Strategy
- Why Monitoring the Extract Is Important
- Getting the Maximum Threshold
- Which Processes to Monitor in the GoldenGate Environment
- Monitoring All Running Processes
- Monitoring the Detail Extract
- Checking the Current Oracle Online Redo Log
- Checking the Archived Log
- Monitoring the GoldenGate Rate and Redo Log Consumption Rate
- Monitoring Lags for Each Group
- Viewing Event and Error Logs
- Automating Monitoring
- Checking GoldenGate Process Scripts
- Monitoring Lag Scripts
- Checking Memory and CPU Scripts
- Checking Disk Space
- Chapter 9: Oracle GoldenGate Veridata
- Veridata Components
- GoldenGate Veridata Server
- GoldenGate Veridata Web
- GoldenGate Veridata Repository
- GoldenGate Veridata Agent,Java,and C-Code
- GoldenGate Veridata CLI (Vericom)
- How Veridata Comparison Works
- How Veridata Can Help You
- Setting Up the Veridata Compares
- Creating Database Connections
- Setting Up Tables and Data Scripts.
- Creating a Group
- Creating Compare Pairs
- Creating a Job
- Creating a Profile
- Running the Veridata Job
- Improving Performance and Reducing Overhead
- Excluding Columns
- Tuning Profiles Settings
- Disabling the Confirm Out of Sync Step
- Increasing the Number of Threads
- Compares Methods
- Right Trim on Character Fields
- Comparing Incremental Data for Large Tables
- Comparing GoldenGate Real-Time Replication Data
- Comparing Different Column Types and Compare Formats
- Using Performance Statistics
- Using Vericom Command Line
- Setting Up Role-Based Security
- Chapter 10: GoldenGate Director
- Director Components
- GoldenGate GGSCI Instances
- Director Administrator
- Director Server and Database
- Director Web
- Director Client
- Setting Up the Data Source
- Modifying the Manager Parameter file
- Modifying the Parameter File Using the Built-in Editor
- Modifying the Parameter File Using the GUI
- Setting Up the Initial Load
- Adding an Initial Load Task
- Creating a One-Way Replication
- Adding a Data Pump Process
- Additional Director Features and Tricks
- Alter Extract or Replicat RUN Options
- Changing the Trail-File Size
- Extracting Tranlogoptions
- Generating Definition Files
- Finding Parameters or Attributes in Director
- Advanced Mapping
- Alerts
- Chapter 11: Troubleshooting Oracle GoldenGate
- Common Problems and Solutions
- Oracle GoldenGate Process Failures
- Oracle GoldenGate Extract Process Failures
- Oracle GoldenGate Process Failures Without Report Diagnostics
- Oracle GoldenGate Trail File Problems
- Trail Files that Don’t Empty
- Trail Files that Don’t Roll Over
- Trail File Purging Issues
- Trail Files that Purge Too Soon
- Oracle GoldenGate Error Log Analysis
- Understanding the Oracle GoldenGate Discard File
- Discard File Not Created
- Discard File Is Too Big
- Can’t Open the Discard File
- Using Trace Commands with Oracle GoldenGate
- Oracle GoldenGate Process Tracing with TLTRACE
- Using TRACE Parameters with Oracle GoldenGate
- Troubleshooting Case Study with Oracle GoldenGate
- Oracle GoldenGate Configuration Issues
- Incorrect Software Versions with Oracle GoldenGate
- Database Availability Issues
- Missing Oracle GoldenGate Process Groups
- Missing Oracle GoldenGate Trail Files
- Oracle GoldenGate Parameter File Configuration Issues
- Operating System Configuration Issues with Oracle GoldenGate
- Network Configuration Issues with Oracle GoldenGate
- Network Data-Transfer Issues
- Oracle Database Issues with GoldenGate
- Extract Can’t Access Oracle Database Archive and Redo Logs
- Extract Failure Conditions Due to Oracle Source Database Issues
- Data-Pump Errors
- Replicat Errors on the Oracle Database Target System
- Replicat Hangs on the Target System
- Replicat Experiences an Abend Failure on the Target System
- Replicat Fails on Large Transactions
- Incompatible Record Errors with a Replicat
- Data-Synchronization Issues
- Tables Missing Key Constraints
- Character Set Configuration Issues
- Missing-Column Errors
- Fetch Failures
- Chapter 12: Disaster Recovery Replication
- Prerequisites
- Requirements
- Disaster Recovery Replication Topology
- Setup
- Configuring the Local Extract for Disaster Recovery
- Configuring the Data Pump for Disaster Recovery
- Configuring the Replicat for Disaster Recovery
- Configuring the Standby Extract
- Configuring the Standby Data Pump
- Configuring the Standby Replicat
- Performing a Planned Switchover
- Performing an Unplanned Failover
- Chapter 13: Zero-Downtime Migration Replication
- Prerequisites
- Requirements
- Zero-Downtime Migration Topology
- Setup
- Configuring the Local Extract for Zero-Downtime Migration
- Configuring the Data Pump for Zero-Downtime Migration
- Configuring the Replicat for Zero-Downtime Migration
- Configuring the Fallback Local Extract for Zero-Downtime Migration
- Configuring the Fallback Data-Pump for Zero-Downtime Migration
- Configuring the Fallback Replicat for Zero-Downtime Migration
- Performing the Migration Cutover
- Performing the Migration Fallback
- Chapter 14: Tips and Tricks
- Requirements and Planning
- Knowing the Business Objectives.
- Understanding the Requirements
- Determining the Topology
- Installation and Setup
- Creating Dedicated Users
- Encrypting Passwords
- Creating a Dedicated Installation Directory
- Using a Checkpoint Table
- Verifying the Character Sets
- Developing Naming Standards
- Using a Data Pump
- Management and Monitoring
- Using GGSCI Command Shortcuts
- Using OBEY Files
- Generating Interim Statistics
- Using a Discard File
- Reporting Regularly on Process Health
- Purging Old Trail Files Regularly
- Automatically Starting Processes
- Performance
- Running Performance Tests
- Limiting the Number of Extracts
- Using Passthru Mode for Data Pumps
- Using Parallel Replicats
- Using the Fastest Available Storage
- Tuning the Database
- Appendix: Additional Technical Resources for the
- Oracle GoldenGate Administrator
- References for Further Reading
- Quick Guide to Oracle GoldenGate Commands
- ADD
- GGSCI
- HELP
- INFO
- SEND
- STATUS
- Logdump Commands and Syntax for Troubleshooting
- Accessing the Logdump Utility
- Getting Help with Logdump Syntax
- HISTORY.
- Opening GoldenGate Trail Files with Logdump
- Chapter 1: What Is Exadata?.
- An Overview of Exadata
- History of Exadata
- Alternative Views of What Exadata Is
- Data Warehouse Appliance
- OLTP Machine
- Consolidation Platform
- Configuration Options
- Exadata Database Machine X2-2.
- Exadata Database Machine X2-8.
- Hardware Components
- Operating Systems
- Database Servers
- Storage Servers.
- InfiniBand
- Flash Cache
- Disks.
- Bits and Pieces
- Software Components
- Database Server Software
- Storage Server Software
- Software Architecture.
- Chapter 2: Offloading / Smart Scan
- Why Offloading Is Important
- What Offloading Includes
- Column Projection
- Predicate Filtering
- Storage Indexes.
- Simple Joins (Bloom Filters)
- Function Offloading
- Compression/Decompression.
- Encryption/Decryption
- Virtual Columns
- Data Mining Model Scoring
- Non-Smart Scan Offloading.
- Smart Scan Prerequisites
- Full Scans
- Direct Path Reads
- Exadata Storage
- Smart Scan Disablers
- Simply Unavailable
- Reverting to Block Shipping
- Skipping Some Offloading
- How to Verify That Smart Scan is Happening
- 10046 Trace.
- Performance Statistics (v$sessstat)
- Offload Eligible Bytes
- SQL Monitoring
- Parameters
- Chapter 3: Hybrid Columnar Compression
- Oracle Storage Review
- Oracle Compression Mechanisms
- BASIC.
- OLTP
- HCC.
- HCC Mechanics.
- HCC Performance.
- Load Performance
- Query Performance.
- DML Performance.
- Expected Compression Ratios
- Compression Advisor.
- Real World Examples.
- Restrictions/Challenges.
- Moving Data to a non-Exadata Platform.
- Disabling Serial Direct Path Reads
- Locking Issues
- Single Row Access
- Common Usage Scenarios
- Chapter 4: Storage Indexes
- Structure.
- Monitoring Storage Indexes
- Database Statistics.
- Tracing.
- Monitoring Wrap Up
- Controlling Storage Indexes.
- _kcfis_storageidx_disabled
- _kcfis_storageidx_diag_mode.
- _cell_storidx_mode
- Storage Software Parameters
- Behavior
- Performance
- Special Optimization for Nulls
- Physical Distribution of Values
- Potential Issues
- Incorrect Results
- Moving Target.
- Partition Size
- Incompatible Coding Techniques
- Chapter 5: Exadata Smart Flash Cache
- Hardware
- Cache vs. Flash Disk
- Using Flash Memory as Cache
- How ESFC is Created
- Controlling ESFC Usage
- Monitoring
- At the Storage Layer
- At the Database Layer
- Performance
- Chapter 6: Exadata Parallel Operations
- Parameters
- Parallelization at the Storage Tier
- Auto DOP
- Operation and Configuration.
- I/O Calibration.
- Auto DOP Wrap Up
- Parallel Statement Queuing
- The Old Way.
- The New Way.
- Controlling Parallel Queuing
- Parallel Statement Queuing Wrap Up
- In-Memory Parallel Execution
- Chapter 7: Resource Management
- Database Resource Manager.
- Consumer Groups
- Plan Directives.
- Resource Plan.
- Resource Manager Views
- The Wait Event: resmgr: cpu quantum
- DBRM Example
- Testing a Resource Plan.
- Instance Caging
- Configuring and Testing Instance Caging.
- Over-Provisioning
- I/O Resource Manager
- How IORM Works
- Methods for Managing I/O on Exadata
- Bringing It All Together
- IORM Monitoring and Metrics
- Chapter 8: Configuring Exadata
- Exadata Network Components
- The Management Network
- The Client Access Network.
- The Private Network
- About the Configuration Process
- Configuring Exadata.
- Step 1: The Configuration Worksheet.
- Step 2: The DBM Configurator
- Step 3: Upload Parameter and Deployment Files
- Step 4: CheckIP (checkip.sh)
- Step 5: Firstboot
- Step 6: Staging the Installation Media
- Step 7: Running OneCommand
- Upgrading Exadata.
- Creating a New RAC Cluster
- Upgrading the Existing Cluster
- Chapter 9: Recovering Exadata.
- Exadata Diagnostic Tools
- Sun Diagnostics: sundiag.sh
- HealthCheck
- CellCLI.
- Backing Up Exadata
- Backing Up the Database Servers
- Backing Up the Storage Cell
- Backing Up the Database.
- Disk-Based Backups.
- Tape-Based Backups.
- Backup from Standby Database
- Exadata Optimizations for RMAN.
- Recovering Exadata
- Restoring the Database Server.
- Recovering the Storage Cell
- Chapter 10: Exadata Wait Events.
- Events Specific to Exadata
- The “cell” Events.
- Plan Steps That Trigger Events
- Exadata Wait Events in the User I/O Class.
- cell smart table scan
- cell smart index scan
- cell single block physical read
- cell multiblock physical read.
- cell list of blocks physical read
- cell smart file creation
- cell statistics gather
- Exadata Wait Events in the System I/O Class
- cell smart incremental backup.
- cell smart restore from backup
- Exadata Wait Events in the Other and Idle Classes
- cell smart flash unkeep
- Old Events
- direct path read
- enq: KO—fast object checkpoint
- reliable message
- Resource Manager Events.
- resmgr:cpu quantum
- resmgr:pq queued
- Chapter 11: Understanding Exadata Performance Metrics.
- Measuring Exadata’s Performance Metrics.
- Revisiting the Prerequisites for Exadata Smart Scans
- Exadata Smart Scan Performance
- Understanding Exadata Smart Scan Metrics and Performance Counters
- Exadata Dynamic Performance Counters
- When and How to Use Performance Counters
- The Meaning and Explanation of Exadata Performance Counters.
- Exadata Performance Counter Reference
- Understanding SQL Statement Performance
- Chapter 12: Monitoring Exadata Performance
- A Systematic Approach.
- Monitoring SQL Statement Response Time
- Monitoring SQL Statements with Real-Time SQL Monitoring Reports.
- Monitoring SQL Statements using V$SQL and V$SQLSTATS
- Monitoring the Storage Cell Layer
- Accessing Cell Metrics in the Cell Layer Using CellCLI
- Accessing Cell Metrics Using the Grid Control Exadata Storage Server Plug-In
- Which Cell Metrics to Use?
- Monitoring Exadata Storage Cell OS-level Metrics
- Chapter 13: Migrating to Exadata
- Migration Strategies
- Logical Migration
- Extract and Load
- Copying Data over a Database Link.
- Replication-Based Migration
- Logical Migration Wrap Up
- Physical Migration
- Backup and Restore
- Full Backup and Restore.
- Incremental Backup
- Transportable Tablespaces (and XTTS)
- Physical Standby
- ASM Rebalance
- Post-Migration Tasks
- Wrap Up Physical Migration Section
- Chapter 14: Storage Layout
- Exadata Disk Architecture
- Failure Groups
- Grid Disks
- Storage Allocation
- Creating Grid Disks
- Creating Grid Disks.
- Grid Disk Sizing
- Creating FlashDisk-Based Grid Disks
- Storage Strategies
- Configuration Options
- Isolating Storage Cell Access
- Cell Security.
- Cell Security Terminology.
- Cell Security Best Practices
- Configuring ASM-Scoped Security
- Configuring Database-Scoped Security
- Removing Cell Security
- Chapter 15: Compute Node Layout
- Provisioning Considerations
- Non-RAC Configuration.
- RAC Clusters
- Typical Exadata Configuration
- Exadata Clusters
- Chapter 16: Unlearning Some Things We Thought We Knew.
- A Tale of Two Systems
- OLTP-Oriented Workloads.
- Exadata Smart Flash Cache (ESFC)
- Scalability
- Write-Intensive OLTP Workloads
- DW-Oriented Workloads
- Enabling Smart Scans
- Things that Can Cripple Smart Scans.
- Other Things to Keep in Mind
- Mixed Workloads
- To Index or Not to Index?.
- The Optimizer Doesn’t Know
- Using Resource Manager
- Appendix A: CellCLI and dcli
- CellCLI Command Syntax
- Getting Familiar with CellCLI
- Sending Commands from the Operating System
- Configuring and Managing the Storage Cell.
- dcli Command Syntax.
- Appendix B: Online Exadata Resources
- Exadata MOS Support Notes.
- Helpful Exadata MOS Support Notes
- Exadata Bulletins and Blogs
- Appendix C: Diagnostic Scripts
