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

Part Number E13073-08
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, 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
monitor, 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
monitor, 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
automatically create Oracle objects to manage cache, 3.2.3
AUTOREFRESH cache group attribute, 4.2.5
autorefresh now, 4.2.5, 5.2.4

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, 4.7.2
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
ttRepStateSet, 6.2.1
ttRepStop, 2.7.2, 4.2.2.1, 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
monitor, 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
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.2
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
figure, 1.1
Oracle system parameters, 3.4.1
ten or more nodes, 3.4.1
cache group
create, 2.3
definition, 1.2, 4.1
table hierarchy, 4.1.2
cache instance
definition, 1.2.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
defined, 3.3.2
cache table users
create, 2.1.3, 3.3.2
definition, 2.1.3, 3.3.2
cacheCleanUp.sql SQL*Plus script, 7.5, 12.1
CacheGridEnable DSN attribute, 3.4.2
CacheGridMsgWait DSN attribute, 4.7
cacheInfo.sql SQL*Plus script, 7.2.2, 12.1
child table
definition, 1.2, 4.1.2
CLOB data
caching in TimesTen, 4.4
connection failures
Oracle Database, 9.1
connectivity between TimesTen and Oracle databases
test, 3.5
CREATE ACTIVE STANDBY PAIR statement, 6.2.1

D

Data Guard, 10.1
data type mapping
key columns, 11.5
non-key columns, 11.5
DatabaseCharacterSet DSN attribute, 3.3.1
DDL statements on cached Oracle tables
track, 7.2.7
detaching all grid members, 8.1
DROP ACTIVE STANDBY PAIR statement, 8.3
DROP CACHE GROUP statement
example, 2.7.3, 8.3
DSN attributes
CacheGridEnable, 3.4.2
CacheGridMsgWait, 4.7
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
DSN for TimesTen database
example, 2.1.2, 3.3.1
dynamic cache group
create, 4.6
definition, 1.2.4, 4.6
dynamic load
definition, 5.3
disable, 5.3.3
display errors, 5.3.4
example, 2.6.1, 5.3.1
DynamicLoadEnable DSN attribute, 5.3.3
DynamicLoadErrorMode DSN 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

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
create, 4.7
definition, 1.2.5, 4.7
sharing data among grid members, 6.3
global cache groups
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 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 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 DSN attribute, 3.3.1
LRU aging policy, 4.5.1

M

manually create Oracle objects to manage cache, 3.2.4
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
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 DSN attribute, 3.3.1
OraclePWD DSN attribute, 3.3.1

P

PassThrough DSN attribute, 3.3.1, 5.7
PermSize DSN attribute, 3.3.1
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 DSN attribute, 3.3.1

Q

query
cache grid, 6.4
global, 6.4

R

RACCallback DSN 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 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
replication agent start policy
definition, 4.2.2.1
set, 4.2.2.1
root table
definition, 1.2, 4.1.2

S

SELECT statement
cache grid, 6.4
global, 6.4
single-table cache group, 4.1.1
sliding window, 4.5.4
SNMP traps, 7.2.2
SQLGetStmtOption() ODBC function
TT_STMT_PASSTHROUGH_TYPE option, 5.7.2
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

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
Transparent Application Failover (TAF), 9.1
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.2
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.1
ttIsql utility, 2.1.3
ttOptSetFlag built-in procedure
DynamicLoadEnable flag, 5.3.3
DynamicLoadErrorMode flag, 5.3.4
PassThrough flag, 5.7.1
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
ttRepStateSet built-in procedure, 6.2.1
ttRepStop built-in procedure, 2.7.2, 4.2.2.1, 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 DSN attribute, 3.3.1

U

UID DSN 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