Skip Headers
Oracle® TimesTen In-Memory Database Reference
11
g
Release 2 (11.2.2)
Part Number E21643-10
Home
Book List
Contents
Master Index
Contact Us
Previous
PDF
·
Mobi
·
ePub
Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
X
A
Access Control
Authenticate,
1.2
DSN attributes,
1.1
ttAgingLRUConfig,
2
ttAgingScheduleNow,
2
ttApplicationContext,
2
ttBackupStatus,
2
ttBookmark,
2
ttCacheAdvisor,
3.2.2
ttCacheAutorefreshStatsGet,
2
,
2
ttCacheAwtThresholdSet,
2
ttCacheConfig,
2
ttCacheDBCgStatus,
2
ttCachePolicyGet,
2
ttCachePolicySet,
2
ttCachePropagateFlagSet,
2
ttCacheSqlGet,
2
ttCacheStart,
2
ttCacheStop,
2
ttCacheUidGet,
2
ttCacheUidPwdSet,
2
ttCapture,
3.2.2
ttCkpt,
2
ttCkptBlocking,
2
ttCompact,
2
ttCompactTS,
2
ttComputeTabSizes,
2
ttConfiguration,
2
ttContext,
2
ttDaemonAdmin,
3.2.2
ttDataStoreStatus,
2
ttDurableCommit,
2
ttGridAttach,
2
,
2
,
2
,
2
ttGridCheckOwner,
2
ttGridCreate,
2
,
2
ttGridDestroy,
2
,
2
ttGridDetach,
2
,
2
ttGridDetachAll,
2
,
2
,
2
ttGridDetachList,
2
ttGridGlobalCGResume,
2
ttGridGlobalCGSuspend,
2
,
2
,
2
ttGridInfo,
2
,
2
ttGridNameSet,
2
,
2
ttGridNodeStatus,
2
,
2
ttHostGridCheckOwner,
2
ttHostNameGet,
2
,
2
ttHostNameSet,
2
,
2
ttLoadFromOracle,
2
ttLockLevel,
2
ttLockWait,
2
ttLogHolds,
2
ttmodinstall,
3.2.2
ttMonitorHighWaterReset,
2
ttOptClearStats,
2
,
2
ttOptEstimateStats,
2
ttOptGetColStats,
2
ttOptGetFlag,
2
ttOptGetMaxCmdFreeListCnt,
2
ttOptGetOrder,
2
ttOptJoinOrder,
2
ttOptSetColIntvlStats,
2
ttOptSetColStats,
2
ttOptSetFlag,
2
ttOptSetMaxCmdFreeListCnt,
2
ttOptSetMaxPriCmdFreeListCnt,
2
ttOptSetOrder,
2
ttOptSetTblStats,
2
ttOptStatsExport,
2
ttOptUpdateStats,
2
ttOptUseIndex,
2
ttPLSQLMemoryStats,
2
ttRamPolicyGet,
2
,
2
ttRamPolicySet,
2
,
2
ttRedundantIndexCheck,
2
ttRepAdmin,
3.2.2
ttRepDeactivate,
2
ttReplicationStatus,
2
ttRepPolicyGet,
2
ttRepPolicySet,
2
ttRepQueryThresholdGet,
2
ttRepQueryThresholdSet,
2
ttRepStart,
2
ttRepStateGet,
2
ttRepStateSave,
2
ttRepStateSet,
2
ttRepStop,
2
ttRepSubscriberStateSet,
2
ttRepSubscriberWait,
2
ttRepSyncGet,
2
ttRepSyncSet,
2
ttRepSyncSubscriberStatus,
2
ttRepTransmitGet,
2
ttRepXactStatus,
2
ttRepXactTokenGet,
2
ttSetUserColumnID,
2
ttSetUserTableID,
2
ttSize,
2
ttSQLCmdCacheInfo,
2
ttSQLCmdQueryPlan,
2
,
2
ttTableSchemaFromOraQueryGet,
2
ttUserPrivileges,
2
ttWarnOnLowMemory,
2
,
2
ttXactAdmin,
3.2.2
ttXactIdGet,
2
ttXlaBookmarkCreate,
2
ttXlaBookmarkDelete,
2
ttXlaSubscribe,
2
ttXlaUnsubscribe,
2
utilities,
3.2.1
access modes, conflicting,
1.2
AllFlags optimizer flag,
2
allocated statement handles
maximum number,
4.1
allocating disk space
first connection attributes
Preallocate,
1.2
,
1.2
altering plan generation,
2
,
2
ASCII files and ttBulkCp,
3.2.2
attributes
access control,
1.1
AutoCreate,
1.2
CacheAWTMethod,
1.2
CacheAWTParallelism,
1.2
CacheGridEnable,
1.2
CacheGridMsgWait,
1.2
CkptFrequency,
1.2
CkptLogVolume,
1.2
CkptRate,
1.2
ConnectionCharacterSet,
1.2
ConnectionName,
1.2
Connections,
1.2
Data Source Name,
1.2
DatabaseCharacterSet,
1.2
DataStore,
1.2
DDLCommitBehavior,
1.2
,
1.2
,
1.2
Description,
1.2
Diagnostics,
1.2
DuplicateBindMode,
1.2
DurableCommits,
1.2
DynamicLoadEnable,
1.2
DynamicLoadErrorMode,
1.2
ForceConnect,
1.2
Isolation,
1.2
LockLevel,
1.2
LockWait,
1.2
LogAutoTruncate,
1.2
LogBuffMB,
1.2
LogBufParallelism,
1.2
LogDir,
1.2
LogFileSize,
1.2
LogFlushMethod,
1.2
LogPurge,
1.2
MatchLogOpts,
1.2
MaxConnsPerServer,
1.2
MemoryLock,
1.2
NLS_LENGTH_SEMANTICS,
1.2
NLS_NCHAR_CONV_EXCP,
1.2
NLS_SORT,
1.2
OracleNetServiceName,
1.2
OraclePWD,
1.2
Overwrite,
1.2
PassThrough,
1.2
PermSize,
1.2
PermWarnThreshold,
1.2
PLSCOPE_SETTINGS,
1.2
PLSQL,
1.2
PLSQL_CCFLAGS,
1.2
PLSQL_MEMORY_ADDRESS,
1.2
,
1.2
PLSQL_MEMORY_SIZE,
1.2
PLSQL_OPTIMIZE_LEVEL,
1.2
PLSQL_TIMEOUT,
1.2
Preallocate,
1.2
PrivateCommands,
1.2
PWD,
1.2
PWDCrypt,
1.2
QueryThreshold,
1.2
RACCallback,
1.2
ReceiverThreads,
1.2
RecoveryThreads,
1.2
ReplicationApplyOrdering,
1.2
,
1.2
ReplicationParallelism,
1.2
,
1.2
ReplicationTrack,
1.2
ServersPerDSN,
1.2
ServerStackSize,
1.2
SQLQueryTimeout,
1.2
TCP_Port,
1.2
TCP_Port2,
1.2
Temporary,
1.2
TempSize,
1.2
TempWarnThreshold,
1.2
TTC_FailoverPortRange,
1.2
TTC_Server,
1.2
TTC_Server_DSN,
1.2
TTC_Server_DSN2,
1.2
TTC_Server2,
1.2
TTC_Timeout,
1.2
TypeMode,
1.2
UID,
1.2
WaitForConnect,
1.2
autocommit,
2
AutoCreate attribute,
1.2
AWT cache group
maximum length of path name for database,
4.1
B
backups,
3.2.2
BranchandBound optimizer flag,
2
built-in procedure
ttIndexAdviceCaptureDrop,
2
ttIndexAdviceCaptureEnd,
2
ttIndexAdviceCaptureInfoGet,
2
ttIndexAdviceCaptureOutput,
2
ttIndexAdviceCaptureStart,
2
built-in procedures
ttAgingLRUConfig,
2
ttAgingScheduleNow,
2
ttApplicationContex,
2
ttApplicationContext,
2
ttBookmark,
2
ttCacheAWTMonitorConfig,
2
ttCacheAwtThresholdGet,
2
ttCacheAWTThresholdSet,
2
ttCacheConfig,
2
ttCacheDbCgStatus,
2
ttCachePolicyGet,
2
ttCachePolicySet,
2
ttCachePropagateFlagSet,
2
ttCacheSqlGet,
2
ttCacheStart,
2
ttCacheStop,
2
ttCacheUidPwdSet,
2
ttCkpt,
2
,
2
ttCkptBlocking,
2
ttCkptConfig,
2
ttCkptHistory,
2
ttCompact,
2
ttCompactTS,
2
ttConfiguration,
2
ttContext,
2
ttDataStoreStatus,
2
ttDurableCommit,
2
ttGridAttach,
2
,
2
ttGridCheckOwner,
2
ttGridCreate,
2
ttGridDestroy,
2
ttGridDetach,
2
ttGridDetachAll,
2
ttGridGlobalCGSuspend,
2
ttGridInfo,
2
ttGridNameSet,
2
ttGridNodeStatus,
2
ttHostNameGet,
2
ttHostNameSet,
2
ttIndexAdviceCaptureDrop,
2
ttLoadFromOracle,
2
ttLockLevel,
2
ttLockWait,
2
ttLogHolds,
2
ttOptClearStats,
2
,
2
ttOptEstimateStats,
2
ttOptGetColStats,
2
ttOptGetFlag,
2
ttOptGetMaxCmdFreeListCnt,
2
ttOptGetOrder,
2
ttOptSetColIntvlStats,
2
ttOptSetFlag,
2
ttOptSetMaxCmdFreeListCnt,
2
ttOptSetMaxPriCmdFreeListCnt,
2
ttOptSetOrder,
2
ttOptSetTblStats,
2
ttOptShowJoinOrder,
2
ttOptStatsExport,
2
ttOptUpdateStats,
2
ttOptUseIndex,
2
ttPLSQLMemoryStats,
2
ttRamPolicyGet,
2
,
2
ttRamPolicySet,
2
,
2
ttRedundantIndexCheck,
2
ttRepDeactivate,
2
ttReplicationStatus,
2
ttRepPolicyGet,
2
ttRepPolicySet,
2
ttRepQueryThresholdGet,
2
ttRepQueryThresholdSet,
2
ttRepStart,
2
ttRepStateSet,
2
ttRepStop,
2
ttRepSubscriberStateSet,
2
ttRepSubscriberStatus,
2
ttRepSubscriberWait,
2
ttRepSyncGet,
2
ttRepSyncSet,
2
ttRepTransmitGet,
2
ttRepTransmitSet,
2
ttRepXactStatus,
2
ttRepXactTokenGet,
2
ttSetUserColumnID,
2
ttSetUserTableID,
2
,
2
ttSize,
2
ttTableSchemaFromOraQueryGet,
2
ttVersion,
2
ttWarnOnLowMemory,
2
ttXactIdGet transaction ID
displaying,
2
ttXlaBookmarkCreate,
2
ttXlaBookmarkDelete,
2
ttXlaSubscribe,
2
bulk copy,
3.2.2
C
cache agent
ttCacheConfig procedure,
2
ttCacheDbCgStatus procedure,
2
ttCachePolicyGet procedure,
2
ttCachePolicySet procedure,
2
CacheAWTMethod attribute,
1.2
CacheAWTParallelism attribute,
1.2
CacheGridEnable attribute,
1.2
CacheGridMsgWait attribute,
1.2
caching Oracle data
ttCacheAgingIntervalSet procedure,
2
ttCacheConfig procedure,
2
ttCacheDbCgStatus procedure,
2
ttCachePolicyGet procedure,
2
ttCachePolicySet procedure,
2
ttCachePropagateFlagSet procedure,
2
ttCacheSqlGet procedure,
2
ttCacheStart procedure,
2
ttCacheStop procedure,
2
ttCacheUidPwdSet procedure,
2
CallableStatement
example,
2
changing lock level,
2
checkpoints,
2
ttCkpt,
2
ttCkptBlocking,
2
,
2
ttCkptConfig,
2
ttCkptHistory,
2
,
2
CkptFrequency attribute,
1.2
CkptLogVolume attribute,
1.2
CkptRate attribute,
1.2
clearing statistics,
2
,
2
Client connection attributes
TCP_Port,
1.2
TCP_Port2,
1.2
TTC_FailoverPortRange,
1.2
TTC_Server,
1.2
TTC_Server_DSN,
1.2
TTC_Server_DSN2,
1.2
TTC_Server2,
1.2
TTC_Timeout,
1.2
UID/PWD,
1.2
client/server connections
maximum,
4.1
,
4.1
COL_STATS system table
updating explicitly,
2
columns
fixed-length maximum,
4.1
maximum in GROUP BY clause,
4.1
maximum in ORDER BY clause,
4.1
maximum number in index,
4.1
maximum per table,
4.1
replication, maximum length,
4.1
varying-length maximum,
4.1
compacting database,
2
concurrency,
1.2
concurrent connections
maximum,
4.1
,
4.1
conflicting access modes,
1.2
connection attribute
DynamicLoadEnable,
1.2
connection failure and MatchLogOpts,
1.2
ConnectionCharacterSet attribute,
1.2
ConnectionName attribute,
1.2
Connections attribute,
1.2
consistency checking,
3.2.2
Correlation Name
definition,
2
createandloadfromoraquery,
3.2.2
creating databases
AutoCreate attribute,
1.2
Overwrite attribute,
1.2
PermSize attribute,
1.2
Preallocate attribute,
1.2
RecoveryThreads attribute,
1.2
TempSize attribute,
1.2
cumulative length of columns,
4.1
D
Data Source Name attribute,
1.2
data store
attributes,
1.2
Data Source Name attribute,
1.2
DatabaseCharacterSet attribute,
1.2
DataStore attribute,
1.2
Description attribute,
1.2
LogDir attribute,
1.2
Preallocate attribute,
1.2
ReplicationApplyOrdering attribute,
1.2
ReplicationParallelism,
1.2
Temporary attribute,
1.2
TypeMode,
1.2
database
AutoCreate attribute,
1.2
backups,
3.2.2
calling ttCompact,
2
calling ttCompactTS,
2
compacting,
2
creating,
1.2
database-level locking,
1.2
destroying,
3.2.2
estimating size,
2
,
3.2.2
ForceConnect attribute,
1.2
LockLevel attribute,
1.2
LogAutoTruncate attribute,
1.2
LogFlushMethod attribute,
1.2
LogPurge attribute,
1.2
MatchLogOpts attribute,
1.2
maximum length of name,
4.1
Overwrite attribute,
1.2
PermSize attribute,
1.2
PermWarnThreshold attribute,
1.2
PrivateCommands attribute,
1.2
PWDCrypt attribute,
1.2
QueryThreshold attribute,
1.2
ReplicationApplyOrdering attribute,
1.2
restoring,
3.2.2
status,
2
TempSize attribute,
1.2
TempWarnThreshold attribute,
1.2
WaitForConnect attribute,
1.2
database size
minimum,
4.1
DatabaseCharacterSet attribute,
1.2
database-level locking
ttLockLevel procedure,
2
DataStore attribute,
1.2
data-store-level locking
attribute,
1.2
,
1.2
,
1.2
different levels of locking,
1.2
DDLCommitBehavior attribute,
1.2
,
1.2
,
1.2
Default optimizer flag,
2
deleting database,
3.2.2
depth of nesting subqueries maximum,
4.1
Description attribute,
1.2
destroying database,
3.2.2
Diagnostics attribute,
1.2
displayed predicate maximum length,
4.1
displaying the TimesTen Version,
3.2.2
,
3.2.2
displaying transaction ID,
2
displaying transaction log,
3.2.2
DuplicateBindMode attribute,
1.2
,
1.2
durable commits
ttDurableCommit procedure,
2
DurableCommits attribute,
1.2
,
1.2
DynamicLoadEnable connection attribute,
1.2
DynamicLoadEnable optimizer flag,
2
DynamicLoadErrorMode attribute,
1.2
DynamicLoadErrorMode optimizer flag,
2
E
eliminating fragmentation,
2
error message maximum length,
4.1
estimating statistics,
2
estimating table size,
2
,
3.2.2
expressions in SELECT statement maximum,
4.1
F
Firs tRow optimizer flag,
2
first connection attributes
AutoCreate,
1.2
LogPurge,
1.2
Overwrite,
1.2
PermSize,
1.2
TempSize,
1.2
fixed-length column
maximum length,
4.1
,
4.1
ForceCompile optimizer flag,
2
ForceConnect attribute,
1.2
fragmentation
eliminating with ttCompact,
2
eliminating with ttCompactTS,
2
G
general connection attributes
ConnectionCharacterSet,
1.2
ConnectionName,
1.2
description,
1.2
Diagnostics,
1.2
DurableCommits,
1.2
LockLevel,
1.2
LockWait,
1.2
MatchLogOpts,
1.2
PLSQL,
1.2
WaitForConnect,
1.2
GenPlan optimizer flag,
2
getting statistics,
2
GlobalProcessing optimizer flag,
2
GROUP BY
maximum number of columns,
4.1
H
Hash optimizer flag,
2
HashGb optimizer flag,
2
I
IF command,
3.2.2
Index Advisor
ttIndexAdviceCaptureDrop,
2
,
2
ttIndexAdviceCaptureEnd,
2
ttIndexAdviceCaptureInfoGet,
2
ttIndexAdviceCaptureOutput,
2
ttIndexAdviceCaptureStart,
2
IndexedOR optimizer flag,
2
indexes
maximum number of columns,
4.1
maximum number on a table,
4.1
interactively running SQL,
3.2.2
internal consistency checking,
3.2.2
Isolation attribute,
1.2
J
join order
maximum string length,
4.1
L
length of basic names maximum,
4.1
Load From Oracle
ttIsql createandloadfromoraquery,
3.2.2
,
3.2.2
Load from Oracle
ttLoadFromOracle,
2
ttTableSchemaFromOraQueryGet,
2
locked database,
1.2
locking
ttLockLevel procedure,
2
LockLevel attribute,
1.2
locks
changing level,
2
ttLockLevel procedure,
2
LockWait attribute,
1.2
log buffer size
and logging to disk,
1.2
attribute,
1.2
log file size
and logging,
1.2
attribute,
1.2
log files
purging,
1.2
LogAutoTruncate attribute,
1.2
LogBuffSize attribute,
1.2
,
1.2
LogBufParallelism attribute,
1.2
LogDir attribute,
1.2
LogFileSize attribute,
1.2
LogFlushMethod attribute,
1.2
LogPurge attribute,
1.2
and MatchLogOpts,
1.2
description,
1.2
logs
transaction log,
3.2.2
M
MatchLogOpts attribute,
1.2
MaxConnsPerServer attribute,
1.2
maximum
client/server timeout period,
1.2
columns in index,
4.1
columns per table,
4.1
,
4.1
concurrent connections,
4.1
,
4.1
cumulative length of columns,
4.1
depth of nesting subqueries,
4.1
error message length,
4.1
expressions in SELECT statement,
4.1
fixed-length column,
4.1
indexes per table,
4.1
join order string length,
4.1
length of database name,
4.1
length of displayed predicate,
4.1
length of names,
4.1
length of path name for database in AWT cache group,
4.1
length of SQL statement,
4.1
number of subscriber databases,
4.1
prepared PL/SQL statements per connection,
4.1
recently used PL/SQL blocks cached per session,
4.1
rows per table,
4.1
table partitions,
4.1
table references in query,
4.1
varying-length columns,
4.1
maximum columns
GROUP BY,
4.1
ORDER BY,
4.1
maximum length,
4.1
memory
usage policy,
3.2.2
MemoryLock attribute,
1.2
migrating databases
ttMigrate utility,
3.2.2
minimum database size,
4.1
modifying column statistics explicitly,
2
,
2
modifying table statistics explicitly,
2
N
NestedLoop optimizer flag,
2
,
2
NLS general connection attributes,
1.2
NLS_LENGTH_SEMANTICS attribute,
1.2
NLS_NCHAR_CONV_EXCP attribute,
1.2
NLS_SORT attribute,
1.2
NoRemRowIdOpt optimizer flag,
2
O
open files, maximum number,
4.2
optimizer flag
settings,
2
ttOptGetFlag procedure,
2
optimizer flags
AllFlags,
2
Default,
2
FirstRow,
2
GenPlan,
2
GlobalProcessing,
2
Hash,
2
HashGb,
2
NestedLoop,
2
,
2
PassThrough,
2
Range,
2
Rowid,
2
RowLock,
2
,
2
Scan,
2
TblLock,
2
,
2
TmpHash,
2
TmpRange,
2
TmpTable,
2
OracelNetServiceName attribute,
1.2
Oracle Agent
ttCacheStart procedure,
2
ttCacheStop procedure,
2
Oracle Connect
ttCacheAgingIntervalSet procedure,
2
ttCachePropagateFlagSet procedure,
2
ttCacheSqlGet procedure,
2
ttCacheUidPwdSet procedure,
2
OraclePWD attribute,
1.2
,
1.2
ORDER BY
maximum number of columns,
4.1
out-of memory warnings,
1.2
,
1.2
Overwrite attribute,
1.2
P
parallel replication,
1.2
PassThrough attribute,
1.2
PassThrough optimizer flag,
2
path names,
4.3
PermSize attribute,
1.2
PermWarnThreshold attribute,
1.2
plan generation
altering,
2
,
2
PLSCOPE_SETTINGS attribute,
1.2
PLSQL attribute,
1.2
PL/SQL first connection attributes,
1.2
PLSQL_CCFLAGS attribute,
1.2
PLSQL_MEMORY_ADDRESS attribute,
1.2
,
1.2
PLSQL_MEMORY_SIZE attribute,
1.2
PLSQL_OPTIMIZE_LEVEL attribute,
1.2
PLSQL_TIMEOUT attribute,
1.2
Preallocate attribute,
1.2
prepared PL/SQL statements per connection
maximum,
4.1
PrivateCommands attribute,
1.2
propagator databases
maximum number,
4.1
purging log files,
1.2
PWD,
1.2
PWD attribute,
1.2
PWDCrypt,
3.2.2
PWDCrypt attribute,
1.2
Q
QueryThreshold attribute,
1.2
R
RACCallback attribute,
1.2
RAM
usage policy,
3.2.2
RAM policy
ttAdmin,
3.2.2
ramPolicy,
3.2.2
Range optimizer flag,
2
read-only isolation mode,
1.2
ReceiverThreads attribute,
1.2
attributes
ReceiverThreads,
1.2
recently-used PL/SQL blocks cached per session
maximum,
4.1
RecoveryThreads attribute,
1.2
,
1.2
removing database,
3.2.2
replicated column,
4.1
replication
ttRepSubscriberStateSet procedure,
2
ttRepSubscriberWait procedure,
2
ttRepSyncGet,
2
ttRepSyncSet,
2
Replication Agent
ttReplicationStatus procedure,
2
ttRepPolicyGet procedure,
2
ttRepPolicySet procedure,
2
ttRepQueryThresholdGet procedure,
2
ttRepQueryThresholdSet procedure,
2
ttRepStart procedure,
2
ttRepStateSet procedure,
2
ttRepStop procedure,
2
ttRepSubscriberStatus procedure,
2
ttRepXactStatus procedure,
2
ttRepXactTokenGet procedure,
2
ReplicationApplyOrdering attribute,
1.2
,
1.2
ReplicationParallelism attribute,
1.2
,
1.2
ReplicationTrack attribute,
1.2
RepStateGet,
2
restoring databases,
3.2.2
row
maximum length,
4.1
Rowid optimizer flag,
2
row-level locking
attribute setting,
1.2
,
1.2
optimizer flag,
2
,
2
rows
maximum per table,
4.1
running SQL interactively,
3.2.2
S
Scan optimizer flag,
2
serializable isolation mode,
1.2
ServersPerDSN attribute,
1.2
ServerStackSize attribute,
1.2
ShowJoinOrder optimizer flag,
2
sizing databases,
2
,
3.2.2
SQL statement
maximum length,
4.1
SQL, running interactively,
3.2.2
SQLExecDirect
example,
2
SQLQueryTimeout attribute,
1.2
statistics
clearing,
2
,
2
estimating,
2
getting,
2
modifying explicitly (column),
2
,
2
modifying explicitly (table),
2
ttOptClearStats procedure,
2
,
2
ttOptEstimateStats procedure,
2
ttOptGetColStats procedure,
2
updating explicitly,
2
subscriber databases
maximum number,
4.1
maximum number in active standby pair,
4.1
syslog,
3.2.2
T
table partitions maximum,
4.1
table references
maximum number in SQL query,
4.1
table size
estimating,
2
,
3.2.2
tables
ttBulkCp,
3.2.2
TBL_STATS system table
updating explicitly,
2
TblLock optimizer flag,
2
,
2
TCP_Port,
1.2
,
1.2
,
1.2
,
1.2
TCP_Port attribute,
1.2
TCP_Port2 attribute,
1.2
Temporary attribute,
1.2
temporary database,
1.2
TempSize attribute,
1.2
TempWarnThreshold attribute,
1.2
TimesTen Version
displaying,
3.2.2
,
3.2.2
TmpHash optimizer flag,
2
TmpRange optimizer flag,
2
TmpTable optimizer flag,
2
trace information display,
3.2.2
tracing
disabling,
3.2.2
enabling,
3.2.2
options,
3.2.2
transaction commit
and DurableCommits attribute,
1.2
transaction log,
3.2.2
transaction log API
ttSetUserColumnID procedure,
2
ttSetUserTableID procedure,
2
ttAdmin,
3.2.2
ttAgingLRUConfig,
2
ttAgingScheduleNow,
2
ttApplicationContext,
2
,
2
ttBackup,
3.2.2
ttBookmark,
2
,
2
ttBulkCp,
3.2.2
,
3.2.2
TTC_FailoverPortRange,
1.2
TTC_FailoverPortRange attribute,
1.2
TTC_Server,
1.2
TTC_Server attribute,
1.2
TTC_Server_DSN,
1.2
TTC_Server_DSN attribute,
1.2
TTC_Server_DSN2,
1.2
TTC_Server_DSN2 attribute,
1.2
TTC_Server2,
1.2
TTC_Server2 attribute,
1.2
TTC_Timeout,
1.2
TTC_Timeout attribute,
1.2
ttCacheAdvisor,
3.2.2
ttCacheAgingIntervalSet,
2
ttCacheAutorefreshStatsGet,
2
,
2
,
2
,
2
,
2
ttCacheAwtMonitorConfig,
2
ttCacheAwtThresholdGet,
2
ttCacheAWTThresholdSet,
2
ttCacheConfig,
2
ttCacheDbCgStatus,
2
ttCachePolicyGet,
2
ttCachePolicySet,
2
ttCachePropagateFlagSet,
2
,
2
ttCacheSqlGet,
2
,
2
ttCacheStart,
2
,
2
ttCacheStop,
2
,
2
ttCacheUidGet,
2
ttCacheUidPwdSet,
2
,
2
,
2
ttCapture,
3.2.2
ttCheck,
3.2.2
ttCkpt,
2
,
2
,
2
ttCkptBlocking,
2
,
2
ttCkptConfig,
2
ttCkptHistory,
2
,
2
ttCompact,
2
,
2
ttCompactTS,
2
,
2
ttComputeTabSizes,
2
ttConfiguration,
2
ttContext,
2
,
2
ttCWAdmin,
3.2.2
ttDaemonAdmin,
3.2.2
ttDaemonLog,
3.2.2
ttDataStoreStatus,
2
,
2
ttDestroy,
3.2.2
ttDurableCommit,
2
,
2
ttGridAttach,
2
ttGridCGGlobalResume,
2
ttGridcheckOwner,
2
ttGridCreate,
2
ttGridDestroy,
2
ttGridDetach,
2
ttGridDetachAll,
2
ttGridDetachList,
2
ttGridGlobalCGSuspend,
2
ttGridInfo,
2
ttGridNameSet,
2
ttGridNodeStatus,
2
ttHostNameGet,
2
ttHostNameSet,
2
,
2
ttIndexAdviceCaptureDrop,
2
,
2
ttIndexAdviceCaptureEnd,
2
ttIndexAdviceCaptureInfoGet,
2
ttIndexAdviceCaptureOutput,
2
ttIndexAdviceCaptureStart,
2
ttIsql,
3.2.2
error recovery,
3.2.2
IF command,
3.2.2
WHENEVER SQLERROR,
3.2.2
ttLoadFromOracle,
2
ttLockLevel,
2
,
2
ttLockWait,
2
,
2
ttLogHolds,
2
,
2
ttMigrate,
3.2.2
ttmodinstall,
3.2.2
ttOptClearStats,
2
,
2
,
2
ttOptCmdCacheInvalidate,
2
ttOptEstimateStats,
2
,
2
ttOptGetColStats,
2
,
2
ttOptGetFlag,
2
,
2
ttOptGetMaxCmdFreeListCnt,
2
ttOptGetOrder,
2
ttOptSetColIntvlStats,
2
ttOptSetFlag,
2
ttOptSetMaxCmdFreeListCnt,
2
ttOptSetMaxPriCmdFreeListCnt,
2
ttOptSetOrder,
2
ttOptSetTblStats,
2
ttOptShowJoinOrder,
2
ttOptStatsExport,
2
ttOptUpdateStats,
2
ttOptUseIndex,
2
ttPLSQLMemoryStats,
2
ttRamPolicyGet,
2
,
2
ttRamPolicySet,
2
,
2
ttRedundantIndexCheck,
2
ttRepAdmin,
3.2.2
ttRepDeactivate,
2
ttReplicationStatus,
2
ttRepPolicyGet,
2
ttRepPolicySet,
2
ttRepQueryThresholdGet,
2
ttRepQueryThresholdSet,
2
ttRepStart,
2
ttRepStateSet,
2
ttRepStateStore,
2
ttRepStop,
2
ttRepSubscriberStateSet,
2
ttRepSubscriberStatus,
2
ttRepSubscriberWait,
2
ttRepSyncGet,
2
,
2
,
2
ttRepSyncSet,
2
,
2
ttRepSyncSubscriberStatus,
2
ttRepTransmitGet,
2
,
2
ttRepTransmitSet,
2
,
2
ttRepXactStatus,
2
ttRepXactTokenGet,
2
ttRestore,
3.2.2
ttSchema,
3.2.2
ttSetUserColumnID,
2
,
2
ttSetUserTableID,
2
,
2
,
2
ttSize,
2
,
3.2.2
ttSQLCmdCacheInfo,
2
ttSQLCmdCacheInfoGet,
2
ttSQLCmdQueryPlan,
2
ttStatus,
3.2.2
ttSyslogCheck,
3.2.2
ttTableSchemaFromOraQueryGet,
2
ttTail,
3.2.2
ttTraceMon,
3.2.2
ttUser,
1.2
ttuser,
3.2.2
ttVersion,
2
,
2
,
3.2.2
,
3.2.2
ttWarnOnLowMemory,
2
,
2
ttXactAdmin,
3.2.2
ttXactIdGet,
2
ttXactLog,
3.2.2
ttXlaBookmarkCreate,
2
ttXlaBookmarkDelete,
2
ttXlaSubscribe,
2
ttXlaUnsubscribe,
2
TypeMode attribute,
1.2
U
UID,
1.2
UID attribute,
1.2
updating statistics explicitly,
2
UseBoyerMooreStringSearch optimizer flag,
2
user table ID
definition,
2
utilities
access control,
3.2.1
authentication,
3.2.1
privileges,
3.2.1
ttAdmin,
3.2.2
ttBackup,
3.2.2
ttBulkCp,
3.2.2
,
3.2.2
ttCacheAdvisor,
3.2.2
ttCapture,
3.2.2
ttCheck,
3.2.2
ttCWAdmin,
3.2.2
ttDaemonAdmin,
3.2.2
ttDestroy,
3.2.2
ttIsql,
3.2.2
ttMigrate,
3.2.2
ttmodinstall,
3.2.2
ttRepAdmin,
3.2.2
ttRestore,
3.2.2
ttSchema,
3.2.2
ttSize,
3.2.2
ttStatus,
3.2.2
ttSyslogCheck,
3.2.2
ttTail,
3.2.2
ttTraceMon,
3.2.2
ttVersion,
3.2.2
,
3.2.2
ttXactAdmin,
3.2.2
ttXactLog,
3.2.2
V
varying-length column
maximum length,
4.1
,
4.1
W
WaitForConnect attribute,
1.2
WHENEVER SQLERROR command,
3.2.2
X
XLA
bookmark, deleting,
3.2.2
xlabookmarkdelete command
ttIsql utility,
3.2.2
Scripting on this page enhances content navigation, but does not change the content in any way.