Question8Replies172Views JohnPaulRaja,C Member since 2011 246 posts Cognizant Posted: 1 year agoLast activity: 5 months 1 week ago Performance issue - Application takes more time to get work object details dataHi , Application Report definition are takes more time to get the data from pega work and index tables, but when the same database query executed from SQL developer works fast.Not sure, where the bottleneck. Report definition using application connection id when I run in SQL developer, using different id for db connection Report definition are pointing to exposed column, not blob Pega version: 7.2.1 , DB: oracle , server: web sphere System Administration Data Integration ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Posted: 1 year agoMarcLasserre_GCS PEGA replied to JohnPaulRaja,CHello, Have you tried tracer or performance analyser to check where the time is spent? Posted: 1 year agoMahendra_Kumar Tata Consultancy Services replied to JohnPaulRaja,CHi, Please try DB Tracer to analyze the time taken (getting connection, executing query, etc.) Based on the findings you can either narrow down the issue or get hints on what to do next. Also check the Pega alert log to see if you have any alerts related to connection pooling. Posted: 1 year agoJohnPaulRaja,C Cognizant replied to Mahendra_KumarTried DB trace, it shows high time in preparedStatement in SQL Posted: 1 year agoN.SenSharma Accenture UK replied to JohnPaulRaja,CWhen you executed the query using Oracle SQL developer, did you use the same attribute values in the where clause, as it was when you executed that report def from PRPC? BTW, does it say 'PreparedStatement' or 'PreparedStatementQuery'? Posted: 1 year agoJohnPaulRaja,C Cognizant replied to N.SenSharma1. yes, same attribute element withe same set of where clause 2. TB tracer shows - preparedStatement under operation column Posted: 1 year agoN.SenSharma Accenture UK replied to JohnPaulRaja,CI was referring to the value used in where clause. Can you please get the generated query, and update it with the actual values used in query/report def, and get the cost/explain plan of that query from your DBA or Oracle SQL developer? Posted: 1 year agoJohnPaulRaja,C Cognizant replied to N.SenSharmaWorking with DBA, will update the status shortly Posted: 5 months agoSarithaP4895 Mastercard Inc replied to JohnPaulRaja,CWere you able to find a resolution ? What is the root cause for the prepared stmt to take longer.