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

or

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

Symptoms

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