Index

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

A

active standby pair

active master database, 6.2.1

create, 6.2.1

definition, 6.2

read-only subscriber database, 6.2.3

standby master database, 6.2.2

aging policy

cache group, 4.5

LRU aging, 4.5.1

time-based aging, 4.5.2

asynchronous writethrough (AWT) cache group

create, 2.3.3, 4.2.2

definition, 1.2.2, 4.2.2

monitoring, 7.2.3

restrictions, 4.2.2.3

automatic refresh

definition, 1.2.3

example, 2.5.2

automatic refresh cache group

change log table, 7.4

definition, 3.2.1

drop Oracle objects to manage cache, 7.5

load and refresh, 5.2.1

manually create Oracle objects, 4.2.5.2

monitoring, 7.2.2

recovery method, 7.4

status, 7.4

automatic refresh interval, 4.2.5

automatic refresh mode, 4.2.5

automatic refresh state, 4.2.5

autorefresh

using SNMP traps, 7.2.2

AUTOREFRESH cache group attribute, 4.2.5

autorefresh now, 4.2.5, 5.2.4

AWT cache group

definition, 4.2.2

monitoring, 7.2.3

B

BLOB data

caching in TimesTen, 4.4

built-in procedures

ttAgingLRUConfig, 4.5.1

ttAgingScheduleNow, 4.5.3

ttCacheAutorefreshStatsGet, 7.2.2

ttCacheAWTMonitorConfig, 7.2.3

ttCacheAWTThresholdSet, 7.2.4

ttCacheConfig built-in procedure with DeadDbRecovery parameter, 7.4

ttCacheConfig built-in procedure with TblSpaceFullRecovery parameter, 7.6

ttCacheConfig built-in procedure with TblSpaceThreshold parameter, 7.6

ttCacheConfig with AgentTimeout parameter, 7.4

ttCacheDbCgStatus, 7.4

ttCacheDDLTrackingConfig, 7.2.7

ttCachePolicySet, 3.6.1

ttCacheStart, 2.3.2, 3.6

ttCacheStop, 2.7.5, 3.6, 8.5

ttCacheUidGet, 3.5

ttCacheUidPwdSet, 2.1.4, 3.3.4

ttGridAttach, 2.4, 3.6.1, 4.7.4

ttGridCreate, 2.2, 3.4.2

ttGridDestroy, 2.7.4, 8.4

ttGridDetach, 2.7.1, 8.1

ttGridDetachList, 8.1

ttGridInfo, 7.2.5

ttGridNameSet, 2.2, 3.4.3

ttGridNodeStatus, 7.2.5

ttRepPolicySet, 4.2.2.1

ttRepStart, 2.3.4, 4.2.2.1

ttRepStateGet, 7.7

ttRepStateSet, 6.2.1

ttRepStop, 2.7.2, 4.2.2.1, 8.2, 8.2

ttRepSubscriberWait, 7.2.7, 8.1, 8.3

C

cache administration user

create, 2.1.1, 3.2.1

definition, 2.1.1, 3.2.1

determine, 3.5

set in TimesTen database, 2.1.4, 3.3.4

cache administration user default tablespace

create, 2.1.1, 3.2.1

drop, 2.7.6, 8.7

monitoring, 7.6

recover when full, 7.6

usage warning threshold, 7.6

cache agent

reconnecting with Oracle Database, 9.1

start, 2.3.2, 3.6

status, 7.1, 7.1

stop, 2.7.5, 3.6, 8.5

timeout, 7.4

cache agent start policy

and cache grid, 3.6.1

definition, 3.6.1

set, 3.6.1

cache grid

associate TimesTen database, 2.2, 3.4.3

attach a TimesTen database, 2.4, 4.7.4

cache agent start policy, 3.6.1, 3.6.1

create, 2.2, 3.4.2

definition, 1.1, 3.4

destroy, 2.7.4, 8.4

detach a set of TimesTen databases, 8.1

detach a TimesTen database, 2.7.1, 8.1

instance owner, 4.7.1

member failure, 3.6.1

Oracle system parameters, 3.4.1

ten or more nodes, 3.4.1

using ttRepStateGet, 7.7

cache group

create, 2.3

definition, 1.2, 4.1

table hierarchy, 4.1.2

cache instance

definition, 1.2.1

owner, 4.7.1

cache manager user

create, 2.1.3, 3.3.2

defined, 3.3.2

definition, 2.1.3, 3.3.2

minimum privileges, 2.1.3, 3.3.3

cache table attributes

ON DELETE CASCADE, 4.2.7

PROPAGATE, 4.2.4.1

READONLY, 4.2.4.2

UNIQUE HASH ON, 4.2.8

cache table user

create, 2.1.3

defined, 3.3.2

cache table users

create, 3.3.2

definition, 2.1.3, 3.3.2

cacheCleanUp.sql SQL*Plus script, 7.5, 12.1

CacheGridEnable connection attribute, 3.4.2

CacheGridMsgWait connection attribute, 4.7.1, 4.7.2

cachegroups

ttIsql command, 2.3.3, 7.2.1

cacheInfo.sql SQL*Plus script, 7.2.2, 12.1

cachesqlget

ttIsql command, 4.2.5.2, 7.2.7

child table

definition, 1.2, 4.1.2

CLOB data

caching in TimesTen, 4.4

connection attributes

CacheGridEnable, 3.4.2

CacheGridMsgWait, 4.7.1, 4.7.2

DatabaseCharacterSet, 3.3.1

DynamicLoadEnable, 5.3.3

DynamicLoadErrorMode, 5.3.4

LockLevel, 3.3.1

OracleNetServiceName, 3.3.1

OraclePWD, 3.3.1

PassThrough, 3.3.1, 5.7

PermSize, 3.3.1

PWD, 3.3.1

RACCallback, 9.3

TypeMode, 3.3.1

UID, 3.3.1

connection failures

Oracle Database, 9.1

connectivity between TimesTen and Oracle databases

test, 3.5

CREATE ACTIVE STANDBY PAIR statement, 6.2.1

create Oracle objects to manage cache

automatic, 3.2.3

manual, 3.2.4

D

Data Guard, 10.1

data type mapping

key columns, 11.5

non-key columns, 11.5

data type support

differences between Oracle and TimesTen, 11.4.3

data types

mapping between Oracle and TimesTen, 11.5

DatabaseCharacterSet connection attribute, 3.3.1

DDL statements on cached Oracle tables

tracking, 7.2.7

detaching all grid members, 8.1

DROP ACTIVE STANDBY PAIR statement

example, 8.3

DROP CACHE GROUP statement

example, 2.7.3, 8.3

drop Oracle objects, 8.7

drop Oracle users, 8.7

DSN for TimesTen database

example, 2.1.2, 3.3.1

duplicating a database, 6.2.2

dynamic cache group

create, 4.6

definition, 1.2.4, 4.6

dynamic global cache group

dynamic load, 4.7.1

dynamic load

definition, 4.7.1, 5.3

disable, 5.3.3

display errors, 5.3.4

example, 2.6.1, 5.3.1

DynamicLoadEnable connection attribute, 5.3.3

DynamicLoadErrorMode connection attribute, 5.3.4

E

environment variables

Microsoft Windows, 3.1.2

UNIX, 3.1.1

explicitly loaded cache group

definition, 1.2.4

F

failure

grid member, 7.7

Fast Application Notification (FAN), 9.1

flush a cache group

definition, 1.2.3

FLUSH CACHE GROUP statement

definition, 5.4

example, 5.4

G

global cache group

definition, 1.2.5, 4.7

example, dynamic, 4.7.1

example, explicitly loaded, 4.7.2

explicitly loaded, 4.7.2

sharing data among grid members, 6.3

global cache groups

dynamic, 4.7.1

ownership changes, 7.2.6

global query, 6.4

global unload operation, 5.5.1

GlobalProcessing optimizer hint

query, 6.4

unload operation, 5.5.1

grantCacheAdminPrivileges.sql SQL*Plus script, 2.1.1, 3.2.3, 12.1

grid

attaching a member, 7.7

cache agent start policy, 7.7

failure, 7.7

recovery, 7.7

using ttRepStateGet, 7.7

grid data transfer, 4.7.1, 4.7.2

grid member

definition, 1.1, 3.4

grid members

detaching all, 8.1

grid node

definition, 1.1, 3.4

H

high availability

active standby pair, 1.3

cache grid, 1.3

Data Guard, 1.3

Oracle Real Application Clusters (Oracle RAC), 1.3

I

initCacheAdminSchema.sql SQL*Plus script, 3.2.4, 12.1

initCacheGlobalSchema.sql SQL*Plus script, 2.1.1, 3.2.1, 12.1

initCacheGridSchema.sql SQL*Plus script, 3.2.4, 12.1

instance administrator, 2.1.3

L

load a cache group

definition, 1.2.3

LOAD CACHE GROUP

example, 5.2.8

LOAD CACHE GROUP statement

definition, 5.2

example, 2.5.1, 5.2

PARALLEL clause, 5.2.6

WITH ID clause, 5.2.3

LOB data

cache administration user privileges, 3.2.2

caching in TimesTen, 4.4

restrictions on caching, 4.4

local cache group

definition, 1.2.5

LockLevel connection attribute, 3.3.1

LRU aging policy, 4.5.1

M

Maximum Availability Architecture (MAA), 10.1

multiple-table cache group, 4.1.2

N

NCLOB data

caching in TimesTen, 4.4

O

OCIAttrGet() OCI function

OCI_ATTR_ROW_COUNT option, 5.6

ON DELETE CASCADE cache table attribute, 4.2.7

Oracle Database

connection failures, 9.1

differences from TimesTen, 11.1

Oracle database character set

determine, 3.3.1

Oracle objects to manage cache

automatically create, 3.2.3

determine, 3.2.4

manually create, 3.2.4

tables and triggers, 7.3

Oracle Real Application Clusters (Oracle RAC), 9.1

Oracle schema users

create, 2.1.1, 3.2.1

definition, 2.1.1, 3.2.1

Oracle Server releases

supported, 3.1

Oracle SQL*Plus scripts

cacheCleanUp.sql, 7.5, 12.1

cacheInfo.sql, 7.2.2, 12.1

grantCacheAdminPrivileges.sql, 2.1.1, 3.2.3, 12.1

initCacheAdminSchema.sql, 3.2.4, 12.1

initCacheGlobalSchema.sql, 2.1.1, 3.2.1, 12.1

initCacheGridSchema.sql, 3.2.4, 12.1

Oracle synonyms

cache, 4.3

Oracle timesten user

definition, 2.1.1

Oracle users

cache administration user, 2.1.1

drop, 2.7.6, 8.7

privileges, 3.2.2

schema users, 2.1.1

timesten user, 2.1.1, 3.2.1

OracleNetServiceName connection attribute, 3.3.1

OraclePWD connection attribute, 3.3.1

owner

cache instance, 4.7.1

P

PassThrough connection attribute, 3.3.1, 5.7

and RETURN TWOSAFE, 5.7

passthrough level

changing, 5.7.8

setting, 5.7

PermSize connection attribute, 3.3.1

port

cache grid member, 4.7.4

privileges

Oracle users, 3.2.2

propagate

example, 2.6.2

propagate cache instances

definition, 1.2.3

PROPAGATE cache table attribute, 4.2.4.1

PWD connection attribute, 3.3.1

Q

query

cache grid, 6.4

global, 6.4

R

RACCallback connection attribute, 9.3

read-only cache group

create, 2.3.3, 4.2.1

definition, 1.2.2, 4.2.1

restrictions, 4.2.1.1

READONLY cache table attribute, 4.2.4.2

refresh a cache group

definition, 1.2.3

REFRESH CACHE GROUP

example, 5.2.8

REFRESH CACHE GROUP statement

definition, 5.2

example, 5.2

PARALLEL clause, 5.2.6

WITH ID clause, 5.2.3

refresh now, 4.2.5, 5.2.4

replication agent

start, 2.3.4, 4.2.2.1

status, 7.1, 7.1

stop, 2.7.2, 4.2.2.1, 8.2, 8.2

replication agent start policy

definition, 4.2.2.1

set, 4.2.2.1

root table

definition, 1.2, 4.1.2

S

scripts

IMDB Cache, 12

SQL*Plus, 12

SELECT statement

cache grid, 6.4

global, 6.4

semantics

differences between Oracle and TimesTen, 11.2

single-table cache group, 4.1.1

sliding window

cache group, 4.5.4

SNMP traps

monitoring autorefresh, 7.2.2

SQL

differences between TimesTen and Oracle, 11.4

SQLRowCount() ODBC function, 5.6

SQLSetConnectOption() ODBC function

TT_DYNAMIC_LOAD_ENABLE option, 5.3.3

TT_DYNAMIC_LOAD_ERROR_MODE option, 5.3.4

Statement.getUpdateCount() JDBC method, 5.6

synchronous writethrough (SWT) cache group

create, 4.2.3

definition, 1.2.2, 4.2.3

restrictions, 4.2.3.1

system managed cache groups, 4.2

T

tables

Oracle, 7.3

test TimesTen and Oracle database connectivity, 3.5

time-based aging policy, 4.5.2

TimesTen database

automatic refresh status, 7.4

TimesTen users

cache manager user, 2.1.3, 3.3.2

cache table users, 2.1.3, 3.3.2

transaction log file threshold for AWT cache groups

set, 7.2.4

transaction semantics

differences between Oracle and TimesTen, 11.2

Transparent Application Failover (TAF), 9.1

triggers

Oracle, 7.3

TT_CACHE_ADMIN_ROLE role

definition, 2.1.1

tt_cache_admin_role role

definition, 3.2.1

drop, 2.7.6, 8.7

ttAdmin -cachePolicy utility command, 3.6.1

ttAdmin -cacheStart utility command, 3.6

ttAdmin -cacheStop utility command, 3.6

ttAdmin -cacheUidGet utility command, 3.5

ttAdmin -cacheUidPwdSet utility command, 3.3.4

ttAdmin -query utility command, 7.1

ttAdmin -repPolicy utility command, 4.2.2.1

ttAdmin -repStart utility command, 4.2.2.1

ttAdmin -repStop utility command, 4.2.2.1

ttAgingLRUConfig built-in procedure, 4.5.1

ttAgingScheduleNow built-in procedure, 4.5.3

ttCacheAutorefresh built-in procedure, 4.2.5, 5.2.4

ttCacheAutorefreshStatsGet built-in procedure, 7.2.2

ttCacheAWTMonitorConfig built-in procedure, 7.2.3

ttCacheAWTThresholdSet built-in procedure, 7.2.4

ttCacheConfig built-in procedure

AgentTimeout parameter, 7.4

DeadDbRecovery parameter, 7.4

TblSpaceFullRecovery parameter, 7.6

TblSpaceThreshold parameter, 7.6

ttCacheDbCgStatus built-in procedure, 7.4

ttCacheDDLTrackingConfig built-in procedure, 7.2.7

ttCachePolicySet built-in procedure, 3.6.1

ttCacheStart built-in procedure, 2.3.2, 3.6

ttCacheStop built-in procedure, 2.7.5, 3.6, 8.5

ttCacheUidGet built-in procedure, 3.5

ttCacheUidPwdSet built-in procedure, 2.1.4, 3.3.4

ttDaemonLog utility

automatic refresh support log messages, 7.2.2

ttDestroy utility, 8.6

ttGridAttach built-in procedure, 2.4, 4.7.4, 7.7

calling after database failure, 3.6.1

ttGridCreate built-in procedure, 2.2, 3.4.2

ttGridDestroy built-in procedure, 2.7.4, 8.4

ttGridDetach built-in procedure, 2.7.1, 8.1

ttGridDetachAll built-in procedure, 8.1

ttGridDetachList built-in procedure, 8.1

ttGridGlobalCGResume built-in procedure, 7.2.6

ttGridGlobalCGSuspend built-in procedure, 7.2.6

ttGridInfo built-in procedure, 7.2.5

ttGridNameSet built-in procedure, 2.2, 3.4.3

ttGridNodeStatus built-in procedure, 7.2.5

ttIsql cachegroups command, 2.3.3, 7.2.1

ttIsql cachesqlget command

INCREMENTAL AUTOREFRESH option, 4.2.5.2

ORACLE_DDL_TRACKING option, 7.2.7

ttIsql set dynamicloadenable command, 5.3.3

ttIsql set dynamicloaderrormode command, 5.3.4

ttIsql set passthrough command, 5.7.8

ttIsql utility, 2.1.3

ttOptSetFlag built-in procedure

DynamicLoadEnable flag, 5.3.3

DynamicLoadErrorMode flag, 5.3.4

PassThrough flag, 5.7.8

ttRepAdmin -duplicate utility, 6.2.2

ttRepAdmin -duplicate utility command

-keepCG option, 6.2.2

-noKeepCG option, 6.2.3

ttRepAdmin -receiver -list utility command, 7.2.3

ttRepAdmin -showstatus -awtmoninfo utility command, 7.2.3

ttRepPolicySet built-in procedure, 4.2.2.1

ttRepStart built-in procedure, 2.3.4, 4.2.2.1

ttRepStateGet built-in procedure, 7.7

ttRepStateSet built-in procedure, 6.2.1

ttRepStop built-in procedure, 2.7.2, 4.2.2.1, 8.2, 8.2

ttRepSubscriberWait built-in procedure, 7.2.7, 8.1, 8.3

ttStatus utility, 7.1

ttTraceMon utility

AUTOREFRESH component, 7.2.2

TypeMode connection attribute, 3.3.1

U

UID connection attribute, 3.3.1

UNIQUE HASH ON cache table attribute, 4.2.8

unload cache group

global, 5.5.1

UNLOAD CACHE GROUP statement

definition, 5.5

example, 5.5

user managed cache group

bidirectional transmit, 4.2.4

create, 4.2.4, 4.2.4

definition, 1.2.2, 4.2.4

W

WHERE clause, 4.2.6

referencing Oracle PL/SQL functions, 4.2.6.2