Oracle Database Cache Concepts and Administration Guide -- Index

Add Wizard, 2-13, 3-10

ADD_PLSQL_OBJECT procedure, 6-4

ADD_TABLE procedure, 6-6

adding databases

to Navigator tree, 2-9

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

adding PL/SQL objects to caches, 2-21, 3-9, 3-10, 6-4

adding schemas to caches, 3-23, 6-29

adding tables to caches, 2-23, 3-7, 3-8, 3-10, 6-6

adding users, 3-23, 6-29

anonymous blocks, 1-7

routing, 2-24

application environments

configuring, 2-26

applications

controlling which use caching, 4-2

layered on OCI, 1-7, 4-1

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

multithreaded, 5-10

single-threaded, 5-10

types of, 1-1

use with Oracle Database Cache, 1-1

attaching to databases, 2-9, 2-10

benefits of Oracle Database Cache, 1-2

cache management

Cache Manager, 1-5

managing Oracle Database Cache with, 3-1

troubleshooting, 5-8

user privileges, 2-10

cache name

modifying, 3-25

cache status

verifying, 2-25, 6-9

cached objects

retrieving from view, A-2

Cached PL/SQL tab, 3-9, 3-11

Cached Tables tab, 2-23, 3-13, 3-18

caches

caching

selecting data for, 2-2

selecting PL/SQL objects for, 2-7

cachshut script, 5-8

cachstrt script, 5-8

character set

of caches, 2-13

checking disk space, 2-23

checking memory allocation, 2-23

commands

wtacca, 3-25

wtcme, 5-1

Complete synchronization policy, 2-5, 2-18, 6-6, 6-23

components

Oracle Database Cache, 1-5

Configuration Assistant, 3-25

configuring application environments, 2-26

connecting to databases, 2-9, 2-10

content publishing applications, 1-1

copying caches, 2-25

copying PL/SQL objects, 2-25

copying tables, 2-25

credentials

setting for origin, 6-5, 6-18

data

refreshing, 2-5, 3-18, 3-19

synchronizing, 2-5, 3-18, 3-19, 6-28

considerations, 2-6

Data Gatherer

starting, 5-8, 5-9

data set, 1-5, 2-3

databases

adding to Navigator tree, 2-9

connecting to, 2-9, 2-10

origin, 1-4

DBA Studio, 1-5

invoking, 2-7

logging in to, 2-8

DBA_ICACHE_AGGREGATE_STATS view, A-1

DBA_ICACHE_OBJECTS view, A-2

DBA_ICACHE_QUERY_STATS view, A-4

DBMS_CACHE_MASTER package, 5-4

DBMS_CACHE_MASTER_UTL package, 5-4

DBMS_ICACHE package

procedures in, 6-1

DBMS_ICACHE.ADD_PLSQL_OBJECT procedure, 6-4

DBMS_ICACHE.ADD_TABLE procedure, 6-6

DBMS_ICACHE.GET_FLAG function, 3-3, 6-8

DBMS_ICACHE.GET_ROUTING_STATE function, 6-9

DBMS_ICACHE.GET_STATS_INTERVAL function, 6-10

DBMS_ICACHE.GET_STATS_RESET_TIME function, 6-11

DBMS_ICACHE.GET_TABLE_SIZE procedure, 6-13

DBMS_ICACHE.REMOVE_PLSQL_OBJECT procedure, 6-14

DBMS_ICACHE.REMOVE_TABLE procedure, 6-15

DBMS_ICACHE.RESET_STATS procedure, 6-16

DBMS_ICACHE.SET_FLAG procedure, 6-17

DBMS_ICACHE.SET_ORIGIN_CREDENTIALS procedure, 6-5, 6-18

DBMS_ICACHE.SET_ROUTING_STATE procedure, 6-20

DBMS_ICACHE.SET_STATS_INTERVAL procedure, 6-21

DBMS_ICACHE.SET_SYNC_METHOD procedure, 6-23

DBMS_ICACHE.SET_SYNC_SCHEDULE procedure, 6-25

DBMS_ICACHE.SYNC_PLSQL_OBJECT procedure, 6-27

