im trying TPC-H benchmark on my Oracle database, testing takes place on a 10GB dataset. Currently I have target_memory set to 7GB, but the current test time is 18 minutes. The biggest problem is with the lineitem table(7,5GB), because its size does not fit in the cache and with each new query, all data must be reloaded from disk. Do you have any ideas how to speed up the test?
I've already tried the parallelization offered by the optimizer, but it ran even slower with that test due to the HDD and index doesnt work here, because for example in Q1 Oracle need to proccess almost 97% of table lineitem, which is the largest table with a size of 7.5 GB.