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:
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: