Index

A  B  C  D  E  G  H  I  J  L  M  N  O  P  Q  R  S  T  U  V  W 

---

A

Add Tables Wizard, 2-13, 3-8

adding databases

to Navigator tree, 2-8

adding files to caches, 2-13, 3-11

adding schemas to caches, 3-18

adding tables to caches, 2-22, 3-6, 3-7, 3-8

adding users, 3-18

anonymous blocks, 1-7

application environments

configuring, 2-25

applications

controlling which use caching, 4-2

layered on OCI, 1-7, 4-1

linking, 1-7, 4-1, 5-5

multithreaded, 5-5

single-threaded, 5-5

types of, 1-1

use with Oracle8i Cache, 1-1

attaching to databases, 2-8, 2-9

---

B

benefits of Oracle8i Cache, 1-2

---

C

Cache Manager, 1-5

description of, 2-6

invoking, 2-6

managing Oracle8i Cache with, 3-1

troubleshooting, 5-3

user privileges, 2-10

cache name

modifying, 3-19

cache status

verifying, 2-24

Cached Tables tab, 2-22, 3-10, 3-15

caches

adding schemas to, 3-18

adding tables to, 3-6, 3-7, 3-8

duplicating, 2-24

enabling, 2-24

middle-tier, 1-4

pausing, 3-1

removing tables from, 3-6, 3-8

resuming, 3-1

selecting, 2-4

setting up, 2-1, 2-13

starting, 3-1

stopping, 3-1

caching

enabling or disabling, 3-1

selecting data, 2-2

cachshut script, 5-4

cachstrt script, 5-4

character set

of caches, 2-13

checking disk space, 2-23

checking memory allocation, 2-23

commands

wtacca, 3-19

wtcme, 5-1

Complete synchronization policy, 2-5, 2-18

components

Oracle8i Cache, 1-5

Configuration Assistant, 3-19

configuring application environments, 2-25

connecting to databases, 2-8, 2-9

content publishing applications, 1-1

copying caches, 2-24

copying tables, 2-24

---

D

data

refreshing, 2-4, 3-15, 3-16

synchronizing, 2-4, 3-15, 3-16

considerations, 2-5

Data Gatherer

starting, 5-3, 5-4

data set, 1-5, 2-3

databases

adding to Navigator tree, 2-8

connecting to, 2-8, 2-9

origin, 1-4

DBA Studio, 1-5

invoking, 2-6

logging in to, 2-7

DBMS_CACHE_MASTER package, 5-3

DBMS_CACHE_MASTER_UTL package, 5-3

DBMSSIZE package, 5-3

debugging, 5-2

decreasing disk space, 3-11

decreasing memory allocation, 3-10

delete statements, 1-7, 3-5, 3-6

deleting allocated disk space, 3-13

designing Oracle8i Cache environment, 2-1

selecting data, 2-2

disabling caching, 3-1

disk space

decreasing, 3-11

deleting files, 3-13

increasing, 2-13, 2-23, 3-11

verifying, 2-23

duplicating caches, 2-24

dynamic libraries

OCI, 4-1

---

E

e-business applications, 1-1

enabling caching, 2-24, 3-1

environment

application

configuring, 2-25

controlling use of caches, 4-2

designing cache, 2-1

Oracle8i Cache, 1-3

troubleshooting problems in, 5-1

tuning, 4-1

environment variables

LD_LIBRARY_PATH, 2-26, A-2

ORA_OCI_CACHE, 2-25, 4-2

ORACLE_HOME, 2-26

ORACLE_SID, A-2

error messages, A-1

Data Gatherer and, 5-4

logging, 5-1, 5-2

single-threaded applications and, 5-5

---

G

General tab, 2-24

dimmed, 2-12, 5-3

enabling caching, 3-1

---

H

hit or miss statistics, 3-3

resetting, 3-5

hit ratio, 3-5

Hit/Miss Count per Second chart, 3-6

Hit/Miss Percentages chart, 3-5

Hit/Miss Statistics tab, 3-3

hits, 1-5, 3-3

monitoring, 3-5

host name

modifying, 3-19

hostname, 2-9

---

I

improving performance, 4-1

increasing disk space, 2-13, 2-23, 3-11

increasing memory allocation, 3-10

Incremental synchronization policy, 2-5, 2-18

insert statements, 1-7, 3-5, 3-6

interprocess communication (IPC) protocol, 5-5

invoking DBA Studio, 2-6

IPC protocol, 5-5

---

J

JDBC applications, 1-7, 4-1

---

L

language

character set of caches, 2-13

launching DBA Studio, 2-6

LD_LIBRARY_PATH environment variable, 2-26, A-2

libraries

OCI, 4-1

linking applications, 5-5

OCI, 4-1

listener

port number, 5-2

starting, 5-4

log file

wtcme.ora, 5-1

log files, 5-2

logging error messages, 5-1

level of detail, 5-2

logging in to DBA Studio, 2-7

---

M

management engine

starting, 5-3

managing Oracle8i Cache, 3-1

memory allocation

modifying, 3-10

verifying, 2-23

memory usage, 3-6

ratio of hits, 3-6

messages

error, A-1

middle-tier caches, 1-4

misses, 1-5, 3-3

monitoring, 3-5

modifying synchronization policies, 2-6, 3-13, 3-14

monitoring hits and misses, 3-5

monitoring Oracle8i Cache, 3-3

monitoring performance, 3-5

