Project and Portfolio Management Practitioners Forum
cancel

Logging Queries (SQL Statements)

Highlighted
raheel.hussain
Contributor.

Logging Queries (SQL Statements)

Hello guys
is it possible that I capture all the queries and SQL statements which are fired from the PPM system

suppose, running reports i need to capture what sql queries are passed in the backgroud

etc.

i had set a parameter
ENABLE_JDBC_LOGGING=true

but seems like it only logs that when the sql command was passed, and how much time taken to run that command and when the results were retrieved,... not the actual query which was passed to the databas oracle.

your help is much appreciated.

regards
1 REPLY
Darshan Bavisi
Outstanding Contributor.

Re: Logging Queries (SQL Statements)

Hi Raheel,

You can setup the sql trace from Workbench > Edit (in file menu) > Debug Settings (also refer to pages 185-189 in sysadmin.pdf guide for the same). But this will add overhead on the application and can affect the performance.

Alternatively, and a better option would be to get all the sqls from the Oracle logging. Ask your DBA, who should be able to capture all the sqls coming from PPM application in the Oracle logging and can send you all the sqls.