Troubleshooting oracle 19c RAC ‘gc cr block lost’ and ‘Library Cache Load Lock’

  • 2023/05/19
  • Cloud
  • 801 views
  • Troubleshooting oracle 19c RAC ‘gc cr block lost’ and ‘Library Cache Load Lock’已关闭评论

最近遇到这个案例大量FG prorcess堵塞，19c (19.4) 2nodes RAC, 等待Library Cache Load Lock， 堵塞会话为REC0， 该进程等待gc cr block lost. 同时在rec0进程trace文件中提示
IPCLW:[0.0]{-}[WAIT]:PROTO: [1661188358080974]ipclw_data_chunk_process:1165 Discarding msg with seq # 875492546, expecting 2730385062
IPCLW:[0.0]{-}[WAIT]:PROTO: [1661188358080974]ipclw_data_chunk_process:1165 Discarding msg with seq # 875492587, expecting 2730385062

, ,

阅读全文