18/18

Index

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

---

A

Active Data Guard

configuration to support cache, 10.2.1

configure active standby pair, 10.2.2

failure and recovery options, 10.2.3

active standby pair

active database, 4.7.1

create, 4.7.1

definition, 4.7

read-only subscriber database, 4.7.3

standby database, 4.7.2

AgentFailoverTimeout parameter, 9.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

autorefresh

cleanup

drop Oracle Database objects, 6.5

continuous, 4.2.5.1

definition, 1.1.3

example, 2.3.2

full, 4.2.5.4

incremental, 4.2.5.4

avoid transactional inconsistency, 7.3.5.2

initiate, 4.2.5.1, 5.2.4

interval, 4.2.5.1, 7.3.5.3

mode, 4.2.5.1

performance, 7.1, 7.3

select limit, 7.3.6

state, 4.2.5.1

statistics, 7.3.5.3, 7.4

status, 6.4

autorefresh cache group

change log table, 6.4

defragment, 6.6.1

definition, 3.2.1

dynamic read-only

performance, 7.3.2

load and refresh, 5.2.1

manually create Oracle Database objects, 4.2.5.3

monitoring, 6.2.2

read-only

performance, 7.3.2, 7.3.5, 7.3.6

recovery method, 6.4

status, 6.4

transaction reclaim performance, 7.3.4

AUTOREFRESH cache group attribute, 4.2.5

AWT cache group

create, 2.2.3, 4.2.2

definition, 1.1.2, 4.2.2

error reporting, 4.2.2.3, 4.2.2.5

monitoring, 6.2.3

parallel propagation, 4.2.2.2, 7.2.1

batch size, 4.2.2.2.3

performance, 7.2

restrictions, 4.2.2.4

SQL array execution, 7.2.2

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

ttCacheAWTThresholdSet, 6.2.4

ttCacheConfig, 6.4

AgentTimeout parameter, 6.4

AutoRefreshLogTblSpaceUsagePCT parameter, 6.6.2

TblSpaceFullRecovery parameter, 6.6.3

ttCacheDbCgStatus, 6.4

ttCacheDDLTrackingConfig, 6.2.5, 6.2.5

ttCachePolicySet, 3.5.1

ttCacheStart, 2.2.2, 3.5

ttCacheStop, 2.5.3, 3.5, 8.3

ttCacheUidGet, 3.4

ttCacheUidPwdSet, 2.1.4, 3.3.4

ttRepPolicySet, 4.2.2.1

ttRepStart, 2.2.4, 4.2.2.1

ttRepStateSet, 4.7.1

ttRepStop, 2.5.1, 4.2.2.1, 8.1, 8.1

ttRepSubscriberWait, 6.2.5, 8.2

---

C

cache

manage, 3.2.3, 3.2.4

manage through Oracle Database object, 3.2.4

cache administration user

caching table on more than one TimesTen database, 7.5

create, 2.1.1, 3.2.1

default tablespace

create, 2.1.1, 3.2.1

drop, 2.5.4, 8.5

monitoring, 6.6

recover when full, 6.6.3

usage warning threshold, 6.6.2

definition, 2.1.1, 3.2.1

determine, 3.4

set in TimesTen database, 2.1.4, 3.3.4

cache agent

connection failure, 6.1.1

reconnecting with Oracle Database, 9.1

start, 2.2.2, 3.5

start policy

definition, 3.5.1

set, 3.5.1

status, 6.1, 6.1

stop, 2.5.3, 3.5, 8.3

timeout, 6.4

cache connection pool, 7.1.1

example, 7.1.1.5

restrictions, 7.1.1.7

sizing, 7.1.1.2

cache group

autorefresh

definition, 1.1.3, 3.2.1

large transactions, 7.3.5

transaction reclaim performance, 7.3.4

create, 2.2

dead

recovery, 6.4

definition, 1.1, 4.1

dynamic load, 5.3

dynamic read-only

performance, 7.3.2

flush

definition, 1.1.3

load, 1.1.3

read-only

autorefresh with select limit, 7.3.6

improving autorefresh, 7.3.2, 7.3.5, 7.3.6

refresh, 1.1.3

table hierarchy, 4.1.2

table partition, C.4.1.1

cache instance

definition, 1.1.1, 5.3

propagate

definition, 1.1.3

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

cache table

multiple TimesTen databases, 7.5

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 connection attribute, 7.2, 7.2.2

CacheAWTParallelism data store attribute, 3.3.1, 4.2.2.2

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

CacheCommitDurable cache configuration parameter, 7.3.3

cachegroups ttIsql command, 2.2.3, 6.2.1

cacheInfo.sql SQL*Plus script, B.1

CacheParAwtBatchSize parameter, 4.2.2.2.3

cachesqlget ttIsql command, 4.2.5.3, 6.2.5

change log tables

defragment, 6.6.1

character set

on Oracle Database, 2.1.2

child server process

identification, 7.1.1.3

child server processes

configuration, 7.1.1.1

child table

definition, 1.1, 4.1.2

ChildServer connection attribute, 7.1.1.3

client connections

maximum, 7.1.1.1

client/server connection

configuration, 7.1.1.1

CLOB data

caching in TimesTen, 4.4

CONNECT BY clause, C.4.6

connection

between TimesTen and Oracle database, 3.4

failure

cache agent, 6.1.1

Oracle Database, 9.1

replication agent, 6.1.1

limit number to Oracle database, 7.1.1.6

connection attribute

CacheAWTMethod, 7.2, 7.2.2

ChildServer, 7.1.1.3

MaxConnsPerServer, 7.1.1.1

ServersPerDSN, 7.1.1.1

UseCacheConnPool, 7.1.1.1

connection attributes

DatabaseCharacterSet, 3.3.1

DynamicLoadEnable, 5.3.1

DynamicLoadErrorMode, 5.3.4

LockLevel, 3.3.1

OracleNetServiceName, 3.3.1, 10.2.2

OraclePWD, 3.3.1

PassThrough, 3.3.1, 5.7

PermSize, 3.3.1

PWD, 3.3.1

RACCallback, 9.3

UID, 3.3.1

connection pool, 7.1.1

connections

maximum, 7.1.1.1

contention

reducing, 7.3.3

continuous autorefresh, 4.2.5.1

CREATE ACTIVE STANDBY PAIR statement, 4.7.1

---

D

Data Guard, 10.1

Active

failure and recovery options, 10.2.3

configure active standby pair, 10.2.2

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

duplicate, 4.7.2

temporary, 4.2

DatabaseCharacterSet connection attribute, 3.3.1

DDL statements

tracking, 6.2.5

DeadDbRecovery parameter, 6.4, 6.4

DROP ACTIVE STANDBY PAIR statement

example, 8.2

DROP CACHE GROUP statement

example, 2.5.2, 8.2

DSN

TimesTen database

example, 2.1.2, 7.1.1.1

DSN for TimesTen database

example, 3.3.1

duplicating a database, 4.7.2

durability

performance, 7.3.3

dynamic cache group

create, 4.6

definition, 1.1.4, 4.6

dynamic load

configuration, 5.3.1

definition, 5.3

disable, 5.3.1

display errors, 5.3.4

examples, 2.4.1, 5.3.3

guidelines, 5.3.2

performance, 7.1, 7.1.1, 7.3

rules, 5.3.2

DynamicLoadEnable connection attribute, 5.3.1, 5.3.1

DynamicLoadErrorMode connection attribute, 5.3.4

DynamicLoadReduceContention database system parameter, 4.2.5.1, 4.6, 7.3.2

---

E

environment variables

Microsoft Windows, 3.1.2

UNIX or Linux, 3.1.1

explicitly loaded cache group

definition, 1.1.4

---

F

Fast Application Notification (FAN), 9.1

FLUSH CACHE GROUP statement

definition, 5.4

example, 5.4

foreign key

index, 4.2.2.2

restriction, 4.2.2.2

---

G

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

---

H

high availability, 1.2

active standby pair, 1.2

Data Guard, 1.2

Oracle Real Application Clusters (Oracle RAC), 1.2

---

I

index

foreign key, 4.2.2.2

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

instance administrator, 2.1.3

---

L

LOAD CACHE GROUP statement

definition, 5.2

example, 2.3.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

lock contention

reducing, 7.3.3

LockLevel connection attribute, 3.3.1

LRU aging policy, 4.5.1

---

M

materialized views

Oracle Database, C.4.1

MaxConnsPerServer connection attribute, 7.1.1.1

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

autorefresh

cleanup, 6.5

AWT errors, 4.2.2.5

character set

determine, 2.1.2, 3.3.1

