Skip to Content
0

Automatic Report Capturing use in SAP

Oct 20, 2016 at 08:24 PM

442

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

James Zhang
Oct 21, 2016 at 07:51 AM
0

Hi Gordon,

SAP customer cannot set any any hidden parameter, only if any sap note explicitly lets us set it.

I assume setting _report_capture_cycle_time = 0 is not default setting, so please raise a call to SAP support to consult whether you can set this hidden parameter, because I didn't find any sap document talks this parameter.

Best regards,
James

Share
10 |10000 characters needed characters left characters exceeded
Fidel Vales
Oct 21, 2016 at 01:01 PM
0

Hello Gordon,

As James mentioned, please open a ticket. I'm aware of such issue and the solution. Pushing the issue to the ORacle people will make them either document it or solve it or both.

Fidel

Share
10 |10000 characters needed characters left characters exceeded
Gordon Schlegel Oct 25, 2016 at 02:39 AM
0

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.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

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

0

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.

1

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

1
Gordon Schlegel Oct 28, 2016 at 08:31 PM
0

James, Fidel,

Thanks for chiming in. I appreciate it. I'll put in an incident, since this is now a "Can I do this?" instead of a "How do I do this?" or a "What is this?".

Share
10 |10000 characters needed characters left characters exceeded