cancel
Showing results for 
Search instead for 
Did you mean: 

Automatic Report Capturing use in SAP

0 Kudos

Since we started upgrading to Oracle 12c, we've seen high CPU use in the MMON_SLAVE modules. These are associated with Oracle's new Automatic Report Capturing functionality. The functionality can be turned off by setting _report_capture_cycle_time = 0. But before turning it off in production, we'd like to know if SAP needs or uses Automatic Report Capturing in any way. Would anyone have any experience with this functionality in the context of Sap?

Thanks very much.

Gordon

View Entire Topic

Thank you, but my question isn't about the hidden parameter as such. I just need to know if SAP requires Oracle 12g's Automatic Report Capturing functionality in any way. If not, we will probably turn it off, and Oracle has already given us their OK to do this.

JamesZ
Advisor
Advisor
0 Kudos

Hi Gordon,

Still I didn't find any SAP document mentioned this function. The same way, please raise a ticket to SAP support.

By the way I only find SAP note 105047 related, but no mentioning Automatic Report Capturing functionality.

Best regards,
James

JamesZ
Advisor
Advisor

Another comment, please ALWAYS involve SAP to confirm if Oracle lets you set any parameter or any hidden parameter. This is the essential rule for SAP on oracle.

fidel_vales
Employee
Employee

Hello,

That functionality is not "REQUIRED", it is part of the AWR and very useful in troubleshooting performance problems.

Never set an underscore parameter that is not documented in an SAP note or provided to you via incident, regardless of what the internet says (including MOS) If you have a problem that you think can be solved via underscore parameter, open an incident at SAP to get confirmation. Be ready to provide enough information.

Thanks