Troubleshooting Oracle 19c real-time statistics row cache lock(dc_realtime_tabst)

Recently, a customer’s Oracle database encountered a performance problem, waiting for “row cache lock”. Analysis showed that the cache# p1 value pointed to the dc_realtime_tabst 。

, ,