Where are the JOEZSHM_<SID>_* files coming from?
We are running Oracle 19c on a Linux server. We are receiving a large number of JOEZSHM files for two of our applications (total of 6 databases including dev, test, and prod). Research has lead me to believe that it is cycle related (shutdown immediate vice shutdown). I don't believe this is the case because two of our databases are spitting out files every 5-20 minutes (inconsistent timing between file creation).
Has anyone seen this? If so, can you explain what it is and how to stop/reduce the number of files created?
Thanks!