What controls PS_MESSAGE_LOG entries?
One month ago today (since Monday, 6/20/2022), we went from generating a half dozen to a couple dozen PS_MESSAGE_LOG entries daily--mostly of MESSAGE_SEVERITY 10-- to generating on the order of 60,000 sev “0” and 40,000 sev “10” rows daily. We are not aware of any changes made around that date! Is there some type of debug or trace level that we accidentally tripped over? We want to switch it back!
We began to experience the well-documented “ORA-00001: unique constraint (SYSADM.PS_MESSAGE_LOG) violated” issue recently, so I dug into the data a bit. It is my working assumption that if I slow down the rate of rows being inserted, we are less likely to run into this error. We just don’t know how to slow it down, and I haven’t been able to find any helpful docs.