My Oracle Support Banner

D1-PSACC Running Too Slow (Doc ID 2648442.1)

Last updated on MARCH 18, 2020

Applies to:

Oracle Utilities Customer to Meter Base - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Goal

On : 2.6.0.1.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.
 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.