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.