Hi Andre,
It’s probably out of scope to give a reasonable response to your questions via the public mailing list (feel free to ask for our commercial services), but here’s a quick shot:
- why is the whole database read even for a "small" query ? (looks
like a missing index or bad execution plan.. ?)
It may depend a lot on what the query does. Could you give us an example
for a typical “small query”?
- The UNIX related question (maybe it's worth opening a ticket with redhat)
I guess so. I’m sorry I have no in-depth knowledge on why RHL 6 and 8
behaves differently here.
Have you already tried different JDK versions/distributions?
Best, Christian