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 laterHP 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 |