List of Connection Attributes

These are the connection attributes defined for TimesTen, with their types, and descriptions.

Name and Type	Description
AutoCreate First connection attribute	Specifies that the first connection creates the database if it does not exist.
BackupFailThreshold First connection attribute	Controls the number of log files that can accumulate before a backup fails.
CacheAdminWallet Cache first connection attribute	Specifies that credentials for the Oracle cache administration user that are specified with the ttCacheUidPwdSet built-in procedure are stored in a system managed Oracle Wallet.
CacheAWTMethod Cache first connection attribute	Enables the AWT propagation method to be used on Oracle database tables.
CacheAWTParallelism Cache database attribute	Indicates the number of threads necessary to apply changes to the Oracle database.
ChildServer Client general connection attribute	Identifies the client server process.
CipherSuites Client general connection attribute Server first connection attribute	Lists the cipher suite or suites that can be used by TLS for client/server connections, depending also on the client setting.
CkptFrequency First connection attribute	Controls the frequency in seconds that TimesTen performs a background checkpoint.
CkptLogVolume First connection attribute	Controls the amount of data in megabytes (MB) that collects in the log between background checkpoints.
CkptRate First connection attribute	Controls the maximum rate at which data should be written to disk during a checkpoint operation.
CkptReadThreads First connection attribute	Controls the number of threads used to read a checkpoint file when loading the database into memory.
CommitBufferSizeMax General connection attribute	Specifies the maximum size of the commit buffer in the transaction control block.
ConnectionCharacterSet NLS general connection attribute	The character encoding for the connection, which can be different from the database character set.
ConnectionName General connection attribute	Specifies whether there is a symbolic name for the data source.
Connections First connection attribute	Indicates the upper bound on the number of user-specified concurrent connections to the database.
Data Source Name Data store attribute	A name that identifies the specific attributes of a connection to the database.
DatabaseCharacterSet NLS general connection attribute	Identifies the character set used by the database. This attribute is required at database creation time.
DataStore Data store attribute	Identifies the physical database.
DbEncrypted Data store attribute	Determines whether encryption at rest is enabled and specifies the preferred AES encryption algorithm.
DbKeyWallet Data store attribute	The directory where the wallet for encryption at rest is stored.
DDLReplicationAction General connection attribute	Determines whether a table or sequence is included in an active standby pair replication scheme when it is created, which can only occur if the DDLReplicationLevel connection attribute is set to 2 or 3.
DDLReplicationLevel General connection attribute	Enables replication of data definition language (DDL) statements in an active standby replication scheme.
DefragThreshold First connection attribute	Specifies the level of online defragmentation. A higher value leads to more space being freed.
DefragSpeed First connection attribute	Specifies the speed at which the online defragmentation should occur. A higher value uses more CPU resources. The default value indicates that the online defragmentation is disabled.
DefragCycle First connection attribute	Specifies the number of seconds to wait until the next cycle of the online defragmentation.
Description Data store attribute	A statement that identifies the use of the data source name.
Diagnostics General connection attribute	Specifies whether diagnostic messages are generated.
Driver Data store attribute	Specifies the TimesTen ODBC Driver Manager.
DurableCommits General connection attribute	Specifies that commit operations should write log records to disk.
DynamicLoadEnable Cache general connection attribute	Enables or disables transparent load of data from an Oracle database to dynamic cache groups.
DynamicLoadErrorMode Cache general connection attribute	Determines if an error message is returned upon a transparent load failure.
EnableParallelConnect First connection attribute	Specifies whether TimesTen enables parallel database connections at the process level, allowing multiple processes to connect simultaneously.
EnableParallelRedo First connection attribute	Specifies whether TimesTen enables parallel redo for faster database recovery.
Encryption Client general connection attribute Server first connection attribute	Specifies whether encryption is required or not for a client/server connection for the client and whether encryption is accepted, rejected, requested, or required for the server.
ForceConnect First connection attribute	Specifies whether a connection is allowed to a failed database if it is not properly restored from the corresponding subscriber database.
ForceDisconnectEnabled First connection attribute	Enables forced disconnections through ttAdmin -disconnect.
IncludeInCore General connection attribute	Specifies which parts of shared memory are included in a core dump.
Isolation General connection attribute	Specifies whether the isolation level is read committed or serializable.
LockLevel General connection attribute	Specifies whether the connection should use row-level locking (0) or database-level locking (1).
LockWait General connection attribute	Enables an application to configure the lock wait interval for the connection.
LogAutoTruncate First connection attribute	Determines whether the first connection to a database should proceed if TimesTen recovery encounters a defective log record.
LogBufMB First connection attribute	The size of the internal log buffer in MB.
LogBufParallelism First connection attribute	The number of log buffer strands.
LogDir Data store attribute	The directory where transaction log files are stored.
LogFileSize First connection attribute	The transaction log file size in MB.
LogFlushMethod First connection attribute	Controls the method used by TimesTen to write and sync log data to transaction log files.
LogPurge First connection attribute	Specifies that unneeded transaction log files are deleted during a checkpoint operation.
MaxConnsPerServer Server first connection attribute	The maximum number of concurrent connections a child TimesTen server process can handle.
MemoryLock First connection attribute	Enables applications that connect to a shared database to specify whether the real memory should be locked during database loading.
NLS_LENGTH_SEMANTICS NLS general connection attribute	The default length semantics configuration.
NLS_NCHAR_CONV_EXCP NLS general connection attribute	Determines whether an error is reported when there is data loss during an implicit or explicit character type conversion between NCHAR/NVARCHAR data and CHAR/VARCHAR data.
NLS_SORT NLS general connection attribute	The collating sequence to use for linguistic comparisons.
OptimizerHint General connection attribute	Sets optimizer hints at the connection level.
OracleNetServiceName Cache general connection attribute	The Oracle Service Name of the Oracle database instance from which data is to be loaded into a TimesTen database. This attribute is only used by the cache agent. Set the OracleNetServiceName attribute to the Oracle Service Name.
OraclePWD Cache general connection attribute	Identifies the password for the Oracle database that is being cached in TimesTen.
Overwrite First connection attribute	Specifies that the existing database should be overwritten with a new one when a connection is attempted.
PassThrough Cache general connection attribute	Specifies which SQL statements are executed locally in TimesTen and which SQL statements are passed through to the Oracle database for execution.
PermSize First connection attribute	The size in MB for the permanent partition of the database.
PermWarnThreshold General connection attribute	The threshold at which TimesTen returns a warning when the permanent partition of the database is low in memory.
PLSQL_CCFLAGS PL/SQL general connection attribute	Controls conditional compilation of PL/SQL units.
PLSQL_CONN_MEM_LIMIT PL/SQL general connection attribute	Specifies the maximum amount of process heap memory in MB that PL/SQL can use for this connection.
PLSQL_MEMORY_ADDRESS PL/SQL first connection attribute	The virtual address at which the shared memory segment is loaded into each process that uses the TimesTen direct drivers.
PLSQL_MEMORY_SIZE PL/SQL first connection attribute	The size in MB of the shared memory segment used by PL/SQL.
PLSQL_OPEN_CURSORS PL/SQL first connection attribute	The number of open cursors.
PLSQL_OPTIMIZE_LEVEL PL/SQL general connection attribute	The optimization level that the PL/SQL compiler uses to compile PL/SQL library units.
PLSQL_SESSION_CACHED_CURSORS PL/SQL general connection attribute	The number of session cursors to cache.
PLSQL_TIMEOUT PL/SQL general connection attribute	The number of seconds a PL/SQL procedure can run before being automatically terminated.
Preallocate Data store attribute	Specifies that disk space for the checkpoint files should be preallocated when creating the database.
PrivateCommands General connection attribute	Determines if commands are shared between connections.
PWD See UID and PWD General connection attribute	Specify the password that corresponds with the specified UID. When caching data from an Oracle database, PWD specifies the TimesTen password. You can specify the Oracle PWD in the connection string, if necessary.
PWDCrypt General connection attribute	The value of the encrypted user password.
PwdWallet General connection attribute	Provides the location and name of the wallet that contains stored user credentials needed for a connection.
QueryThreshold General connection attribute	Determines whether TimesTen returns a warning if a query times out before executing.
RACCallback Cache general connection attribute	Specifies whether to enable or disable the installation of Application Failover (TAF) and Fast Application Notification (FAN) callbacks.
RecoveryThreads First connection attribute	The number of threads used to rebuild indexes during recovery.
RedoParallelism First connection attribute	Specifies the number of threads used for database redo during recovery.
RedoSegmentSize First connection attribute	Specifies the size, in MB, of each segment into which the transaction log is divided.
ReplicationApplyOrdering Data store attribute	Enables automatic parallel replication.
ReplicationParallelism Data store attribute	Specifies the number of tracks available for automatic parallel replication.
ReplicationTrack General connection attribute	Assigns a connection to a replication track.
ShmPagesNoTouch First connection attribute	Determines whether TimesTen touches all pages in the shared memory segment when loading the database.
ServersPerDSN Server first connection attribute	The desired number of TimesTen server processes for the DSN.
ServerStackSize Server first connection attribute	The size in kilobytes (KB) of the thread stack for each connection.
SQLQueryTimeout General connection attribute	Specifies the time limit in seconds within which the database should execute SQL statements.
SQLQueryTimeoutMSec General connection attribute	Specifies the time limit in milliseconds within which the database should execute SQL statements.
SSLClientAuthentication Client general connection attribute	Specifies whether SSL client authentication is required
SSLClientAuthentication Server first connection attribute	Specifies whether SSL client authentication is required
SSLRenegotiationPeriod Server first connection attribute	The time in minutes before which the client/server session is renegotiated.
SSLRenegotiationSize Server first connection attribute	The data transfer size in MB before which the client/server session is renegotiated.
StandbyNetServiceName Cache general connection attribute	The Oracle Service Name of the standby Oracle database instance from which data is to be loaded into a TimesTen database. This attribute is only used by the cache agent in an Oracle Active Data Guard configuration. Set the StandbyNetServiceName attribute to the standby Oracle Service Name.
TCP_Port Client general connection attribute	The port number on which the TimesTen server is listening.
TCP_Port2, TCP_PortN Client general connection attributes	For TimesTen, the port number on which the TimesTen server should listen if an automatic failover occurs.
TempSize First connection attribute	The size in MB for the temporary partition of the database.
TempWarnThreshold General connection attribute	The threshold at which TimesTen returns a warning when the temporary partition of the database is low in memory.
TransactionTimeout General connection attribute	Specifies the time limit in seconds for user transactions to complete.
TTC_ConnectTimeout Client general connection attribute	Number of seconds for the client to wait for a connect or disconnect call.
TTC_FailoverPortRange Client general connection attribute	A range for the failover port numbers.
TTC_NetMsgMaxBytes Client general connection attribute	Specifies the maximum size in bytes of a client result set buffer.
TTC_NetMsgMaxRows Client general connection attribute	Specifies the maximum number of rows of a client result set buffer.
TTC_NoReconnectOnFailover Client general connection attribute	Specifies if TimesTen performs an automatic reconnect after all other failover procedures are completed.
TTC_Random_Selection Client general connection attribute	Specifies that the client randomly selects an alternate server from the list provided or selects the server according to TTC_ServerN settings.
TTC_Server or TTC_Server1 Client general connection attributes	Name of the computer where the TimesTen Server is running or a logical TimesTen server name.
TTC_Server_DSN Client general connection attribute	Server DSN corresponding to the TimesTen database.
TTC_Server_DSN2, TTC_Server_DSNn Client general connection attributes	For TimesTen, server DSN corresponding to the TimesTen database, if an automatic failover occurs.
TTC_Server2, TTC_ServerN Client general connection attributes	If an automatic failover occurs, the name of the system where the TimesTen Server should be running or a logical TimesTen server name.
TTC_SqlTimeoutMS Client general connection attribute	The time (in milliseconds) to wait for a response from the client.
TTC_TCP_KEEPALIVE_INTVL_MS Client general connection attribute	The time interval (in milliseconds) between subsequential probes.
TTC_TCP_KEEPALIVE_PROBES Client general connection attribute	The number of unacknowledged probes to send before considering the connection as failed and notifying the client.
TTC_TCP_KEEPALIVE_TIME_MS Client general connection attribute	The duration time (in milliseconds) between the last data packet sent and the first probe.
TTC_Timeout Client general connection attribute	Timeout period, in seconds, for completion of a TimesTen client/server operation.
UID See UID and PWD. General connection attribute	Specify a user name that is defined on the TimesTen server. When caching data from an Oracle database, the UID must match the UID on the Oracle database that is being cached in TimesTen.
UseCacheConnPool Cache database attribute	Enables or disables the cache connection pool.
WaitForConnect General connection attribute	Specifies that the connection attempt should wait if an immediate connection is not possible.
Wallet Client general connection attribute Server first connection attribute	The fully qualified path to the directory where the wallet is stored.