Generating a system-wide database trace

As an alternative to using the Database Trace tool, you can trace system-wide database statistics. As a best practice, do this for very short periods on a non-production system.

CAUTION:
This setting generates a system-wide database trace file in the ServiceExport directory that can become very large quickly, and can affect system performance. Use this setting only for brief periods, and when a single-requestor DB trace is not suitable.

To enable a system-side database trace, do either of the following steps.

  1. Update the prconfig.xml file and restart the server.
    1. Update the <database> node of the prconfig.xml file to add this element. 
      <entry key="dumpStats" value="true" />
    2. Stop and restart the application server.
  2. As an alternative to updating the prconfig.xml file, you can use dynamic system settings to configure your application. See Using dynamic system settings.
What to do next: Turn off system-wide database trace by setting the dumpStats setting to false.