Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When are transaction log files deleted?

April 26, 2017deleted files log transaction

0

Posted

When are transaction log files deleted?

1 Answer

0

Posted

Transaction log files are kept until TimesTen or the IMDB Cache declares them to be purgeable. A transaction log file cannot be purged until all of the following actions have been completed: • All transactions writing log records to the transaction log file (or a previous transaction log file) have committed or rolled back. • All changes recorded in the transaction log file have been written to the checkpoint files on disk. • All changes recorded in the transaction log file have been replicated (if replication is used). • All changes recorded in the transaction log file have been propagated to the Oracle database if the IMDB Cache has been configured for that behavior. • All changes recorded in transaction log files have been reported to the XLA applications (if XLA is used).