Bug high 'direct path read'

Bug 12530276 - high 'direct path read' waits when buffer pools are not setup [ID 12530276.8]

Bug 12530276  high 'direct path read' waits when buffer pools are not setup

 This note gives a brief overview of bug 12530276. 
 The content was last updated on: 12-JUN-2012
 Click here for details of each of the sections below.


Product (Component)Oracle Server (Rdbms)
Range of versions believed to be affectedVersions >= 11.2 but BELOW 12.1
Versions confirmed as being affected
Platforms affectedGeneric (all / most platforms affected)


This issue is fixed in


Related To:


While detemining whether (being) scanned objects should be cached or direct read,Current code treats all 'keep objects' as large objects when 'keep pool'
is not configured. This results in direct read of objects created with
'BUFFER_POOL KEEP' clause, even though they are small enough to be cached
in default pool. 
Configure keep pool for keep objects db_keep_cache_size


Niciun comentariu:

Trimiteți un comentariu