Getting Started with the Oracle Berkeley DB SQL APIs
     Next

Getting Started with the Oracle Berkeley DB SQL APIs

Legal Notice

This documentation is distributed under an open source license. You may review the terms of this license at:

Oracle, Berkeley DB, and Sleepycat are trademarks or registered trademarks of Oracle. All rights to these marks are reserved. No third-party use is permitted without the express prior written consent of Oracle.

Other names may be trademarks of their respective owners.

To obtain a copy of this document's original source code, please submit a request to the Oracle Technology Network forum at:

8/27/2010

Table of Contents

Preface
Conventions Used in this Book
For More Information
Contact Us
1. Berkeley DB SQL: The Absolute Basics
BDB SQL Is Nearly Identical to SQLite
Getting and Installing BDB SQL
On Windows Systems
On Unix
The Journal Directory
Unsupported PRAGMAs
Changed PRAGMAs
PRAGMA journal_size_limit
PRAGMA max_page_count
Added PRAGMAs
PRAGMA TXN_BULK
Miscellaneous Differences
Berkeley DB Concepts
Encryption
2. Locking Notes
Internal Database Usage
Lock Handling
SQLite Lock Usage
Lock Usage with the DB SQL Interface
3. Configuring the Berkeley DB SQL interface
Introduction to Environments
The DB_CONFIG File
Creating the DB_CONFIG File Before Environment Creation
Re-creating the Environment
Configuring the Database Page Size
Selecting the Page Size
Selecting the Database File Size
Configuring the In-Memory Cache
Administering Log Files
Setting the Log File Size
Configuring the Logging Region Size
Setting the In-Memory Log Buffer Size
Managing the Locking Subsystem
4. Administrating Berkeley DB SQL Databases
Backing Up Berkeley DB SQL Databases
Offline Backups
Hot Backup
Incremental Backups
About Unix Copy Utilities
Recovering from a Backup
Catastrophic Recovery
Syncing with Oracle Databases
Syncing on Unix Platforms
Syncing on Windows Platforms
Syncing on Windows Mobile Platforms
Data Migration
Migration Using the Shells
Supported Data and Schema
Replicating Berkeley DB SQL Databases
Preparing to use Replication with the Berkeley DB SQL API
Using Replication with the Berkeley DB SQL API
     Next
     Preface