Result cache in 11g
Prior to 10g, every query must be re-executed even if there is no change in the tables. This reexecution is unnecessary for few static tables and only caching using at client tools resolve this issue. But, in 11g, query results can be cached in SGA. Just to avoid confusion, this is much different from buffer …
Result cache in 11g Read More »