“Anyway, based on the paper, I started searching on ways to reduce logical
IOs. Any pointers on that are welcome too. ”
How much do you want to reduce it to? Why do you think your current levels
are too high? Have you identified a problem?
Once you have confirmed you don’t suffer from compulsive tuning disorder
and you have a problem that is caused by too many LIOs. Look at where they
are coming from, use your instrumentation to check which processes are
responsible for the most LIO during times that it matters. Then tune the
process so that it doesn’t require as much - this may be straight forward
SQL tuning like adding appropriate indexes, helping the optimizer choose
the correct path, filtering down earlier in joins. It could be rethinking
about what your process should be doing, should it really be populating a
GTT with all rows from table_x? Etc
Hope that helps,
Andrew
