RDBPROD: High Page Fault Rate with a Complex Query that uses Quick Sort
Last updated on AUGUST 12, 2016
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms