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
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.
Frequent or numerous changes to table columns over time.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!