Skip Headers
Oracle® In-Memory Database Cache User's Guide
Release 11.2.1

Part Number E13073-11
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

A  B  C  D  E  F  G  H  I  L  M  N  O  P  Q  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
cache group, 4.5
LRU aging, 4.5.1
time-based aging, 4.5.2
asynchronous writethrough (AWT) cache group
create, 2.3.3, 4.2.2
definition, 1.2.2, 4.2.2
monitoring, 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
monitoring, 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
autorefresh
using SNMP traps, 7.2.2
AUTOREFRESH cache group attribute, 4.2.5
autorefresh now, 4.2.5, 5.2.4
AWT cache group
definition, 4.2.2
monitoring, 7.2.3

B

BLOB data
caching in TimesTen, 4.4
built-in procedures
ttAgingLRUConfig, 4.5.1
ttAgingScheduleNow, 4.5.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.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.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
monitoring, 7.6
recover when full, 7.6
usage warning threshold, 7.6
cache agent
reconnecting with Oracle Database, 9.1
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
and cache grid, 3.6.1
definition, 3.6.1
set, 3.6.1
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
create, 2.2, 3.4.2
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
instance owner, 4.7.1
member failure, 3.6.1
Oracle system parameters, 3.4.1
ten or more nodes, 3.4.1
using ttRepStateGet, 7.7
cache group
create, 2.3
definition, 1.2, 4.1
table hierarchy, 4.1.2
cache instance
definition, 1.2.1
owner, 4.7.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
create, 2.1.3
defined, 3.3.2
cache table users
create, 3.3.2
definition, 2.1.3, 3.3.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, 7.2.2, 12.1
cachesqlget
ttIsql command, 4.2.5.2, 7.2.7
child table
definition, 1.2, 4.1.2
CLOB data
caching in TimesTen, 4.4
connection attributes
CacheGridEnable, 3.4.2
CacheGridMsgWait, 4.7.1, 4.7.2
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
connection failures
Oracle Database, 9.1
connectivity between TimesTen and Oracle databases
test, 3.5
CREATE ACTIVE STANDBY PAIR statement, 6.2.1
create Oracle objects to manage cache
automatic, 3.2.3
manual, 3.2.4

D

Data Guard, 10.1
data type mapping
key columns, 11.5
non-key columns, 11.5
data type support
differences between Oracle and TimesTen, 11.4.3
data types
mapping between Oracle and TimesTen, 11.5
DatabaseCharacterSet connection attribute, 3.3.1
DDL statements on cached Oracle tables
tracking, 7.2.7
detaching all grid members, 8.1
DROP ACTIVE STANDBY PAIR statement
example, 8.3
DROP CACHE GROUP statement
example, 2.7.3, 8.3
drop Oracle objects, 8.7
drop Oracle users, 8.7
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
definition, 4.7.1, 5.3
disable, 5.3.3
display errors, 5.3.4
example, 2.6.1, 5.3.1
DynamicLoadEnable connection attribute, 5.3.3
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
grid member, 7.7
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
definition, 1.2.5, 4.7
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
global unload operation, 5.5.1
GlobalProcessing optimizer hint
query, 6.4
unload operation, 5.5.1
grantCacheAdminPrivileges.sql SQL*Plus script, 2.1.1, 3.2.3, 12.1
grid
attaching a member, 7.7
cache agent start policy, 7.7
failure, 7.7
recovery, 7.7
using ttRepStateGet, 7.7
grid data transfer, 4.7.1, 4.7.2
grid member
definition, 1.1, 3.4
grid members
detaching all, 8.1
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 (Oracle 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
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

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
connection failures, 9.1
differences from TimesTen, 11.1
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 Real Application Clusters (Oracle RAC), 9.1
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 connection attribute, 3.3.1
OraclePWD connection attribute, 3.3.1
owner
cache instance, 4.7.1

P

PassThrough connection attribute, 3.3.1, 5.7
and RETURN TWOSAFE, 5.7
passthrough level
changing, 5.7.8
setting, 5.7
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
PWD connection attribute, 3.3.1

Q

query
cache grid, 6.4
global, 6.4

R

RACCallback connection 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
refresh a cache group
definition, 1.2.3
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, 5.2.4
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, 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

scripts
IMDB Cache, 12
SQL*Plus, 12
SELECT statement
cache grid, 6.4
global, 6.4
semantics
differences between Oracle and TimesTen, 11.2
single-table cache group, 4.1.1
sliding window
cache group, 4.5.4
SNMP traps
monitoring autorefresh, 7.2.2
SQL
differences between TimesTen and Oracle, 11.4
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

tables
Oracle, 7.3
test TimesTen and Oracle database connectivity, 3.5
time-based aging policy, 4.5.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
transaction semantics
differences between Oracle and TimesTen, 11.2
Transparent Application Failover (TAF), 9.1
triggers
Oracle, 7.3
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.5.1
ttAgingScheduleNow built-in procedure, 4.5.3
ttCacheAutorefresh built-in procedure, 4.2.5, 5.2.4
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.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
ttDaemonLog utility
automatic refresh support log messages, 7.2.2
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
ttGridNameSet built-in procedure, 2.2, 3.4.3
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.7
ttIsql set dynamicloadenable command, 5.3.3
ttIsql set dynamicloaderrormode command, 5.3.4
ttIsql set passthrough command, 5.7.8
ttIsql utility, 2.1.3
ttOptSetFlag built-in procedure
DynamicLoadEnable flag, 5.3.3
DynamicLoadErrorMode flag, 5.3.4
PassThrough flag, 5.7.8
ttRepAdmin -duplicate utility, 6.2.2
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
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.1, 8.3
ttStatus utility, 7.1
ttTraceMon utility
AUTOREFRESH component, 7.2.2
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

W

WHERE clause, 4.2.6
referencing Oracle PL/SQL functions, 4.2.6.2