UnOptimized Reads in Oracle Database 11gR2

Many of you who have been reading statspack or AWR reports might be wondering what is the new category of "SQL Statistics; SQL ordered by Physical Reads (UnOptimized)".  What is an UnOptimized read? To begin, we need to clarify the meaning of the statistic. For systems not using Exadata Hardware and the Oracle Database [...]

By |2017-09-20T08:36:47+00:00December 2nd, 2013|Performance Wire|Comments Off on UnOptimized Reads in Oracle Database 11gR2

Direct Path Reads in Oracle Database 11gR2

Updated: 11/26 A new feature introduced in Oracle 11gR2 is the way the Direct Path Read operation is done.  A direct path read is where the data is read directly from the data files into the PGA rather than into the buffer cache in the SGA.  Direct Path reads have been around for a [...]

By |2018-02-23T17:58:49+00:00November 12th, 2013|Performance Wire|Comments Off on Direct Path Reads in Oracle Database 11gR2