Skip to main content

Knowledge Document: High query history/consumption growth caused by procedural loop executing dynamic SQL repeatedly

  • Mar 11, 2026 8:28 AM UTC
  • 0 replies
  • 10 views

coest_opentext_com
Forum|alt.badge.img

PL/vSQL loop runs dynamic SQL many times inside one statement, creating huge internal executions and monitoring growth; batch/limit or redesign to set-based SQL to reduce it.