Oracle Database 19c -- Physical Standby Database Slow Performance with RSP0 respawns

Problem

A physical standby database in a DataGuard configuration with the Broker enabled, performs slowly or hangs

The Alert log shows that the RSP0 process keeps respawning:

2023-03-09T02:33:13.534865+08:00
Process RSM0, PID = 79219, will be killed
2023-03-09T02:33:13.535291+08:00
Process termination requested for pid 79219 [source = rdbms], [info = 2] [request issued by pid: 22759, uid: 101]
2023-03-09T02:33:14.752257+08:00
Starting background process RSM0
2023-03-09T02:33:14.849150+08:00
RSM0 started with pid=117, OS id=81351

Solution

Check the OperationTimeout parameter of the Broker configuration:

DGMGRL> show configuration OperationTimeout
  OperationTimeout = '30'    <<<< in seconds

If the value in range 10 - 30 seconds, it might be too low for this this particular configuration depending on the network and hardware resources

Set the value higher like 600 (10 minutes):

DGMGRL> EDIT CONFIGURATION SET PROPERTY OperationTimeout=600;
Property "operationtimeout" updated
DGMGRL> show configuration OperationTimeout
  OperationTimeout = '600'