SQL Queries Log

The SQL Queries Log identifies long-running SQL queries in the database. You can view the start time of a query, statements that consume more time, the end time of a query, and more. Unlike SQL Audit Log, the SQL Queries Log allows printing the latest information straightforwardly so that information can be viewed or saved at the same moment. When you print the SQL Queries Log, the filedbquerypl.log is saved in the directory%AGILIANCE_HOME%\Tomcat\logs\, by default. You can also save the filedbquerypl.log in a different directory using the following property, which is found in the file.default.system. properties.

log.dbquerypl={.home}/../dbquerypl.log