On Prem - Need to get SQL statement log which is executed from application instance when the instance connect Oracle (database server)


Description

In self-hosted , Customer wants to get SQL statement log which is executed from application instance when the instance connect Oracle (database server) first. 
To do that , Customer is trying to get Oracle JDBC log in application instance. 

Does service-now provide any OOB method/way to set Oracle JDBC logging configuration on ServiceNow application instance ?


Steps to Reproduce:
I tried the step to configure JDBC logging but it failed.
1. add following configuration in logging.properties
oracle.jdbc.driver.level=CONFIG
2. modify following configuration in wrapper.conf to activate JDBC logging
wrapper.java.additional.8=-Doracle.jdbc.Trace=true
3. replace ojdbc6-11.2.0.3.jar to ojdbc6_g.jar
ojdbc6-11.2.0.3.jar file in /glide/nodes/appnode/webapps/glide/itil/WEB-INF/lib was replaced to ojdbc6_g.jar downloaded from this web site.
https://www.oracle.com/database/technologies/jdbcdriver-ucp-downloads.html.
ojdbc-diag.tar.gz
4. restart servicenow instance by following command
# systemctl restart snc

Release or Environment

environment
OS:RedHat Enterprise Linux v7.1
ServiceNow version: Orland (self-hosted)

Resolution

Dev confirmed that - We have no method to provide all of the sql generated by the application via JDBC parameter settings.