Oracle Database Cache Concepts and Administration Guide
Release 1.0.2.1
Part Number A88706-01
Library
Solution Area
Contents
Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
A
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
B
benefits of Oracle Database Cache,
1-2
C
cache management
API for, 6-1
views for, A-1
Cache Manager,
1-5
description of, 2-7
invoking, 2-7
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
adding PL/SQL objects to, 2-21,
3-9,
3-10,
6-4
adding schemas to, 3-23,
6-29
adding tables to, 3-7,
3-8,
3-10,
6-6
disabling routing to, 3-1,
6-17,
6-20
duplicating, 2-25
enabling routing to, 2-24,
3-1,
6-17,
6-20
middle-tier, 1-4
pausing, 3-1,
6-20
removing PL/SQL objects from, 3-10,
3-11,
6-14
removing tables from, 3-7,
3-11,
6-15
resuming, 3-1
selecting, 2-4
setting up, 2-1,
2-13
starting, 3-1,
6-20
stopping, 3-1
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
D
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
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
listener, 5-4
logging, 5-1,
5-3
ORA-12541, 5-4
ORA-20001, 6-3
port number conflicts and, 5-4
returned by PL/SQL package, 6-3
single-threaded applications and, 5-10
event viewer,
5-1
F
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
G
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
H
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
I
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
J
JDBC applications,
1-7
,
4-1
L
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
entries, 5-7
port number, 5-4
log files
wtcme.log, 5-2
wtcme.ora, 5-1
logging error messages,
5-1
level of detail, 5-3
logging in to DBA Studio,
2-8
M
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
N
Navigator tree
adding databases to, 2-9
net service name,
2-10
nodes
selecting, 2-4
O
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
managing, 3-1
monitoring, 3-3
setting up, 2-1
starting, 5-8,
5-9
stopping, 5-8,
5-9
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
P
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
Q
queries
statistics, 3-3
types of, 1-5,
3-3
R
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
S
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
memory, 3-6
memory usage, 3-7
processor time, 3-7
queries, 3-3
refreshing, 3-5
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
T
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
multiple, 1-2,
1-3
TNS Listener
errors, 5-4
starting, 5-8,
5-10
stopping, 5-8
tnsnames.ora file,
2-10
entries, 5-5
port number, 5-4
transactions
consistency, 2-3
rate per second, 3-7
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
U
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
V
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
W
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
Copyright © 2001 Oracle Corporation.
All Rights Reserved.
Library
Solution Area
Contents