9/9

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

OracleNetServiceName 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

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

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

OracleNetServiceName 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