logical read Vs Physical Reads
718724Apr 20 2010 — edited Apr 20 2010Hi,
I want to know How should we balance the logical reads and physical reads on database.
I generaly assume logical reads is always better but what if too many session accessing the same
objects it will cause latch contention.
If it is physical read then it will take more time to read from disk than reading from SGA.
If I look at statspack report I check the
Logical reads: 59,846.54 840.03
Physical reads: 1,095.91 15.38
Is there any standards for logical reads on database. If there is latch contentions can we go for the
decreasing the SGA to avoid the contentions so that there will balance between the physical reads
and logical reads.