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