My Oracle Support Banner

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

Last updated on JANUARY 30, 2020

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

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.