Specifies whether snapshot dumps are suppressed if resource exhaustion is detected when reserving memory for aggregate processing.
|TRUE||Snapshot dumps are suppressed.
In this case, although snapshot dumps are not created when resources are exhausted, insufficient memory errors are still returned.
|FALSE||Snapshot dumps are created when memory resources are exhausted.|
Changes Take Effect
After the next Teradata Database restart.
SnapBypassAggrCache can be used when submitting transactions that involve many aggregate functions, which require much cache processing. In these situations, memory resource exhaustion would normally cause snapshot dumps, slowing the system down. Use SnapBypassAggrCache to turn off snapshot dumps temporarily. If memory resources become exhausted, the transaction will be aborted with an error message, but the system will not record a snapshot dump.
To avoid masking real memory leak issues, reset SnapBypassAggrCache to FALSE when the memory intensive query has completed. Snapshot dumps are useful for tracing the cause of real memory problems.