DBMS_ICACHE.SYNC_TABLE procedure, 6-28

DBMS_ICACHE.SYNC_USERS procedure, 6-29

DBMSSIZE package, 5-4

debugging, 5-3

decreasing disk space, 3-14

decreasing memory allocation, 3-13

delete statements, 1-7, 3-6

deleting allocated disk space, 3-16

designing Oracle Database Cache environment, 2-2

selecting data, 2-2

selecting PL/SQL objects, 2-7

disabling routing of PL/SQL subprograms, 6-8, 6-17

disabling routing of queries, 3-1, 6-20

disk space

decreasing, 3-14

deleting files, 3-16

increasing, 2-13, 2-23, 3-14

verifying, 2-23

duplicating caches, 2-25

dynamic libraries

OCI, 4-1

e-business applications, 1-1

enabling routing

of PL/SQL, 2-24, 6-17

of queries, 2-24, 3-1, 6-20

environment

application

configuring, 2-26

controlling use of caches, 4-2

designing cache, 2-2

Oracle Database Cache, 1-3

troubleshooting problems in, 5-1

tuning, 4-1

environment variables

LD_LIBRARY_PATH, 2-27, B-2

ORA_OCI_CACHE, 2-26, 4-2

ORACLE_HOME, 2-27

ORACLE_SID, B-3

PATH, 2-27, B-2

error messages, B-1

Data Gatherer and, 5-9

port number conflicts and, 5-4

returned by PL/SQL package, 6-3

single-threaded applications and, 5-10

event viewer, 5-1

functions

caching, 2-21, 3-9, 3-10

DBMS_ICACHE.GET_FLAG, 3-3, 6-8

DBMS_ICACHE.GET_ROUTING_STATE, 6-9

DBMS_ICACHE.GET_STATS_INTERVAL, 6-10

DBMS_ICACHE.GET_STATS_RESET_TIME, 6-11

General tab, 2-25

dimmed, 2-12, 5-8

enabling caching, 3-1

GET_FLAG function, 3-3, 6-8

GET_ROUTING_STATE function, 6-9

GET_STATS_INTERVAL function, 6-10

GET_STATS_RESET_TIME function, 6-11

GET_TABLE_SIZE procedure, 6-13

hit or miss statistics, 3-3, A-1

resetting, 3-5

hit ratio, 3-6

Hit/Miss Count per Second chart, 3-7

Hit/Miss Percentages chart, 3-6

Hit/Miss Statistics tab, 3-3

hits, 1-5, 3-3

monitoring, 3-6, A-1

host name

modifying, 3-25

hostname, 2-10

improving performance, 4-1

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

increasing memory allocation, 3-13

Incremental synchronization policy, 2-5, 2-18, 6-6, 6-23

insert statements, 1-7, 3-6

interprocess communication (IPC) protocol, 5-10

invoking DBA Studio, 2-7

IPC protocol, 5-10

JDBC applications, 1-7, 4-1

language

character set of caches, 2-13

launching DBA Studio, 2-7

LD_LIBRARY_PATH environment variable, 2-27, B-2

libraries

OCI, 4-1

linking applications, 5-10

OCI, 4-1

listener

port number, 5-2

starting, 5-10

listener error, 5-4

listener.ora file

log files

logging error messages, 5-1

level of detail, 5-3

logging in to DBA Studio, 2-8

management engine

starting, 5-8

managing Oracle Database Cache, 3-1

memory allocation

modifying, 3-13

verifying, 2-23

memory usage, 3-7

ratio of hits, 3-6

messages

See error messages

middle-tier caches, 1-4

misses, 1-5, 3-3

monitoring, 3-6, A-1

modifying synchronization policies, 2-6, 3-16, 3-17

monitoring hits and misses, 3-6, A-1

monitoring Oracle Database Cache, 3-3

monitoring performance, 3-5

multiple-tier environments

Oracle Database Cache, 1-3

traditional, 1-2

multithreaded applications, 5-10

Navigator tree

adding databases to, 2-9

net service name, 2-10

nodes

selecting, 2-4

object size

getting, 6-13

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-26, 4-2

