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
connection attributes, 1.1
utilities, 1.2, 3.2.1
administration
daemon, ttDaemonAdmin utility, 3.2.2
database, ttAdmin utility, 3.2.2
AllFlags optimizer flag, 2
attributes--see connection attributes
authentication, utilities, 1.2
AutoCreate connection attribute, 1.2

B

backup
ttBackup utility, 3.2.2
ttBackupStatus built-in procedure, 2
BranchAndBound optimizer flag, 2
built-in procedures
calling, 2
ttAgingLRUConfig, 2
ttAgingScheduleNow, 2
ttApplicationContext, 2
ttBackupStatus, 2
ttBlockInfo, 2
ttBookmark, 2
ttCacheAllowFlushAwtSet, 2
ttCacheAutorefIntervalStatsGet, 2
ttCacheAutorefresh, 2
ttCacheAutorefreshLogDefrag, 2
ttCacheAutorefreshSelectLimit, 2
ttCacheAutorefreshStatsGet, 2
ttCacheAutorefreshXactLimit, 2
ttCacheAWTMonitorConfig, 2
ttCacheAWTThresholdGet, 2
ttCacheAWTThresholdSet, 2
ttCacheCheck, 2
ttCacheConfig, 2
ttCacheDbCgStatus, 2
ttCachePolicyGet, 2
ttCachePolicySet, 2
ttCachePropagateFlagSet, 2
ttCacheSqlGet, 2
ttCacheStart, 2
ttCacheStop, 2
ttCacheUidGet, 2
ttCacheUidPwdSet, 2
ttCkpt, 2
ttCkptBlocking, 2
ttCkptConfig, 2
ttCkptHistory, 2
ttCommitBufferStats, 2
ttCommitBufferStatsReset, 2
ttCompact, 2
ttCompactTS, 2
ttComputeTabSizes, 2
ttConfiguration, 2
ttContext, 2
ttDataStoreStatus, 2
ttDBConfig, 2
ttDbWriteConcurrencyModeGet, 2
ttDbWriteConcurrencyModeSet, 2
ttDurableCommit, 2
ttGridAttach, 2
ttGridCheckOwner, 2
ttGridCreate, 2
ttGridDestroy, 2
ttGridDetach, 2
ttGridDetachAll, 2
ttGridDetachList, 2
ttGridFirstMemberAttach, 2
ttGridGlobalCGResume, 2
ttGridGlobalCGSuspend, 2
ttGridInfo, 2
ttGridNameSet, 2
ttGridNodeStatus, 2
ttHostNameGet, 2
ttHostNameSet, 2
ttIndexAdviceCaptureDrop, 2
ttIndexAdviceCaptureEnd, 2
ttIndexAdviceCaptureInfoGet, 2
ttIndexAdviceCaptureOutput, 2
ttIndexAdviceCaptureStart, 2
ttLoadFromOracle, 2
ttLockLevel, 2
ttLockWait, 2
ttLogHolds, 2
ttMonitorHighWaterReset, 2
ttOptClearStats, 2
ttOptCmdCacheInvalidate, 2
ttOptEstimateStats, 2
ttOptGetColStats, 2
ttOptGetFlag, 2
ttOptGetMaxCmdFreeListCnt, 2
ttOptGetOrder, 2
ttOptSetColIntvlStats, 2
ttOptSetColStats, 2
ttOptSetFlag, 2
ttOptSetMaxCmdFreeListCnt, 2
ttOptSetMaxPriCmdFreeListCnt, 2
ttOptSetOrder, 2
ttOptSetTblStats, 2
ttOptShowJoinOrder, 2
ttOptStatsExport, 2
ttOptUpdateStats, 2
ttOptUseIndex, 2
ttPLSQLMemoryStats, 2
ttRamPolicyAutoReloadGet, 2
ttRamPolicyAutoReloadSet, 2
ttRamPolicyGet, 2
ttRamPolicySet, 2
ttRedundantIndexCheck, 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
ttRepTransmitSet, 2
ttRepXactStatus, 2
ttRepXactTokenGet, 2
ttSetUserColumnID, 2
ttSetUserTableID, 2
ttSize, 2
ttSQLCmdCacheInfo, 2
ttSQLCmdCacheInfo2, 2
ttSQLCmdCacheInfoGet, 2
ttSQLCmdQueryPlan, 2
ttSQLExecutionTimeHistogram, 2
ttStatsConfig, 2
ttTableSchemaFromOraQueryGet, 2
ttVersion, 2
ttWarnOnLowMemory, 2
ttXactIdGet, 2
ttXlaBookmarkCreate, 2
ttXlaBookmarkDelete, 2
ttXlaSubscribe, 2
ttXlaUnsubscribe, 2
bulk copy, ttBulkCp utility, 3.2.2

C

cache
DynamicLoadEnable connection attribute, 1.2
DynamicLoadErrorMode connection attribute, 1.2
OracelNetServiceName connection attribute, 1.2
OraclePWD connection attribute, 1.2
PassThrough connection attribute, 1.2
policy, ttAdmin utility, 3.2.2
RACCallback connection attribute, 1.2
ttCacheAdvisor utility, 3.2.2
cache grid--see ttGridXXX built-in procedures
cache--also see TimesTen Cache
CacheAWTMethod connection attribute, 1.2
CacheAWTParallelism connection attribute, 1.2
CacheGridEnable connection attribute, 1.2
CacheGridMsgWait connection attribute, 1.2
cache--see ttCacheXXX built-in procedures
character sets
ConnectionCharacterSet connection attribute, 1.2
DatabaseCharacterSet connection attribute, 1.2
supported character sets, 1.2
checkpoints
CkptFrequency connection attribute, 1.2
CkptLogVolume connection attribute, 1.2
CkptRate connection attribute, 1.2
ttCkpt built-in procedure, 2
ttCkptBlocking built-in procedure, 2
ttCkptConfig built-in procedure, 2
ttCkptHistory built-in procedure, 2
CkptFrequency connection attribute, 1.2
CkptLogVolume connection attribute, 1.2
CkptRate connection attribute, 1.2
client connection
attributes, 1.2, 1.2
concurrent shared memory segment connections per TimesTen instance, maximum, 4.1
shared memory segment size, maximum, 4.1
statement handles, maximum per shared memory segment, 4.1
TCP_Port connection attribute, 1.2
TCP_Port2 connection attribute, 1.2
TTC_FailoverPortRange connection attribute, 1.2
TTC_Server connection attribute, 1.2
TTC_Server_DSN connection attribute, 1.2
TTC_Server_DSN2 connection attribute, 1.2
TTC_Server2 connection attribute, 1.2
TTC_Timeout connection attribute, 1.2
UID and PWD connection attributes, 1.2
clusterware, ttCWAdmin utility, 3.2.2
COL_STATS system table, 2
column ID, XLA, ttSetUserColumnID built-in procedure, 2
columns
fixed-length column, maximum length, 4.1
maximum length, varying-length column, 4.1
maximum number in index, 4.1
maximum per table, 4.1
maximum, GROUP BY clause, 4.1
maximum, ORDER BY clause, 4.1
replicated column, maximum length, 4.1
command cache, SQL
query plans, ttSQLCmdQueryPlan built-in procedure, 2
ttSQLCmdCacheInfo built-in procedure, 2
ttSQLCmdCacheInfo2 built-in procedure, 2
ttSQLCmdCacheInfoGet built-in procedure, 2
ttSQLCmdQueryPlan built-in procedure, 2
commit
DDLCommitBehavior connection attribute, 1.2
DurableCommits connection attribute, 1.2
CommitBufferSizeMax connection attribute, 1.2
compacting database
ttCompact built-in procedure, 2
ttCompactTS built-in procedure, 2
concurrency
concurrent application connections, maximum, 4.1
concurrent client connections, maximum, 4.1
concurrent connections, maximum, 4.1
concurrent connections, system plus applications, maximum, 4.1
LockLevel connection attribute, 1.2
LockWait connection attribute, 1.2
connection
concurrent application connections, maximum, 4.1
concurrent client connections, maximum, 4.1
concurrent connections, maximum, 4.1
concurrent connections, system plus applications, maximum, 4.1
conflicts, 1.2
ConnectionCharacterSet connection attribute, 1.2
failure, MatchLogOpts connection attribute, 1.2
MaxConnsPerServer connection attribute, 1.2
PL/SQL statements, prepared, maximum, 4.1
UID and PWD connection attributes, 1.2
WaitForConnect connection attribute, 1.2
connection 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
client connection attributes, 1.2, 1.2
CommitBufferSizeMax, 1.2
ConnectionCharacterSet, 1.2
ConnectionName, 1.2
Connections, 1.2
Data Source Name, 1.2
data store attributes, 1.2, 1.2
DatabaseCharacterSet, 1.2
DataStore, 1.2
DDLCommitBehavior, 1.2
DDLReplicationAction, 1.2
DDLReplicationLevel, 1.2
Description, 1.2
Diagnostics, 1.2
Driver, 1.2
DuplicateBindMode, 1.2
DurableCommits, 1.2
DynamicLoadEnable, 1.2
DynamicLoadErrorMode, 1.2
first connection attributes, 1.2, 1.2
ForceConnect, 1.2
general connection attributes, 1.2, 1.2
Isolation, 1.2
LockLevel, 1.2
LockWait, 1.2
LogAutoTruncate, 1.2
LogBufMB, 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 general connection attributes, 1.2, 1.2
NLS_LENGTH_SEMANTICS, 1.2
NLS_NCHAR_CONV_EXCP, 1.2
NLS_SORT, 1.2
OracelNetServiceName, 1.2
OraclePWD, 1.2
Overwrite, 1.2
PassThrough, 1.2
PermSize, 1.2
PermWarnThreshold, 1.2
PLSCOPE_SETTINGS, 1.2
PLSQL, 1.2
PL/SQL first connection attributes, 1.2, 1.2
PL/SQL general connection attributes, 1.2, 1.2
PLSQL_CCFLAGS, 1.2
PLSQL_MEMORY_ADDRESS, 1.2
PLSQL_MEMORY_SIZE, 1.2
PLSQL_OPTIMIZE_LEVEL, 1.2
PLSQL_TIMEOUT, 1.2
Preallocate, 1.2
PrivateCommands, 1.2
privileges, 1.1
PWD, 1.2
PWDCrypt, 1.2
QueryThreshold, 1.2
RACCallback, 1.2
RangeIndexType, 1.2
ReceiverThreads, 1.2
RecoveryThreads, 1.2
ReplicationApplyOrdering, 1.2
ReplicationParallelism, 1.2
ReplicationTrack, 1.2
server connection attributes, 1.2, 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
TimesTen Cache database attributes, 1.2, 1.2
TimesTen Cache first connection attributes, 1.2, 1.2
TimesTen Cache general connection attributes, 1.2, 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
ttConfiguration built-in procedure (check values), 2
TypeMode, 1.2
UID, 1.2
WaitForConnect, 1.2
ConnectionCharacterSet connection attribute, 1.2
ConnectionName connection attribute, 1.2
Connections connection attribute, 1.2
consistency checking, ttCheck utility, 3.2.2
correlation name, optimizer, 2
creation, database
AutoCreate connection attribute, 1.2
Overwrite connection attribute, 1.2
PermSize connection attribute, 1.2
Preallocate connection attribute, 1.2
RecoveryThreads connection attribute, 1.2
TempSize connection attribute, 1.2

