RDBPROD: Performance problems caused by excessive activity on table RDB$FIELD_VERSIONS
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.
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