Oracle Cloud Infrastructure Documentation

Additional Configurations

There are some additional configurations in RUEI and APM Java Agent files recommended to take advantage of E-Business Suite tracing and optimize the data capture and presentation in APM.

Configure Abridge Traces to Remove Insignificant JDBC Spans

E-Business Suite runs many SQL statements to the database: Their runtime is fast and in most cases, they are insignificant to monitoring. From APM side, each SQL statement becomes an individual span and it shows up in the Trace Details page from Trace Explorer.

To eliminate the excessive numbers of insignificant JBC spans from being collected by APM, you can configure the abridged traces settings in the APM Java Agent.

  1. Login to the E-Business Suite host and open the ProbeConfig.acml file using an editor.
    For example: 
    vi /u01/ebs122/fs_ne/oracle-apm-agent/config/1.6.2363/ProbeConfig.acml
  2. Edit the abridge parameters using the following example:
    ...
...
...
summarize: true
settings_by_probe:
- probe: "JDBC"
  span_limit: 50
  threshold:
    duration: 10
    start_thresholding_after: 0

    In this example, JDBC spans at a single trace shows up only when the duration is more than 10 milliseconds.

  3. After making the changes, go to Trace Explorer.

    • Open Trace Details and go to Spans. If you see a span with the scissors icon Scissors icon for Abridged Traces, it indicates nested spans were abridged.

    • Click on the span to open Span Details.
      • Go to Dimensions and see the abridged dimensions listed.
      • Go to Logs and see the top abridged span values.

Convert Usernames to Lowercase Captured by RUEI

Since APM captures the username value in lowercase (See above step: Capture Username from the Browser), it's important that the username that RUEI captures is also converted to lowercase. Therefore, the APM session regards the spans from the browser and RUEI, are from the same user.

To configure RUEI to convert the username to lowercase when it is stored in the RUEI database, and then sent to APM, do the following:

  • Login to RUEI web interface.
  • Select Configuration > Applications> Suites.
  • Select your EBS suite.
  • Select Users.
  • Select username (URL Argument).
  • Click Advanced tab.
  • In the Lowercasing: section, change the selection to Before Ruling from the pulldown menu.
    Note

    This setting provides an option to convert the username to lowercase either before or after the ruling. If there is no rule configured, it will simply lowercase the username when it's stored to the RUEI database, regardless of the option (before or after) selected. The default is No which captures the username as a user typs into the login screen.