D

daemon
administration, ttDaemonAdmin utility, 3.2.2
log, ttDaemonLog utility, 3.2.2
Data Source Name connection attribute, 1.2
data store attributes, 1.2, 1.2
data types, TypeMode connection attribute, 1.2
DatabaseCharacterSet connection attribute, 1.2
DataStore connection attribute, 1.2
DDLCommitBehavior connection attribute, 1.2
DDLReplicationAction connection attribute, 1.2
DDLReplicationLevel connection attribute, 1.2
Default optimizer flag, 2
Description connection attribute, 1.2
destroy, ttDestroy utility, 3.2.2
Diagnostics connection attribute, 1.2
disk space, file system, Preallocate connection attribute, 1.2
Driver connection attribute, 1.2
DuplicateBindMode connection attribute, 1.2
durable commits, ttDurableCommit built-in procedure, 2
DurableCommits connection attribute, 1.2
DynamicLoadEnable connection attribute, 1.2
DynamicLoadEnable optimizer flag, 2
DynamicLoadErrorMode connection attribute, 1.2
DynamicLoadErrorMode optimizer flag, 2

E

error message, maximum length, 4.1
expressions, SELECT statement, maximum, 4.1

F

file system disk space, Preallocate connection attribute, 1.2
files, open, maximum, 4.2
Firs tRow optimizer flag, 2
first connection attributes, 1.2, 1.2
fixed-length column, maximum length, 4.1
ForceCompile optimizer flag, 2
ForceConnect connection attribute, 1.2
fragmentation
eliminating with ttCompact built-in procedure, 2
eliminating with ttCompactTS built-in procedure, 2

G

general connection attributes, 1.2, 1.2
GenPlan optimizer flag, 2
GlobalLocalJoin optimizer flag, 2
GlobalProcessing optimizer flag, 2
grid, cache--see ttGridXXX built-in procedures
GROUP BY clause, maximum columns, 4.1

H

Hash optimizer flag, 2
HashGb optimizer flag, 2
host name
ttHostNameGet built-in procedure, 2
ttHostNameSet built-in procedure, 2

I

IF-THEN-ELSE command, ttIsql utility, 3.2.2
Index Advisor--see ttIndexAdviceXXX built-in procedures
IndexedOR optimizer flag, 2
indexes
columns, maximum, 4.1
maximum per table, 4.1
RangeIndexType connection attribute, 1.2
redundant indexes check, 2
Isolation connection attribute, 1.2

J

join order, maximum length, 4.1

L

limits, system, 4
limits--also see maximum
Load from Oracle
ttIsql createandloadfromoraquery command, 3.2.2
ttLoadFromOracle built-in procedure, 2
ttTableSchemaFromOraQueryGet built-in procedure, 2
locking, database
LockLevel connection attribute, 1.2
LockWait connection attribute, 1.2
ttLockLevel built-in procedure, 2
ttLockWait built-in procedure, 2
LockLevel connection attribute, 1.2
LockWait connection attribute, 1.2
log
buffer size, LogBufMB connection attribute, 1.2
daemon, ttDaemonLog utility, 3.2.2
directory, LogDir connection attribute, 1.2
file size, LogFileSize connection attribute, 1.2
flush, LogFlushMethod connection attribute, 1.2
holds, ttLogHolds built-in procedure, 2
parallelism, LogBufParallelism connection attribute, 1.2
purge, LogPurge connection attribute, 1.2
purge, MatchLogOpts connection attribute, 1.2
LogAutoTruncate connection attribute, 1.2
LogBufMB connection attribute, 1.2
LogBufParallelism connection attribute, 1.2
LogDir connection attribute, 1.2
LogFileSize connection attribute, 1.2
LogFlushMethod connection attribute, 1.2
LogPurge connection attribute, 1.2

M

MatchLogOpts connection attribute, 1.2
MaxConnsPerServer connection attribute, 1.2
maximum
basic name, length, 4.1
columns per table, 4.1
columns, GROUP BY clause, 4.1
columns, ORDER BY clause, 4.1
concurrent application connections, 4.1
concurrent client connections, 4.1
concurrent connections, 4.1
concurrent connections system plus applications, 4.1
concurrent shared memory segment client connections per TimesTen instance, 4.1
database name, length, 4.1
error message length, 4.1
expressions, SELECT statement, 4.1
files open, 4.2
fixed-length column, length, 4.1
index, number of columns, 4.1
indexes per table, 4.1
join order length, 4.1
nesting subqueries, depth, 4.1
partitions per table, 4.1
path name, length, database in AWT cache group, 4.1
PL/SQL blocks, recently used, cached, 4.1
PL/SQL statements, prepared, per connection, 4.1
predicate string, SYS.PLAN table, length, 4.1
propagator databases, 4.1
replicated column, length, 4.1
row, cumulative length of fixed-length columns, 4.1
shared memory segment size, client connections, 4.1
SQL statement, length, 4.1
statement handles per shared memory segment, client connections, 4.1
subscriber databases, 4.1
subscriber databases, active standby pair, 4.1
table references, SQL query, 4.1
varying-length column, length, 4.1
memory
low memory warning, ttWarnOnLowMemory built-in procedure, 2
MemoryLock connection attribute, 1.2
out-of-memory warnings, PermWarnThreshold connection attribute, 1.2
out-of-memory warnings, TempWarnThreshold connection attribute, 1.2
permanent, PermSize connection attribute, 1.2
temporary, TempSize connection attribute, 1.2
MemoryLock connection attribute, 1.2
MergeJoin optimizer flag, 2
metrics--see ttStats
migrate, ttMigrate utility, 3.2.2
minimum database size, 4.1
multibyte characters, path name, non-support, 4.3

N

name
basic, maximum length, 4.1
database, maximum length, 4.1
NestedLoop optimizer flag, 2
nesting subqueries, maximum depth, 4.1
NLS general connection attributes, 1.2, 1.2
NLS_LENGTH_SEMANTICS connection attribute, 1.2
NLS_NCHAR_CONV_EXCP connection attribute, 1.2
NLS_SORT connection attribute, 1.2
NoRemRowIdOpt optimizer flag, 2

O

