Index

A B C D E F G H I L M O P 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, 4.4

LRU aging, 4.4.1

time-based aging, 4.4.2

asynchronous writethrough (AWT) cache group

create, 2.3.3, 4.2.2

definition, 1.2.2, 4.2.2

monitor, 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

monitor, 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

automatically create Oracle objects to manage cache, 3.2.3

AUTOREFRESH cache group attribute, 4.2.5

B

built-in procedures

ttAgingLRUConfig, 4.4.1

ttAgingScheduleNow, 4.4.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.6

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, 4.6.2

ttGridCreate, 2.2, 3.4.1

ttGridDestroy, 2.7.4, 8.4

ttGridDetach, 2.7.1, 8.1

ttGridDetachList, 8.1

ttGridInfo, 7.2.5

ttGridNameSet, 2.2, 3.4.2

ttGridNodeStatus, 7.2.5

ttRepPolicySet, 4.2.2.1

ttRepStart, 2.3.4, 4.2.2.1

ttRepStateSet, 6.2.1

ttRepStop, 2.7.2, 4.2.2.1, 8.2

ttRepSubscriberWait, 7.2.6, 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

monitor, 7.6

recover when full, 7.6

usage warning threshold, 7.6

cache agent

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

definition, 3.6.1

set, 3.6.1

cache grid

associate TimesTen database, 2.2, 3.4.2

attach a TimesTen database, 2.4, 4.6.2

create, 2.2, 3.4.1

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

figure, 1.1

cache group

create, 2.3

definition, 1.2, 4.1

table hierarchy, 4.1.2

cache instance

definition, 1.2.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

defined, 3.3.2

cache table users

create, 2.1.3, 3.3.2

definition, 2.1.3, 3.3.2

cacheCleanUp.sql SQL*Plus script, 7.5, 12.1

CacheGridEnable DSN attribute, 3.4.1

CacheGridMsgWait DSN attribute, 4.6

cacheInfo.sql SQL*Plus script, 7.2.2, 12.1

child table

definition, 1.2, 4.1.2

connectivity between TimesTen and Oracle databases

test, 3.5

CREATE ACTIVE STANDBY PAIR statement, 6.2.1

D

Data Guard, 10.1

data type mapping

key columns, 11.5

non-key columns, 11.5

DatabaseCharacterSet DSN attribute, 3.3.1

DDL statements on cached Oracle tables

track, 7.2.6

DROP ACTIVE STANDBY PAIR statement, 8.3

DROP CACHE GROUP statement

example, 2.7.3, 8.3

DSN attributes

CacheGridEnable, 3.4.1

CacheGridMsgWait, 4.6

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

DSN for TimesTen database

example, 2.1.2, 3.3.1

dynamic cache group

create, 4.5

definition, 1.2.4, 4.5

dynamic load

definition, 5.3

disable, 5.3.3

display errors, 5.3.4

example, 2.6.1, 5.3.1

DynamicLoadEnable DSN attribute, 5.3.3

DynamicLoadErrorMode DSN 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

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

create, 4.6

definition, 1.2.5, 4.6

sharing data among grid members, 6.3

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

grid member

definition, 1.1, 3.4

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 (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 statement

definition, 5.2

example, 2.5.1, 5.2

PARALLEL clause, 5.2.4

WITH ID clause, 5.2.2

local cache group

definition, 1.2.5

LockLevel DSN attribute, 3.3.1

LRU aging policy, 4.4.1

M

manually create Oracle objects to manage cache, 3.2.4

Maximum Availability Architecture (MAA), 10.1

multiple-table cache group, 4.1.2

O

OCIAttrGet() OCI function

OCI_ATTR_ROW_COUNT option, 5.6

ON DELETE CASCADE cache table attribute, 4.2.7

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 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 DSN attribute, 3.3.1

OraclePWD DSN attribute, 3.3.1

P

PassThrough DSN attribute, 3.3.1, 5.7

PermSize DSN attribute, 3.3.1

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 DSN attribute, 3.3.1

R

RACCallback DSN 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

Real Application Clusters (RAC), 9.1

refresh a cache group

definition, 1.2.3

REFRESH CACHE GROUP statement

definition, 5.2

example, 5.2

PARALLEL clause, 5.2.4

WITH ID clause, 5.2.2

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

replication agent start policy

definition, 4.2.2.1

set, 4.2.2.1

root table

definition, 1.2, 4.1.2

S

single-table cache group, 4.1.1

sliding window, 4.4.4

SNMP traps, 7.2.2

SQLGetStmtOption() ODBC function

TT_STMT_PASSTHROUGH_TYPE option, 5.7.2

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

test TimesTen and Oracle database connectivity, 3.5

time-based aging policy, 4.4.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

Transparent Application Failover (TAF), 9.1

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.4.1

ttAgingScheduleNow built-in procedure, 4.4.3

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.6

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.6.2

ttGridCreate built-in procedure, 2.2, 3.4.1

ttGridDestroy built-in procedure, 2.7.4, 8.4

ttGridDetach built-in procedure, 2.7.1, 8.1

ttGridDetachList built-in procedure, 8.1

ttGridInfo built-in procedure, 7.2.5

ttGridNameSet built-in procedure, 2.2, 3.4.2

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.6

ttIsql set dynamicloadenable command, 5.3.3

ttIsql set dynamicloaderrormode command, 5.3.4

ttIsql set passthrough command, 5.7.1

ttIsql utility, 2.1.3

ttOptSetFlag built-in procedure

DynamicLoadEnable flag, 5.3.3

DynamicLoadErrorMode flag, 5.3.4

PassThrough flag, 5.7.1

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

ttRepStateSet built-in procedure, 6.2.1

ttRepStop built-in procedure, 2.7.2, 4.2.2.1, 8.2

ttRepSubscriberWait built-in procedure, 7.2.6, 8.1, 8.3

ttStatus utility, 7.1

ttTraceMon utility

AUTOREFRESH component, 7.2.2

TypeMode DSN attribute, 3.3.1

U

UID DSN attribute, 3.3.1

UNIQUE HASH ON cache table attribute, 4.2.8

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