RDBPROD: High Page Fault Rate with a Complex Query that uses Quick Sort
(Doc ID 1967999.1)
Last updated on DECEMBER 03, 2023
Applies to:Oracle Rdb Server on OpenVMS - Version 7.3 and later
HP OpenVMS Itanium
HP OpenVMS Alpha
It has been observed that complex queries are page faulting excessively if they are using Quick Sort.
Upgrade from Rdb 7.2.x to Rdb 7.3.x
Define the logical RDMS$BIND_MAX_QSORT_COUNT to a high value.
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