Database Administration (MOSC)

MOSC Banner

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!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center