Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the database LATCH:ROW CACHE OBJECTS problem". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to solve the database LATCH:ROW CACHE OBJECTS problem".

Check the waiting time and the resulting address contention

Select p1, p1raw,p2 from v$session_wait where event='latch: row cache objects'

Check the misses loss rate of the address block to be used

Select * from v$latch_children where name like'% row cache objects%'

View objects in row cache

Column cache# format 99999

Column name format a33

Column latch# format 999999

Select distinct s.kqrstcln latch#,r.cache#,r.parameter name, r.type, r.subterra-ciatefujijimi r.gets from v$rowcache rjorgxcrikqrst s where r.cache#=s.kqrstcid order by 1meme 4je 5

Select t.parameter,t.gets,t.getmisses,t.modifications,t.flushes from v$rowcache t where cache#=16

Solution:

1. Increase the size of shared pool

Second, increase the size of PGA

Third, increase the SESSION_CACHED_CURSORS parameters

Thank you for your reading, the above is the content of "how to solve the database LATCH:ROW CACHE OBJECTS problem", after the study of this article, I believe you have a deeper understanding of how to solve the database LATCH:ROW CACHE OBJECTS problem, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.