RDBPROD: High Page Fault Rate with a Complex Query that uses Quick Sort (Doc ID 1967999.1)

Last updated on AUGUST 12, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.3 and later
HP OpenVMS Itanium
HP OpenVMS Alpha

Symptoms

It has been observed that complex queries are page faulting excessively if they are using Quick Sort.

Changes

Upgrade from Rdb 7.2.x to Rdb 7.3.x

or

Define the logical RDMS$BIND_MAX_QSORT_COUNT to a high value.

Cause

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