Indexes for database tables used by String-keyed-database-store for RHDG
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.