Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introducing Oracle8i Cache

Who Should Use Oracle8i Cache?

What Are the Benefits of Oracle8i Cache?

What Is the Oracle8i Cache Environment?

How Does Oracle8i Cache Work?

How Do Applications Use Oracle8i Cache?

2 Setting Up Oracle8i Cache

Setting Up Oracle8i Cache: General Steps

Designing Your Oracle8i Cache Environment

Determining the Data to Be Cached

Deciding Where to Cache the Data

Deciding Synchronization Policies

Installing Oracle8i Cache

Invoking Oracle DBA Studio

Setting Up the Caches

Increasing the Disk Space Allocated to a Cache

Using the Add Tables Wizard to Set Up Caches

Verifying Your Cache Setup

Enabling Caching

Copying Cached Tables to Other Caches

Configuring Your Application Environment

3 Managing Oracle8i Cache

Enabling and Disabling Caching

Monitoring Your Oracle8i Cache Environment

Monitoring Hit and Miss Statistics

Resetting Hit and Miss Statistics

Monitoring Performance

Modifying Which Data Is Cached

Adding Tables to One Cache

Adding Tables to One or More Caches

Removing Tables from One Cache

Removing Tables from One or More Caches

Modifying Characteristics of a Cache

Modifying the Memory Allocated to a Cache

Modifying the Disk Space Allocated to a Cache

Modifying the Synchronization Policy

Synchronizing Data

Synchronizing Data in One Cache

Synchronizing Data in More than One Cache

Updating Users

Using the Configuration Assistant to Reconfigure a Cache

4 Tuning Your Oracle8i Cache Environment

Linking Applications That Use Static OCI Libraries

Controlling Which Applications Use Oracle8i Cache

Controlling Which Statements Use Oracle8i Cache

Tuning Hints

5 Troubleshooting Oracle8i Cache

Logging Errors

Important Cautions

Starting Oracle8i Cache and Related Software

Starting Oracle Data Gatherer

Starting the TNS Listener

Applications Must Be Linked in Multithreaded Mode

A Error Messages

Message Formats

Oracle8i Cache Error Messages

Index