ORA-12541 error message, 5-4

ORA-20001 error message, 6-3

ORACACHE user, 5-3

ORACACHE$n users, 5-3

Oracle Call Interface (OCI)

See OCI

Oracle Data Gatherer

starting, 5-8, 5-9

Oracle Database Cache

Oracle Database Cache management engine

starting, 5-8, 5-9

Oracle DBA Studio

See DBA Studio

Oracle TNS Listener

starting, 5-10

ORACLE_HOME environment variable, 2-27

ORACLE_SID environment variable, B-3

origin databases, 1-4

connecting to, 2-9, 2-10

packages created in, 5-4

users created on, 5-3

packages

caching, 2-21, 3-9, 3-10

created in origin database, 5-4

for cache management, 6-1

PATH environment variables, 2-27, B-2

pausing caches, 3-1

pausing query routing on caches, 3-1, 6-20

performance

improving, 4-1

memory and, 3-6

monitoring, 3-5

Performance Monitor tab, 3-5

error, 5-9

PL/SQL objects

adding to caches, 2-21, 3-9, 3-10, 6-4

copying, 2-25

deciding which to cache, 2-7

removing from caches, 3-10, 3-11, 6-14

synchronizing, 3-21, 3-22, 6-27

PL/SQL packages

created in origin database, 5-4

for cache management, 6-1

PL/SQL subprograms, 1-7

disabling routing of, 6-8

enabling routing of, 2-24, 6-17

status of routing, 3-3, 6-8

port numbers

conflict with, 5-4

modifying, 3-25

of Oracle Database Cache, 5-2

of origin database, 2-10

privileges

Cache Manager and, 2-10

required

for PL/SQL procedures, 6-3

procedures

caching, 2-21, 3-9, 3-10

DBMS_ICACHE.ADD_PLSQL_OBJECT, 6-4

DBMS_ICACHE.ADD_TABLE, 6-6

DBMS_ICACHE.GET_TABLE_SIZE, 6-13

DBMS_ICACHE.REMOVE_PLSQL_OBJECT, 6-14

DBMS_ICACHE.REMOVE_TABLE, 6-15

DBMS_ICACHE.RESET_STATS, 6-16

DBMS_ICACHE.SET_FLAG, 6-17

DBMS_ICACHE.SET_ORIGIN_CREDENTIALS, 6-5, 6-18

DBMS_ICACHE.SET_ROUTING_STATE, 6-20

DBMS_ICACHE.SET_STATS_INTERVAL, 6-21

DBMS_ICACHE.SET_SYNC_METHOD, 6-23

DBMS_ICACHE.SET_SYNC_SCHEDULE, 6-25

DBMS_ICACHE.SYNC_PLSQL_OBJECT, 6-27

DBMS_ICACHE.SYNC_TABLE, 6-28

DBMS_ICACHE.SYNC_USERS, 6-29

processor time, 3-7

property sheets, 2-12

displaying, 2-22, 3-3

queries

statistics, 3-3

types of, 1-5, 3-3

read/write transactions, 2-3, 2-7

reconfiguring caches, 3-25

refreshing data, 2-5, 3-18, 3-19

Remove Wizard, 3-11

REMOVE_PLSQL_OBJECT procedure, 6-14

REMOVE_TABLE procedure, 6-15

removing PL/SQL objects from caches, 3-10, 3-11, 6-14

removing tables from caches, 2-23, 3-7, 3-9, 3-11, 6-15

replication

See synchronization policies

requests

types of, 1-7

RESET_STATS procedure, 6-16

resetting statistics, 3-5, 6-11, 6-16

resuming routing of queries, 3-1

routing PL/SQL subprograms to cache, 2-24, 3-1, 6-17

routing queries to cache, 2-24, 3-1, 6-20

Scheduled synchronization policy, 2-5, 2-20

scheduling synchronization, 2-5, 2-20, 6-25

schemas

adding to caches, 3-23, 6-29

scripts

cachshut, 5-8

cachstrt, 5-8

managing cache with, 6-1

security

setting credentials for origin, 6-5, 6-18

selecting data to be cached, 2-2

