Details
-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
11.0.4.Final
-
None
-
Undefined
Description
In class OracleTableManager at string 61 there is:
rs = meta.getIndexInfo(null, null, tableName.toString(), false, false);
last parameter is approximate (when true, result is allowed to reflect approximate or out of data values; when false, results are requested to be accurate)
When Oracle DB used for JDBC cachestore and this parameter == false, then during startup Infinispan runs statistic gathering for every cache table. As a result it spends a lot of time during startup.
I think that parameter "approximate" must be changed to true:
rs = meta.getIndexInfo(null, null, tableName.toString(), false, true);
in this case Oracle uses existing metainformation of the table.