connection failures, 9.1

create objects to manage cache, 3.2.3

differences from TimesTen IMDB, 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, 6.3

partitioned tables, C.4.1.1

schema users

create, 2.1.1, 3.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.5.4, 8.5

privileges, 3.2.2, A.2

schema users, 2.1.1

users

timesten user, 3.2.1

Oracle RAC

using TimesTen Cache, 9.3

using TimesTen Cache in, 9.1

Oracle Real Application Clusters (Oracle RAC)

Oracle SQL*Plus scripts

cacheCleanUp.sql, 6.5, B.1

cacheInfo.sql, B.1

grantCacheAdminPrivileges.sql, 2.1.1, 3.2.3, B.1

initCacheAdminSchema.sql, 3.2.4, B.1

OracleNetServiceName connection attribute, 2.1.2, 3.3.1, 10.2.2

OraclePWD connection attribute, 3.3.1

---

P

parallel propagation

AWT cache group, 4.2.2.2, 7.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.6

setting, 5.7

performance

autorefresh, 7.1

cache, 7

connection pool, 7.1.1

dynamic load, 7.1

read-only cache group

incremental autorefresh, 7.3.6

large transactions, 7.3.5

transaction reclaim, 7.3.4

PermSize connection attribute, 3.3.1

privileges

Oracle Database users, 3.2.2, A.2

propagate

cache instances

definition, 1.1.3

error reporting, 4.2.2.5

example, 2.4.2

parallel, 4.2.2.2, 7.2.1

PROPAGATE cache table attribute, 4.2.4.2

PWD connection attribute, 3.3.1

---

R

RACCallback connection attribute, 9.3

read-only cache group

autorefresh

performance, 7.3.5, 7.3.6

create, 2.2.3, 4.2.1

definition, 1.1.2, 4.2.1

incremental autorefresh

statistics, 7.4

large transactions, 7.3.5

restrictions, 4.2.1.1

READONLY cache table attribute, 4.2.4.1

refresh

autorefresh, 4.2.5.1

cache group, 1.1.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, 6.1.1

start, 2.2.4, 4.2.2.1

start policy

definition, 4.2.2.1

set, 4.2.2.1

status, 6.1, 6.1

stop, 2.5.1, 4.2.2.1, 8.1, 8.1

ReplicationApplyOrdering data store attribute, 3.3.1, 4.2.2.2

ReplicationParallelism data store attribute, 4.2.2.2

root table

definition, 1.1, 4.1.2

---

S

schema users

create, 2.1.1

definition, 2.1.1

scripts

SQL*Plus, B

TimesTen Cache, B

semantics

differences between Oracle Database and TimesTen IMDB, C.2

server

multithreaded mode, 7.1.1.1

ServersPerDSN connection attribute, 7.1.1.1

single-table cache group, 4.1.1

sliding window

cache group, 4.5.4

SQL

differences between TimesTen and Oracle, C.4

SQL array execution, 7.2.2

SQLRowCount() ODBC function, 5.6

Statement.getUpdateCount() JDBC method, 5.6

synchronous writethrough (SWT) cache group

create, 4.2.3

definition, 1.1.2, 4.2.3

restrictions, 4.2.3.1

system managed cache groups, 4.2

---

T

tables

caching on more than one TimesTen database, 7.5

Oracle Database, 6.3

partition, C.4.1.1

tablespace

create default, 2.1.1, 3.2.1

defragmentation, 6.6.1

drop default, 2.5.4, 8.5

full, 6.6.3

monitoring default, 6.6

recover when full, 6.6.3, 6.6.3

threshold, 6.6.2, 6.6.2

usage notification, 6.6.2

utilization, 6.6.1

TAF

overview, 9.1

timeout, 9.3

TblSpaceFullRecovery parameter, 6.6.3

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

incremental autorefresh

performance, 7.3.5

large

incremental commit, 7.3.5

performance, 7.3.5

reclaim operations

performance, 7.3.4, 7.3.4

semantics

differences between Oracle Database and TimesTen IMDB, C.2

transaction log file threshold for AWT cache groups

set, 6.2.4

Transparent Application Failover (TAF), see TAF

triggers

Oracle Database, 6.3

tt_cache_admin_role role

drop, 8.5

TT_CACHE_ADMIN_ROLE role

drop, 2.5.4

ttAdmin utility

-cachePolicy command, 3.5.1

