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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content