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

AgentFailoverTimeout parameter, 11.3

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 Database objects, 7.5

definition, 1.2.3

example, 2.5.2

incremental

avoid transactional inconsistency, 8.3.1.2

initiate, 4.2.5, 5.2.4

interval, 4.2.5

mode, 4.2.5

select limit, 8.3.2

state, 4.2.5

statistics, 8.5

status, 7.4

autorefresh cache group

change log table, 7.4

defragment, 7.6.1

definition, 3.2.1

load and refresh, 5.2.1

manually create Oracle Database objects, 4.2.5.2

monitoring, 7.2.2

read-only

performance, 8.3.1, 8.3.2

recovery method, 7.4

status, 7.4

transaction reclaim performance, 8.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, 8.2.1

batch size, 4.2.2.2.3

restrictions, 4.2.2.4

awterrs file, 4.2.2.3, 4.2.2.5

DTD for XML format, 4.2.2.5

XML format, 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

AutoRefreshLogTblSpaceUsagePCT parameter, 7.6.2

TblSpaceFullRecovery parameter, 7.6.3

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, 9.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.2

ttGridDestroy, 2.7.4, 9.4

ttGridDetach, 2.7.1, 9.1

ttGridDetachList, 9.1

ttGridInfo, 7.2.5

ttGridNameSet, 2.2, 3.4.2.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, 9.2, 9.2

ttRepSubscriberWait, 7.2.7, 9.3

C

cache

manage, 3.2.3, 3.2.4

manage through Oracle Database object, 3.2.4

performance evaluation, 10.1

cache administration user

caching table on more than one TimesTen database, 8.6

create, 2.1.1, 3.2.1, 10.2.1

default tablespace

create, 2.1.1, 3.2.1, 10.2.1

drop, 2.7.6, 9.7, 10.6.1, 10.6.2

monitoring, 7.6

recover when full, 7.6.3

usage warning threshold, 7.6.2

definition, 2.1.1, 3.2.1

determine, 3.5

set in TimesTen database, 2.1.4, 3.3.4

Cache Advisor

configuration, 10.2

configure repository database, 10.2.2

configure target Oracle database, 10.2.1

configure TimesTen database, 10.2.3

DataPump, 10.4.1

executing, 10.4

-export option, 10.4.1

-ftp option, 10.4.1

identify target Oracle database, 10.4

-import option, 10.4.1

-OraDirNfs option, 10.4.1

overview, 10

performance option, 10.4.1

post-processing clean up, 10.6

recommends cache group definitions, 10.1

repository setup script, 10.2.2

supported configurations, 10.2.4

target

setup script, 10.2.1

usage guidelines, 10.2.4

cache agent

connection failure, 7.1.1

reconnecting with Oracle Database, 11.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, 9.5

timeout, 7.4

cache grid

associate TimesTen database, 2.2, 3.4.2.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.2

data transfer, 4.7.1, 4.7.2

definition, 1.1, 1.1.1, 3.4, 3.4.2

destroy, 2.7.4, 9.4

detach

set of TimesTen databases, 9.1

TimesTen database, 2.7.1, 9.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.1, 3.4.2

detach all, 9.1

port, 4.7.4

sharing data, 6.3

member failure, 3.6.1

node

definition, 1.1.1, 3.4.2

Oracle Database system parameters, 3.4.2.1

recovery, 7.7

ten or more nodes, 3.4.2.1

using ttRepStateGet, 7.7, 7.7

cache group

autorefresh

definition, 1.2.3, 3.2.1

large transactions, 8.3.1

transaction reclaim performance, 8.4

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

read-only

autorefresh, 8.3.2

improving autorefresh, 8.3.1, 8.3.2

recommendations

Cache Advisor, 10.1

refresh, 1.2.3

table hierarchy, 4.1.2

table partition, C.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, 10.2.3

defined, 3.3.2

definition, 2.1.3, 2.1.3, 3.3.2

minimum privileges, 2.1.3, 3.3.3, 10.2.3

cache table

caching on more than one TimesTen database, 8.6

ON DELETE CASCADE attribute, 4.2.7

PROPAGATE attribute, 4.2.4.2

READONLY attribute, 4.2.4.1

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

CacheAWTParallelism data store attribute, 3.3.1, 4.2.2.2

cacheCleanUp.sql SQL*Plus script, 7.5, B.1

CacheGridEnable connection attribute, 3.3.1, 3.4.1, 3.4.2.2

CacheGridMsgWait connection attribute, 4.7.1, 4.7.2

cachegroups ttIsql command, 2.3.3, 7.2.1

cacheInfo.sql SQL*Plus script, B.1

CacheParAwtBatchSize parameter, 4.2.2.2.3

cachesqlget ttIsql command, 4.2.5.2, 7.2.7

change log tables

defragment, 7.6.1

character set

on Oracle Database, 10.2.3

child table

definition, 1.2, 4.1.2

CLOB data

caching in TimesTen, 4.4

CONNECT BY clause, C.4.6

connection

between TimesTen and Oracle database, 3.5

failure

cache agent, 7.1.1

Oracle Database, 11.1

replication agent, 7.1.1

connection attributes

CacheGridEnable, 3.4.1, 3.4.2.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, 11.3

TypeMode, 3.3.1

UID, 3.3.1

CREATE ACTIVE STANDBY PAIR statement, 6.2.1

D

Data Guard, 12.1

data store attributes

CacheAWTParallelism, 3.3.1

ReplicationApplyOrdering, 3.3.1

data type

differences between Oracle Database and TimesTen, C.4.4

mapping between Oracle Database and TimesTen, C.5

mapping for key columns, C.5

mapping for non-key columns, C.5

database

character set, 10.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, 9.3

DROP CACHE GROUP statement

example, 2.7.3, 9.3

DSN

Cache Advisor

TimesTen database, 10.2.3

TimesTen database

example, 2.1.2

DSN for TimesTen database

example, 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), 11.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, 4.7.1

dynamic load, 5.3

example, dynamic, 4.7.1

example, explicitly loaded, 4.7.2

explicitly loaded, 4.7.2

ownership changes, 7.2.6

sharing data among grid members, 6.3

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

grantCacheAdminPrivileges.sql SQL*Plus script, 2.1.1, 3.2.3, B.1

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, B.1

initCacheGlobalSchema.sql script, 10.2.1

initCacheGlobalSchema.sql SQL*Plus script, 2.1.1, 3.2.1, 10.2.1, 10.2.2, B.1

initCacheGridSchema.sql SQL*Plus script, 3.2.4, B.1

instance administrator, 2.1.3

L

LOAD CACHE GROUP statement

definition, 5.2

example, 2.5.1, 5.2, 5.2.8

PARALLEL clause, 5.2.6

WITH ID clause, 5.2.3

LOB data

cache administration user privileges, A.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 Database, 4.2.4, C.4.1

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

autorefresh

cleanup, 7.5

AWT errors, 4.2.2.5

character set

determine, 3.3.1

connection failures, 11.1

create objects to manage cache, 3.2.3

database character set

determine, 10.2.3

differences from TimesTen, C.1

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, C.4.1.1

schema users

create, 2.1.1, 3.2.1, 10.2.1

definition, 3.2.1

Server releases

supported, 3.1

synonyms

cache, 4.3

user

cache administration user, 2.1.1

definition, 2.1.1

drop, 2.7.6, 9.7

privileges, 3.2.2, A.2

schema users, 2.1.1

users

timesten user, 3.2.1

Oracle RAC

using TimesTen Cache, 11.3

using TimesTen Cache in, 11.1

Oracle Real Application Clusters (Oracle RAC)

Oracle SQL*Plus scripts

cacheCleanUp.sql, 7.5, B.1

cacheInfo.sql, B.1

grantCacheAdminPrivileges.sql, 2.1.1, 3.2.3, B.1

initCacheAdminSchema.sql, 3.2.4, B.1

initCacheGlobalSchema.sql, 2.1.1, 3.2.1, 10.2.1, 10.2.2, B.1

initCacheGridSchema.sql, 3.2.4, B.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 group, 4.2.2.2, 8.2.1

foreign key

restriction, 4.2.2.2

restriction, 4.2.2.2.1

partition, C.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, 10.1

comparison between Oracle Database and TimesTen, 10.1

read-only cache group

incremental autorefresh, 8.3.2

large transactions, 8.3.1

transaction reclaim, 8.4

PermSize connection attribute, 3.3.1

port

cache grid member, 4.7.4

privileges

Oracle Database users, 3.2.2, A.2

propagate

cache instances

definition, 1.2.3

error reporting, 4.2.2.5

example, 2.6.2

parallel, 4.2.2.2, 8.2.1

PROPAGATE cache table attribute, 4.2.4.2

PWD connection attribute, 3.3.1

Q

query

cache grid, 6.4

global, 6.4

R

RACCallback connection attribute, 11.3

read-only cache group

autorefresh

performance, 8.3.1, 8.3.2

create, 2.3.3, 4.2.1

definition, 1.2.2, 4.2.1

incremental autorefresh

statistics, 8.5

large transactions, 8.3.1

restrictions, 4.2.1.1

READONLY cache table attribute, 4.2.4.1

refresh

autorefresh, 4.2.5

cache group, 1.2.3

initiate, 5.2.4

REFRESH CACHE GROUP statement

definition, 5.2

example, 5.2, 5.2.8

PARALLEL clause, 5.2.6

WITH ID clause, 5.2.3

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, 9.2, 9.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

schema users

create, 2.1.1

definition, 2.1.1

scripts

SQL*Plus, B

TimesTen Cache, B

select limit, 8.3.2

SELECT statement

cache grid, 6.4

global, 6.4

semantics

differences between Oracle Database and TimesTen, C.2

single-table cache group, 4.1.1

sliding window

cache group, 4.5.4

SQL

differences between TimesTen and Oracle, C.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, 10.2.3

system managed cache groups, 4.2

T

tables

caching on more than one TimesTen database, 8.6

Oracle Database, 7.3

partition, C.4.1.1

tablespace

create default, 2.1.1, 3.2.1, 10.2.1

defragmentation, 7.6.1

drop default, 2.7.6, 9.7, 10.6.1, 10.6.2

full, 7.6.3

monitoring default, 7.6

recover when full, 7.6.3, 7.6.3

threshold, 7.6.2, 7.6.2

usage notification, 7.6.2

utilization, 7.6.1

TAF

overview, 11.1

timeout, 11.3

TblSpaceFullRecovery parameter, 7.6.3

time-based aging policy, 4.5.2

TimesTen users

cache manager user, 2.1.3, 2.1.3, 3.3.2

cache table users, 2.1.3, 3.3.2

transaction

incremental autorefresh

performance, 8.3.1

large

incremental commit, 8.3.1

performance, 8.3.1

reclaim operations

performance, 8.4, 8.4

semantics

differences between Oracle Database and TimesTen, C.2

transaction log file threshold for AWT cache groups

set, 7.2.4

Transparent Application Failover (TAF), see TAF

triggers

Oracle Database, 7.3

TT_CACHE_ADMIN_ROLE role

definition, 2.1.1, 3.2.1

drop, 2.7.6, 9.7, 10.6.1, 10.6.1

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

ttca_setupRepostory script, 10.2.2

ttCacheAdvisor utility

-oraConn option, 10.4

-oraDirObject option, 10.4

-oraTarget option, 10.4

usage, 10.4

ttCacheAutorefIntervalStatsGet built-in procedure, 8.5

ttCacheAutorefresh built-in procedure, 4.2.5, 5.2.4

ttCacheAutoRefreshLogDefrag built-in procedure

defragment tablespace, 7.6.1.1

ttCacheAutorefreshSelectLimit built-in procedure, 8.3.2

ttCacheAutorefreshStatsGet built-in procedure

tablespace

utilization, 7.6.1

ttCacheAutorefreshXactLimit built-in procedure, 8.3.1

ttCacheAWTMonitorConfig built-in procedure, 7.2.3

ttCacheAWTThresholdSet built-in procedure, 7.2.4

ttCacheConfig

usage notification, 7.6.2

ttCacheConfig built-in procedure

AgentFailoverTimeout parameter, 11.3

AgentTimeout parameter, 7.4

AutoRefreshLogTblSpaceUsagePCT parameter, 7.6.2

AwtErrrorXmlOutput, 4.2.2.5

DeadDbRecovery parameter, 7.4

defragment tablespace, 7.6.1

full tablespace, 7.6.3

TblSpaceFullRecovery parameter, 7.6.3

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

ttCacheUidGet built-in procedure, 3.5

ttCacheUidPwdSet built-in procedure, 2.1.4, 3.3.4, 10.2.3

ttDBConfig, 4.2.2.2.3

ttDbConfig built-in procedure, 8.4

ttDestroy utility, 9.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.2

ttGridDestroy built-in procedure, 2.7.4, 9.4

ttGridDetach built-in procedure, 2.7.1, 9.1

ttGridDetachAll built-in procedure, 9.1

ttGridDetachList built-in procedure, 9.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.2.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, 10.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, 9.2, 9.2

ttRepSubscriberWait built-in procedure, 7.2.7, 9.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

create, 2.1.1

definition, 2.1.1

Oracle Database

create, 10.2.1

drop, 9.7

user managed cache group

bidirectional transmit, 4.2.4

create, 4.2.4.3, 4.2.4.3

definition, 1.2.2, 4.2.4

V

views

Oracle Database, 4.2.4, C.4.1

W

WHERE clause, 4.2.6

referencing Oracle Database PL/SQL functions, 4.2.6.2