Ask the DBA to run the SQL profile as that will ensure correct execution plan is picked till you upgrade.
------------------------------
Thanks & Regards
Suman Pramanik
Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
Broadcom
------------------------------
Original Message:
Sent: 11-25-2020 09:50 AM
From: Devendra Jakhmola
Subject: Job log Page Slow!
Hi Kathryn, Thanks for your input.
We are on V15.7 and the job log page has slowed down from last few weeks, wondering what can we do fix this.
Regards.
Original Message:
Sent: 11-19-2020 01:09 PM
From: Kathryn Ellis
Subject: Job log Page Slow!
This has been reported and resolved.
Please reference
[DE57636]: Report and Job's scheduled job Log list page takes time to load and sometimes times out
Resolved in 15.8.1.2 and 15.9.0
https://knowledge.broadcom.com/external/article?articleId=199870
Original Message:
Sent: 11-19-2020 06:12 AM
From: Devendra Jakhmola
Subject: Job log Page Slow!
Hi there , We have started facing slowness while opening the job log page from last few days - can you please advice .
Please note that there is not much of data in the cmn_sch_job_runs, have only around 70 K records.
Clarity Version- 15.7