RDBPROD: Repeated TRUNCATE TABLE operations may run out of Pagefile Quota
(Doc ID 1997996.1)
Last updated on FEBRUARY 21, 2019
Applies to:Oracle Rdb Server on OpenVMS - Version 126.96.36.199 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 188.8.131.52.
Program repeats the TRUNCATE TABLE command hundreds of times.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document