-cacheStart command, 3.5

-cacheStop command, 3.5

-cacheUidGet command, 3.4

-cacheUidPwdSet command, 3.3.4

-query command, 6.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

ttCacheADGStandbyStateSet built-in procedure, 10.2.3.1, 10.2.3.1, 10.2.3.1, 10.2.3.1

ttCacheADGStandbyTimeoutSet built-in procedure, 10.2.3.1

ttCacheAutorefIntervalStatsGet built-in procedure, 7.3.5.3, 7.4

ttCacheAutorefresh built-in procedure, 4.2.5.1, 5.2.4

ttCacheAutoRefreshLogDefrag built-in procedure

defragment tablespace, 6.6.1.1

ttCacheAutorefreshSelectLimit built-in procedure, 7.3.6

ttCacheAutorefreshStatsGet built-in procedure

tablespace

utilization, 6.6.1

ttCacheAutorefreshXactLimit built-in procedure, 7.3.5

ttCacheAWTMonitorConfig built-in procedure, 6.2.3

ttCacheAWTThresholdSet built-in procedure, 6.2.4

ttCacheConfig

usage notification, 6.6.2

ttCacheConfig built-in procedure

AgentFailoverTimeout parameter, 9.3

AgentTimeout parameter, 6.4

AutoRefreshLogTblSpaceUsagePCT parameter, 6.6.2

AwtErrrorXmlOutput, 4.2.2.5

DeadDbRecovery parameter, 6.4

defragment tablespace, 6.6.1

full tablespace, 6.6.3

TblSpaceFullRecovery parameter, 6.6.3

ttCacheConnPoolApply built-in procedure, 7.1.1.2, 7.1.1.3, 7.1.1.4

ttCacheConnPoolGet built-in procedure, 7.1.1.3

ttCacheConnPoolSet built-in procedure, 7.1.1.2

ttCacheDbCgStatus built-in procedure, 6.4

ttCacheDDLTrackingConfig built-in procedure, 6.2.5, 6.2.5

ttCachePolicySet built-in procedure, 3.5.1

ttCacheStart built-in procedure, 2.2.2, 3.5

ttCacheStop built-in procedure, 2.5.3, 3.5, 8.3

ttCacheUidGet built-in procedure, 3.4

ttCacheUidPwdSet built-in procedure, 2.1.4, 3.3.4

ttDBConfig, 4.2.2.2.3

ttDbConfig built-in procedure, 7.3.4

ttDBConfig built-in procedure, 7.2.2

DynamicLoadReduceContention, 7.3.2

ttDestroy utility, 8.4

ttIsql set dynamicloadenable command, 5.3.1

ttIsql set dynamicloaderrormode command, 5.3.4

ttIsql utility, 2.1.3

cachegroups command, 2.2.3, 6.2.1

cachesqlget command

INCREMENTAL AUTOREFRESH option, 4.2.5.3

ORACLE_DDL_TRACKING option, 6.2.5

set passthrough command, 5.7.6

ttOptSetFlag built-in procedure

DynamicLoadEnable flag, 5.3.1

DynamicLoadErrorMode flag, 5.3.4

PassThrough flag, 5.7.6

ttRepAdmin -duplicate utility, 4.7.2

-keepCG option, 4.7.2

-noKeepCG option, 4.7.3

ttRepPolicySet built-in procedure, 4.2.2.1

ttRepStart built-in procedure, 2.2.4, 4.2.2.1

ttRepStateSet built-in procedure, 4.7.1

ttRepStop built-in procedure, 2.5.1, 4.2.2.1, 8.1, 8.1

ttRepSubscriberWait built-in procedure, 6.2.5, 8.2

ttStatus utility, 6.1

---

U

UID connection attribute, 3.3.1

UNIQUE HASH ON cache table attribute, 4.2.8

UNLOAD CACHE GROUP statement

definition, 5.5

example, 5.5

UseCacheConnPool connection attribute, 7.1.1.1

user

create, 2.1.1

definition, 2.1.1

Oracle Database

drop, 8.5

user managed cache group

bidirectional transmit, 4.2.4

create, 4.2.4.3, 4.2.4.3

definition, 1.1.2, 4.2.4

---

V

views

Oracle Database, C.4.1

---

W

WHERE clause, 4.2.6

referencing Oracle Database PL/SQL functions, 4.2.6.2