Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Improving Performance

• 1.1 Improving Connection Performance
  • 1.1.1 Using Connection Pooling for Applications
  • 1.1.2 Limit Application Connection Requests to the Database
• 1.2 Increasing Synchronization Performance
  • 1.2.1 Analyzing Performance of Publications With the Consperf Utility
    • 1.2.1.1 Deciphering the Performance Evaluation Files
  • 1.2.2 Monitoring Synchronization Using SQL Scripts
    • 1.2.2.1 Synchronization Times for All Clients
    • 1.2.2.2 Failed Transactions for all Clients
    • 1.2.2.3 Completely Refreshed Publication Items for all Clients
    • 1.2.2.4 Publications Flagged for Complete Refresh for All Clients
    • 1.2.2.5 Clients and Publication where Subscription Parameters are Not Set
    • 1.2.2.6 Record Counts for Map-based Publication Item by Client
    • 1.2.2.7 Record Count for Map-based Publication Items by Store
    • 1.2.2.8 All Client Sequence Partitions and Sequence Values
    • 1.2.2.9 All Publication Item Indexes
  • 1.2.3 Create SQL Scripts With All Dependencies
  • 1.2.4 Configuration Parameters in the MOBILE.ORA that Affect Synchronization Performance
  • 1.2.5 Tuning Queries to Manage Synchronization Performance
    • 1.2.5.1 Avoid Using Non-Mergable Views
    • 1.2.5.2 Tune Queries With Consperf Utility
    • 1.2.5.3 Manage the Query Optimizer
  • 1.2.6 Synchronization Tablespace Layout
  • 1.2.7 Shared Maps
    • 1.2.7.1 Performance Attributes
    • 1.2.7.2 Shared Map Usage
    • 1.2.7.3 Compatibility and Migration for Shared Maps
  • 1.2.8 Use Map Table Partitions to Streamline Users Who Subscribe to a Large Amount of Data
    • 1.2.8.1 Create a Map Table Partition
    • 1.2.8.2 Add Map Table Partitions
    • 1.2.8.3 Drop a Map Table Partition
    • 1.2.8.4 Drop All Map Table Partitions
    • 1.2.8.5 Merge Map Table Partitions
  • 1.2.9 Configuring Back-End Oracle Database to Enhance Synchronization Performance
    • 1.2.9.1 Physically Separate Map Tables and Map Indexes
    • 1.2.9.2 Database Parameter Tuning
  • 1.2.10 Priority-Based Replication
    • 1.2.10.1 Create Restricting Predicate in Publication Item
    • 1.2.10.2 Set Priority Flag in Mobile Sync API Before Initiating Synchronization
  • 1.2.11 Caching Publication Item Queries
    • 1.2.11.1 Enabling Publication Item Query Caching
    • 1.2.11.2 Disabling Publication Item Query Caching
  • 1.2.12 Architecture Design of Mobile Server and Oracle Database for Synchronization Performance
  • 1.2.13 Designing Application Tables and Indexes for Synchronization Performance
• 1.3 Integrating Oracle Database Mobile Server With the Oracle Real Application Clusters
• 1.4 Maximizing JVM Performance By Managing Java Memory

2 Troubleshooting

• 2.1 Troubleshooting Synchronization
  • 2.1.1 Synchronization Errors and Conflicts
    • 2.1.1.1 General Synchronization Errors and Conflicts
    • 2.1.1.2 Synchronization Error if Client Device Clock is Inaccurate
    • 2.1.1.3 Synchronization Error After Modifying Client Password
    • 2.1.1.4 Synchronization Error if Synchronized with a Large Number of Tables
  • 2.1.2 Situations Where the Client is Out of Sync that Triggers a Complete Refresh
  • 2.1.3 The "Inconsistent Datatypes" SQLException Received If Order is Not Correct in Query
  • 2.1.4 MGP Compose Postponed Due to Transaction in the In-Queue
  • 2.1.5 Avoiding the Server Busy Warning
• 2.2 Troubleshooting the Mobile Server
  • 2.2.1 Running the Mobile Server With Tracing Enabled
• 2.3 Troubleshooting the Mobile Server Repository
  • 2.3.1 Troubleshooting the Mobile Server Repository with the Mobile Server Repository Diagnostic Tool
    • 2.3.1.1 Use the Mobile Server Repository Diagnostic Tool to Validate Your Environment and the Repository
    • 2.3.1.2 Execute the Repository Diagnostics Tool
  • 2.3.2 Inspecting Files in the Mobile Repository With the WSH Tool
  • 2.3.3 Modifying IP Address of Machine Where Mobile Repository Exists
• 2.4 Troubleshooting JVM Errors
  • 2.4.1 Troubleshooting An Out of Memory Error
    • 2.4.1.1 JVM Memory Settings
    • 2.4.1.2 Why is Memory Not Released?
    • 2.4.1.3 Thread Memory Consumption and Concurrency
• 2.5 Troubleshooting Security
  • 2.5.1 SSL Certificate Rejection for Client Authentication
• 2.6 Troubleshooting Device Manager

3 Tracing and Logging

• 3.1 General Tracing for the Mobile Server
• 3.2 Data Synchronization Tracing
  • 3.2.1 Description of the Five Data Synchronization Components
    • 3.2.1.1 MGP
    • 3.2.1.2 MGPAPPLY
    • 3.2.1.3 MGPCOMPOSE
    • 3.2.1.4 SYNC
    • 3.2.1.5 GLOBAL

4 Backup and Recovery

• 4.1 How Does Oracle Database Mobile Server Store its Information?
• 4.2 Backing Up Oracle Database Mobile Server
• 4.3 Oracle Database Mobile Server Backup Coordination Between Client and Server
• 4.4 Oracle Database Mobile Server Recovery Issues

Index