Evgenii Balakhonov created ISPN-12425: ----------------------------------------- Summary: Inifinispan + JDBC cachestore runs statistic collection on Oracle DB Key: ISPN-12425 URL: https://issues.redhat.com/browse/ISPN-12425 Project: Infinispan Issue Type: Bug Components: Loaders and Stores Affects Versions: 11.0.4.Final Reporter: Evgenii Balakhonov In class OracleTableManager at string 61 there is: rs = meta.getIndexInfo(null, null, tableName.toString(), false, {color:#FF0000}*false*{color}); 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.     -- This message was sent by Atlassian Jira (v7.13.8#713008)