Go to main content
1/11
Contents
Title and Copyright Information
Preface
Audience
Related documents
Conventions
Documentation Accessibility
What's New
New features in release 18.1.4.1.0
New features in release 18.1.2.1.0
New features in release 18.1.1.1.0
1
TimesTen Instance Configuration File
Configuration attributes
Required attributes
Optional attributes
2
Connection Attributes
Required privileges for attributes
List of attributes
Data store attributes
Data Source Name
DataStore
DatabaseCharacterSet
Supported character sets
Description
Driver
Durability
LogDir
Preallocate
ReplicationApplyOrdering
ReplicationParallelism
Temporary
First connection attributes
AutoCreate
BackupFailThreshold
CkptFrequency
CkptLogVolume
CkptRate
CkptReadThreads
Connections
EpochInterval
ForceConnect
ForceDisconnectEnabled
LogAutoTruncate
LogBufMB
LogBufParallelism
LogFileSize
LogFlushMethod
LogPurge
MemoryLock
Overwrite
PermSize
RecoveryThreads
TempSize
General connection attributes
ChannelCreateTimeout
CommitBufferSizeMax
ConnectionName
CreateEpochAtCommit
DDLReplicationAction
DDLReplicationLevel
Diagnostics
DurableCommits
IncludeInCore
Isolation
LockLevel
LockWait
OptimizerHint
PermWarnThreshold
PrivateCommands
PWDCrypt
QueryThreshold
ReplicationTrack
SQLQueryTimeout
SQLQueryTimeoutMSec
TempWarnThreshold
UID and PWD
WaitForConnect
NLS general connection attributes
ConnectionCharacterSet
NLS_LENGTH_SEMANTICS
NLS_NCHAR_CONV_EXCP
NLS_SORT
Supported linguistic sorts
PL/SQL first connection attributes
PLSQL_MEMORY_ADDRESS
PLSQL_MEMORY_SIZE
PLSQL_OPEN_CURSORS
PL/SQL general connection attributes
PLSCOPE_SETTINGS
PLSQL_CCFLAGS
PLSQL_CONN_MEM_LIMIT
PLSQL_OPTIMIZE_LEVEL
PLSQL_SESSION_CACHED_CURSORS
PLSQL_TIMEOUT
TimesTen Cache first connection attributes
CacheAWTMethod
TimesTen Cache database attributes
CacheAWTParallelism
UseCacheConnPool
TimesTen Cache general connection attributes
DynamicLoadEnable
DynamicLoadErrorMode
OracleNetServiceName
OraclePWD
PassThrough
RACCallback
StandbyNetServiceName
TimesTen Client connection attributes
CipherSuites
ClientServer
Encryption
SSLClientAuthentication
TCP_Port
TCP_Port2, TCP_PortN
TTC_ConnectTimeout
TTC_FailoverPortRange
TTC_NoReconnectOnFailover
TTC_Random_Selection
TTC_REDIRECT
TTC_Redirect_Limit
TTC_RollbackRequiredOnFailover
TTC_Server or TTC_Server1
TTC_Server2, TTC_ServerN
TTC_Server_DSN
TTC_Server_DSN2, TTC_Server_DSNn
TTC_TCP_KEEPALIVE_INTVL_MS
TTC_TCP_KEEPALIVE_PROBES
TTC_TCP_KEEPALIVE_TIME_MS
TTC_Timeout
Wallet
TimesTen Server connection attributes
CipherSuites
Encryption
SSLClientAuthentication
MaxConnsPerServer
ServersPerDSN
ServerStackSize
SSLRenegotiationPeriod
SSLRenegotiationSize
Wallet
3
Built-In Procedures
List of built-in procedures
ttAgingLRUConfig
ttAgingScheduleNow
ttApplicationContext
ttBackupStatus
ttBlockInfo
ttBookmark
ttCacheADGStandbyStateGet
ttCacheADGStandbyStateSet
ttCacheADGStandbyTimeoutGet
ttCacheADGStandbyTimeoutSet
ttCacheAllowFlushAwtSet
ttCacheAutorefIntervalStatsGet
ttCacheAutorefresh
ttCacheAutorefreshLogDefrag
ttCacheAutorefreshStatsGet
ttCacheAutorefreshSelectLimit
ttCacheAutorefreshXactLimit
ttCacheAWTMonitorConfig
ttCacheAWTThresholdGet
ttCacheAWTThresholdSet
ttCacheCheck
ttCacheConfig
ttCacheConnPoolApply
ttCacheConnPoolGet
ttCacheConnPoolSet
ttCacheDbCgStatus
ttCacheDDLTrackingConfig
ttCachePolicyGet
ttCachePolicySet
ttCachePropagateFlagSet
ttCacheSqlGet
ttCacheStart
ttCacheStop
ttCacheUidGet
ttCacheUidPwdSet
ttCkpt
ttCkptBlocking
ttCkptConfig
ttCkptHistory
ttCommitBufferStats
ttCommitBufferStatsReset
ttCompact
ttComputeTabSizes
ttConfiguration
ttContext
ttDataStoreStatus
ttDBCompactConfig
ttDBConfig
ttDBWriteConcurrencyModeGet
ttDBWriteConcurrencyModeSet
ttDistributionProgress
ttDurableCommit
ttEpochCreate
ttEpochSessionGet
ttHeapInfo
ttHostNameGet
ttHostNameSet
ttIndexAdviceCaptureDrop
ttIndexAdviceCaptureEnd
ttIndexAdviceCaptureInfoGet
ttIndexAdviceCaptureOutput
ttIndexAdviceCaptureStart
ttLatchStatsGet
ttLoadFromOracle
ttLockLevel
ttLockWait
ttLogHolds
ttMonitorHighWaterReset
ttOptClearStats
ttOptCmdCacheInvalidate
ttOptEstimateStats
ttOptGetColStats
ttOptGetFlag
ttOptGetMaxCmdFreeListCnt
ttOptGetOrder
ttOptSetColIntvlStats
ttOptSetColStats
ttOptSetFlag
ttOptSetMaxCmdFreeListCnt
ttOptSetMaxPriCmdFreeListCnt
ttOptSetOrder
ttOptSetTblStats
ttOptShowJoinOrder
ttOptStatsExport
ttOptUpdateStats
ttOptUseIndex
ttPLSQLMemoryStats
ttRamPolicyAutoReloadGet
ttRamPolicyAutoReloadSet
ttRamPolicyGet
ttRamPolicySet
ttRedundantIndexCheck
ttRepDeactivate
ttReplicationStatus
ttRepPolicyGet
ttRepPolicySet
ttRepQueryThresholdGet
ttRepQueryThresholdSet
ttRepStart
ttRepStateGet
ttRepStateSave
ttRepStateSet
ttRepStop
ttRepSubscriberStateSet
ttRepSubscriberWait
ttRepSyncGet
ttRepSyncSet
ttRepSyncSubscriberStatus
ttRepTransmitGet
ttRepTransmitSet
ttRepXactStatus
ttRepXactTokenGet
ttSetUserColumnID
ttSetUserTableID
ttSize
ttSQLCmdCacheInfo
ttSQLCmdCacheInfoGet
ttSQLCmdQueryPlan
ttSQLExecutionTimeHistogram
ttStatsConfig
ttStatsConfigGet
ttTableSchemaFromOraQueryGet
ttVersion
ttWarnOnLowMemory
ttXactIdGet
ttXlaBookmarkCreate
ttXlaBookmarkDelete
ttXlaSubscribe
ttXlaUnsubscribe
4
TimesTen Scaleout Utilities
Overview
Utilities list
ttGridAdmin
Grid model
Grid objects and object naming
Address formats
Database management operations
Command timeouts and waits
ttGridAdmin operations
Help and general options
Return values
Backup and restore operations
Back up a database (dbBackup)
Delete a database backup (dbBackupDelete)
Display the status of a database backup (dbBackupStatus)
Restore a database (dbRestore)
Display the status of a database restore (dbRestoreStatus)
Connectable operations
Create a connectable (connectableCreate)
Delete a connectable (connectableDelete)
Export a connectable (connectableExport)
List connectables (connectableList)
Modify a connectable (connectableModify)
Data space group operations
Get recommendations for data space group assignments (dataSpaceGroupSuggest)
Database definition operations
Create a database definition (dbdefCreate)
Delete a database definition (dbdefDelete)
Export a database definition (dbdefExport)
List database definitions (dbdefList)
Modify a database definition (dbdefModify)
Database operations
Close a database (dbClose)
Create a database (dbCreate)
Destroy a database (dbDestroy)
Force all connections to disconnect (dbDisconnect)
Check status of forced disconnection (dbDisconnectStatus)
Set or modify the distribution scheme of a database (dbDistribute)
List databases (dbList)
Load a database into memory (dbLoad)
Open a database (dbOpen)
Monitor the status of a database (dbStatus)
Unload a database (dbUnload)
Grid operations
Export sys.odbc.ini for client/server connections outside grid (gridClientExport)
Create a grid (gridCreate)
Display information about the grid (gridDisplay)
Get diagnostic information about the grid (gridDump)
Collect log information about the grid (gridLogCollect)
Modify grid settings (gridModify)
Configure SSH (gridSshConfig)
Host operations
Create a host (hostCreate)
Delete a host (hostDelete)
Execute a command or script on grid hosts (hostExec)
List all hosts in the model (hostList)
Modify a host (hostModify)
Import and export operations
Export a database (dbExport)
Delete a database export (dbExportDelete)
Display the status of a database export (dbExportStatus)
Import a database (dbImport)
Display the status of a database import (dbImportStatus)
Installation operations
Create an installation (installationCreate)
Delete an installation (installationDelete)
Execute a command or script on grid installations (installationExec)
List installations (installationList)
Display status of installations (installationStatus)
Instance operations
Export instance configuration attributes (instanceConfigExport)
Import instance configuration attributes (instanceConfigImport)
Create an instance (instanceCreate)
Delete an instance (instanceDelete)
Execute a command or script on grid instances (instanceExec)
List instances (instanceList)
Modify an instance (instanceModify)
Display status of instances (instanceStatus)
Management instance operations
Start the active management instance (mgmtActiveStart)
Stop the active management instance (mgmtActiveStop)
Switch the active management instance (mgmtActiveSwitch)
Examine management instances (mgmtExamine)
Start the standby management instance (mgmtStandbyStart)
Stop the standby management instance (mgmtStandbyStop)
Display status of management instances (mgmtStatus)
Membership operations
Export the membership configuration file (membershipConfigExport)
Import the membership configuration file (membershipConfigImport)
Model operations
Apply the latest version of the model (modelApply)
Compare models (modelCompare)
Export a version of a model (modelExport)
Import a version of the model (modelImport)
List model versions (modelList)
Oracle Database operations
Export a sqlnet file (SQLNetExport)
Import a sqlnet file (SQLNetImport)
Export TNS names (TNSNamesExport)
Import TNS names (TNSNamesImport)
Physical group operations
Create a physical group (physicalCreate)
Delete a physical group (physicalDelete)
List physical groups (physicalList)
Repository operations
Attach a repository (repositoryAttach)
Create a repository (repositoryCreate)
Detach a repository (repositoryDetach)
List repositories (repositoryList)
ttGridRollout
5
Utilities
Overview
Utilities List
ttAdmin
Help, version, and query options
Set database loading policies
Open or close a database
Force disconnect
Set cache policies
Set replication policies
ttAdoptStores
ttBackup
ttBulkCp
ttCapture
ttCheck
ttCWAdmin
ttDaemonAdmin
ttDaemonLog
ttDestroy
ttInstallationCheck
ttInstallDSN
ttInstanceCreate
ttInstanceDestroy
ttInstanceModify
ttIsql
Commands
Syntax for the IF-THEN-ELSE command construct
Syntax for the WHENEVER SQLERROR command
Set/show attributes
Comment syntax
Command shortcuts
Parameters
Examples
ttMigrate
ttRepAdmin
Help and version information
Database information
Subscriber database operations
Duplicate a database
Wait for updates to complete
Replication status
ttRestore
ttSchema
ttSize
ttStats
TimesTen Classic
TimesTen Scaleout
ttStatus
ttTail
ttTraceMon
ttUser
ttVersion
ttXactAdmin
ttXactLog
6
System Limits
System limits and defaults
Limits on number of open files
Path names
Index
Scripting on this page enhances content navigation, but does not change the content in any way.