Direct Path Reads in Oracle Database 11gR2 page 2

Direct Path Reads Solution Explained: So, how do you solve the “ direct path reads ” problem (where the same data is being constantly re-read from disk)?  There are a couple of suggestions. Put the table in question in the KEEP buffer cache.  This is a two-step process.  First allocate memory for the KEEP [...]

By |2018-05-18T16:40:00+00:00February 23rd, 2018|Database, Oracle|Comments Off on Direct Path Reads in Oracle Database 11gR2 page 2