RDBPROD: Repeated TRUNCATE TABLE operations may run out of Pagefile Quota
Last updated on JULY 19, 2017
Applies to:Oracle Rdb Server on OpenVMS - Version 184.108.40.206 and later
HP OpenVMS Itanium
HP OpenVMS Alpha
A program ran out of PGFLQUO due to repeated executions of TRUNCATE TABLE.
This can be observed using the lexical F$GETJPI. Example below, which could be enclosed in a loop for continual checks.
Upgraded to Oracle Rdb 220.127.116.11.
Program repeats the TRUNCATE TABLE command hundreds of times.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms