Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 John Paul Raja Christu Raja (JohnPaulRaja,C)
Maantic Inc
Consultant
Maantic Inc
US
JohnPaulRaja,C Member since 2011 302 posts
Maantic Inc
Posted: Aug 20, 2019
Last activity: Apr 17, 2020
Posted: 20 Aug 2019 22:54 EDT
Last activity: 17 Apr 2020 14:25 EDT
Closed

Performance issue - Application takes more time to get work object details data

Hi ,

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

To see attachments, please log in.
System Administration
Data Integration

Posted: 5 years ago
Posted: 21 Aug 2019 5:05 EDT
Mahendra Kumar Mahaveer Chand (Mahendra_Kumar)
Verizon

Verizon
IN
Hi, 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.
To see attachments, please log in.
Posted: 5 years ago
Posted: 21 Aug 2019 15:29 EDT
Nirmalya Sen Sharma (Nirmalya.SenSharma)
Ernst & Young LLP
Program Manager
Ernst & Young LLP
MT

When 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'?

To see attachments, please log in.
Posted: 5 years ago
Posted: 22 Aug 2019 17:57 EDT
Nirmalya Sen Sharma (Nirmalya.SenSharma)
Ernst & Young LLP
Program Manager
Ernst & Young LLP
MT

I 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?

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice