Friday, 26 February 2016

Row cache objects latch

Possible Causes:
  • This latch comes into play when user processes are attempting to  access the cached data dictionary values.


Actions:
  • It is not common to have contention in this latch and the only way to reduce contention for this latch is by increasing the size of the shared pool (SHARED_POOL_SIZE).
  •  Use Locally Managed tablespaces for your application objects especiallyindexes
  • Review and amend your database logical design , a good example is to merge or decrease the number of indexes on tables with heavy inserts


Remarks:


  • Configuring the library cache to an acceptable size usually ensures that the data  dictionary cache is also properly sized. So tuning Library Cache will tune Row Cache indirectly

No comments: