Contents

Title and Copyright Information

Preface

• Audience
• Related documents
• Conventions
• Documentation Accessibility

What's New

• New features in Release 11.2.2.7.0
• New features in Release 11.2.2.6.0
• New features in Release 11.2.2.5.0
• New features in Release 11.2.2.4.0
• New features in Release 11.2.2.2.0
• New features in Release 11.2.2.1.0

1 Connection Attributes

• Required privileges for attributes
• List of Attributes
• Data store attributes
  • Data Source Name
  • DataStore
  • DatabaseCharacterSet
    • Supported character sets
  • Description
  • Driver
  • LogDir
  • Preallocate
  • RangeIndexType
  • ReplicationApplyOrdering
  • ReplicationParallelism
  • Temporary
  • TypeMode
• First connection attributes
  • AutoCreate
  • CkptFrequency
  • CkptLogVolume
  • CkptRate
  • CkptReadThreads
  • Connections
  • ForceConnect
  • LogAutoTruncate
  • LogBufMB
  • LogBufParallelism
  • LogFileSize
  • LogFlushMethod
  • LogPurge
  • MemoryLock
  • Overwrite
  • PermSize
  • ReceiverThreads
  • RecoveryThreads
  • TempSize
• General connection attributes
  • CommitBufferSizeMax
  • ConnectionName
  • DDLCommitBehavior
  • DDLReplicationAction
  • DDLReplicationLevel
  • Diagnostics
  • DuplicateBindMode
  • DurableCommits
  • Isolation
  • LockLevel
  • LockWait
  • MatchLogOpts
  • PermWarnThreshold
  • PrivateCommands
  • PWDCrypt
  • QueryThreshold
  • ReplicationTrack
  • SQLQueryTimeout
  • 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
  • PLSQL_MEMORY_ADDRESS
  • PLSQL_MEMORY_SIZE
• PL/SQL general connection attributes
  • PLSCOPE_SETTINGS
  • PLSQL_CCFLAGS
  • PLSQL_CONN_MEM_LIMIT
  • PLSQL_OPTIMIZE_LEVEL
  • PLSQL_TIMEOUT
• TimesTen Cache first connection attributes
  • CacheAWTMethod
• TimesTen Cache database attributes
  • CacheAWTParallelism
  • CacheGridEnable
  • CacheGridMsgWait
• TimesTen Cache general connection attributes
  • DynamicLoadEnable
  • DynamicLoadErrorMode
  • OracleNetServiceName
  • OraclePWD
  • PassThrough
  • RACCallback
• TimesTen Client connection attributes
  • TCP_Port
  • TCP_Port2
  • TTC_FailoverPortRange
  • TTC_Server
  • TTC_Server2
  • TTC_Server_DSN
  • TTC_Server_DSN2
  • TTC_Timeout
• Server connection attributes
  • MaxConnsPerServer
  • ServersPerDSN
  • ServerStackSize

2 Built-In Procedures

• ttAgingLRUConfig
• ttAgingScheduleNow
• ttApplicationContext
• ttBackupStatus
• ttBlockInfo
• ttBookmark
• ttCacheAllowFlushAwtSet
• ttCacheAutorefIntervalStatsGet
• ttCacheAutorefresh
• ttCacheAutorefreshLogDefrag
• ttCacheAutorefreshStatsGet
• ttCacheAutorefreshSelectLimit
• ttCacheAutorefreshXactLimit
• ttCacheAWTMonitorConfig
• ttCacheAWTThresholdGet
• ttCacheAWTThresholdSet
• ttCacheCheck
• ttCacheConfig
• ttCacheDbCgStatus
• ttCacheDDLTrackingConfig
• ttCachePolicyGet
• ttCachePolicySet
• ttCachePropagateFlagSet
• ttCacheSqlGet
• ttCacheStart
• ttCacheStop
• ttCacheUidGet
• ttCacheUidPwdSet
• ttCkpt
• ttCkptBlocking
• ttCkptConfig
• ttCkptHistory
• ttCommitBufferStats
• ttCommitBufferStatsReset
• ttCompact
• ttCompactTS
• ttComputeTabSizes
• ttConfiguration
• ttContext
• ttDataStoreStatus
• ttDBConfig
• ttDbWriteConcurrencyModeGet
• ttDbWriteConcurrencyModeSet
• ttDurableCommit
• ttGridAttach
• ttGridCheckOwner
• ttGridCreate
• ttGridDestroy
• ttGridDetach
• ttGridDetachAll
• ttGridDetachList
• ttGridFirstMemberAttach
• ttGridGlobalCGResume
• ttGridGlobalCGSuspend
• ttGridInfo
• ttGridNameSet
• ttGridNodeStatus
• ttHostNameGet
• ttHostNameSet
• ttIndexAdviceCaptureDrop
• ttIndexAdviceCaptureEnd
• ttIndexAdviceCaptureInfoGet
• ttIndexAdviceCaptureOutput
• ttIndexAdviceCaptureStart
• 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
• ttSQLCmdCacheInfo2
• ttSQLCmdCacheInfoGet
• ttSQLCmdQueryPlan
• ttSQLExecutionTimeHistogram
• ttStatsConfig
• ttTableSchemaFromOraQueryGet
• ttVersion
• ttWarnOnLowMemory
• ttXactIdGet
• ttXlaBookmarkCreate
• ttXlaBookmarkDelete
• ttXlaSubscribe
• ttXlaUnsubscribe

3 Utilities

• Overview
• Required authentication and authorization for utilities
  • Required user authentication for utilities
  • Required privileges for executing utilities
• ttAdmin
• ttAdoptStores
• ttBackup
• ttBulkCp
• ttCacheAdvisor
• ttCapture
• ttCheck
• ttCWAdmin
• ttDaemonAdmin
• ttDaemonLog
• ttDestroy
• ttIsql
• ttMigrate
• ttmodinstall
• ttRepAdmin
  • Help and version information
  • Database information
  • Subscriber database operations
  • Duplicate a database
  • Wait for updates to complete
  • Replication status
• ttRestore
• ttSchema
• ttSize
• ttStats
• ttStatus
• ttSyslogCheck (UNIX)
• ttTail
• ttTraceMon
• ttUser
• ttVersion
• ttXactAdmin
• ttXactLog

4 System Limits

• System limits and defaults
• Limits on number of open files
• Path names

Index