Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introducing Oracle Database Cache

Who Should Use Oracle Database Cache?

What Are the Benefits of Oracle Database Cache?

What Is the Oracle Database Cache Environment?

How Does Oracle Database Cache Work?

How Do Applications Use Oracle Database Cache?

2 Setting Up Oracle Database Cache

Setting Up Oracle Database Cache: General Steps

Designing Your Oracle Database Cache Environment

Determining the Data to Be Cached

Deciding Where to Cache the Data

Deciding Synchronization Policies

Deciding Which PL/SQL Objects to Cache

Installing Oracle Database Cache

Invoking Oracle DBA Studio

Setting Up the Caches

Increasing the Disk Space Allocated to a Cache

Using the Add Wizard to Set Up Caches

Verifying Your Cache Setup

Enabling Routing to the Cache

Copying Cached Objects to Other Caches

Configuring Your Application Environment

3 Managing Oracle Database Cache

Enabling and Disabling Routing to the Cache

Monitoring Your Oracle Database 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 PL/SQL Objects to One Cache

Adding Tables and PL/SQL Objects to One or More Caches

Removing Tables from One Cache

Removing PL/SQL Objects from One Cache

Removing Tables and PL/SQL Objects 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

Synchronizing PL/SQL Objects

Synchronizing PL/SQL Objects in One Cache

Synchronizing PL/SQL Objects in One or More Caches

Updating Users

Using the Configuration Assistant to Reconfigure a Cache

4 Tuning Your Oracle Database Cache Environment

Linking Applications That Use Static OCI Libraries

Controlling Which Applications Use Oracle Database Cache

Controlling Which Statements Use Oracle Database Cache

Tuning Hints

5 Troubleshooting Oracle Database Cache

Logging Errors

Important Cautions

Port Number Conflicts

Restoring tnsnames.ora Entries

Restoring listener.ora Entries

Starting Oracle Database Cache and Related Software

Starting Oracle Data Gatherer

Starting the TNS Listener

Applications Must Be Linked in Multithreaded Mode

6 Cache Management API

Privileges Required

Errors

ADD_PLSQL_OBJECT Procedure

ADD_TABLE Procedure

GET_FLAG Function

GET_ROUTING_STATE Function

GET_STATS_INTERVAL Function

GET_STATS_RESET_TIME Function

GET_TABLE_SIZE Procedure

REMOVE_PLSQL_OBJECT Procedure

REMOVE_TABLE Procedure

RESET_STATS Procedure

SET_FLAG Procedure

SET_ORIGIN_CREDENTIALS Procedure

SET_ROUTING_STATE Procedure

SET_STATS_INTERVAL Procedure

SET_SYNC_METHOD Procedure

SET_SYNC_SCHEDULE Procedure

SYNC_PLSQL_OBJECT Procedure

SYNC_TABLE Procedure

SYNC_USERS Procedure

A Oracle Database Cache Views

DBA_ICACHE_AGGREGATE_STATS View

DBA_ICACHE_OBJECTS View

DBA_ICACHE_QUERY_STATS View

B Error Messages

Message Formats

Oracle Database Cache Error Messages

Index