My Oracle Support Banner

RDBPROD: Performance problems caused by excessive activity on table RDB$FIELD_VERSIONS (Doc ID 438627.1)

Last updated on APRIL 16, 2024

Applies to:

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


Symptoms

Performance issue on system table RDB$FIELD_VERSIONS.

RMU/SHOW STATISTICS and screen "Logical Area Overview (Tables)" shows a high number of reads to metadata table RDB$FIELD_VERSIONS. It may show that it even exceeds or compares to the busiest of the data tables.

Changes

Frequent or numerous changes to table columns over time.

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

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