Skip to Content

SQL Trace in Java SQL Monitor

The Java SQL Monitor is useful to troubleshoot issues in GRC 5.3 release.

1- Type the address http://<server>:<port>/SQLTrace and you will see the OpenSQLMonitor page:

2- Activate the trace I click on Switch on and off SQL Trace link.

3- Click on “SQL Trace ON” button, recreate the issue in GRC frontend, and click “SQL Trace OFF” (this button will appear once the trace is ON).

4- Click “Trace Evaluation” to evaluate the SQL statements sent to the database.

Example of existing traces in an internal system:

Once you evaluate it, this is what is used for analysis: