Index

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

A

active standby pair

active database, 6.2.1

create, 6.2.1

definition, 6.2

read-only subscriber database, 6.2.3

standby database, 6.2.2

aging policy

cache group, 4.5

LRU aging, 4.5.1

time-based aging, 4.5.2

asynchronous writethrough cache group, see AWT cache group

autocommit

global queries, 6.4, 6.4.1

autorefresh

cleanup

drop Oracle objects, 7.5

definition, 1.2.3

example, 2.5.2

initiate, 4.2.5, 5.2.4

interval, 4.2.5

mode, 4.2.5

state, 4.2.5

status, 7.4

autorefresh cache group

change log table, 7.4

definition, 3.2.1

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

AUTOREFRESH cache group attribute, 4.2.5

AWT cache group

create, 2.3.3, 4.2.2

definition, 1.2.2, 4.2.2

error reporting, 4.2.2.3, 4.2.2.5

monitoring, 7.2.3

parallel propagation, 4.2.2.2

restrictions, 4.2.2.4

awterrs file, 4.2.2.3, 4.2.2.5

B

BLOB data

caching in TimesTen, 4.4

built-in procedures

ttAgingLRUConfig, 4.5.1

ttAgingScheduleNow, 4.5.3

ttCacheAWTMonitorConfig, 7.2.3

ttCacheAWTThresholdSet, 7.2.4

ttCacheConfig, 7.4

AgentTimeout parameter, 7.4

TblSpaceFullRecovery parameter, 7.6.2

TblSpaceThreshold parameter, 7.6.1

ttCacheDbCgStatus, 7.4

ttCacheDDLTrackingConfig, 7.2.7, 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.3

C

cache

manage, 3.2.3, 3.2.4

manage through Oracle object, 3.2.4

performance evaluation, 9.1

cache administration user

create, 2.1.1, 3.2.1, 9.2.1

default tablespace

create, 2.1.1, 3.2.1, 9.2.1

drop, 2.7.6, 8.7, 9.6.1, 9.6.2

monitoring, 7.6

recover when full, 7.6.2

usage warning threshold, 7.6.1

definition, 2.1.1, 3.2.1

determine, 3.5

set in TimesTen database, 2.1.4, 3.3.4

Cache Advisor

configuration, 9.2

configure repository database, 9.2.2

configure target Oracle database, 9.2.1

configure TimesTen database, 9.2.3

executing, 9.4

identify target Oracle database, 9.4

overview, 9

post-processing clean up, 9.6

recommends cache group definitions, 9.1

supported configurations, 9.2.4

usage guidelines, 9.2.4

cache agent

connection failure, 7.1.1

reconnecting with Oracle Database, 10.1

start, 2.3.2, 3.6

start policy

and cache grid, 3.6.1

definition, 3.6.1

set, 3.6.1

status, 7.1, 7.1

stop, 2.7.5, 3.6, 8.5

timeout, 7.4

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

cache agent start policy, 7.7

create, 2.2, 3.4.2

data transfer, 4.7.1, 4.7.2

definition, 1.1, 3.4

destroy, 2.7.4, 8.4

detach

set of TimesTen databases, 8.1

TimesTen database, 2.7.1, 8.1

failure, 7.7

global query with local join, 6.4.1

instance owner, 4.7.1

location of data, 6.4.2

member

attach, 7.7

definition, 1.1, 3.4

detach all, 8.1

sharing data, 6.3

member failure, 3.6.1

node

definition, 1.1, 3.4

Oracle system parameters, 3.4.1

recovery, 7.7

ten or more nodes, 3.4.1

using ttRepStateGet, 7.7, 7.7

cache group

autorefresh

definition, 1.2.3, 3.2.1

create, 2.3

dead

recovery, 7.4

definition, 1.2, 4.1

dynamic load, 5.3

flush

definition, 1.2.3

load, 1.2.3

recommendations

Cache Advisor, 9.1

refresh, 1.2.3

table hierarchy, 4.1.2

table partition, 13.4.1.1

cache instance

definition, 1.2.1, 5.3

owner, 4.7.1

ownership, 4.7, 4.7.1

propagate

definition, 1.2.3

cache manager user

create, 2.1.3, 3.3.2, 9.2.3

defined, 3.3.2

definition, 2.1.3, 3.3.2

minimum privileges, 2.1.3, 3.3.3, 9.2.3

cache table

ON DELETE CASCADE attribute, 4.2.7

PROPAGATE attribute, 4.2.4.1

READONLY attribute, 4.2.4.2

UNIQUE HASH ON attribute, 4.2.8

user

create, 2.1.3, 3.3.2

defined, 3.3.2

definition, 2.1.3, 3.3.2

cacheAWTMethod first connection attribute, 5.8.2

CacheAwtParallelism data store attribute, 3.3.1, 4.2.2.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, 12.1

cachesqlget ttIsql command, 4.2.5.2, 7.2.7

character set

on Oracle, 9.2.3

child table

definition, 1.2, 4.1.2

CLOB data

caching in TimesTen, 4.4

CONNECT BY clause, 13.4.6

connection

between TimesTen and Oracle database, 3.5

failure

cache agent, 7.1.1

Oracle Database, 10.1

replication agent, 7.1.1

connection attributes

CacheGridEnable, 3.4.2

CacheGridMsgWait, 4.7.1, 4.7.2

DatabaseCharacterSet, 3.3.1

DynamicLoadEnable, 5.3.1

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

TypeMode, 3.3.1

UID, 3.3.1

CREATE ACTIVE STANDBY PAIR statement, 6.2.1

D

Data Guard, 11.1

data store attributes

CacheAwtParallelism, 3.3.1

ReplicationApplyOrdering, 3.3.1

data type

differences between Oracle and TimesTen, 13.4.4

mapping between Oracle and TimesTen, 13.5

mapping for key columns, 13.5

mapping for non-key columns, 13.5

database

character set, 9.2.3

duplicate, 6.2.2

temporary, 4.2

DatabaseCharacterSet connection attribute, 3.3.1

DDL statements

tracking, 7.2.7

DeadDbRecovery parameter, 7.4, 7.4

DROP ACTIVE STANDBY PAIR statement

example, 8.3

DROP CACHE GROUP statement

example, 2.7.3, 8.3

DSN

Cache Advisor

TimesTen database, 9.2.3

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

configuration, 5.3.1

definition, 4.7.1, 5.3

disable, 5.3.1

display errors, 5.3.4

examples, 2.6.1, 5.3.3

guidelines, 5.3.2

rules, 5.3.2

DynamicLoadEnable connection attribute, 5.3.1, 5.3.1

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

cache grid member, 7.7

Fast Application Notification (FAN), 10.1

FLUSH CACHE GROUP statement

definition, 5.4

example, 5.4

foreign key

index, 4.2.2.2

restriction, 4.2.2.2

G

global cache group

definition, 1.2.5, 4.7

dynamic load, 5.3

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

autocommit, 6.4, 6.4.1

local join, 6.4.1

global unload operation, 5.5.1

GlobalLocalJoin optimizer flag, 6.4.1

GlobalProcessing optimizer flag, 6.4

GlobalProcessing optimizer hint

unload operation, 5.5.1

grantCacheAdminPrivileges.sql script, 9.2.1, 9.2.1

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

grid

member

port, 4.7.4

grid, see cache grid

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

index

foreign key, 4.2.2.2

initCacheAdminSchema.sql SQL*Plus script, 3.2.4, 12.1

initCacheGlobalSchema.sql script, 9.2.1

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

initCacheGridSchema.sql SQL*Plus script, 3.2.4, 12.1

instance administrator, 2.1.3

L

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

materialized views

Oracle, 4.2.4, 13.4.1

Maximum Availability Architecture (MAA), 11.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

autorefresh

cleanup, 7.5

AWT errors, 4.2.2.5

create objects to manage cache, 3.2.3

database character set

determine, 3.3.1, 9.2.3

execution errors, 4.2.2.5

manually manage cache, 3.2.4

objects to manage cache

determine, 3.2.4

tables and triggers, 7.3

partitioned tables, 13.4.1.1

Oracle Database

connection failures, 10.1

differences from TimesTen, 13.1

Oracle Real Application Clusters (Oracle RAC), 10.1

Oracle schema users

create, 2.1.1, 3.2.1, 9.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, 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, 9.2.1, 9.2.2, 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

ownership

cache instance, 4.7, 4.7.1

P

parallel propagation

AWT cache groups, 4.2.2.2

foreign key

restriction, 4.2.2.2

partition, 13.4.1.1

PassThrough connection attribute, 3.3.1, 5.7

and RETURN TWOSAFE, 5.7

passthrough level

changing, 5.7.8

setting, 5.7

performance

Cache Advisor, 9.1

comparison between Oracle and TimesTen, 9.1

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

propagation

error reporting, 4.2.2.5

PWD connection attribute, 3.3.1

Q

query

cache grid, 6.4

global, 6.4

R

RACCallback connection attribute, 10.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

cache group, 1.2.3

initiate, 5.2.4

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

replication agent

connection failure, 7.1.1

start, 2.3.4, 4.2.2.1

start policy

definition, 4.2.2.1

set, 4.2.2.1

status, 7.1, 7.1

stop, 2.7.2, 4.2.2.1, 8.2, 8.2

ReplicationApplyOrdering data store attribute, 3.3.1, 4.2.2.2

ReplicationParallelism data store attribute, 4.2.2.2

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

single-table cache group, 4.1.1

sliding window

cache group, 4.5.4

SQL

differences between TimesTen and Oracle, 13.4

SQLRowCount() ODBC function, 5.6

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

sys.odbc.ini

Cache Advisor

example, 9.2.3

system managed cache groups, 4.2

T

tables

Oracle, 7.3

partition, 13.4.1.1

tablespace

create default, 2.1.1, 3.2.1, 9.2.1

drop default, 2.7.6, 8.7, 9.6.1, 9.6.2

full, 7.6.2

monitoring default, 7.6

recover when full, 7.6.2, 7.6.2

threshold, 7.6.1, 7.6.1

usage notification, 7.6.1

TblSpaceFullRecovery parameter, 7.6.2

time-based aging policy, 4.5.2

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

Transparent Application Failover (TAF), 10.1

triggers

Oracle, 7.3

tt_cache_admin_role role

definition, 3.2.1

drop, 8.7

TT_CACHE_ADMIN_ROLE role

definition, 2.1.1

drop, 2.7.6, 9.6.1, 9.6.1, 9.6.2, 9.6.2

ttAdmin utility

-cachePolicy command, 3.6.1

-cacheStart command, 3.6

-cacheStop command, 3.6

-cacheUidGet command, 3.5

-cacheUidPwdSet command, 3.3.4

-query command, 7.1

-repPolicy command, 4.2.2.1

-repStart command, 4.2.2.1

-repStop command, 4.2.2.1

ttAgingLRUConfig built-in procedure, 4.5.1

ttAgingScheduleNow built-in procedure, 4.5.3

ttCacheAdvisor utility

-oraConn option, 9.4

-oraDirObject option, 9.4

-oraTarget option, 9.4

usage, 9.4

ttCacheAutorefresh built-in procedure, 4.2.5, 5.2.4

ttCacheAWTMonitorConfig built-in procedure, 7.2.3

ttCacheAWTThresholdSet built-in procedure, 7.2.4

ttCacheConfig

usage notification, 7.6.1

ttCacheConfig built-in procedure

AgentTimeout parameter, 7.4

DeadDbRecovery parameter, 7.4

full tablespace, 7.6.2

TblSpaceFullRecovery parameter, 7.6.2

TblSpaceThreshold parameter, 7.6.1

ttCacheDbCgStatus built-in procedure, 7.4

ttCacheDDLTrackingConfig built-in procedure, 7.2.7, 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, 9.2.3

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

TTGRIDMEMBERID() SQL function, 6.4.2

ttGridNameSet built-in procedure, 2.2, 3.4.3

TTGRIDNODENAME() SQL function, 6.4.2

ttGridNodeStatus built-in procedure, 7.2.5

TTGRIDUSERASSIGNEDNAME() SQL function, 6.4.2

ttIsql set dynamicloadenable command, 5.3.1

ttIsql set dynamicloaderrormode command, 5.3.4

ttIsql utility, 2.1.3, 9.2.3

cachegroups command, 2.3.3, 7.2.1

cachesqlget command

INCREMENTAL AUTOREFRESH option, 4.2.5.2

ORACLE_DDL_TRACKING option, 7.2.7

set passthrough command, 5.7.8

ttOptSetFlag built-in procedure

DynamicLoadEnable flag, 5.3.1

DynamicLoadErrorMode flag, 5.3.4

PassThrough flag, 5.7.8

ttRepAdmin -duplicate utility, 6.2.2

-keepCG option, 6.2.2

-noKeepCG option, 6.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.3

ttStatus utility, 7.1

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

V

views

Oracle, 4.2.4, 13.4.1

W

WHERE clause, 4.2.6

referencing Oracle PL/SQL functions, 4.2.6.2