optimizer
correlation name, 2
execution plans, generation, ttOptUseIndex built-in procedure, 2
ttOptSetOrder built-in procedure, 2
optimizer flags
AllFlags, 2
BranchAndBound, 2
Default, 2
DynamicLoadEnable, 2
DynamicLoadErrorMode, 2
FirstRow, 2
ForceCompile, 2
GenPlan, 2
GlobalLocalJoin, 2
GlobalProcessing, 2
Hash, 2
HashGb, 2
IndexedOR, 2
MergeJoin, 2
NestedLoop, 2
NoRemRowIdOpt, 2
PassThrough, 2
Range, 2
Rowid, 2
RowLock, 2, 2
Scan, 2
settings, ttOptGetFlag built-in procedure, 2
settings, ttOptSetFlag built-in procedure, 2
ShowJoinOrder, 2
TblLock, 2, 2
TmpHash, 2
TmpRange, 2
TmpTable, 2
UseBoyerMooreStringSearch, 2
OracelNetServiceName connection attribute, 1.2
OraclePWD connection attribute, 1.2
ORDER BY clause, maximum columns, 4.1
Overwrite connection attribute, 1.2

P

parallel replication
ReplicationApplyOrdering connection attribute, 1.2
ReplicationParallelism connection attribute, 1.2
partitions, maximum per table, 4.1
PassThrough connection attribute, 1.2
PassThrough optimizer flag, 2
password
OraclePWD connection attribute, 1.2
PWD connection attribute, 1.2
PWDCrypt connection attribute, 1.2
ttUser utility, 3.2.2
path name
maximum length, database in AWT cache group, 4.1
multibyte characters, non-support, 4.3
PermSize connection attribute, 1.2
PermWarnThreshold connection attribute, 1.2
PLSCOPE_SETTINGS connection attribute, 1.2
PL/SQL blocks, recently used, maximum cached per session, 4.1
PLSQL connection attribute, 1.2
PL/SQL first connection attributes, 1.2, 1.2
PL/SQL general connection attributes, 1.2, 1.2
PL/SQL statements, prepared, maximum per connection, 4.1
PLSQL_CCFLAGS connection attribute, 1.2
PLSQL_MEMORY_ADDRESS connection attribute, 1.2
PLSQL_MEMORY_SIZE connection attribute, 1.2
PLSQL_OPTIMIZE_LEVEL connection attribute, 1.2
PLSQL_TIMEOUT connection attribute, 1.2
Preallocate connection attribute, 1.2
predicate string, SYS.PLAN table, maximum length, 4.1
PrivateCommands connection attribute, 1.2
propagator databases, maximum, 4.1
PWD connection attribute, 1.2
PWDCrypt connection attribute, 1.2

Q

query
nesting subqueries, maximum depth, 4.1
plans, ttSQLCmdQueryPlan built-in procedure, 2
table references, maximum, 4.1
QueryThreshold connection attribute, 1.2

R

RACCallback connection attribute, 1.2
ram policy, ttAdmin utility, 3.2.2
ram policy--see ttRamPolicyXXX built-in procedures
Range optimizer flag, 2
RangeIndexType connection attribute, 1.2
ReceiverThreads connection attribute, 1.2
RecoveryThreads connection attribute, 1.2
replicated column, maximum length, 4.1
replication
DDLReplicationAction connection attribute, 1.2
DDLReplicationLevel connection attribute, 1.2
policy, ttAdmin utility, 3.2.2
ReceiverThreads connection attribute, 1.2
ttCWAdmin utility, 3.2.2
ttRepAdmin utility, 3.2.2
replication--also see ttRepXXX built-in procedures
ReplicationApplyOrdering connection attribute, 1.2
ReplicationParallelism connection attribute, 1.2
ReplicationTrack connection attribute, 1.2
restore, ttRestore utility, 3.2.2
row, maximum cumulative length of fixed-length columns, 4.1
Rowid optimizer flag, 2
row-level locking, optimizer flag, 2, 2
RowLock optimizer flag, 2, 2

S

