Would size of rows in SCM_CONFIGURATION_SELECTIONS table affect system performance?
We use RTC3013/WAS 7.0.0.23 On Red Hat Enterprise linux 5 64bit with 32GB, Oracle 11.2.0.3 on another Linux machine and 48GB memory.
We have frequent build running on Android development and the project has 30k files in general.
Recently we have some performance issue and when monitoring SQL query, it seems that lots of db top activities are related to this table:SCM_CONFIGURATION_SELECTIONS.
There are 200,000,000 rows in SCM_CONFIGURATION_SELECTIONS table currently.
The question is: is the size of this table considered as normal? and if the size of rows in this table would impact system performance?
Thank you very much for any info.
We have frequent build running on Android development and the project has 30k files in general.
Recently we have some performance issue and when monitoring SQL query, it seems that lots of db top activities are related to this table:SCM_CONFIGURATION_SELECTIONS.
There are 200,000,000 rows in SCM_CONFIGURATION_SELECTIONS table currently.
The question is: is the size of this table considered as normal? and if the size of rows in this table would impact system performance?
Thank you very much for any info.