D1-PSACC Running Too Slow
(Doc ID 2648442.1)
Last updated on JULY 05, 2021
Applies to:Oracle Utilities Customer to Meter Base - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 version, Framework
D1-PSACC running too slow
It appears that this job is using a full table explain plan rather than an index scan. You noticed this job is running a few select queries in the background that is using a full table explain plan which is causing the job to run slowly.
SELECT IMD.BO_STATUS_CD, IMD.BUS_OBJ_CD, COUNT (*) AS CNT
FROM CISADM.D1_INIT_MSRMT_DATA IMD
WHERE IMD.IMD_EXT_ID = :1
GROUP BY IMD.BO_STATUS_CD, IMD.BUS_OBJ_CD
ORDER BY IMD.BO_STATUS_CD, IMD.BUS_OBJ_CD /* SQL for Zone 'D1-ACCSTATS' */
/* com.splwg.base.web.dataExplorer.common.DataExplorerSQLExecuter */
If you notice it is using a count(*) which is causing the explain plan to use Table access INMEMORY full. the D1_INIT_MSRMT_DATA table currently has 24 million records.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document