Indexes for database tables used by String-keyed-database-store for RHDG

Solution Verified - Updated -

Issue

  • There are full table scans for the Oracle database detected for configured JDBC persistence of caches, what is the cause and how to avoid it?
  • Preloading a cache from a JDBC store is very slow, how to tune it?
  • There are timeouts when use a .getCache(...) in the code
  • DG is slow and stuck sometimes, the thread dumps show that lot of threads are waiting for a response from the database, what is the root-cause of this?

Environment

  • Red Hat Data Grid (RHDG)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In