multiple-tier environments

Oracle8i Cache, 1-3

traditional, 1-2

multithreaded applications, 5-5

---

N

Navigator tree

adding databases to, 2-8

net service name, 2-9

nodes

selecting, 2-4

---

O

OCI

applications layered on, 4-1

connectivity and, 1-5

libraries, 4-1

OCI_CACHE mode, 4-2

OCI_NO_CACHE mode, 4-2

OCI_ATTR_NO_CACHE statement handle attribute, 4-3

OCI_CACHE value

mode parameter, 4-2

OCI_NO_CACHE value

mode parameter, 4-2

OCIAttrGet() function, 4-3

OCIAttrSet() function, 4-3

OCIEnvCreate() function

OCI_CACHE mode, 4-2

OCI_NO_CACHE mode, 4-2

ODBC applications, 1-7, 4-1

ORA_OCI_CACHE environment variable, 2-25, 4-2

ORACACHE user, 5-2

ORACACHE$n users, 5-3

Oracle Call Interface (OCI)

See OCI

Oracle Data Gatherer

starting, 5-3, 5-4

Oracle DBA Studio

See DBA Studio

Oracle TNS Listener

starting, 5-4

ORACLE_HOME environment variable, 2-26

ORACLE_SID environment variable, A-2

Oracle8i Cache

managing, 3-1

monitoring, 3-3

setting up, 2-1

starting, 5-3

stopping, 5-3

origin databases, 1-4

connecting to, 2-8, 2-9

packages created in, 5-3

users created on, 5-2

---

P

packages

created in origin database, 5-3

pausing caches, 3-1

performance

improving, 4-1

memory and, 3-6

monitoring, 3-5

Performance Monitor tab, 3-5

error, 5-4

PL/SQL statements, 1-7

port number, 2-9

modifying, 3-19

of Oracle8i Cache, 5-2

privileges

Cache Manager and, 2-10

processor time, 3-6

property sheets, 2-12

displaying, 2-22, 3-3

---

Q

queries

statistics, 3-3

types of, 1-5, 3-3

---

R

read/write transactions, 2-3

reconfiguring caches, 3-19

refreshing data, 2-4, 3-15, 3-16

Remove Tables Wizard, 3-8

removing tables from caches, 2-22, 3-6, 3-7, 3-8

replication

See synchronization policies

requests

types of, 1-7

resuming caching, 3-1

---

S

Scheduled synchronization policy, 2-5, 2-20

scheduling synchronization, 2-5, 2-20

schemas

adding to caches, 3-18

scripts

cachshut, 5-4

cachstrt, 5-4

selecting data to be cached, 2-2

selecting nodes

for cached data, 2-4

selecting tables, 2-16, 3-9

service name, 2-9

setting up caches, 2-1, 2-13

verifying, 2-22

shared libraries

OCI, 4-1

shutting down Oracle8i Cache, 5-4

SID, 2-9, A-2

single-threaded applications, 5-5

starting caches, 3-1

starting DBA Studio, 2-6

starting management engine, 5-3

starting Oracle Data Gatherer, 5-3

starting Oracle8i Cache, 5-3

starting TNS Listener, 5-3

statement handle attribute, 4-3

static libraries

OCI, 4-1

statistics

hit or miss, 3-3

memory, 3-6

memory usage, 3-6

processor time, 3-6

queries, 3-3

refreshing, 3-4

resetting, 3-5

stopping caches, 3-1

stopping Oracle8i Cache, 5-3

stopping TNS Listener, 5-4

synchronization policies, 2-4

Complete, 2-5, 2-18

Incremental, 2-5, 2-18

modifying, 2-6, 3-13, 3-14

not scheduled, 2-20

Scheduled, 2-5, 2-20

specifying, 2-17

verifying, 2-22

Synchronize Tables Wizard, 3-15, 3-16

synchronizing data, 2-5, 3-15, 3-16

considerations, 2-5

planning, 2-4

system identifier (SID), 2-9, A-2

---

T

tables

adding to caches, 2-22, 3-7, 3-8

copying, 2-24

removing from caches, 2-22, 3-7, 3-8

selecting, 2-16, 3-9

threads, 5-5

tiers

multiple, 1-2, 1-3

TNS Listener

starting, 5-3, 5-4

stopping, 5-4

tnsnames.ora file, 2-9

transactions

consistency, 2-3

rate per second, 3-6

troubleshooting, 5-1

starting software, 5-3

tuning hints

controlling use of caches, 4-2

linking applications, 4-1

memory, 3-6

selecting data to cache, 3-5

tuning Oracle8i Cache, 4-1

---

U

unknown status, 3-4

update statements, 1-7, 3-5, 3-6

updating user lists, 3-18

user interface, 1-5

username

for DBA Studio, 2-10

users

adding to caches, 3-18

dropping from caches, 3-18

updating attributes, 3-18

updating lists of, 3-18

users on origin database, 5-2

---

V

verifying allocated disk space, 2-23

verifying allocated memory, 2-23, 3-10

verifying setup, 2-22

vertical applications, 1-1

---

W

wizards

Add Tables, 2-13, 3-8

Remove Tables, 3-8

Synchronize Tables, 3-15, 3-16

wtacca command, 3-19

wtcme command, 5-1

wtcme.log file, 5-1, 5-2

wtcme.ora file, 5-1

WTCSINI package, 5-3

WTCSYS package, 5-3