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:
Post a Comment