IN ORACLE MILIEU …

For tuning buffer cache, we need to understand following point very closely. Physical reads: These are the data blocks that Oracle reads from disk. Reading data from disk is much more expensive than reading data that’s already in Oracle’s memory. When you issue a query, Oracle always first tries to retrieve the data from memory—the [...]