Oracle Database Cache Concepts and Administration Guide Release 1.0.2.1 Part Number A88706-01 |
Library | Service | 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 | Service | Contents