Capture core dumping with the following error
Notice: Oracle version 92 [sp_ocap(osp)/25966]
Error: process sp_ocap killed due to SIGSEGV [sp_cop/24833]
Perform the following to resolve this issue
Set param SP_OCT_CHECKPOINT_FREQ = 1
Monitor for a while and then reset param:
reset param SP_OCT_CHECKPOINT_FREQ