SAP Knowledge Base Article - Preview

1934471 - After enabling snapshot isolation for refreshing materialized views, there is significant transaction log growth

Symptom

In a SQL Anywhere database, when issuing the "REFRESH MATERIALIZED VIEW" statement at a snapshot isolation level, the transaction log size can grow significantly.


Read more...

Environment

  • SAP Sybase SQL Anywhere 10 (and above)

Product

SAP SQL Anywhere 16.0 ; SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 10.0 ; Sybase SQL Anywhere 11.0

Keywords

11653445 , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.