DESCRIPTION:
The size MMON trace files gets increased which is causing trace file Location Overflow.
CAUSE:
Trace files generation with message “AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1”.
Regarding excessive MMON trace generation, this is a known issue
This is due to an unpublished Bug 25415713 – MMON TRACE FILE GROWS WHEN NO TRACES ARE ENABLED.
SOLUTION:
Applying Patch in Offline Mode:
- Download and apply this one-off patch 25415713 according to your release.
- 1. shut down all the services running from the Oracle home
- Download the patch 25415713
- cd <PATCH_TOP_DIR>/25415713
- 1. opatch apply
- 1. Verify whether the patch has been successfully installed using “opatch lsinventory”
- Start the services from the Oracle home
CONCLUSION:
- Please make sure that you have a valid backup and install this fix on your test environment prior to installing it on your full production environment.
Before applying this one-off patch, it is highly recommended to check the patch conflicts. - Refer (Doc ID 989072.1)
Recent Posts