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

Last updated on AUGUST 09, 2016

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

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