Choose a topic
ttLogHoldsDescriptionThis procedure returns information about transaction log holds, including those created on behalf of incremental backups, replication peers, active standby pairs (and any subscribers), AWT cache groups, persistent XLA subscribers, XA, long-running transactions and checkpoints. This procedure can help diagnose situations where it appears that checkpoint operations are not purging all unneeded transaction log files.Applications should monitor log holds and the accumulation of log files. For more information, see "Show replicated log holds" in the Oracle TimesTen In-Memory Database Replication Guide and "Monitoring accumulation of transaction log files" in the Oracle TimesTen In-Memory Database Operations Guide.Required privilegeThis procedure requires no privilege.SyntaxttLogHolds()ParametersttLogHolds has no parameters.Result setttLogHolds returns the result set:ColumnTypeDescriptionHoldLFNTT_INTEGER NOT NULLReturns the transaction log file number of the hold.HoldLFOTT_BIGINT NOT NULLReturns the transaction log file offset of the hold.typeTT_CHAR (30) NOT NULLReturns the type of hold, one of:CheckpointReplicationBackupXLALong-Running TransactionLong-Running XA TransactiondescriptionTT_VARCHAR (1024) NOT NULLDescribes the type-specific object for which the hold was created. Each description corresponds with the Type returned. Descriptions are one of:The name of the checkpoint fileThe name of the standby masterThe name of the replication subscriber_ORACLE when tracking AWT cache group propagationThe parallel replication track ID used by the subscriberThe backup pathThe name of the persistent XLA subscription and the process ID of the last process to open it, if it is openThe XID (transaction ID) of the XA transactionThe TimesTen transaction ID of the long-running transactionExamplesCALL ttLogHolds();< 0, 1148544, Long-Running XA Transaction , 0x1-476c6f62616c-5861637431 >< 0, 1149752, Long-Running Transaction, 4.2 >< 0, 1149992, Checkpoint , sample.ds1 >< 0, 1150168, Checkpoint , sample.ds0 >The following example shows the output of ttLogHolds built-in procedure for an active standby pair replication scheme, where the active master is master1 and the standby master is master2 with a single subscriber, subscriber1.Command> call ttLogHolds;< 0, 3569664, Checkpoint , master1.ds0 >< 0, 15742976, Checkpoint , master1.ds1 >< 0, 16351496, Replication , ADC6160529:SUBSCRIBER1 >< 0, 16351640, Replication , ADC6160529:MASTER2 >4 rows found.The following example shows the progress of the asynchronous propagation for an AWT cache group to the Oracle database. The description field contains "_ORACLE" to identify the transaction log hold for the AWT cache group propagation.Command> call ttLogHolds();< 0, 18958336, Checkpoint , cachealone1.ds0 >< 0, 19048448, Checkpoint , cachealone1.ds1 >< 0, 19050904, Replication , ADC6160529:_ORACLE >3 rows found.