LinkedIn
Copied!

Table of Contents

Generating a system-wide database trace

Version:

Only available versions of this content are shown in the dropdown

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.

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.

Turn off system-wide database trace by setting the dumpStats setting to false.
Did you find this content helpful?

Have a question? Get answers now.

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