Hi Experts,
I was reading through this wonderful paper by Cary Millsap -- Why You Should Focus on LIOs Instead of PIOs
He thoroughly explains the complexities involved in accessing LIOs i.e. Database Buffer cache.
Still I am confused on few below points -
1) Under sub-heading "How to Eliminate LIOs", Cary writes -
the most economically efficient way to solve the problem is probably to optimize the SQL that causes too many LIOs. A high-LIO SQL statement running in one program at a time is a problem for one user who is waiting for the program’s output.
Just trying to understand how to optimize SQL queries which reduce LIOs.
2) Reducing LIOs and PIOs - Is it a DBA thing or as a developer I can improve performance on these factors. (I am aware of being silly on this point )
Please share your thoughts regarding this. Help is much appreciated.
(I am reading through some other article on this, and will ask further doubts.)
-- Ranit
( on Oracle 11.2.0.3.0 )