Scan optimizer flag, 2
schema, ttSchema utility, 3.2.2
SELECT statement, expressions, maximum, 4.1
server connection attributes, 1.2, 1.2
ServersPerDSN connection attribute, 1.2
ServerStackSize connection attribute, 1.2
session, PL/SQL blocks, recently used, maximum cached, 4.1
shared memory segment
concurrent client connections per TimesTen instance, maximum, 4.1
size, maximum, client connections, 4.1
ShowJoinOrder optimizer flag, 2
size, database, minimum, 4.1
size, table
ttSize built-in procedure, 2
ttSize utility, 3.2.2
SQL command cache
query plans, ttSQLCmdQueryPlan built-in procedure, 2
ttSQLCmdCacheInfo built-in procedure, 2
ttSQLCmdCacheInfo2 built-in procedure, 2
ttSQLCmdCacheInfoGet built-in procedure, 2
ttSQLCmdQueryPlan built-in procedure, 2
SQL query, table references, maximum, 4.1
SQL statement, maximum length, 4.1
SQLQueryTimeout connection attribute, 1.2
statement handles, maximum per shared memory segment, client connections, 4.1
statement, SQL, maximum length, 4.1
statistics
clearing stats, ttOptClearStats built-in procedure, 2
configuration, ttStatsConfig built-in procedure, 2
estimating, ttOptEstimateStats built-in procedure, 2
getting, ttOptGetColStats built-in procedure, 2
modifying explicitly (column), ttOptSetColIntvlStats built-in procedure, 2
modifying explicitly (column), ttOptSetColStats built-in procedure, 2
modifying explicitly (table), ttOptSetTblStats built-in procedure, 2
PL/SQL memory, ttPLSQLMemoryStats built-in procedure, 2
TBL_STATS and COL_STATS system tables, 2
ttStats utility, 3.2.2
updating explicitly, ttOptUpdateStats built-in procedure, 2
status
ttDataStoreStatus built-in procedure, 2
ttStatus utility, 3.2.2
subqueries, nesting, maximum depth, 4.1
subscriber databases
maximum, 4.1
maximum, active standby pair, 4.1
syslog (UNIX), 3.2.2
SYS.PLAN table, predicate string, maximum length, 4.1
system table ID, XLA, ttSetUserTableID built-in procedure, 2

T

table
columns, maximum, 4.1
indexes, maximum, 4.1
partitions, maximum, 4.1
references, SQL query, maximum, 4.1
size, ttSize built-in procedure, 2
size, ttSize utility, 3.2.2
TBL_STATS system table, 2
TblLock optimizer flag, 2, 2
TCP_Port connection attribute, 1.2
TCP_Port2 connection attribute, 1.2
Temporary connection attribute, 1.2
temporary database, Temporary connection attribute, 1.2
TempSize connection attribute, 1.2
TempWarnThreshold connection attribute, 1.2
threads
ReceiverThreads connection attribute, 1.2
RecoveryThreads connection attribute, 1.2
timeout
PLSQL_TIMEOUT connection attribute, 1.2
SQLQueryTimeout connection attribute, 1.2
TTC_Timeout connection attribute, 1.2
TimesTen Cache database attributes, 1.2, 1.2
TimesTen Cache first connection attributes, 1.2, 1.2
TimesTen Cache general connection attributes, 1.2, 1.2
TmpHash optimizer flag, 2
TmpRange optimizer flag, 2
TmpTable optimizer flag, 2
tracing
enabling/disabling, ttTraceMon utility, 3.2.2
information display, ttTail utility, 3.2.2
transaction
administration, ttXactAdmin utility, 3.2.2
commit, DDLCommitBehavior connection attribute, 1.2
commit, DurableCommits connection attribute, 1.2
ID, ttXactIdGet built-in procedure, 2
log, ttXactLog utility, 3.2.2
transaction log API--see XLA
ttAdmin utility, 3.2.2
ttAdoptStores utility, 3.2.2
ttAgingLRUConfig built-in procedure, 2
ttAgingScheduleNow built-in procedure, 2
ttApplicationContext built-in procedure, 2
ttBackup utility, 3.2.2
ttBackupStatus built-in procedure, 2
ttBlockInfo built-in procedure, 2
ttBookmark built-in procedure, 2
ttBulkCp utility, 3.2.2
TTC_FailoverPortRange connection attribute, 1.2
TTC_Server connection attribute, 1.2
TTC_Server_DSN connection attribute, 1.2
TTC_Server_DSN2 connection attribute, 1.2
TTC_Server2 connection attribute, 1.2
TTC_Timeout connection attribute, 1.2
ttCacheAdvisor utility, 3.2.2
ttCacheAllowFlushAwtSet built-in procedure, 2
ttCacheAutorefIntervalStatsGet built-in procedure, 2
ttCacheAutorefresh built-in procedure, 2
ttCacheAutorefreshLogDefrag built-in procedure, 2
ttCacheAutorefreshSelectLimit built-in procedure, 2
ttCacheAutorefreshStatsGet built-in procedure, 2
ttCacheAutorefreshXactLimit built-in procedure, 2
ttCacheAWTMonitorConfig built-in procedure, 2
ttCacheAWTThresholdGet built-in procedure, 2
ttCacheAWTThresholdSet built-in procedure, 2
ttCacheCheck built-in procedure, 2
ttCacheConfig built-in procedure, 2
ttCacheDbCgStatus built-in procedure, 2
ttCachePolicyGet built-in procedure, 2
ttCachePolicySet built-in procedure, 2
ttCachePropagateFlagSet built-in procedure, 2
ttCacheSqlGet built-in procedure, 2
ttCacheStart built-in procedure, 2
ttCacheStop built-in procedure, 2
ttCacheUidGet built-in procedure, 2
ttCacheUidPwdSet built-in procedure, 2
ttCapture utility, 3.2.2
ttCheck utility, 3.2.2
ttCkpt built-in procedure, 2
ttCkptBlocking built-in procedure, 2
ttCkptConfig built-in procedure, 2
ttCkptHistory built-in procedure, 2
ttCommitBufferStats built-in procedure, 2
ttCommitBufferStatsReset built-in procedure, 2
ttCompact built-in procedure, 2
ttCompactTS built-in procedure, 2
ttComputeTabSizes built-in procedure, 2
ttConfiguration built-in procedure, 2
ttContext built-in procedure, 2
ttCWAdmin utility, 3.2.2
ttDaemonAdmin utility, 3.2.2
ttDaemonLog utility, 3.2.2
ttDataStoreStatus built-in procedure, 2
ttDBConfig built-in procedure, 2
ttDbWriteConcurrencyModeGet built-in procedure, 2
ttDbWriteConcurrencyModeSet built-in procedure, 2
ttDestroy utility, 3.2.2
ttDurableCommit built-in procedure, 2
ttGridAttach built-in procedure, 2
ttGridCheckOwner built-in procedure, 2
ttGridCreate built-in procedure, 2
ttGridDestroy built-in procedure, 2
ttGridDetach built-in procedure, 2
ttGridDetachAll built-in procedure, 2
ttGridDetachList built-in procedure, 2
ttGridFirstMemberAttach built-in procedure, 2
ttGridGlobalCGResume built-in procedure, 2
ttGridGlobalCGSuspend built-in procedure, 2
ttGridInfo built-in procedure, 2
ttGridNameSet built-in procedure, 2
ttGridNodeStatus built-in procedure, 2
ttHostNameGet built-in procedure, 2
ttHostNameSet built-in procedure, 2
ttIndexAdviceCaptureDrop built-in procedure, 2
ttIndexAdviceCaptureEnd built-in procedure, 2
ttIndexAdviceCaptureInfoGet built-in procedure, 2
ttIndexAdviceCaptureOutput built-in procedure, 2
ttIndexAdviceCaptureStart built-in procedure, 2
ttIsql utility, 3.2.2
ttLoadFromOracle built-in procedure, 2
ttLockLevel built-in procedure, 2
ttLockWait built-in procedure, 2
ttLogHolds built-in procedure, 2
ttMigrate utility, 3.2.2
ttmodinstall utility, 3.2.2
ttMonitorHighWaterReset built-in procedure, 2
ttOptClearStats built-in procedure, 2
ttOptCmdCacheInvalidate built-in procedure, 2
ttOptEstimateStats built-in procedure, 2
ttOptGetColStats built-in procedure, 2
ttOptGetFlag built-in procedure, 2
ttOptGetMaxCmdFreeListCnt built-in procedure, 2
ttOptGetOrder built-in procedure, 2
ttOptSetColIntvlStats built-in procedure, 2
ttOptSetColStats built-in procedure, 2
ttOptSetFlag built-in procedure, 2
ttOptSetMaxCmdFreeListCnt built-in procedure, 2
ttOptSetMaxPriCmdFreeListCnt built-in procedure, 2
ttOptSetOrder built-in procedure, 2
ttOptSetTblStats built-in procedure, 2
ttOptShowJoinOrder built-in procedure, 2
ttOptStatsExport built-in procedure, 2
ttOptUpdateStats built-in procedure, 2
ttOptUseIndex built-in procedure, 2
ttPLSQLMemoryStats built-in procedure, 2
ttRamPolicyAutoReloadGet built-in procedure, 2
ttRamPolicyAutoReloadSet built-in procedure, 2
ttRamPolicyGet built-in procedure, 2
ttRamPolicySet built-in procedure, 2
ttRedundantIndexCheck built-in procedure, 2
ttRepAdmin utility, 3.2.2
ttRepDeactivate built-in procedure, 2
ttReplicationStatus built-in procedure, 2
ttRepPolicyGet built-in procedure, 2
ttRepPolicySet built-in procedure, 2
ttRepQueryThresholdGet built-in procedure, 2
ttRepQueryThresholdSet built-in procedure, 2
ttRepStart built-in procedure, 2
ttRepStateGet built-in procedure, 2
ttRepStateSave built-in procedure, 2
ttRepStateSet built-in procedure, 2
ttRepStop built-in procedure, 2
ttRepSubscriberStateSet built-in procedure, 2
ttRepSubscriberWait built-in procedure, 2
ttRepSyncGet built-in procedure, 2
ttRepSyncSet built-in procedure, 2
ttRepSyncSubscriberStatus built-in procedure, 2
ttRepTransmitGet built-in procedure, 2
ttRepTransmitSet built-in procedure, 2
ttRepXactStatus built-in procedure, 2
ttRepXactTokenGet built-in procedure, 2
ttRestore utility, 3.2.2
ttSchema utility, 3.2.2
ttSetUserColumnID built-in procedure, 2
ttSetUserTableID built-in procedure, 2
ttSize built-in procedure, 2
ttSize utility, 3.2.2
ttSQLCmdCacheInfo built-in procedure, 2
ttSQLCmdCacheInfo2 built-in procedure, 2
ttSQLCmdCacheInfoGet built-in procedure, 2
ttSQLCmdQueryPlan built-in procedure, 2
ttSQLExecutionTimeHistogram built-in procedure, 2
ttStats utility
description, 3.2.2
example, monitor, 3.2.2
example, snapshot, 3.2.2
examples, reports, 3.2.2
ttStatsConfig built-in procedure, 2
ttStatus utility, 3.2.2
ttSysLogCheck utility, 3.2.2
ttTableSchemaFromOraQueryGet built-in procedure, 2
ttTail utility, 3.2.2
ttTraceMon utility, 3.2.2
ttUser utility, 3.2.2
ttVersion built-in procedure, 2
ttVersion utility, 3.2.2
ttWarnOnLowMemory built-in procedure, 2
ttXactAdmin utility, 3.2.2
ttXactIdGet built-in procedure, 2
ttXactLog utility, 3.2.2
ttXlaBookmarkCreate built-in procedure, 2
ttXlaBookmarkDelete built-in procedure, 2
ttXlaSubscribe built-in procedure, 2
ttXlaUnsubscribe built-in procedure, 2
TypeMode connection attribute, 1.2

U

UID connection attribute, 1.2
UseBoyerMooreStringSearch optimizer flag, 2
user table ID, XLA, ttSetUserTableID built-in procedure, 2
utilities
access control, 3.2.1
authentication, 1.2, 3.2.1
privileges, 3.2.1
ttAdmin, 3.2.2
ttAdoptStores, 3.2.2
ttBackup, 3.2.2
ttBulkCp, 3.2.2
ttCacheAdvisor, 3.2.2
ttCapture, 3.2.2
ttCheck, 3.2.2
ttCWAdmin, 3.2.2
ttDaemonAdmin, 3.2.2
ttDaemonLog, 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
ttStats, 3.2.2
ttStatus, 3.2.2
ttSysLogCheck, 3.2.2
ttTail, 3.2.2
ttTraceMon, 3.2.2
ttUser, 3.2.2
ttVersion, 3.2.2
ttXactAdmin, 3.2.2
ttXactLog, 3.2.2

V

varying-length column, maximum length, 4.1
version, TimesTen
ttVersion built-in procedure, 2
ttVersion utility, 3.2.2

W

WaitForConnect connection attribute, 1.2
WHENEVER SQLERROR command, ttIsql utility, 3.2.2

X

XLA
bookmark, managing, ttIsql utility, 3.2.2
column ID, ttSetUserColumnID built-in procedure, 2
system table ID, ttSetUserTableID built-in procedure, 2
ttBookmark built-in procedure, 2
ttXlaBookMarkCreate built-in procedure, 2
ttXlaBookmarkDelete built-in procedure, 2
ttXlaSubscribe built-in procedure, 2
ttXlaUnsubscribe built-in procedure, 2
user table ID, ttSetUserTableID built-in procedure, 2