Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle runs slowly with high latch free

David TenNov 14 2018 — edited Nov 14 2018

Hi all

 Recently my client complains about oracle 12C(12.1.0.2.0) slow running. Then i did awrrpt, _latch free_ ranks first in _Top 10 Foreground Events by Total Wait Time。_So i checked the _Latch Sleep Breakdown_, found that there are too many misses in  _①space background task latch ②row cache objects ③Result Cache: RC Latch ④shared pool_. But i cannot find any information about _space background task latch_.

Can anyone tell me how to do next to solve the problem. Thanks a lot.

Top10.png

latch sleep breakdown.PNG

Comments
Post Details
Added on Nov 14 2018
6 comments
1,767 views