Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

Generating a system-wide database trace

Updated on August 25, 2021

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 Configuring dynamic system settings.
What to do next: Turn off system-wide database trace by setting the dumpStats setting to false.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us