selecting nodes

for cached data, 2-4

selecting PL/SQL objects to be cached, 2-7

service name, 2-10

services

on Windows NT, 5-8, 5-9

SET_FLAG procedure, 6-17

SET_ORIGIN_CREDENTIALS procedure, 6-5, 6-18

SET_ROUTING_STATE procedure, 6-20

SET_STATS_INTERVAL procedure, 6-21

SET_SYNC_METHOD procedure, 6-23

SET_SYNC_SCHEDULE procedure, 6-25

setting up caches, 2-1, 2-13

verifying, 2-22

shared libraries

OCI, 4-1

shutting down Oracle Database Cache, 5-8

SID, 2-10, B-3

single-threaded applications, 5-10

size

of objects, 6-13

SQL*Plus

managing cache with, 6-1

starting caches, 3-1, 6-20

starting DBA Studio, 2-7

starting management engine, 5-8

starting Oracle Data Gatherer, 5-8, 5-9

starting Oracle Database Cache, 5-8, 5-9

starting Oracle Database Cache management engine, 5-8, 5-9

starting TNS Listener, 5-8

statement handle attribute, 4-3

static libraries

OCI, 4-1

statistics

enabling, 6-17

hit or miss, 3-3

interval, 3-5, 6-10, 6-21

resetting, 3-5, 6-11, 6-16

retrieving from view, A-1, A-4

status of, 6-8

stopping caches, 3-1

stopping Oracle Database Cache, 5-8, 5-9

stopping TNS Listener, 5-8

SYNC_PLSQL_OBJECT procedure, 6-27

SYNC_TABLE procedure, 6-28

SYNC_USERS procedure, 6-29

synchronization policies, 2-5

Complete, 2-5, 2-18, 6-6, 6-23

Incremental, 2-5, 2-18, 6-6, 6-23

modifying, 2-6, 3-16, 3-17, 6-23

modifying schedule, 6-25

not scheduled, 2-20

Scheduled, 2-5, 2-20

specifying, 2-17, 6-6

verifying, 2-23

Synchronize Wizard, 3-18, 3-19

synchronizing data, 2-6, 3-18, 3-19, 6-28

considerations, 2-6

planning, 2-5

synchronizing PL/SQL objects, 3-21, 3-22, 6-27

synchronizing tables, 2-6, 3-18, 3-19, 6-28

synchronizing users, 3-23, 6-29

system identifier (SID), 2-10, B-3

tables

adding to caches, 2-23, 3-8, 3-10, 6-6

copying, 2-25

removing from caches, 2-23, 3-9, 3-11, 6-15

synchronizing, 2-6, 3-18, 3-19, 6-28

threads, 5-10

tiers

TNS Listener

tnsnames.ora file, 2-10

transactions

troubleshooting, 5-1

starting software, 5-8

tuning hints

controlling use of caches, 4-2

linking applications, 4-1

memory, 3-6

selecting data to cache, 3-6

tuning Oracle Database Cache, 4-1

unknown status, 3-4

update statements, 1-7, 3-6

updating user lists, 3-23, 6-29

user interface, 1-5

username

for DBA Studio, 2-10

users

adding to caches, 3-23, 6-29

dropping from caches, 3-23, 6-29

synchronizing, 6-29

updating attributes, 3-23, 6-29

updating lists of, 3-23, 6-29

users on origin database, 5-3

verifying allocated disk space, 2-23

verifying allocated memory, 2-23, 3-13

verifying PL/SQL object caching, 6-5

verifying setup, 2-22

vertical applications, 1-1

viewing events, 5-1

views

DBA_ICACHE_AGGREGATE_STATS, A-1

DBA_ICACHE_OBJECTS, A-2

DBA_ICACHE_QUERY_STATS, A-4

supplied by Oracle Database Cache, A-1

Windows NT services, 5-8, 5-9

wizards

Add, 2-13, 3-10

Remove, 3-11

Synchronize, 3-18, 3-19

wtacca command, 3-25

wtcme command, 5-1

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

wtcme.ora file, 5-1

WTCSINI package, 5-4

WTCSYS package, 5-4